Page 1 of 1

xlsx to EViews

Posted: Sun Jul 29, 2018 7:16 am
by ecofin
Hi everybody
1/I have xlsx file named exchange_rate with three sheets named ( USD_DZD, EURO_DZD, GBP_DZD) from 01/01/2008 to 20/07/2018 every sheet have six columns (Date, Price, Open, Hight, Low, Change) and 2769 rows.
How can import the three sheets directly in my workfile with the three pages?. (all the sheets in the same time).

2/Suppose now i have three sheets named USD_DZD, EURO_DZD, GBP_DZD, every sheet have six columns:
sheet1 named: USD_DZD with six columns (Date, Price1, Open1, Hight1, Low1, Change1)
sheet2 named: EURO_DZD with six columns(Date, Price2, Open2, Hight2, Low2, Change2)
sheet3 named: GBP_DZD with six columns (Date, Price3, Open3, Hight3, Low3, Change3)
date (from 01/01/2008 to 20/07/2018)
How can import the three sheets in the same page in my workfile? (my workfile should contain 16 series.)
and happy holidays for everyone. :)

Re: xlsx to EViews

Posted: Sun Jul 29, 2018 11:56 am
by EViews Gareth
Drag the Excel file onto EViews. On the first tab of the Excel import dialog, specify which sheet you want. You'll have to do it once for each sheet.

Re: xlsx to EViews

Posted: Sun Jul 29, 2018 12:52 pm
by ecofin
Oups! i missed this idea (Drag the Excel file onto EViews...etc), Thank you so much.