EPS Estimates Don't Align with Analyst Name or Analyst Code

Hi. I am trying to pull the EPS estimates, associated Broker Name, Analyst Name, Analyst Code, and Estimate Date for a variety of tickers and variety of dates that span between 1989 and the present. I have provided sample code below for pulling for a single ticker from 1989. Some of the values are <NA> for the EPS estimate, Broker Name, Analyst Name and so on. The problem I am having is that the <NA> values are being sorted to the bottom of the output misaligning the data across the rows (i.e. the EPS Estimate does not line up with the right Broker name which doesn't match the right Analyst Name, which doesn't match the right Analyst Code,...). Is there an additional parameter I am missing to make these align? I am using the refinitiv API with python on Windows.
import refinitiv.data as rd
print("Opening Refinitiv session...")
rd.open_session()
data = rd.get_data( ['AXXN.O^J92'], ['TR.EPSEstValue','TR.EPSEstValue.BrokerName','TR.EPSEstValue.analystname','TR.EPSEstValue.Analystcode','TR.EPSEstValue.date'], parameters={'frq': 'FQ', 'Period': '1FQ1989', 'CURN':'USD', 'Sdate':'1987-01-01', 'Edate':'1990-12-31'} )
print(data)
rd.close_session()
Best Answer
-
Thank you for reaching out to us.
I got the following output when using the platform.rdp session.
However, the output is correct when using the desktop.workspace session.
Please confirm that you are using the platform.rdp session.
Otherwise, please also check the version of RD library.
rd.__version__
I am using 1.3.1.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 250 ETA
- 555 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛