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
1 1 2 6

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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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
78.2k 246 52 72

@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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 2 6

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 512.0 KiB each and 1.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.

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.