Support Board
Date/Time: Tue, 01 Jul 2025 06:03:54 +0000
Post From: Color Bar Based on Alert Condition - Time Constraint?
| [2025-06-19 16:11:33] |
| John - SC Support - Posts: 40676 |
|
Time conditions are most easily entered by using the BARTIME and TIME() functions. 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 instance, to check if a bar opened after 09:30, you would enter the following: =BARTIME > TIME(09, 30, 00) To combine items, you need to use the AND() and/or OR() functions. Refer to the following: Study/Chart Alerts And Scanning: OR and AND Functions Therefore, to get what you want, your formula would be the following: =AND((C>(ABS(H-L)*.95)+L, BARTIME > TIME(09, 30, 00), BARTIME < TIME(12, 00, 00)) Note that you can change the Greater Than and Less Than to be Greater Than or Equal To, if you want to be inclusive the time (i.e. BARTIME >= TIME(09, 30, 00)) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |