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 365 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