For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
25 2 7 10

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:


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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythondatadata-item-browser
1572605964255.png (55.6 KiB)
1572606240289.png (78.2 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
18k 21 12 20

Hi @ant1bball

I believe that this is the equivalent call:


ahs.png (30.4 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea