I am trying to set up an excel file as an fmt file.
I use the steps below and the file appears created in my folder.
new; fname = "investment2.xls"; range = "A1:D8475"; sheet = 1; investment2= spreadSheetReadM(fname, range, sheet); print investment2; save investment2; load investment2; save investment.fmt=investment2; end;
However, when I try to run my regression using the file I get the error:
G:\temp\temp2\invest03.prg(28) : error G0058 : Index out of range
Any help please?
Not sure why, but I switched from Gauss 10 to 13 and all seemed to be working fine now!