Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by Petya · Nov 22, 2019 at 06:31 PM · financial analysts

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · Nov 25, 2019 at 10:35 AM

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)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by chavalit.jintamalit · Nov 23, 2019 at 06:39 PM

Hi @Petya

I think you have to add Frq too.


ahs.png (37.9 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by Petya · Nov 24, 2019 at 07:42 AM

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

Best,

Petya

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by Petya · Nov 24, 2019 at 07:51 AM

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)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by Petya · Nov 25, 2019 at 05:44 PM

Thank you Chavalit! Best, Petya

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.
  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges