Point in Time Estimates

vincent.donovan

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'})

jason.ramchandani01

@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

I hope this can help.

vincent.donovan

Yes this solves my problem. Thanks!