Can users retrieve Deals data from Eikon API?
By Deals data I mean the following data from Eikon.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Can users retrieve Deals data from Eikon API?
By Deals data I mean the following data from Eikon.
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)"]