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
1
●3 ●2 ●1
How to obtain the fiscal period year and Fiscal Month for Interim and Annual Fundamentals Data
Hello @kamal.Jayapalan
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
39.4k
●77 ●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.
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.
