Support Board

Date/Time: Sun, 19 May 2024 04:12:09 +0000

Post From: Problem with AVAP Multiplier when using in Formulas

[2019-12-30 06:35:58] Link To Thread - Link To Post [Go To First Post]
User994153 - Posts: 2
I'm trying to plot a number at the top of number bars using combination of "spreadsheet formula" and "study subgraph above/below bar as text". To simplify and clarify my problem I provide a simple example with the results in the attached picture. I want the ask volume to be ploted. case 1: when using multiplier of 1 and the formula is AVAP(H,0) the result is OK case 2: when using multiplier of 1 and the formula for getting the second high level is AVAP(H-(TICKSIZE1),0) the result is OK case 3: when using multiplier of 2 and the formula for getting the highest level of ask is AVAP(MROUND(H,Ticksize2),0) I get the wrong results (zero) as evident in the picture. I'm having this problem only with AVAP at the highs. In the cases where I use BVAP at the lows the result is always ok I'd be grateful if you could help me with this


hamidn.png / V - Attached On 2019-12-30 06:28:47 UTC - Size: 26.35 KB - 226 views