Linking Excel with eviews

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

sreeja.gupta
Posts: 8
Joined: Mon Aug 19, 2013 3:23 am

Linking Excel with eviews

Postby sreeja.gupta » Mon Aug 19, 2013 3:33 am

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

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

Re: Linking Excel with eviews

Postby EViews Gareth » Mon Aug 19, 2013 7:43 am

It cannot be done automatically.

sreeja.gupta
Posts: 8
Joined: Mon Aug 19, 2013 3:23 am

Re: Linking Excel with eviews

Postby sreeja.gupta » Tue Sep 03, 2013 7:06 am

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?

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Linking Excel with eviews

Postby EViews Steve » Tue Sep 03, 2013 7:36 am

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

valeria
Posts: 4
Joined: Fri Jun 21, 2013 1:17 am

Re: Linking Excel with eviews

Postby valeria » Wed Apr 16, 2014 1:49 am

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

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

Re: Linking Excel with eviews

Postby EViews Gareth » Wed Apr 16, 2014 8:55 am

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests