Support Board
Date/Time: Sat, 08 Nov 2025 20:27:27 +0000
Help with Creating a Volume-Based Color Bar Alert (1 AM - 7 AM Time Range
View Count: 32
| [2025-11-05 18:14:04] |
| rebeccaemme - Posts: 20 |
|
I’ve tried to create a color bar based on an alert condition to give me an alert and display a colored bar on the candlestick when the volume exceeds 2000. However, I only want this to happen between 1 AM and 7 AM according to my chart's time zone, which is Rome. I wrote the following formula: =AND(ALERT_CONDITION_TIME_RANGE(100, 600), V > 2000) But it returned an error. Could you please help me understand how to write this formula correctly? Thank you for your assistance. |
| [2025-11-05 20:20:07] |
| John - SC Support - Posts: 42874 |
|
We are curious where you found "ALERT_CONDITION_TIME_RANGE" from? If this exists in our documentation somewhere, then we need to remove it, as that is not a valid function. You have the general idea right, and the Volume test is correct. Just the time is the issue. To limit the time, it is easiest to use the "BARTIME" and "TIME(HH, MM, SS)" functions. BARTIME gives you the opening time for a bar, so can control things relative to the bars. For example, to check if the time is after 1 am, you would use the following formula: =BARTIME > TIME(01, 00, 00) Therefore, the formula for what you want would be the following: =AND(BARTIME > TIME(01, 00, 00), BARTIME < TIME(07, 00, 00), V > 2000) Refer to the following: Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIME_Function 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: