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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 1

How to obtain the fiscal period year and Fiscal Month for Interim and Annual Fundamentals Data

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
capture.jpg (162.3 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

@kamal.Jayapalan
The best way to go about discovering metadata for use with Eikon Data APIs is by using Data Item Browser app in Eikon application or following Formula Builder wizard in Eikon Excel as described in the following tutorial.

https://developers.refinitiv.com/eikon-apis/eikon-data-api/learning?content=14707&type=learning_material_item

The data you're looking for can be derived from income statement / balance sheet / cash flow statement period end date. The following expression retrieves income statement period end date and financial period reference in absolute notation for the last 5 annual fiscal periods for a given stock.

ek.get_data('TREC.K',['TR.ISPeriodEndDate','TR.ISPeriodEndDate.fperiod'],
           {'Period':'FY0', 'Frq':'FY', 'SDate':'0', 'EDate':'-4'})

I hope this helps.

icon clock
10 |1500

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

Click below to post an Idea Post Idea