Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 02:53:57 +0000
[Programming Help] - Spreadsheet programming question
View Count: 570
| [2021-12-08 20:45:21] |
| User183724 - Posts: 183 |
|
Can a spreadsheet study reference data cells of other spreadsheet studies attached to the same chart? I have two spreadsheet studies attached to a 5 min chart. I would like #1 study to access cells on #2 study.
|
| [2021-12-08 22:57:53] |
| John - SC Support - Posts: 31362 |
|
They can not access the data from another spreadsheet, but what you can do is use the same Spreadsheet and each chart will have it's own sheet within the Spreadsheet, and you can then reference between the sheets. Refer to the following: Referencing Other Charts in Spreadsheet Study Formulas: Using Common Spreadsheet for Multiple Charts For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-12-09 04:28:38] |
| Sawtooth - Posts: 3993 |
|
Can a spreadsheet study reference data cells of other spreadsheet studies attached to the same chart?
While you cannot reference a differently-named spreadsheet study on another chart, you can reference a differently-named spreadsheet study's subgraphs of only the Spreadsheet Study study on the same chart.You would do it like you'd reference any other study on the same chart, via its ID# and SG#. Only the Spreadsheet Study study's subgraphs can be seen by any of the 3 spreadsheet studies: - The Spreadsheet Study study can only see another Spreadsheet Study study. - The Spreadsheet System/Alert study can only see a Spreadsheet Study study. - The Spreadsheet System for Trading study can only see a Spreadsheet Study study. Date Time Of Last Edit: 2021-12-09 13:17:13
|
| [2021-12-10 00:04:03] |
| Ticks - Posts: 174 |
|
Can a color bar on alert condition study access a value in spreadsheet cell and use the value within its alert condition? If it cant, what study can be used to get the cell value. |
| [2021-12-10 01:49:41] |
| Sawtooth - Posts: 3993 |
|
Can a color bar on alert condition study access a value in spreadsheet cell and use the value within its alert condition?
Yes, the Color Bar Based On Alert Condition study can reference any subgraph of any of the 3 spreadsheet studies.If it cant, what study can be used to get the cell value. What this means is that the value must be in one of the Formula Columns K-Z...BR (relative to the Number of Formula Columns setting 16-60, SG1-SG16...SG60). If the cell you want to reference is not in a Formula Column, use a formula like this in row 3 of a Formula Column: =$J$21 Then reference that Formula Column/subgraph SG1-SG16...SG60. If you want to get a value from a spreadsheet Formula Column cell, you can use the Spreadsheet Formula study instead of the color bar study. |
| [2021-12-10 02:20:03] |
| Ticks - Posts: 174 |
|
I currently added a lot of additional formula columns to the spreadsheet system for trading study. The formula column AA works and calculates the correct data. The color bar alert is =and(ID20.SG17@3>0) However this does not color the bar. Date Time Of Last Edit: 2021-12-10 02:22:28
|
| [2021-12-10 02:47:59] |
| Sawtooth - Posts: 3993 |
|
If you only have one condition, you don't need the AND: =ID20.SG17@3>0 This is the correct syntax for the Color Bar study (it is different than the spreadsheet syntax): ID20.SG17>0 |
| [2021-12-11 23:25:22] |
| Ticks - Posts: 174 |
|
tomgilb, thanks post #7 worked.
|
To post a message in this thread, you need to log in with your Sierra Chart account: