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

Find more posts tagged with

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Jirapongse

@Arpit Jain

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

The Python code looks like:

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

The output is:

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.

All comments

Jirapongse

@Arpit Jain

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

The Python code looks like:

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

The output is:

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.

Arpit Jain

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

Jirapongse

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

EXPLORE OUR SITES