Retrieving information about EPS forecasts for all analysts over the past 10 years

Petya

Dear Refinitiv,

I would like to retrieve information about all EPS estimates (for FY1) issued over the past 10 years by all financial analysts for a certain company. Using the Eikon API in Python, I run the following codes:

df, err=ek.get_data(['GOOG.O'],

['TR.EPSEstValue.date', 'TR.EPSEstValue()'],

{'SDate':'2017-01-01', 'EDate': '2018-01-01', 'Period':'FY1'})

Unfortunately, there is no outcome with valid observations.

InstrumentDateEarnings Per Share - Broker Estimate0GOOG.O2017-10-23T15:57:00ZNaN1GOOG.O2017-10-23T15:57:00ZNaN2GOOG.O2017-10-23T15:57:00ZNaN3GOOG.O2017-10-23T15:57:00ZNaN

Can you please help me by pointing out the mistake in my codes: I would like to have something similar to the details analyst template but over several years (always Period FY1)

An example follows: broker, analysts, EPS, date - over multiple periods

ARGUS RESEARCH CORPORATIONBonner, Joseph F5,5125/10/2019ATLANTIC EQUITIESCordwell, James P5,4024/10/2019CLEVELAND RESEARCHTerjanian, Ari5,4608/11/2019
ARGUS RESEARCH CORPORATIONBonner, Joseph F5,0025/10/2010ATLANTIC EQUITIESCordwell, James P5,0524/10/2010CLEVELAND RESEARCHTerjanian, Ari5,1008/11/2010

Thank you,

Petya

chavalit-jintamalit

Hi @Petya

df=df.dropna() is a code to remove record with NaN value.

If you comment this line out, you get the data back to 2016 but all of them are NaN.

I cannot answer why the data is NaN.

Please contact Refinitiv Content Helpdesk at https://my.refinitiv.com/ to get support on the data point.

Helpdesk can guide you to configure the parameter according to your requirement on "Data Item Browser"

chavalit-jintamalit

Hi @Petya

I think you have to add Frq too.

Petya

Thank you very much, Chavalit! Have a nice weekend!

Best,

Petya

Petya

Dear Chavalit,

I tired your solution and saw that it doesn't retrieve all EPS over the past years. It just lists the ones for the most recent year. I changed the year extending it back to 2000 and it doesn't list any EPS forecasts other than the ones for FY2017. Can you please help me by suggesting how to modify the codes. I need historical data. Thanks!

Petya

Thank you Chavalit! Best, Petya