Importing data from Excel that updates daily

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

Samsonian
Posts: 1
Joined: Fri Sep 03, 2010 5:02 am

Importing data from Excel that updates daily

Postby Samsonian » Fri Sep 03, 2010 5:24 am

Can anyone help me with importing data from Excel please? I have got data in Excel that updates daily and I want to find a way of loading it into EViews such that it refreshes to include the most recent observation automatically, rather than having to upload a new file each time just to get the extra day's worth of information. There must be a way of doing this but I just can't get to the bottom of it - can you tell me either how to do it or which is the relevant part of the manuals? Thanks.

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

Re: Importing data from Excel that updates daily

Postby EViews Gareth » Fri Sep 03, 2010 7:30 am

You'll have to write a program that imports the data (using the import command) into your workfile. Then each day you can run that program.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests