Individual estimates not matching series

ant1bball

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

chavalit-jintamalit

Hi @ant1bball

I believe that this is the equivalent call: