Import data from excel plus freq conversion in Eviews9

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

TM_Berlin
Posts: 3
Joined: Wed Sep 07, 2016 7:03 am

Import data from excel plus freq conversion in Eviews9

Postby TM_Berlin » Wed Sep 07, 2016 7:08 am

Hi,

I've been using the following command successfully in Eviews 8 for importing daily data from an xlsm excel sheet into an Eviews workfile with quarterly data. The frequency conversion needs to be maximum per quarter:

import(c=x) c:\filename.xlsm range="sheet1" namepos=last @freq d5 1990

Since upgrading to Eviews 9, I get the following error message: "Unrecognized contraction option"

Any idea?

thanks
thomas

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import data from excel plus freq conversion in Eviews9

Postby EViews Gareth » Wed Sep 07, 2016 7:54 am

What's the build date of your copy of EV9? (Help->About EViews)

TM_Berlin
Posts: 3
Joined: Wed Sep 07, 2016 7:03 am

Re: Import data from excel plus freq conversion in Eviews9

Postby TM_Berlin » Wed Sep 07, 2016 8:08 am

Hi Gareth, I'm using Enterprise Edition Build Jun 8 2015

cheers
tm

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import data from excel plus freq conversion in Eviews9

Postby EViews Gareth » Wed Sep 07, 2016 8:20 am

Please update to the latest version.

TM_Berlin
Posts: 3
Joined: Wed Sep 07, 2016 7:03 am

Re: Import data from excel plus freq conversion in Eviews9

Postby TM_Berlin » Thu Sep 08, 2016 7:03 am

Hi Gareth,

I've upgraded to 9.5. Problem solved.

Thanks
tm


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests