Support Board
Date/Time: Sat, 25 Oct 2025 03:35:16 +0000
Post From: How do i highlight finished auction on footprint.
| [2025-10-24 14:38:15] |
| John - SC Support - Posts: 42557 |
|
The only way to do this would be to use a combination of the "Spreadsheet Formula" and the "Color Bar Based on Alert Condition". You can set the actual condition in the "Spreadsheet Formula" which will also give you the level at which the condition occurs to be used by the "Color Bar Based on Alert Condition". To start, refer to the information for the Volume at Price alert options here: Study/Chart Alerts And Scanning: Special Functions And look at examples 41, 42, and 43 here: Study/Chart Alerts And Scanning: Alert Formula Examples You will have to modify the example, as you want to get back the price level. Therefore, you would use a condition like the following, but you need to continue the idea for the number of levels you would expect to see in a bar: =IF(BVAP(L, 0) = AVAP(L, 0), L, IF(BVAP(L + TICKSIZE, 0) = AVAP(L + TICKSIZE, 0), L + TICKSIZE, 0)) Then in the "Color Bar Based on Alert Condition" you can set the Alert to be the following: =ID1.SG1 Where ID1 is the ID of the "Spreadsheet Formula". And you would set the following Inputs: - Output When Condition True: Study Subgraph Reference - Study Subgraph Reference Value When True: ID1.SG1 (again, changing the ID as necessary for the Spreadsheet Formula) And choose an option for the Draw Style for how you want to mark the level - the "Color Background at Price" or one of the offset markers (such as "Square Offset left for Candlestick") should work well. Refer to the following: Chart Studies: Subgraphs Tab >> Draw Style The documentation for the Color Bar Based on Alert condition is here: Color Bar Based on Alert Condition For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |