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 erik.franco · May 28, 2019 at 01:44 PM · datastreamdata download api issueeviewsdownloading fundamental data

Fetching daily data into a monthly workfile in eviews does not give me the latest value

In the new datastream online database. I am downloading LCPCASH into a monthly workfile: fetch(d=datastream,c=l) LCPCASH. The value being downloaded for May does not correspond to yesterday's close.

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
Answer by Monika.Stankovic · Jun 05, 2019 at 06:19 AM

Hi @erik.franco,

This is normal behavior of this type of requests. Datastream takes the data for this current start date (e.g. 1st Jan) and then values of 1st of Jan day of each next month are visible as monthly results.

Comment

People who like this

0 Show 1 · 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
MichaelQIU · May 26, 2020 at 08:02 AM 0
Share

with all respect, but this is highly problematic; i have also noted that the fetch is fully insensitive if one is fetching data via last, or first, or first excluding uncomplete months, etc... datastream will always return just the first value of the month... this is clearly a bug!

avatar image
Answer by erik.franco · Jun 05, 2019 at 08:38 AM

Hi Monika,

The bug I reported was in eviews. The (c=l) function is supposed to return the last day of the month or the most recent data point.

Below is the eviews code I used to retrieve the data, and the output.

-----------------------------------------

wfcreate(wf = "", page = "monthly") m 2019 2019

fetch(d=datastream,c=l) S&Pcomp(pi)

----------------------------------------------------

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.

Related Questions

Can I request an access ID to Datastream Web Service (DSWS) ?

How to desactivate Datastream auto calculation in VBA ?

Datastream what field to use for market capitalisation

Connecting using Python

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

  • 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