I have an automated Tradestation strategy that needs to get data for each symbol from a spreadsheet I made. I have had problems using ElXL function that is built by Tradestation. I keep getting the error: Workshheet name should not contain extended path information.
The problem is that I dont have the extended path information in the code to begin with so I dont understand this error.
Here is my simple excel code based on the demo:
inputs:
string WorkbookName("FuturesBigList.xls"),
string WorksheetName("FeatureList");
var:bool WorksheetReady(false);
var:bool XLStarted(false);
XLStarted=ELXL_Initialize;
If XLStarted then
begin
WorksheetReady=ELXL_WithSheet(WorkbookName,WorkShe etName);
vars: string Instrument(GetSymbolName);
vars: string ExcelSymbol("");
vars: int GetSheet(1);
vars: int getrow(2);
vars: int getcolum(1);
vars: int RowCounter(2);
Vars:Margin$(1);
vars:double oNumvar(0);
Vars:string oStringVal("");
vars:bool getrtn(false);
If WorksheetReady then begin
For GetRow =2 to 100 begin
RowCounter=getrow;
getrtn= ELXL_GetCellStringRC(Getrow,1,oStringVal);
ExcelSymbol= oStringVal;
print("ExcelSymbol", Excelsymbol);
If ExcelSymbol=Instrument then begin
getrtn= ElXL_GetCellNumberRC(Getrow,12,oNumvar);
Margin$=oNumvar;
print("GetRow",Getrow);
print("margin$",margin$);
end;
end;
end;
end;