Individual estimates not matching series

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:

image

image

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

Best Answer

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.