New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
25 3 12 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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidatadata-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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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