Support Board
Date/Time: Tue, 04 Mar 2025 10:20:48 +0000
Reference A Subgraph Using Condition
View Count: 502
| [2021-12-07 23:50:32] |
| User769783 - Posts: 191 |
|
Hello, I would like to reference a study to display the price of this study as a line on the chart. The issue is I would like to only display the line if a certain condition is true. Is this possible without the use of ASCIL programming? Thanks in advance. |
| [2021-12-08 04:08:20] |
| Sawtooth - Posts: 4179 |
|
Use the Spreadsheet Formula study with a formula like this in its Formula field: =IF(YourCondition,ID1.SG1,0) where ID1.SG1 is the study and subgraph you want to display as a line. Also, set 'Draw Zero Values' to No. |
| [2021-12-08 04:41:16] |
| User769783 - Posts: 191 |
|
Is this correct? ... =IF(ID41.SG1 > ID41.SG3 && ID41.SG1 > ID42.SG1 && ID41.SG1 > ID42.SG3, ID41.SG1,0) .. I tried but this is not working? Thanks |
| [2021-12-08 14:07:06] |
| Sawtooth - Posts: 4179 |
|
This is the proper syntax: =IF(AND(ID41.SG1 > ID41.SG3,ID41.SG1 > ID42.SG1,ID41.SG1 > ID42.SG3),ID41.SG1,0) |
To post a message in this thread, you need to log in with your Sierra Chart account: