| View previous topic :: View next topic |
| Author |
Message |
bennettge
Customer
Joined: 16 Jun 2004
Posts: 2
|
 Posted: Wed Jun 16, 2004 4:32 am Post subject: Using TSLink from RadarScreen |
 |
|
Is there a way using the TS_SetValue function to grab the values in the different cells of a radarscreen and place them in one excel worksheet?
For example, suppose I simply would like to take the "Last" price or the "Net %Chg" for 10 stocks that were being monitored using the radarscreen, and then place them in and excel spreadsheet. Can I reference particular cells?
Thanks |
|
| Back to top |
|
 |
VladGor
Support Team
Joined: 26 Jan 2004
Posts: 528
|
| Posted: Thu Jun 17, 2004 1:49 pm Post subject: |
|
|
Thanks for your question.
As we understood you want that data from different lines of Radar get to different lines of Excel.
For that you need to set parameter that indicate number of line in Radar and use it as number of line in Excel.
See our example of indicator:
| EasyLanguage: |
{*******************************************************************
Description : Export RadarScreen data to Excel
Provided By : TS Research Groupe (c) Copyright 2003
Inputs:
Row - The row number for output data.
********************************************************************}
Input: Row(2);
Vars: TFrame("");
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 miliseconds}
defineDLLFunc: "tslink.dll", float, "TS_GetValue", int,int,int,int; {sheet number,row, column, spleep miliseconds}
defineDLLFunc: "tslink.dll", int, "TS_SetString", lpstr,int,int,int,int; {text,sheet number, row, column, spleep miliseconds}
defineDLLFunc: "tslink.dll", lpstr, "TS_GetString", int,int,int,int; {sheet number, row, column, spleep miliseconds}
TS_StartExcel("Radar.xls","C:\Omega\Radar.xls");
if CurrentBar = 1 then
Begin
If DataCompression = 1 then TFrame = NumToStr(BarInterval,0) + " Min";
if DataCompression = 2 then TFrame = "Daily";
if DataCompression = 3 then TFrame = "Weekly";
if DataCompression = 4 then TFrame = "Monthly";
if DataCompression = 5 then TFrame = "P&F";
if DataCompression = 0 then TFrame = NumToStr(BarInterval,0) + " Tick";
TS_SetString(GetSymbolName,1,Row,1,0);
TS_SetString(TFrame, 1,Row,2,0);
end;
TS_SetValue(H[1],1,Row,3,0);
TS_SetValue(L[1],1,Row,4,0);
TS_SetValue(C,1,Row,5,0);
TS_SetValue(Round((C-O)*PriceScale,0),1,Row,6,0);
Plot1(Round((C-O)*PriceScale,0),"C-O");
|
|
|
| Back to top |
|
|
donald
Customer
Joined: 14 Jul 2004
Posts: 2
|
| Posted: Wed Jul 14, 2004 7:12 pm Post subject: RE: Multiple Lines of Data Between EXCEL and RADARSCREEN |
|
|
In above code you indicate the following Excel file:
TS_StartExcel("Radar.xls","C:\Omega\Radar.xls");
Is the RADAR.XLS file one you have provided or does it matter (not sure if there is any additional EXCEL MACRO or other code in this .XLS file)?
Thanks,
Donald |
|
| Back to top |
|
|
VladGor
Support Team
Joined: 26 Jan 2004
Posts: 528
|
| Posted: Thu Jul 15, 2004 12:06 pm Post subject: |
|
|
C:\Omega\Radar.xls - is empty file without makros and formula.
Indicator that is shown above just copies data from RadarScreen to worksheet C:\Omega\Radar.xls
Row where the data is copied is set by parameter Input: Row(2);
Value of this paremeter should be set for each line of RadarScreen. |
|
| Back to top |
|
|
donald
Customer
Joined: 14 Jul 2004
Posts: 2
|
| Posted: Thu Jul 15, 2004 5:14 pm Post subject: |
|
|
Thanks for response. I see with new code how to transfer several different columns of information from TradeStation to EXCEL.
But I have same question as person above. If we have SEVERAL different equities (rows of data) in RADARSCREEN. What command do we use to transfer the data from multiple symbols in RADARSCREEN to corresponding rows in EXCEL?
Thanks,
Donald |
|
| Back to top |
|
|
VladGor
Support Team
Joined: 26 Jan 2004
Posts: 528
|
| Posted: Fri Jul 16, 2004 3:46 pm Post subject: |
|
|
We prepared example for RadarScreen.
Pay attention to:
-copy Radar.xls to: C:\Omega
-import TS.LINK.RADAR indicator
-open workspace Forex Radar.tsw
-in this workspace format TSLink Radar ...
-value of parameter Row is set for different line in Radar, that is number of line where export of data is made to excel.
With many lines of radarscreen you need powerful computer, more lines more power you need. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
