Support Board
Date/Time: Tue, 18 Nov 2025 06:15:44 +0000
Post From: alert condition not updating on bar close
| [2025-09-26 21:41:01] |
| John - SC Support - Posts: 43003 |
|
We are going to restate this with a bit of a change in the wording to make sure we fully understand: - You want an alert when the current bar trades higher than the Close of the previous bar when it is an UP bar (Close is greater than Open) - OR you want an alert when the current bar trades lower than the Close of the previous bar when it is a DOWN bar (Close is less than Open) The first part of this for an Alert condition would be the following: =AND(C > C[-1], C[-1] > O[-1]) The second part would be the following: =AND(C < C[-1], C[-1] < O[-1]) And putting them together gives you the following: =OR(AND(C > C[-1], C[-1] > O[-1]), AND(C < C[-1], C[-1] < O[-1])) If you are wanting Extension Lines, then the "Color Bar Based on Alert Condition" is the study to use with the above formula for the alert condition. If you want to do this in a Spreadsheet Study, then you need to change the "C"s and "O"s as follows: - "C" would be replaced with ID0.SG4@3 - "C[-1]" would be replaced with ID0.SG4@4 - "O" would be replaced with ID0.SG1@3 - "O[-1]" would be replaced with ID0.SG1@4 If you are looking for something else then we need more information. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |