[vt2009]

I have a strategy that needs to get a risk value from my excel sheet- I tried to used ELXL addon but could not get the program to work correctly. What are fast methods to get data from .csv or .xls file?

[Tams]

you have to give more info

[vt2009]

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("FuturesBigL ist.xls"),
string WorksheetName("FeatureLis t");
var:bool WorksheetReady(false);
var:bool XLStarted(false);

XLStarted=ELXL_Initialize ;
If XLStarted then
begin
WorksheetReady=ELXL_WithS heet(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(Getr ow,1,oStringVal);
ExcelSymbol= oStringVal;
print("ExcelSymbol", Excelsymbol);
If ExcelSymbol=Instrument then begin
getrtn= ElXL_GetCellNumberRC(Getr ow,12,oNumvar);
Margin$=oNumvar;
print("GetRow",Getrow);
print("margin$",margin$);
end;
end;
end;
end;