Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 07:40:54 +0000



Post From: Alerts based on Spreadsheet cell values?

[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