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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
19 1 1 5

How can I use the Eikon Data API with Python to pull Excel Deal Screener data?

using the excel deal screener i get an excel formula like:

=TF('TFScreen.Deals(DEALSEXPRFORMAT(Deals,Active,1, IssuerStatus=M&A),curn=USD,((TF.Deals.AnnDate()>=03/05/2019 And TF.Deals.AnnDate()<=03/20/2019))), "TF.Deals.MADealNo()")

Can I call this excel formula by using the get_data function in the Eikon Data API?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-apiscreening
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

No, you cannot. The Deal Analytics add-on, which creates Deal Screener button under Thomson Reuters tab in Excel ribbon is a legacy component, which over time will be retired. The replacement is the Screener with the Deals selected as the Universe. Expressions created using Screener can be used in get_data method of Eikon Data APIs.

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