Login Page - Create Account

Support Board


Date/Time: Thu, 13 Nov 2025 06:41:06 +0000



alert condition help

View Count: 133

[2025-09-30 12:31:29]
daif1029 - Posts: 11
how would one turn this into an alert formula

betweent the open and low of an up bar (wick) the volume is greater than the volume between the high and the open


or between the open and low the volume is greater than (thereshold) and the bar closes C > O
[2025-09-30 15:08:00]
John - SC Support - Posts: 42965
There is not really a good way to do this. The following will work, but it only adds up a limited number of price levels, so you need to make sure that you have enough levels taken into account for the typical size of your bars.

To start with, you need to get the volume at each price level, which is done using the functions defined at the following link:
Study/Chart Alerts And Scanning: Special Functions

So to sum up the volumes at each price level from the Open to the Low, your formula would look like the following (the following is just 3 levels, you would need to expand for however many levels you need):
=VAP(O, 0) + VAP(O-TICKSIZE, 0) + VAP(O-TICKSIZE*2, 0)

Note that the VAP is testing from the Open and going down, this is important, as any price level below the Low will return a value of 0, so you can have those additional items in your condition.

And to check if it is an UP bar, you need to test the open versus the close:
=C > O

Putting these together along with a test for the volumes in the wicks, gives you the following:
=AND(C > O, VAP(O, 0) + VAP(O-TICKSIZE, 0) + VAP(O-TICKSIZE*2, 0) > VAP(C, 0) + VAP(C+TICKSIZE, 0) + VAP(C+TICKSIZE*2))
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