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

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

Best Answer

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

    image

Answers

  • Hi @Petya

    I think you have to add Frq too.

    image

  • Petya
    Petya Newcomer

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

    Best,

    Petya

  • Petya
    Petya Newcomer

    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!

    image

  • Petya
    Petya Newcomer

    Thank you Chavalit! Best, Petya