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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

Eikon API: Retrieve Annual Report publication date

I'd like to download the history of annual report filings dates for a set of ISINs. Currently, my search query using the Python API looks like this:

  
df, err = eikon.get_data(
    instruments,
    ['TR.ISSourceDate', 'TR.ISSource', 'TR.ISOriginalAnnouncementDate', 'TR.ISPeriodEndDate', 'TR.ISPeriodEndDate.fpa'], {'SDate':  '2000-01-01' , 'EDate':  '2022-07-05' }
)

I am, however, not entirely sure that this query gives me the correct publication dates. For example, for the firm "FR0000124141", the query gives me following two data points:

1657615477064.png

When I use Eikon Desktop to check the filing dates there, I see various publication events that occur immediately in the year after the fiscal year ends.

1657615544553.png

Given that comparison, what is the correct way to extract precise annual report publication dates using the API?

eikon-data-apipython apidatepublication
1657615477064.png (17.5 KiB)
1657615544553.png (216.6 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.

Upvote
Accepted
31.8k 37 11 19

Hello @research2 ,

I am really not a subject matter expert,

From my running example Company Events Calendar referenced by @jason.ramchandani01,

I can see multiple different Event types generated, but none of them are Filings or are named as such.

It looks to me that, on the content side, something might have changed since 2019, when the example was last updated, and consequently, Filings are not classified as Event type anymore, but as another Eikon content category.

If the required content is available for access via Eikon Data API, it has to be findable via CodeCreator, and this is where the matter gets complex. I am seeing many likely looking fields:

filings.gif

Not being a subject matter expert, unable to tell which ones are relevant and which ones you require.

I suggest engaging with Eikon content experts directly, via Refinitiv Helpdesk Online -> Content -> Eikon to clarify your requirement, and to confirm that the required Filings content is accessible via CodeCreator. Once you have the fields required- you can request them via Eikon Data API, and we can be of help you with this task on the dev forums.

Hope that this information is of help




filings.gif (141.9 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.

Upvote
7.6k 10 6 8

@research2 Thanks for your question. So please take a look at this thread and accompanying github repo which contains a notebook containing a full example using our events data. Using a RIC (VIE.PA) - not an ISIN - I was able to generate the following output - which should contain much more detail than your initial request for just annual filling dates. In the example you can just request the event types you require.

1657617399947.png

You can convert from ISINs to RICs using our get_symbology API call - details can be found here. I hope this can help. Please let us know how you get on.


1657617399947.png (240.5 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.

@jason.ramchandani01 thanks for the quick reply! Is it possible that this specific data is bound by the concrete license that my institutions bought? Because when using the query (e.g., for conference calls, code 'CCALL') I obtain only very limited data and only for years 2017+.

Secondly, what would be the correct event type code that captures corporate filings?

Hello @jason.ramchandani01

Could you please help the client with the follow up question?