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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 3 4

How to query Python API for news for M&A events

Hi,

Trying to use the Eikon API via python with query feature. How can one get all english news as per the query to get M&A upcoming or announced news through the API. For example, the below query get all topics news in english. Any similar query for events news in English would be very helpful.

query = 'Topic:TOPALL and Language:LEN'

Regards,

Puneet

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonquery-string
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
4.6k 26 7 22

Try this:

Topic:MRG ANDTopic:DEAL1 AND Topic:BACT AND Language:LEN AND Source:RTRS

This will get you:

  • MRG - Mergers/Acquisitions/Takeovers
  • DEAL1 - Deals
  • BACT - Corporate events

You can play with different topic codes by pressing F9 in Eikon. It opens the News Monitor app, where you can build queries and reuse them in the API.

On a separate note, check out following codes:

  • Report:TOP/DEALS
  • Topic:INVS
  • Topic:CFIN

Also, here is a sample jupiyter notebook that shows you how to work with the news API on TR-API-Sample GitHub group.

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.

Hi Zhenya,

Thank you and apologies for the late reply. We were also looking for Event Type = "Transactions" and then further Significant M&A announced/completed etc. Any chance you would know how to query for that.

Also you mentioned News Monitor in Eikon. Is there an area in Eikon where users can see what possible values can "Topic:" take or EventType could be. News Monitor is helpful but I honestly don't know the queries that need to be constructed so a doc would be really helpful.

Regards,

@puneet.mahajan:

1. You can query the reference database for events like this. Go to Data Item Browser (DIB), in the left-hand side filter Content Classification > Mergers And Acquisitions and click on Done. This will give you all retrievable fields from our M&A DB.

2. Should you like to pursue the News API path, contact your local Thomson Reuters for free training on Eikon and News Monitor;

Click below to post an Idea Post Idea