Point in Time Estimates

vincent.donovan
vincent.donovan Newcomer
in Eikon Data APIs

In the Eikon API in python, I want to get the RevenueMean for S&P500 Components for the next 10 financial quarters, on a point in time basis. So in 2022Q4 the revenue mean for FQ4 should be the available estimate at 2022Q4 for 2023Q4, not the estimate at 2023Q4. I tried this code but this just gives me the shifted estimates.

df, e = ek.get_data('0#.SPX', fields = ['TR.RevenueActValue.periodenddate', 'TR.RevenueActValue.announcedate',
'TR.RevenueActValue(Scale=6)', 'TR.RevenueMean(sdate=0, edate=10, Scale=6)'], 
parameters={'sdate': '-100', 'edate': '0', 'period': 'FQ0', 'Frq': 'FQ'})
Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @vincent.donovan Thanks for your question. You can get point-in-time IBES consensus estimates as follows:

    df,err = ek.get_data(['VOD.L'], ['TR.RevenueMean(Period=FY1).calcdate','TR.RevenueMean(Period=FY1)'],{'SDate': '-2000', 'EDate': '0', 'Frq': 'D'})

    df


    1727781141539.png

    I hope this can help.

Answers

Categories