Page 1 of 1

Linking Excel with eviews

Posted: Mon Aug 19, 2013 3:33 am
by sreeja.gupta
Hi,

I am looking for a way to link an excel database with eviews such that when I update data in excel, the data series in eviews gets updated as well. How can this be done?

Regards,
Sreeja

Re: Linking Excel with eviews

Posted: Mon Aug 19, 2013 7:43 am
by EViews Gareth
It cannot be done automatically.

Re: Linking Excel with eviews

Posted: Tue Sep 03, 2013 7:06 am
by sreeja.gupta
I have installed an Eviews Add-In in Excel 2010. I am using Eviews 7. However, when I click on "get data" from the eviews add-in I get the following message:

"unable to obtain license: licensing has not been configured on this machine"

However, my eviews is showing as registered correctly with the correct serial number.

Any guesses on what might be the problem?

Re: Linking Excel with eviews

Posted: Tue Sep 03, 2013 7:36 am
by EViews Steve
EViews 7 originally had a problem with licensing the add-in. This was immediately fixed in a patch, so you have just have an older version. Update your copy of EViews 7 with the latest patch (which you can get from our download page here: http://eviewsupdates.s3.amazonaws.com/E ... ate_wz.exe), then you should be able to use the add-in.

Steve

Re: Linking Excel with eviews

Posted: Wed Apr 16, 2014 1:49 am
by valeria
Hi everyone,
I need to import a big dataset in Eviews. My data are available in 15 different Excel files or, entirely, in AREMOS. The problem is that my data are frequently updated by datastream. Is there a way to manage this large quantity of data in a flexible way with respect to the updates? The frequency and the sample range is the same along the different excel files. I read about creating a database instead of a workfile. Is it better for my aim?
Thank you
Valeria

Re: Linking Excel with eviews

Posted: Wed Apr 16, 2014 8:55 am
by EViews Gareth
If they are in Excel or Aremos files, the best thing to do is to write an EViews program that imports the files. Then you can run that EViews program whenever you need to update the data.

Alternatively, you could always link directly from EViews to the Datastream source.