Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
ant1bball avatar image
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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-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.

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

@ant1bball

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
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.