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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
zhopan77 avatar image
1 ●0 ●1 ●3

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!

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

2 Answers

Upvotes
Accepted
filip.wyszynski avatar image
101 ●0 ●2 ●2

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.

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.

zhopan77 avatar image zhopan77

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?

Upvotes
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

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?

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.

Click below to post an Idea Post Idea