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
Petya avatar image
1 ●1 ●1 ●1

Retrieving information about EPS forecasts for all analysts over the past 10 years

Dear Refinitiv,

I would like to retrieve information about all EPS estimates (for FY1) issued over the past 10 years by all financial analysts for a certain company. Using the Eikon API in Python, I run the following codes:

df, err=ek.get_data(['GOOG.O'],

['TR.EPSEstValue.date', 'TR.EPSEstValue()'],

{'SDate':'2017-01-01', 'EDate': '2018-01-01', 'Period':'FY1'})

Unfortunately, there is no outcome with valid observations.



InstrumentDateEarnings Per Share - Broker Estimate0GOOG.O2017-10-23T15:57:00ZNaN1GOOG.O2017-10-23T15:57:00ZNaN2GOOG.O2017-10-23T15:57:00ZNaN3GOOG.O2017-10-23T15:57:00ZNaN


Can you please help me by pointing out the mistake in my codes: I would like to have something similar to the details analyst template but over several years (always Period FY1)

An example follows: broker, analysts, EPS, date - over multiple periods

ARGUS RESEARCH CORPORATIONBonner, Joseph F5,5125/10/2019ATLANTIC EQUITIESCordwell, James P5,4024/10/2019CLEVELAND RESEARCHTerjanian, Ari5,4608/11/2019
ARGUS RESEARCH CORPORATIONBonner, Joseph F5,0025/10/2010ATLANTIC EQUITIESCordwell, James P5,0524/10/2010CLEVELAND RESEARCHTerjanian, Ari5,1008/11/2010





Thank you,

Petya

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apidata
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.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @Petya

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

5 Answers

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @Petya

df=df.dropna() is a code to remove record with NaN value.

If you comment this line out, you get the data back to 2016 but all of them are NaN.

I cannot answer why the data is NaN.

Please contact Refinitiv Content Helpdesk at https://my.refinitiv.com/ to get support on the data point.

Helpdesk can guide you to configure the parameter according to your requirement on "Data Item Browser"



ahs.png (80.1 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.

Upvotes
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @Petya

I think you have to add Frq too.


ahs.png (37.9 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.

Upvotes
Petya avatar image
1 ●1 ●1 ●1

Thank you very much, Chavalit! Have a nice weekend!

Best,

Petya

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.

Upvotes
Petya avatar image
1 ●1 ●1 ●1

Dear Chavalit,

I tired your solution and saw that it doesn't retrieve all EPS over the past years. It just lists the ones for the most recent year. I changed the year extending it back to 2000 and it doesn't list any EPS forecasts other than the ones for FY2017. Can you please help me by suggesting how to modify the codes. I need historical data. Thanks!


1574581793523.png (263.1 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.

Upvotes
Petya avatar image
1 ●1 ●1 ●1

Thank you Chavalit! Best, Petya

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.