Page 1 of 1

pageupdate on Excel - dates / smpl options

Posted: Mon Apr 04, 2016 3:03 am
by loulouviews
Hi,

I'm willing to update an excel sheet with new data.
I have two questions :
- How can I have EViews writing dates as in the `write` command, ie "1990M01" instead of 32874.
- How can I restrict the sample ? writing something like `smpl 2014 2016`before the `pagesave` command is unfortunately not working (where as working like a charm for the `write` command).

Thanks

Loulouviews

Re: pageupdate on Excel - dates / smpl options

Posted: Mon Apr 04, 2016 7:19 am
by EViews Gareth
If you want the dates written in a specific string format rather than as an Excel date, you'll have to create an alpha series with that string format using the @datestr command.

The wfsave command has an @smpl argument that lets you specify the sample.