Getting a Fixed Value Rom an Excel Sheet in Tradestation Strategy

[vt2009 10]

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 20]

you have to give more info

[vt2009 10]

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;