For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 2 3 4

Historical Spin-off and M&A information from Eikon API

Hi I am trying to get the historical information of spin-offs for a given set of symbols with - date, new entity ric/ISIN, old entity ric/ISIN

I also need M&A information with date, merger symbol, acquirer symbol, type of acquisition.

How do I do this with Eikon Python API?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
4.6k 26 7 22

For content related questions you will need to contact your local Thomson Reuter support desk and try to build the required functionality in Eikon Excel first. Or, alternatively, have a look at all available fields in the Data Item Browser app on Eikon.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 2 3 4

I do not find the exact information that I am looking for in the data item browser.

I tried following queries

data, _ = ek.get_data(['BLT.L'], ['TR.DealDate', 'TR.DealType', 'TR.DealStatus', 'TR.DealAnnouncementDate', 'TR.DealValueAnnounced'], {'SDate':'-10AY', 'EDate':'1AY', 'sort':'asc'})

data, _ = ek.get_data(['BLT.L'], ['TR.DealAcquiror', 'TR.DealTarget','TR.DealStartDate','TR.DealClosedDate','TR.DealExpirationDate', 'TR.DealPricePerShare', 'TR.DealCashAmount'], {'SDate':'-10AY', 'EDate':'1AY', 'sort':'asc'})

but I do not get the demerger information for demerger event that started on

17-Mar-2015 for BLT.L

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
38.1k 69 35 53

With Eikon Excel Formula Builder, I found it in Corporate Actions ->Capital Changes category.


formular.png (107.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea