Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by pgrahl · Dec 07, 2020 at 11:01 PM · apipoint in timeforecastvintage data

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.

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Dec 08, 2020 at 02:15 AM

@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.

Comment
pgrahl

People who like this

1 Show 2 · 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
pgrahl · Dec 14, 2020 at 12:57 PM 0
Share

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


avatar image
REFINITIV
Alex Putkov. ♦♦ pgrahl · Dec 14, 2020 at 04:29 PM 0
Share

@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.

avatar image
Answer by pgrahl · Dec 31, 2020 at 02:52 PM

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.


economic-indicator-poll.png (82.0 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.

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 >
11 People are following this question.

Related Questions

DSWS API - What is the pricing for this method of accessing the data?

Retrieve Datastream data when we only subscribe to Eikon

Cannot make sense of dataframe format returned by Python datastream API PyDSWS

Datastream Data availaible via Excel Request-Table - But not via R-API

I can access DSWS via Excel but not via DatastreamDSWS2R

  • 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