Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

vt2009

Members
  • Content Count

    2
  • Joined

  • Last visited

Everything posted by vt2009

  1. 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;
  2. 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?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.