EViews.com

Hello to everyone!

I have a code that imports time series data from Excel files and then stores them to the database. However, i have a question about how does EViews merge the data. If for example, when I have updated the data in Excel and by chance made a mistake in the historical part, will EViews "update" that mistake as well? Or does it just leave the historical data untouched in the database and adds only the most recent data update?

Thank you!

It depends upon which options you use when doing the import and store.

It depends upon which options you use when doing the import and store.

The code for import is just the following When I store the data I use the following:

If possible, you should use the IMPORT command rather than the READ command. The IMPORT command offers merging options.

By default the STORE command will only over-write values that exist in the workfile series. Any values in the database that do not exist in the workfile will be left alone. The "o" option changes this.

Dear NurfatimaD,

Can you please post the entire code (or email me)?
I am looking for a simple way to update series inside Eviews, and I think your method is very good. It would be awesome to auto-update via excel.

Thanks,

Agandini