Support Board
Date/Time: Fri, 30 Jan 2026 03:39:57 +0000
color bar based on alert condition - once per day
View Count: 140
| [2025-12-10 01:23:16] |
| User753526 - Posts: 83 |
|
Is it possible to set the 'color bar based on alert condition' study to trigger only once per day/session?
|
| [2025-12-10 15:40:35] |
| John - SC Support - Posts: 44299 |
|
The only possible way to do this would be if you had an Intraday chart setup to have a Bar Period of 1 day and if you can set part of your condition on that daily bar by using the "Spreadsheet Formula". Then you can overlay the result of the Spreadsheet Formula to the chart where you want to use the Color Bar Based on Alert Condition and include that result in the alert condition for the Color Bar Based on Alert Condition. For example (not a great example, but the best we can think of offhand) if part of your alert is when the daily volume is greater than 2000, then you would set your Spreadsheet Formula on the Daily chart (again, an Intraday Daily, not a Historical Daily, or it will not meet the Session Time requirements) and your formula in the Spreadsheet Formula would be the following: =V > 2000 Then use the Study/Price Overlay to get that Spreadsheet Formula result in the chart you want and then you would include that Study/Price Overlay in the Alert Condition for the Color Bar Based on Alert Condition, so it would look like the following: =AND(ID1.SG1, ...) Refer to the following: Spreadsheet Formula Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-12-11 14:25:55] |
| Sawtooth - Posts: 4311 |
|
Is it possible to set the 'color bar based on alert condition' study to trigger only once per day/session?
Here's another way:Add the Spreadsheet Formula study, with a formula like this in its Formula field: =IF(YourAlertCondition,1,IF(BARTIME=0,0,ID1.SG1[-1])) where this Spreadsheet Formula study is ID1. This will create a persistent TRUE at the first alert occurrence after midnight, and release it at the next midnight. Add the Color Bar Based On Alert Condition study, with a formula like this on the Alerts tab: =AND(ID1.SG1[-1]=0,ID1.SG1=1) This will find the first and only occurrence of the alert of the day. |
To post a message in this thread, you need to log in with your Sierra Chart account: