Import Excel time series into EViews (programming command)

[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! :)

[startz]

Try adding the option type=excel

Code: Select all

wfopen(type=excel) filename

[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

[EViews Gareth]

Can you post the Excel file?

[petital]

Here it is.

[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.

[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.

[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!

[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

[EViews Gareth]

Yes.

Code: Select all

import myfile.xlsx

[hasanthi]

thanks a lot for the reply

[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

[EViews Gareth]

Put the path\filename in quotes.