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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 1

Dividend with specific ex date

Is it possible to get dividend data for all equities going ex date on specific date? or maybe for some market segments (not specifying all RICs explicitly)? is it possible in Eikon Excel too?

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidataeikon-for-office
icon clock
10 |1500

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

Upvotes
Accepted
31.6k 37 11 19

Hello @Pawel.Piatkowski,

In my understanding, if you are able to round up the required universe of RICs by applying a filter or a set of filters within Eikon Screener, then you will be able to request dividend data per that set of RICs.

So by applying Eikon Screener, I think "Last EPS Report Date" may be what you are looking for:

Consequently, having selected date:

I came up with a formula, that can be exported to Excel or used in Python, and if we are looking for Dividend Data should be something like:

ek.get_data(  "SCREEN(U(IN(Equity(active,public,primary))),TR.EPSActReportDate(Period=FQ0,SDate=0D)>=20210311, CURN=USD)","TR.CommonName;TR.EPSActReportDate(Period=FQ0,SDate=0D);TR.DividendYield(SDate=0D)") 



icon clock
10 |1500

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

Upvotes
31.6k 37 11 19

Continuing, as can not add more then two screenshots in single answer :

Resulting in:

You can try this approach and further tune it to your requirements, or, a perhaps better approach is to consult Eikon content experts on this content selection and availability via Refinitiv Helpdesk Online -> Content.


result.gif (14.1 KiB)
icon clock
10 |1500

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