question

Upvotes
1 0 0 1

Point in Time Estimates

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'})
eikon-data-api#content
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
11k 22 6 9

@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.


1727781141539.png (38.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 0 0 1

Yes this solves my problem. Thanks!

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.