Retrieving guidance data: Missing observations when using the Eikon API
I downloaded a sample file with IBES Guidance data from Wharton Research Data Services (WRDS). Please find this file attached (Adobe Sample). It appears that the data which is used to create these files are also available in Refinitiv Eikon/Workspace.
Goal: For a given equity, I want to retrieve every guidance that was published in a certain time period (e.g., 2009-2020), including quarterly and annual guidances.
Example code using Adobe:
df, err = ek.get_data(
instruments = ['ADBE.O'],
fields = [
'TR.EstGuidLowValue(Period=FQ1,Frq=FQ,SDate=2009-01-01,GuidEstMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidHighValue(Period=FQ1,Frq=FQ,SDate=2009-01-01,GuidEstMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidMeanAtDate(Period=FQ1,Frq=FQ,SDate=2009-01-01,GuidEstMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidDate(Period=FQ1,Frq=FQ,SDate=2009-01-01,GuidEstMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidValueDescriptor(SDate=2009-01-01,Period=FQ1,Frq=FQ,GuidMeasure=EPS,GuidEstMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidCompGuidMeasureCode(SDate=2009-01-01,Period=FQ1,Frq=FQ,GuidEstMeasure=EPS,GuidMeasure=EPS,EDate=2021-01-31)',
'TR.GuidanceDocType(SDate=2009-01-01,Period=FQ1,Frq=FQ,GuidMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidPeriodYear(SDate=2009-01-01,Period=FQ1,Frq=FQ,GuidMeasure=EPS,EDate=2021-01-31)',
'TR.EstGuidPeriodMon(SDate=2009-01-01,Period=FQ1,Frq=FQ,GuidMeasure=EPS,EDate=2021-01-31)'
]
)
display(df)
It seems that using the API, there are guidance observations missing. The first one in the sample file was announced on March 4th 2009 (EPS range from 0.44 - 0,45) and the second is from March 17th 2009 (EPS 0.31 - 0.38). The first one from March 4th is missing when retrieving the data using the code above though.
Likewise, according to the sample file (as well as Adobe's press release from that day) the firm reconfirmed its guidance on October 7th 2009. This entry is also missing using the API approach (as well as some others). Any ideas why this might be the case and how to fix it?
According to the IBES Guidance user guide p.28ff. (attached) the "Guidance relative to consensus" variable indicates whether a guidance beats (02), matches (03) or falls short (01) of analysts consensus (06 is assigned to management guidance but I don't really understand what this means yet). The approach described on p. 28 ff. to create this variable is quite time consuming. Is there an option to extract this data using the API or is there some postprocessing required?
Finally, I the code above will only extract quarterly earnings guidances. (see September 20th 2011 for example). Is there an option to include both - quarterly AND annual guidance - as well as those where the company doesn't provide an upper boundary?
Thank you!
Best Answer
-
Hi @flammers ,
As mentioned by my colleagues, to be of
help, I have opened a support case on your behalf, 11987043, please expect an Eikon support expert to reach
out to you shortly, via the email address that you have registered on the developers
portal.0
Answers
-
-
Hi Team Developer Community check the above request, this has been pending for many days without any response or answer, Please reply ASAP.0
-
As mentioned by my colleague, it is a content question. Please contact the Helpdesk directly. The helpdesk can explain the retrieved content.
You can ask for the @TR parameters in Eikon Excel that can be used to retrieve the required data. Then, the same formula can be used with the get_data method.
0 -
Hi,
I already received an answer to my question from one of your colleagues some days ago:
He confirms that Guidance data view and history that can be retrieved via desktop and the API (or Excel) is limited to 5 years. The fact that more history is available via API (or Excel) is a bug and there is a plan to align the views (desktop) with API in 2023 to 5 years.
Thank you!
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛