Exporting to existing excel file

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

Re: Exporting to existing excel file

Postby trainee » Wed Jul 26, 2017 5:44 am

Thanks Steve. This worked: wfsave(type=excel, mode=update) tracking.xls range=weights!a2 @keep wt_gmfm_us_t @smpl 2014Q3 2017Q2

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

Re: Exporting to existing excel file

Postby trainee » Wed Jul 26, 2017 2:47 pm

Hi Steve,

The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?

Thanks.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11260
Joined: Tue Sep 16, 2008 5:38 pm

Re: Exporting to existing excel file

Postby EViews Gareth » Wed Jul 26, 2017 2:50 pm

Create an alpha series in the workfile that has the date with the date format you want (use @datestr(@date, "YYYYQQ")). Then save that with the other series.
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: Bing [Bot] and 7 guests