Updating series in the database

[NurfatimaD]

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!

[EViews Gareth]

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

[NurfatimaD]

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

The code for import is just the following

Code: Select all

read(first data cell, s=sheet name,t if need to view series in rows) "path to the excel file" the number of series to read

When I store the data I use the following:

Code: Select all

store(d="path to the database", 2) the name of the series to store

[EViews Gareth]

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.

[agandini]

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