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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

How can I get to know the time period for FY data?

I've downloaded FY data for "Financial Period Absolute" field using API. I'm not sure of which time period the FY data is really of. Is there a way to know what is the time period attached to the FY. For instance Emerson FY20 data will denote financials up till Sep'20. Is there a way to know "Sep'20"?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
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.

Upvote
Accepted
38.1k 71 35 53

@Arpit Jain

I have checked with the Data Item Browser and found a property that can provide Sep'20.

1630463401093.png

The Python code looks like:

df, err = ek.get_data('EMR', ['TR.RevenueActValue','TR.RevenueActValue.fperiod','TR.RevenueActValue.periodenddate'])   

The output is:

1630463508744.png

For more information about the Data Item Browser, please refer to the How to discover available fields for Data Grid service on JET(App Studio HTML5 SDK) API using Eikon Desktop article.


1630463401093.png (82.0 KiB)
1630463508744.png (3.9 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.

Upvotes
1 0 0 2

Thankyou so much for the help.
Will it return the period end date for the financials with NaN or empty value?

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.

@Arpit Jain

If the period end date returns NaN or an empty value, you can contact the Eikon support team via MyRefinitiv to verify the content.

Click below to post an Idea Post Idea