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
pvilleneuve avatar image
4 ●2 ●5 ●7

How can I get corporate event data with python api?

Hello,

Im trying to download corporate event data for certain constituent companies of the S&P 500. In Eikon I can see the data is available but how can I download this through Python (using eikon.get_data())?

For example I would like to get all Significant M&A events that occurred this year. In Eikon on the S&P 500 page I can go to Events > Corporate Events. Under Event Type I can search for "Mergers and Acquisitions - Announced" and a number of entries come up as shown in the image below:

I would like to have the Date, Type, and Event Name fields displayed. Is it possible for eikon.get_data() to retrieve these fields and could you kindly provide me with the inputs required to retrieve this data?


Thanks.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1622665360209.png (206.6 KiB)
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 ●77 ●11 ●27

I'm afraid the data available through Eikon Data APIs is not organized the same way as in the Corporate Events app in Eikon desktop application. The events that are available through Eikon Data APIs include earnings releases, conferences, shareholder meetings etc., but do not include M&A announcements. For an example of retrieving corporate events using Eikon Data APIs (and for the list of event types available) see this repository on Github.

If you'd like to retrieve M&A announcements, you can use Deals Screener. Here's an example retrieving all M&A deals announced year-to-date where either Etsy Inc (company PermID 4297595346) or Accenture Plc (company PermID 4295903017) is the acquirer ultimate parent.

screen = ('SCREEN(U(IN(DEALS)),'
          'IN(TR.MNAParticipant(DealPartRole=AUP),4297595346,4295903017),'
          'relativedate(TR.MnAAnnDate,YTD), CURN=USD)')
df, err = ek.get_data(screen,
                      ['TR.MnASDCDealNumber','TR.MnAAnnDate',
                       'TR.MnATarget','TR.MnATargetPermId',
                       'TR.MnAAcquiror','TR.MnAAcquirorPermId'])
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.

pvilleneuve avatar image pvilleneuve

Hi Alex,

Thanks for your answer. Is there a guide to using Python to extract data from the Deals Screener? If not, how can I modify this code to get all historical data instead of just YTD, and can I remove the requirement for the company to be the AUP? i.e involved in the deal either as target or acquiror. Is it also possible to pass a list of RICs into the screen variable instead of inputting a bunch of PermIDs?

Thanks

Alex Putkov.1 avatar image Alex Putkov.1 pvilleneuve

To construct desired Screener expression follow Screener wizard. See the article titled "Find Your Right Companies with SCREENER", which talks about using Company Screener. With Deals Screener you can use the same methodology, as described in the above article.
I believe Deals Screener can only recognize PermID as company identifier. Lots of companies in the Deals database are private and won't have RICs. If you have a list of RICs, it is trivial to retrieve company PermIDs corresponding to those RICs, which you can then use to construct Screener expression.

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.