Merger and acquisitions python API

sam.humphreys
sam.humphreys
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
    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

  • Zhenya Kovalyov
    Zhenya Kovalyov

    Are you comparing it to CDV app on Eikon?

  • sam.humphreys
    sam.humphreys

    Do you expose the Advanced Events Search app via the API?

  • Zhenya Kovalyov
    Zhenya Kovalyov

    @sam.humphreys I can not really say if it is using the same database. I suggest you contact your local Thomson Reuters support desk and ask them for help in reproducing ADVEV in Excel. The rule of thumb is that if something is available in Excel then it is available in the Python API.

Categories