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

question

Upvotes
Accepted
research2 avatar image
1 ●1 ●2 ●2

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.

raksina.samasiri avatar image   raksina.samasiri

hi @research2 ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text on the left side of the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

Jirapongse avatar image   Jirapongse

@research2

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

2 Answers

· Write an Answer
Upvote
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

@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.

research2 avatar image research2

@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?

Jirapongse avatar image   Jirapongse

@jason.ramchandani01

The client has a further question regarding the correct event type code for corporate filings.

wasin.w avatar image wasin.w
Hello @jason.ramchandani01

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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