TS Excel Link's using example: TS.Link.OHLCV
TS.Link.OHLCV, TS.Link.QuoteFields, TS.Link.QuoteFields, TS.LINK.RADAR - Example of indicators for sending data of instrument:
Open, High, Low, Close, Volume and etc. to Excel.
When sending data to Excel on-line on several instruments and if data is
renewed rapidly (for example NASDAQ stocks) you need to keep in mind that
Excel can take a lot of resources of your PC and cause problems.
| EasyLanguage: |
{*******************************************************************
Name: TS.Link.OHLCV
Analysis Type: Indicator
Description : Example Indicator for TS Link DLL
Used: tslink.dll
Provided By : Trade Smart Research (c) Copyright 2001 - 2005
www.tsresearchgroup.com
********************************************************************}
Inputs:
SetSheet(1),
SetBeginRow(1),
SetColum(2),
ExcelFileName("TSLinkExample.xls"),
ExcelFilePath("C:\Program Files\TradeSmart\TS Link\TSLinkExample.xls");
Var: StartValue(0), SetValue(0), SetOpen(0), SetHigh(0), SetLow(0), SetClose(0), SetVolume(0);
SetOpen = Open;
SetHigh = High;
SetLow = Low;
SetClose = Close;
SetVolume = Volume;
{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}
if currentbar = 1 then begin
StartValue = TS_StartExcel(ExcelFileName,ExcelFilePath);
end;
{Call Dll and send to it of the value OHLCV}
If LastBarOnchart Then begin
SetValue = TS_SetValue(SetOpen,SetSheet,SetBeginRow,SetColum,10); {10 miliseconds sleep}
SetValue = TS_SetValue(SetHigh,SetSheet,SetBeginRow+1,SetColum,10);
SetValue = TS_SetValue(SetLow,SetSheet,SetBeginRow+2,SetColum,10);
SetValue = TS_SetValue(SetClose,SetSheet,SetBeginRow+3,SetColum,10);
SetValue = TS_SetValue(SetVolume,SetSheet,SetBeginRow+4,SetColum,10);
End;
Plot1(SetClose, "Close");
{***** Copyright (c) 2001-2005 Trade Smart Research, Ltd. All rights reserved. www.tsresearchgroup.com *****
***** Trade Smart Research reserves the right to modify or overwrite this analysis technique
with each release. *****}
|
|
