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

Find more posts tagged with

python

eikon

workspace

query-string

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

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.

All comments

Zhenya Kovalyov

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.

puneet.mahajan

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,

Zhenya Kovalyov

@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;

EXPLORE OUR SITES