Support Board
Date/Time: Wed, 26 Nov 2025 22:46:32 +0000
Post From: Strong Bearish Delta + Low Percentage Move in a 5-Bar range
| [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 |