Login Page - Create Account

Support Board


Date/Time: Fri, 24 Oct 2025 16:02:02 +0000



How do i highlight finished auction on footprint.

View Count: 49

[2025-10-23 20:41:31]
User993043 - Posts: 2
Hi Sierrachart team,

Please find the attached picture below.

How do i on about highlighting finished auction as shown in yellow 4, 3, 6, and 10 on footprint chart?

Thanks in advance,
Fabio.
imageFootprint Highlight.png / V - Attached On 2025-10-23 20:41:27 UTC - Size: 150.64 KB - 12 views
[2025-10-23 20:41:35]
John - SC Support - Posts: 42552
We need more information on what exactly you are referring to in the image. We do not know what 4, 3, 6, and 10 are referring to. Please be more specific, or better yet, use some of the drawing tools to highlight the area you are referring to.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-10-23 22:44:53]
User993043 - Posts: 2
The number highlighted in the picture are the finished auction. This is something i have been trying to also add onto my footprint chart, but can't seem to find a way of doing so. Does that help you understand better what I'm trying to achieve?

Thanks,
Fabio.
imageFootprint Highlight finished auction.jpg / V - Attached On 2025-10-23 22:43:13 UTC - Size: 370.59 KB - 9 views
[2025-10-24 14:38:15]
John - SC Support - Posts: 42552
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account