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.
Bloomberg Date oddness
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
Redwing153
- Posts: 30
- Joined: Sat May 30, 2015 5:10 am
Bloomberg Date oddness
- Attachments
-
- 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
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
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 = @dateWho is online
Users browsing this forum: No registered users and 2 guests
