Merger and acquisitions python API

sam.humphreys
sam.humphreys Newcomer
in Eikon Data APIs

I am trying to return all merger and acquisition corporate events for Apple Inc. I have constructed this query using another developer page, as well as Eikons Excel formula build in.

Using:

symbol = 'AAPL.OQ'
names_list = ['TR.DealDate;TR.DealStatus;TR.DealAcquiror;TR.DealTarget;TR.DealType;TR.DealSynopsis; TR.DealAnnouncementDate;TR.DealPercentSought;TR.DealPercentOwned, ']
start_date = str(20100101)
end_date = str(20180312)
df, error = ek.get_data(symbol, names_list, {"SDate": start_date, "EDate": end_date})
df.sort_values('Date', ascending=False)

It appears to be returning very different results for what I can see in Eikon. By changing the RIC you can see more examples of incorrect returns.

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    We are not currently exposing the deals database (CDV app on Eikon) to customers via the API, instead you are getting the default coverage from the standard reference database, which may differ.

    Let me know if your require any further info.

Answers

Categories