question

Upvotes
1 0 0 1

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.

datadatastream-apidsws-apifundamental-dataeviews
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1.1k 3 3 3

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

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!

Upvotes
1 0 0 1

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)

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea