workfile range

[lbkova]

Hello All,

Could you help me how I could import an Excel file into Eviews in which the length of the time series changes (grows) every day by 1. When I use the following line: workfile name d 01/01/2006 23/04/2009, the end of the range should change let's say to today's date...

Thank you for your help!

Laszlo

[EViews Gareth]

There are two parts to that question, I suppose.


The first is how should you import the data into EViews. The obvious answer to that is that you should use the wfopen command rather than the read command to get the data into EViews each day, then you don't need to worry about sizing the workfile at all (since it will be done automatically).


If that doesn't do what you want though, to create a workfile up to todays date, use the following command:
workfile name d 01/01/2006 @datestr(@now,"dd/mm/yyyy")

[lbkova]

Hello Gareth,

Thank you for the answer! Then maybe wfopen is my solution (though I like the second one as well). However wfopen brings up a new question for me: how to achieve that the workfile to be imported in shall be updated each day with the relevant data/dates from the Excel...

Best regards,

Laszlo

[EViews Gareth]

I don't follow the question.

[lbkova]

I don't follow the question.

Sorry, I have just realised that I overcomplicated things... Thank you for the answer! I'm sure it will work fine!