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
thomas01 avatar image
1 ●1 ●1 ●3

Economic indicators from ek.get_data ek.get_timeseries

I am trying to pull historical economic indicator with ek.get_data. While I was able to obtain the time series with ek.get_timeseries, the date returned was in the period which the indicator was responsible for (ie If I'm looking at the CPI released on Oct 12 2023, the data reported was responsible for 2023-09-30. I saw a related problem here and would like to have your insights if there's anyway to get_timeseries to return the (original release date) that I'm looking for.

df=ek.get_timeseries(['USCPNY=ECI'],fields=['TIMESTAMP', 'TRADE_DATE','VALUE'],calendar='native',start_date='2007-03-01',interval='monthly')#,fields=['DSPLY_NMLL','RELEVANCE','ACT_REL_ST','ECI_ACT_DT','ACT_VAL_NS','UNIT_PREFX','FCAST_PRD','RPT_UNITS','ECON_ACT','ECON_PRIOR','RTR_POLL','FCAST_SEST'])
display(df)

1697220264805.png

Figure1. Output from notebook

1697220349158.png

Figure2. Desired output should have date: October 12 2023.

Another approach I attempted: use ek.get_data, which I found the CF_DATE to correspond to the date of release, but in this case ek.get_data returns a single point rather than a dataframe/timeseries.

df, err = ek.get_data(
    instruments = ['USCPNY=ECI'],
    fields = ['CF_TIME','CF_DATE',
        'TR.IndicatorLastObservationDate',
        'TR.IndicatorStartDate',
        'TR.IndicatorType',
        'TR.IndicatorSeasonalAdj',
        'TR.IndicatorBaseYear',
        'TR.IndicatorPeriodicity',
        'ACT_STA_DT',
        'ACT_END_DT',
        'ACT_VAL_NS',
        'ACT_END_DT',
        'ACT_VAL_NS',
        'NDOR_1',
        'TRADE_DATE',
        'REF_PRD',
        'ECON_ACT',
        'GN_TXT16_4'
    ],parameters={"SDate":"2007-01-01",'EDate':"2023-10-14
eikon-data-apirefinitiv-dataplatform-eikon#contenteconomic-data
1697220264805.png (12.1 KiB)
1697220349158.png (137.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.

raksina.samasiri avatar image   raksina.samasiri

Hi @thomas01 ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

aramyan.h avatar image   aramyan.h

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thank you,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.3k ●253 ●52 ●74

@thomas01

Thank you for reaching to us.

The fields without the TR prefix are real-time fields which can't provide historical data when using the get_data method.

I checked the previous issues and found that the original release date may not be retrieved via Eikon APIs. You can contact the helpdesk support team directly via MyRefinitiv to confirm this by asking for the Excel fomular that can be used to retrieve the historical orginial release date. If the fomular is available, we may be able to convert it to the 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.

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.