Merger and acquisitions python API

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.

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

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.

All comments

Zhenya Kovalyov

Are you comparing it to CDV app on Eikon?

Zhenya Kovalyov

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.

sam.humphreys

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

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.

EXPLORE OUR SITES