Excel import - dates problem

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

olkuznet
Posts: 1
Joined: Wed Oct 29, 2008 4:01 am

Excel import - dates problem

Postby olkuznet » Thu Aug 27, 2009 1:38 am

Hi!
My Excel file is irregular time sereis, but mostly on weekly basis. When I open it in Eviews and set workfile structure type as dated, -specified by date series - I got Eviews dates shifted by 4 days back (i.e. it was 15/03/2002 in Excel and became 11/03/2002 in Eviews). Why? How to avoid this?
px.wf1
(16.89 KiB) Downloaded 405 times
thanks,
Olga

EViews Glenn
EViews Developer
Posts: 2682
Joined: Wed Oct 15, 2008 9:17 am

Re: Excel import - dates problem

Postby EViews Glenn » Thu Aug 27, 2009 9:31 am

The dates in your Excel sheet appear to be Fridays. EViews 6 identifies weekly data using the Monday of the week in question. Hence the shift by 4 days.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests