Can users retrieve Deals data from Eikon API?

Unknown
Unknown
in Eikon Data APIs

Can users retrieve Deals data from Eikon API?

By Deals data I mean the following data from Eikon.

image

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    Yes, it's possible to retrieve this data using Eikon Data APIs. The key for retrieving deals data is the deal ID number and the data items are found under the Deals category in the Formula Builder in Eikon Excel. E.g. the following expression retrieves deal information for Tencent Holdings Ltd 2004 IPO

    ek.get_data("154084733987@dealid",
                 ["TR.NISdcPackageNumber","TR.NIIssueDate",
                  "TR.NIIssuer","TR.NIIssuerPermId",
                  "TR.NIIssueType(Concat='|')",
                  "TR.NITransactionStatus","TR.NIOfferPrice",
                  "TR.NIProceedsAmtInclOverallotSoldAllMkts(Scale=6)"]

    In practice you almost always need to use Screener to retrieve deals data, as you wouldn't know the deal ID numbers. In the Screener wizard in Excel select "Deals" as the Universe and follow the wizard to insert =TR function into Excel worksheet. Then you can copy & paste the Screener expression from =TR function into your Python code. E.g. the following retrieves all equity deals Tencent Technologies Ltd (permID 4295865078) has been involved in.

    ek.get_data("SCREEN(U(IN(DEALS)),TR.NIisECM=True, \
                 IN(TR.NIParticipant(NIDealPartRole=SSH:SSHIP:SSHUP: \
                 IS:ISIP:ISUP:SPP:SIN:SINIP:SINUP:IA:IAIP:IAUP: \
                 SIS:SISIP:SISUP:OG:OGIP:OGUP),4295865078))",
                 ["TR.NISdcPackageNumber","TR.NIIssueDate",
                  "TR.NIIssuer","TR.NIIssuerPermId",
                  "TR.NIIssueType(Concat='|')",
                  "TR.NITransactionStatus","TR.NIOfferPrice",
                  "TR.NIProceedsAmtInclOverallotSoldAllMkts(Scale=6)"]

Categories