Bloomberg Date oddness

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

Redwing153
Posts: 30
Joined: Sat May 30, 2015 5:10 am

Bloomberg Date oddness

Postby Redwing153 » Wed Jul 06, 2016 7:33 am

Hello
I'm using Enterprise 9.5 April 5 2016 build

I have a problem representing dates using Bloomberg data
Whenever I try to reference the observation date, eviews is returning the wrong date.

In this example (attached) the formula @date(spx) is missing a large number of days from the start of the series, which is in a dated workfile using a 5 day specification. The result is a date mismatch and a large number of NAs at the end of the series. I get the same problem using other formulae when trying the reference the observation date.

Thanks.
Attachments
Bloomberg error.jpg
Bloomberg error.jpg (282.1 KiB) Viewed 3653 times

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Bloomberg Date oddness

Postby EViews Jason » Wed Jul 06, 2016 8:27 am

The @date function does not return the dates associated with the observation from the original source (Bloomberg in this case). If you think of @date as a series, @date(series) returns the lead or lag of the @date series depending on the value of series.

If SPX came from the Bloomberg, the observations have already been match merged for you.

If you want the date series of your workfile, use

Code: Select all

series date = @date


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests