TS Research Group : Software Products


		по русски \| in english

Overview Research Download Order

eSignal Solutions:
· Wavelet Transform for eSignal

Rocket Science Trading Tools:
· Genetic Optimizer for TradeStation

Portfolio Money Management:
· Real Time Portfolio Analyzer

Research:
Volatility Break

Percent Risk

Optimization of strategy inputs with random exits.

System Trading Tools:
· Wavelet Transform
· TS Link Dll

Research:
Using TS Link. Example of optimal F calculation in TradeStation using Excel.

Automatic System Trading:
· TS Automatic Trader DDE Version

RealTime tools:
· OnDemand Server
· Meta Server RT

Historical tools:
· HistoryCentre for OMZ
· HistoryCentre for XPO
· QLoader for QCharts

Utilities:
. Quotes Genereator DDE Version

Support:
. How to Buy
. Customer support
· Online help
. Download demo
. Ask here
. F.A.Q.

print version

TS Excel Link Dll

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.

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;

Sets name and location of used Excel file
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;

Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
Value that needs to be sent to Excel.
Number of Row in which value from TradeStation will be sent.
Number of Colum in which value from TradeStation will be sent.
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;

Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
Number of Row in which the needed value is located.
Number of Column in which the needed value is located.
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;

Value that needs to be sent to Excel.
Number of Sheet used in Excel beginning from 1 (sheet1 = 1, etc.).
Number of Row in which the value from TradeStation will be sent.
Number of Column in which the value from TradeStation will be sent.
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;

Number of used sheet in Excel beginning from 1 (sheet1 = 1, etc.).
Number of Row in which the needed value is located.
Number of Column in which the neede value is located.
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

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");

Home | Contacts | Site Map | Disclaimer | Privacy Statement