Excel import - dates in columns

[javiersan]

Hi,

I have an Excel file which has dates in the first column and the variables in rows, is there a way of specifying in EViews that the first line of the file is the date information?

See for example the file attached.

test.xls

(37 KiB) Downloaded 502 times

Thanks for your help.

Javier

[EViews Gareth]

Not with WFOPEN, but there is the "t" option with the READ command. However, in your case I think the READ command probably still won't work since your columns are "backwards" (i..e you have the latest date on the left, and the earliest date on the right).

It might be best to just transpose the data in Excel.

[EViews Gareth]

With some EViews magic, you can get the data in via WFOPEN:

Code: Select all

wfopen test.xls pagestack _? d id02 pageunstack series01 id01 pagestruct @date(id01) d _ series01 id01 rename _* * pagedelete test pagedelete test_stk

Pretty messy though...

[javiersan]

Thanks for taking the time to write the program. I have managed to work with the "read" command with "t" option and some previous work in Excel.

Regards,

Javier