Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by zhopan77 · Feb 15, 2018 at 08:32 AM · eikonpython apitimeserieshistoricaleci

How to obtain historical Reuters poll for an economic indicator using Eikon Python API?

How can I obtain historical Reuters poll (i.e. forecast) for an economic indicator using Eikon Python API?

For example, for this RIC "USADP=ECI", I know how to obtain historical time series like this:

eikon.get_timeseries("USADP=ECI", start_date="2010-01-01", interval="monthly")

I also know I can get some present data like this:

ek.get_data("USADP=ECI", fields=["ECON_PRIOR", "ECON_SRCE"])

However, these fields mostly return NaN: "ECON_ACT", "ECON_DES", "ECON_FCAST", "ECON_HIST", "ECON_REV", "FCAST_HIGH", "FCAST_LOW", "FCAST_NUM"

The question is, how do I get historical Reuters poll values (forecast values) in a time series? Apparently get_timeseries() does not support any field other than 'TIMESTAMP', 'VALUE', 'VOLUME', 'HIGH', 'LOW', 'OPEN', 'CLOSE', 'COUNT'; and get_data() does not return historical data.

I think this data is present in Eikon though, since some chart about a RIC can plot historical poll, and Excel plugin is able to retrieve historical poll.

Please help! Thanks!

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
Best Answer
Answer by filip.wyszynski · Apr 23, 2018 at 11:05 AM

I had a similar problem and eventually found the solution. It turns out poll values and other historical datapoints have their own tickers.

Within Eikon, navigate to your economic indicator of choice and export to Excel. Here you will find the relevant tickers.

For your example above:
Actual release = 'USADP=ECI'
Median poll = 'pUSADP=M'
Min poll = 'pUSADP=L
Max poll = 'pUSADP=H'

This ticker logic appears to apply across all economic indicators.

Comment
jason.ramchandani
zoya.farberov
Jonathan.Haruni.Refinitiv
zhopan77

People who like this

4 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
zhopan77 · May 07, 2018 at 11:25 AM 0
Share

Thank you! This works great! Do you know how to obtain the exact date and time of the data announcement? Right now the economic indicators are treated like bars. If it's a monthly data, the date of each data point is the end of the month since the monthly bar closes at end of the month. But we'd like to obtain the exact date and time the data was announced. Is there a way to do it?

avatar image
REFINITIV
Answer by Alex Putkov. · Feb 15, 2018 at 03:51 PM

I'm afraid it's not currently possible to retrieve historical Reuters poll values in a time series using Eikon Data API. I also don't see any way to retrieve this data using Eikon Excel, but if you know otherwise, could you please share an example of the formula?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

Set Python API logs programmatically.

How do I download Historical Data from Starmine?

Date reported for TR.PriceClose

Retrieving minutely bid prices

Time zones for overnight deposits in time series data

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges