Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 04:31:13 +0000



[User Discussion] - Referencing bottom 5 price bid volume in a bar with Alert Condition Formula

View Count: 95

[2024-04-07 17:31:15]
marketorderer - Posts: 8
I've been piecing together a formula today and have become stumped while trying to add the final piece to it. So far, my formula is as follows:

=AND(C>L,ID3.SG3<-80, ID12.SG13>1800)

But I would also like to add another condition where the bid volume of the bottom 5 prices of the numbers bar have a sum greater than 200.

I've tried this below, however, I've had no luck after some trial & error and reading up online.

=AND(C>L,ID3.SG3<-80, ID12.SG13>1800, BVAP(L+(TICKSIZE*5,0)>200))

Any assistance would be greatly appreciated
Date Time Of Last Edit: 2024-04-07 17:35:56
[2024-04-07 20:58:23]
Sawtooth - Posts: 3989
add another condition where the bid volume of the bottom 5 prices of the numbers bar have a sum greater than 200.
You would need to reference each of the 5 prices:
=AND(C>L,ID3.SG3<-80, ID12.SG13>1800, BVAP(L,0)+ BVAP(L+(TICKSIZE*1),0)+ BVAP(L+(TICKSIZE*2),0)+ BVAP(L+(TICKSIZE*3),0)+ BVAP(L+(TICKSIZE*4),0) >200 )

Study/Chart Alerts And Scanning: BVAP
Date Time Of Last Edit: 2024-04-08 13:29:01

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

Login

Login Page - Create Account