Support Board
Date/Time: Fri, 31 Oct 2025 03:00:21 +0000
[User Discussion] - Referencing bottom 5 price bid volume in a bar with Alert Condition Formula
View Count: 392
| [2024-04-07 17:31:15] | 
| marketorderer - Posts: 11 | 
| 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: 4281 | 
| 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:
