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: