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