Login Page - Create Account

Support Board


Date/Time: Tue, 26 Aug 2025 13:18:27 +0000



How can I get alert and visual color bar when there is a delta divergente of at least 500?

View Count: 243

[2025-06-11 12:34:40]
rebeccaemme - Posts: 19
I would get alert and visual color difference bar when there is a Delta Divergence of at least -500 delta close with bullish candle or at least 500 positive delta but close with bearish candle. I have try this formula but is not working

=OR(
AND(C > O, (BidVolume - AskVolume) <= -500),
AND(C < O, (BidVolume - AskVolume) >= 500)
)

How can I correclty write the formula on color bar based on alert condition study? Thank you so much.
[2025-06-11 13:38:43]
cmet - Posts: 719
Just need to tweak the syntax. Used zero in example below so it's easy to test.

=OR(
AND(C > O, AV-BV < 0),
AND(C < O, AV-BV > 0)
)
[2025-07-05 10:22:14]
User274708 - Posts: 12
How do I create a simillar study to color the bar that has VOLUME >500 and DELTA difference at minimum 300 (positive or negative) , I tried to use formula aboves and play with them but no succes ..

I did this "=OR(AND(V >=500) , AND (BV-AV >= 300), AND (BV-AV <= -300))"

but it does color all bars with V > 500 but not essentialy with Delta abv/blw 300
Date Time Of Last Edit: 2025-07-05 10:35:06
[2025-07-05 14:02:19]
Sawtooth - Posts: 4261
How do I create a similar study to color the bar that has VOLUME >500 and DELTA difference at minimum 300 (positive or negative)
Move the OR to not include the V :
=AND(V >=500 , OR(AND (BV-AV >= 300), AND (BV-AV <= -300)))

You could also remove the unnecessary ANDs:
=AND(V >=500 , OR(BV-AV >= 300, BV-AV <= -300))

If the positive and negative thresholds are always the same, you could use the ABS function instead of the OR:
=AND(V>=500,ABS(BV-AV)>=300)
[2025-07-06 07:51:40]
User274708 - Posts: 12
thank you Sawtooth, can you allow direct message for my account ? I would like to ask you for a little guidance if possible
Date Time Of Last Edit: 2025-07-06 07:52:30
[2025-07-06 14:05:47]
Sawtooth - Posts: 4261
can you allow direct message
Yes, you may DM me.

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

Login

Login Page - Create Account