Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 20:44:22 +0000



Post From: Alert Condition for Numbers Bars Calculated Values

[2023-10-30 21:57:17]
John - SC Support - Posts: 31704
We do not see anything wrong with the syntax of what you have written, but with the 2 OR statements within the AND statement, it is a bit complicated, so you need to make sure you have it working as you expect.

The Spreadsheet Formula uses the Alert Syntax (despite its name). Use this to breakdown your formula and look at each piece and build it up. It will help you figure out where you may have something not set exactly as you want it. Keep in mind that with something like =AND(a, b) the Spreadsheet Formula will return either a 0 (false) or 1 (true). Refer to the information here:
Spreadsheet Formula
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing