Getting actual earnings forecast t+1 using Eikon API

business1
business1 Newcomer
in Eikon Data APIs

Hi All,

I'm hoping if someone could help guiding me how to get the actual EPS value. I'm abit confused about the "Financial period" option in the parameters. If I want to get the actual EPS for December, 2019, is the following equation correct? Should I choose FY0 or FY1?

=TR("ABBV.N","ABS(ZAV(TR.EPSActValue))","Period=FY0 Frq=D SDate=20181201 EDate=20181231 RH=date Transpose=Y",D6)

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    hi @business1 ,

    is this what you're looking for? I've checked that the output is the same as Eikon Excel.

    df, err = ek.get_data('ABBV.N', ['TR.EPSActValue(Period=FY0).date', 'ABS(ZAV(TR.EPSActValue(Period=FY0)))']
                                     , { 'Frq': 'D', 'SDate' :'2018-12-01', 'EDate': '2018-12-31'})
    df

    1666325879083.png

    Then you can transpose the dataframe using the code below

    df = df.T
    df

    1666325953056.png


    Hope this helps and please let me know in case you have any further questions

Answers

Categories