EViews.com

Hi,

I am often importing time series data from excel files that are constantly extended (so, new observations become available on a regular frequency).

Is there a way in eviews to import these data without setting the range each time? In other words, can eviews automatically detect the last observation in an excel if I define the location (file, sheet and cell) of the first observation.

Example
import source.xls range="sheet1!B3:B100" @freq M 1985

Currently, I am setting the last observation for each import command manually (in this case "B100) as it changes with each update of the source file. This takes some time especially with many source files.

Many thanks.

No, not for file, sheet, & cell.

However, if the layout of your data on your sheet is simple, and you only have a single group of data on each sheet, you could try and see if EViews will recognize your data range automatically if you only specify the sheet name in the range, like this:
Steve