For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted

Can users retrieve Deals data from Eikon API?

Can users retrieve Deals data from Eikon API?

By Deals data I mean the following data from Eikon.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonscreening
deals-data.jpg (165.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
39.2k 75 11 27

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)"]
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea