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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

Query Corporate Action Calendar

Hi!

I was trying to query the corporate action calendar, but none of the command seems to work for me.

ek.get_data(['DBV'],[ 'TR.CACorpActDesc(SDate=20010101, EDate=20180101,CAEventType=All)'])

Only gives me the return of capital. Instead I am hoping to get Dividend, M&A and Name&ID change.


Thanks!

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.

1 Answer

Upvotes
Accepted
39.2k 75 11 27

@ghanweck

The field TR.CACorpActDesc is from the Capital Changes category, and it returns only capital change events. The field definition found in Data Item Browser or CodeCreator apps is "The full description of Capital Change".
For dividends use fields from Dividend History category, e.g.

ek.get_data(['DBV'],['TR.DivAnnouncementDate','TR.DivExDate',
                     'TR.DivPayDate','TR.DivUnAdjustedGross'],
           {'SDate':'20010101', 'EDate':'20180101'})

For the retrieval of M&A activity see the discussion on this previous thread

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.

@Alex Putkov. Thank you Alex for the quick response. The div and M&A part is very helpful. Any chance you have a previous threads regarding the Name ID change category under Corporate Action Calendar?

I'm afraid not. Name & ID changes are not represented as a category in the data model accessible through Eikon Data APIs. Name/ID changes are tied to capital change events, and you can retrieve the latter. But you cannot make a request for name/ID changes for a list of companies between two dates.

Click below to post an Idea Post Idea