Support Board
Date/Time: Wed, 26 Nov 2025 22:46:17 +0000
Strong Bearish Delta + Low Percentage Move in a 5-Bar range
View Count: 24
| [2025-11-26 17:18:28] |
| rebeccaemme - Posts: 33 |
|
Hello, I am trying to create a Color Bar Based on Alert Condition that detects the following pattern: 1. Within the last 5 bars, at least 2 bars must have a strong bearish delta (delta < –1800). 2. The current bar must have a very small percentage move (≤ 0.30%). 3. The total 5-bar range must be very compressed (≤ 0.45%). This is the exact alert formula I used: AND( SUM(DELTA < -1800, 5) >= 2, ABS((C - O) / O * 100) <= 0.30, ABS((H - L[4]) / L[4] * 100) <= 0.45 ) However, Sierra Chart does not seem to recognize or accept the formula when I paste it into the Alert Condition box. Can you please confirm whether this syntax is correct for a Color Bar Based on Alert Condition? Thank you! |
| [2025-11-26 18:06:54] |
| John - SC Support - Posts: 43196 |
|
The problems are with the SUM() function and the DELTA variable. The SUM() will only work with an alert where you give it explicit values. So you can do something like =SUM(1, 2, 3) and get a result of 6, but you can not do =SUM(ID1.SG1) and get a sum of the values of that subgraph. And there is no variable called "DELTA" anywhere within the Sierra Chart system. To do what you want, you would need to use the "Spreadsheet System/Alert", as this is the only way to test if at least 2 bars within the last 5 meet your Bearish Delta condition. Also, you are not testing the full 5 bar range with your last line, as that is only taking the current High minus the Low from 4 bars prior. Any of the bars in between could be higher or lower, so again, you need the Spreadsheet to be able to look through the bars and give you the highest High and the lowest Low and then use that to get the result you want. Note that the Spreadsheet Syntax is a little different from the Alert formula syntax, so you can not just copy what you have, you will need to rewrite it. Refer to the following: Spreadsheet Systems, Alerts and Automated Trading Spreadsheet Functions Working with Spreadsheets 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: