Excel import: Identifying number of series

[elias41]

Hi,

What are the commands to count the number of imported time series from an excel file?


Best regards,
Elias

[EViews Gareth]

That's actually pretty tricky. If you're not doing a merged import (i.e. over-writing existing series), then something like:

Code: Select all

group g1 * !countbefore = g1.@count import myfile.xls group g2 * !countafter = g2.@count !imported = !countafter - !countbefore

[elias41]

Many thanks.