Excel -> Eviews variable update

[tim_b]

I have a set of regular dated time series models in Eviews 7 that I have to update on a regular basis and I am wondering what the most efficient update mechanism is. I see the data for the models coming from 2 sources a) a general data source of seasonality variables (e.g. temperature, dummies for each month, christmas etc.) and economic indices (e.g. inflation) and b) a model specific data source containing weekly/monthly "sales" data. I am happy that Excel should handle processing the data but I would like to know what is the best way of passing the data into EViews in such a way that I can extend the existing models. Ideally I would have 2 excel files/sheets which are then aggregated in the EViews work file. When either source is updated in Excel the workfile is also updated with the extra time points so I can just go in an extend the models. I have briefly investigated passing data to and from Excel with the COM add-in and looked at the EViews database functionality but I am unclear what role if any these should take.
Thanks in advance.

[EViews Gareth]

To be honest, the best/easiest thing to do would be write a program that just imports (either with WFOPEN or IMPORT) the Excel files into an EViews workfile. Then each time the Excel files are updated, re-run the EViews program.


As an aside, I'm going to have to ask you to choose a new user-name. User-names with the "EViews" prefix are reserved for EViews employees. Let me know what you'd like to change it to, and I'll change it (or I'll choose one at random).

[tim_b]

To be honest, the best/easiest thing to do would be write a program that just imports (either with WFOPEN or IMPORT) the Excel files into an EViews workfile. Then each time the Excel files are updated, re-run the EViews program.

Thanks, if I follow that approach will I also be able to get/copy the equations into the workfile and will EViews automatically handle aggregating the data e.g. if one source goes up to 25th July and the second source goes up to 1st August?

[EViews Gareth]

Yep.