Hello Eikon QA,I seem to have some consistency problems when im retriving data (TR.PtoEPSMeanEst and TR.FwdPtoEPSSmartEst) from the API individually, as a series or from the data item browser. For example:
Retrieve all in a single call as a series:
df = ek.get_data('AAPL.OQ', ['TR.PtoEPSMeanEst'], {'SDate':'0','EDate':'3','Frq':'FY','Period':'FY1'})I obtain the following result:
Instrument Price / EPS (Mean Estimate)
0 AAPL.OQ 12.187330
1 AAPL.OQ 16.823317
2 AAPL.OQ 15.606444
3 AAPL.OQ 17.793991
However if i do try to retrieve each of the elements individually:
df = ek.get_data('AAPL.OQ', ['TR.PtoEPSMeanEst(Period=FY1)','TR.PtoEPSMeanEst(Period=FY2)','TR.PtoEPSMeanEst(Period=FY3)','TR.PtoEPSMeanEst(Period=FY4)'])I get a different result for the FY1:
Instrument Price / EPS (Mean Estimate)
0 AAPL.OQ 19.21973
1 AAPL.OQ 16.823317
2 AAPL.OQ 15.606444
3 AAPL.OQ 17.793991
And finally if i check the DIB i get yet another result for the first year 19.2277:
There seems to be a wrong result in the value of 12.18 since AAPL hasnt had that PE ratio in a very long time. What is wrong? Did i use an incorrect query?
If i do the same operations for EBITMean, the API results are aligned. Thanks in advance for your help. Best regards
