Extend dseries constructor for Excel files
Users want to load data from an Excle file by specifying sheet name and rang. I suggest to introduce the following syntax:
dseries(FILENAME, OPTION_NAME_1, OPTION_VALUE_1, OPTION_NAME_2, OPTION_VALUE_2,...)
The new options would be xls_sheet
and xls_range
as for Dynare estimation
command
It would be good to also introduce option names for the existing options: initial_dates
, range_of_dates
, list_of_names
(or, better, variable_names
), tex_names
(or better variable_tex_names
)
and permit the syntax
dseries(DATA_MATRIX, OPTION_NAME_1, OPTION_VALUE_1, OPTION_NAME_2, OPTION_VALUE_2,...)
Note that we can distinguish between the existing constructors and the new proposed ones as the second argument is a date
in the existing constructor and a char array
or string
in the new one