Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 2 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiquery-string
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.

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question. Thanks, AHS

Hello again!

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

@puneet.mahajan

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an 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 512.0 KiB each and 1.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,

@Zhenya Kovalyov

The client has further questions, could you please help answer these questions?

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

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.