Page 1 of 1

Excel import - dates problem

Posted: Thu Aug 27, 2009 1:38 am
by olkuznet
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 407 times
thanks,
Olga

Re: Excel import - dates problem

Posted: Thu Aug 27, 2009 9:31 am
by EViews Glenn
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.