New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
eric.jian avatar image
19 ●3 ●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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apieikon-com-apiscreening
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●78 ●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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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