TS Research Group : Software Products > Overview www.tsresearchgroup.com
TS Excel Link Dll

portfolio Dll module for data exchange between TradeStation (TradeStation Group, Inc.) and MS Excel.

Dll Add-on module for TradeStation allows to develop trading strategies, indicators, analyze results of trading, use add-ons of other applications and send orders to brokers by using wide range of Excel possibilities in real time.

| Download demo| How to Buy| Ask here| F.A.Q.| Online Help|

Different versions of TS Excel Link Dll

 

TS Excel Link Dll Demo

TS Excel Link Dll for TradeStation

Function: TS_StartExcel

Initializes and opens file of Excel

Yes

Yes

Function: TS_SetValue

Sets the value from TradeStation in Excel

Yes

Yes

Function: TS_GetValue

Gets the value from Excel and sets it in TradeStation

Yes

Yes

Function: TS_SetString

Sets the String from TradeStation in Excel

Yes

Yes

Function: TS_GetString

Gets the String in Excel and sets it in TradeStation

Yes

Yes

Sending data and reading data from different pages from Excel

No

Yes

Number of available cells for data exchange

1

Not Limited

Number of available cells to get values

1

Not Limited

Work in Real Time

Yes

Yes

Description of function tslink.dll

Function "TS_StartExcel"

Initializes and opens Excel file

defineDLLFunc: "tslink.dll", int, "TS_StartExcel",LPSTR, LPSTR;

  1. Sets name and location of used Excel file
  2. Sets name of Excel file.

Function "TS_SetValue"

Sets value from TradeStation in Excel

defineDLLFunc: "tslink.dll", int, "TS_SetValue",float,int,int,int,int;

  1. Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
  2. Value that needs to be sent to Excel.
  3. Number of Row in which value from TradeStation will be sent.
  4. Number of Colum in which value from TradeStation will be sent.
  5. Delay in miliseconds after value is sent to Excel.

Function "TS_GetValue"

Gets value from Excel and sends it to TradeStation

defineDLLFunc: "tslink.dll", float, "TS_GetValue",int,int,int,int;

  1. Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
  2. Number of Row in which the needed value is located.
  3. Number of Column in which the needed value is located.
  4. Delay in miliseconds after value is got from Excel.

Function " TS_SetString"

Sets the Row from TradeStation in Excel

defineDLLFunc: "tslink.dll", int, "TS_SetString",lpstr,int,int,int,int;

  1. Value that needs to be sent to Excel.
  2. Number of Sheet used in Excel beginning from 1 (sheet1 = 1, etc.).
  3. Number of Row in which the value from TradeStation will be sent.
  4. Number of Column in which the value from TradeStation will be sent.
  5. Delay in miliseconds after value is send to Excel.

Function " TS_GetString"

Gets the text from Excel and sends it to TradeStation

defineDLLFunc: "tslink.dll", int, "TS_GetString",int,int,int,int;

  1. Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
  2. Number of Row in which the needed value is located.
  3. Number of Column in which the neede value is located.
  4. Delay in miliseconds before value is got from Excel.

Important !

There are limitations to Demo version of tslink.dll, you can send and get values using the following sheets and cells:

- Sheet ¹ 1 in Excel

- Cell R1C2 for sending data like String (Text) in Excel

- Cell R2C2 for getting data like String (Text) in Excel and sending it to TradeStation.

- Cell R3C2 for sending data like Int in Excel

- Cell R4C2 for getting data like Int from Excel and sending it to TradeStation.

Other parameters of Demo version don’t differ from working version and function in full.

Sample indicator TS_Link(Example):

{*******************************************************************

Description : Trade Smart Research Link DLL for TradeStation (Omega Research)

Used: tslink.dll

Provided By : Trade Smart Research Group (c) Copyright 2001 - 2002

www.tsresearchgroup.com

********************************************************************}

Inputs: Price(close),SetSheet(1),SetRow(3),SetColum(2),GetSheet(1),GetRow(4),GetColum(2);

Var: StartValue(0),SetValue(0), GetValue(0), StrName(""),Str1("");

{Declaration functions}

defineDLLFunc: "tslink.dll", int, "TS_StartExcel",LPSTR,LPSTR; {initalisation excel file 1 - Short BookName, 2 - full path bookname}

defineDLLFunc: "tslink.dll", int, "TS_SetValue",float,int,int,int,int; {value,sheet number, row, column, spleep milisekonds}

defineDLLFunc: "tslink.dll", float, "TS_GetValue",int,int,int,int; {sheet number,row, column, spleep milisekonds}

defineDLLFunc: "tslink.dll", int, "TS_SetString",lpstr,int,int,int,int; {text,sheet number, row, column, spleep milisekonds}

defineDLLFunc: "tslink.dll", lpstr, "TS_GetString",int,int,int,int; {sheet number, row, column, spleep milisekonds}

if currentbar = 1 then begin

If DataCompression = 1 then Str1 = NumToStr(barinterval,0) + "Min";

if DataCompression = 2 then Str1 = "Daily";

if DataCompression = 3 then Str1 = "Weekly";

if DataCompression = 4 then Str1 = "Monthly";

if DataCompression = 5 then Str1 = "P&F";

if DataCompression = 0 then Str1 = NumToStr(barinterval,0) + " " + "Tick";

StrName =GetSymbolName + " " + GetStrategyName + " " + Str1+" ";

StartValue = TS_StartExcel("TSLinkDemo.xls","C:\Program Files\TS Link\TSLinkDemo.xls");

TS_SetString(StrName,SetSheet,1,2,0);

end;

{Call Dll and send and receive to it of the value}

SetValue = TS_SetValue(Price,SetSheet,SetRow,SetColum,0);

GetValue = TS_GetValue(GetSheet,GetRow,GetColum,0);

Plot1(GetValue, "Value");


Copyright © TS Research Group 2002, e-mail: info@tsresearchgroup.com.  Developed by webdesign.tria.lv