Eikon API: Retrieving filing date for annual reports

Question

Question by Joris.Hoendervangers · Sep 29, 2017 at 05:31 AM · eikon eikon-data-api workspace refinitiv-dataplatform-eikon workspace-data-api python data

Question on behalf of a client. Is it possible to retrieve the filing date of quarterly/annual reports?

Maybe the same logic can be used as the 'calcdate' or 'periodenddate'. Is there a field for 'filing date' and/or 'receipt date'?

Thank you so much in advance for your help!

df, err = eikon.get_data('AAPL.O', ['TR.TotalAssetsReported', 'TR.TotalAssetsReported.calcdate', 'TR.TotalAssetsReported.periodenddate'] )

filing.jpg (72.6 KiB)

filings2.jpg (9.4 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2017-09-29T06:03:23Z

Best Answer

Answer by Joris.Hoendervangers · Sep 29, 2017 at 06:03 AM

With help of the Eikon Helpdesk:

Excel formula:

=TR("AAPL.O","TR.ISSourceDate;TR.ISSource","Period=FI0
Frq=FI SDate=0 EDate=-6 CH=Fd RH=IN",)

Using these fields in Python:

filings3.png (13.6 KiB)

1 · Share

10 |1500 characters needed characters left characters exceeded

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