Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 14:56:09 +0000



Post From: Help with formula for volume at price location within candlestick

[2022-05-31 19:13:45]
Sawtooth - Posts: 4173
two or more cells have >= +100 delta in top two-three cells of number bars and same thing for -100 delta in bottom two or three cells of the number bars
Try this:

Delta of each of top 3 prices >= 100 :
=AND(
AVAP(H, 0) - BVAP(H, 0) >= 100,
AVAP(H-TICKSIZE*1, 0) - BVAP(H-TICKSIZE*1, 0) >=100,
AVAP(H-TICKSIZE*2, 0) - BVAP(H-TICKSIZE*2, 0) >=100)
Put this formula on the Alerts tab of the Color Bar Based On Alert Condition study, and set the Draw Style to Point On High.


Delta of each of bottom 3 prices <= -100 :
=AND(
AVAP(L, 0)-BVAP(L, 0) <= -100,
AVAP(L+TICKSIZE*1, 0) - BVAP(L+TICKSIZE*1, 0) <= -100,
AVAP(L+TICKSIZE*2, 0) - BVAP(L+TICKSIZE*2, 0) <= -100)
Put this formula on the Alerts tab of another instance of the Color Bar Based On Alert Condition study, and set the Draw Style to Point On Low.