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?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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?
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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)")
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.