EViews.com

Hi

I am trying to update series which were previously loaded to incorporate new information in that series. My seires were originally imported straight from excel and that is where I update the series. Is there a method to update my current series in eViews with the new information. I would be rerunning the calcs off the information at least quartely and I would like to know the best way to do this

Thanks in advance for the help

Hi Lauren:

There are several ways to do this:

1. You can drag and drop the Excel file directly onto EViews (i assume you have EViews 6 or newer). Once imported to a new workfile, you can copy and paste the objects you want to your current workfile.

2. You can also open your current workfile and call the import command:
3. If you have EViews 7, you can also use the EViews COM Automation interface to launch EViews and push the data from Excel to EViews using the Visual Basic for Applications (VBA) language built into Excel. See our whitepaper for examples on how to do this.

Steve