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?
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'])