Support Board
Date/Time: Sun, 24 Nov 2024 08:07:40 +0000
Alerts based on Spreadsheet cell values?
View Count: 67
| [2024-10-29 14:46:27] |
| ycomp - Posts: 317 |
|
is there a way to make an alert which will display an alert when a cell value in a spreadsheet is TRUE?
|
| [2024-10-29 15:47:00] |
| John - SC Support - Posts: 36238 |
|
Sierra Chart uses a context of zero is the same as False and any non-zero value is True. Therefore, to test if a cell is true, you would just test if it is non-zero, such as "=K3 <> 0". If you are doing this in an alert, you would need to reference the subgraph of the spreadsheet column and then your alert formula would look like the following: =ID1.SG1 <> 0 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: