Page 1 of 1
Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 1:03 pm
by petital
Hey guys,
Here's a view of my Excel file:
So as you can see it, the first column is 1921 different dates plus header and the 15 columns that follow are time series (1921 + header).
I'm trying to import it as time series in EViews with the programming command wfopen but I get weird things instead.
I just want my 15 time series with dates corresponding to my first column. :/
Can anyone help me on this? Thanks! :)
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 1:18 pm
by startz
Try adding the option type=excel
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 1:41 pm
by petital
Hey startz, I tried it but I get weird series like dates. For example for the series CAC40 I get "3897-02-06" instead of "3897.37" for the date of 7/01/2002. I
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 2:11 pm
by EViews Gareth
Can you post the Excel file?
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 2:47 pm
by petital
Here it is.
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 3:04 pm
by startz
I can confirm the problem. As a temporary measure, you might save the Excel file as an Excel 2007 file and then read it in. CAC40 comes in as an alpha. Note also that your original file indicates formatting errors in many cells.
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 3:21 pm
by EViews Gareth
As Startz notes, there are formatting issues with your Excel file - all of your numbers are stored as text. If you fix that in Excel, you'll then be able to bring them into EViews successfully.
Re: Import Excel time series into EViews (programming command)
Posted: Sun Mar 07, 2010 4:11 pm
by petital
Thank you! Actually I thought that I had to change "," in "." in my Excel file so that my data would be readable by EViews, it works well now. Cheers!
Re: Import Excel time series into EViews (programming comman
Posted: Tue Apr 23, 2013 10:41 pm
by hasanthi
I can confirm the problem. As a temporary measure, you might save the Excel file as an Excel 2007 file and then read it in. CAC40 comes in as an alpha. Note also that your original file indicates formatting errors in many cells.
Plz help.
Can't we import data in xlx format into eviews 7.
plz explain me the programming code
Re: Import Excel time series into EViews (programming comman
Posted: Wed Apr 24, 2013 7:40 am
by EViews Gareth
Re: Import Excel time series into EViews (programming comman
Posted: Tue May 07, 2013 2:04 am
by hasanthi
thanks a lot for the reply
Re: Import Excel time series into EViews (programming comman
Posted: Tue Jun 18, 2013 6:06 am
by vytama
Good morning,
I was reading this forum and trying to get the answer why import command does not work for me. I am trying to import this: import C:\TEMP\LF rate.xlsx and I get an error message - c:\temp\lf.wf1 not found on the disk. I also ran @fileexist to see if eview recognizes this file - and it does by returning 1. I even tried to specify the type=excel, no difference. Can you help me to figure out what I am missing or doing wrong? Thank you. Vytas
Re: Import Excel time series into EViews (programming comman
Posted: Tue Jun 18, 2013 6:20 am
by EViews Gareth
Put the path\filename in quotes.