How to get a point in time (vintage) data from a forecast series?
I need to get a vintage data (point in time) for a time series with a forecast. For instance, consider the Datastream ticker (USLGDPQMQ) or alternatively the RIC (pUSGDPQP=M).
If I use the function 'timeSeriesRequest' I can use the 'RELV' datatype and I will get the time series 'as of' the 'endDate' parameter used (vintage, point in time). This works fine for all standard time series, but *not* for the ones with forecast.
If I want to see the forecasts, I need to put 'endDate' into the future. This works fine If I want to get the current snapshot (the latest) forecast. Say I will get today's forecast from now until December 2022. However, this does not work if I want to see what were those same forecasts 3 months ago. The reason is that, in order to get point in time I need to set the 'endDate' to 3 months ago and the parameter 'RELV'. But doing that prevents me from getting the forecast going to Dec 2022.
So the question is: how do I get a point in time time series of a forecast?
Thanks in advance for any help.
Best Answer
-
@pgrahl
Using Eikon you can only get one value per quarter for the economic forecast RIC like pUSGDPQP=M.ek.get_timeseries('pUSGDPQP=M', interval='quarterly',
start_date='2018-01-01', end_date='2023-01-01')In other words, using Eikon you cannot see how the forecast for say Q4 2020 changed over time. I defer to someone else to comment on whether the timeseries of forecasts for a given quarter are available in Datastream.
1
Answers
-
Thanks @Alex Putkov.
This information ('how the forecast changed over time') is available at Eikon/REfinitiv/Datastream database. At Eikon, one can go to a page, look at the forecast evolution and download an excel file with the forecast's evolution.
So the information is indeed availabel. Unfortunately, the excel file does not contain any formula that could provide any hint on how to use any APIs to get the same information.
How do I escalate this question to the proper person?
I have tried the 'formal' EIkon support chat but they directed me to the "developer community"...
Any help on how to get to the answer would be appreciated.Thanks
0 -
@pgrahl
The rule of the thumb is if a data item can be retrieved using a worksheet function in Excel, it can also be retrieved using Eikon APIs and vice versa. Refinitiv Helpdesk is fully equipped to research the data model for any data item available through Eikon and advise you on how to retrieve it into Excel. However, they're not fully versed in APIs, which is why they sometimes may refer you to Refinitiv Developer Portal. In this case what would be helpful is to figure out how to retrieve the data you're after using a worksheet function in Excel, which can then be easily translated into an API call.
I opened case 09454683 on your behalf with Refinitiv Helpdesk to research how the data you're interested in can be retrieved into Excel. The Helpdesk will reach out to you with the answer or if they need any clarification.0 -
I've got feedback from all sides saying that it is not possible to obtain the full history of a specific forecast point.
However, see above the print out from an excel file downloaded directly from Eikon. It clearly shows that the information *do exist* somewhere in the Eikon/Datastream/Refinitiv database.
Unfortunately, the excel file comes with 'paste values' so there is no formula hinting how to access that information.Thanks @Alex Putkov. for your previous help in trying to get this info.
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 中文论坛