Support Board
Date/Time: Tue, 04 Mar 2025 18:20:28 +0000
Post From: Counting Zero Bid/Ask Inside Price Bar
| [2021-12-18 01:37:20] |
| SavantTrader - Posts: 110 |
|
Assuming the following: >> Charting ES using 2.5R bar (i.e., 11 ticks/bar) Is there an elegant way for me to obtain a count of how many bid-at-price slots within that bar were zero? Something similar to this, but perhaps allowing a range to be specified: COUNTBLANK(BVAP(H-TICKSIZE),BVAP(H-TICKSIZE*2),...,BVAP(H-TICKSIZE*11))
I'm not even sure if COUNTBLANK will count a "0" volume value as blank, but assuming it does, my problem is that using the above very lengthy calculation as part of a CBBOAC formula is extremely cumbersome, especially when the expression needs to appear multiple times within the formula. Is there something more abbreviated I can use to specify the price range slots that constitute a bar, or (in the alternative) to simply count the number of zeros that occur in a price bar bid/ask column? I attached an example using a 3rd party study, but I could just as easily have used your Numbers Bar study to illustrate the same example. Thank you! Date Time Of Last Edit: 2021-12-19 06:42:07
|
 Capture.PNG / V - Attached On 2021-12-19 06:38:39 UTC - Size: 14.37 KB - 183 views |