Hi Bruce,

I am trying to build a condition to scan for spikes in my indicator I call C/VOL.  The basic indicator is shown in the PCF  (c-xavgC4) * (v/xavgV4), period set to 1, average type simple, and plot style area.

I want to scan where this condition 4 bars ago is greater than this condition for the 34 bars before that.  I tried the PCF below in a scan and the indicator does not show this condition as being true on the chart (hourly).  The formula below evaluates without error.  What am I doing wrong?

((c-xavgC4.4) * (v/xavgV4.4)) > ((max(c.4,34)-max(xavgc4.4,34) * max(v.4,34)/Max(xavgv4.4,34))

Thanks, Richard

The MAX() function will not take a compound formula as an argument. You would need to make each comparison individually.

(C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C5 - XAVGC4.5) * V5 / XAVGV4.5 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C6 - XAVGC4.6) * V6 / XAVGV4.6 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C7 - XAVGC4.7) * V7 / XAVGV4.7 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C8 - XAVGC4.8) * V8 / XAVGV4.8 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C9 - XAVGC4.9) * V9 / XAVGV4.9 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C10 - XAVGC4.10) * V10 / XAVGV4.10 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C11 - XAVGC4.11) * V11 / XAVGV4.11 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C12 - XAVGC4.12) * V12 / XAVGV4.12 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C13 - XAVGC4.13) * V13 / XAVGV4.13 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C14 - XAVGC4.14) * V14 / XAVGV4.14 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C15 - XAVGC4.15) * V15 / XAVGV4.15 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C16 - XAVGC4.16) * V16 / XAVGV4.16 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C17 - XAVGC4.17) * V17 / XAVGV4.17 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C18 - XAVGC4.18) * V18 / XAVGV4.18 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C19 - XAVGC4.19) * V19 / XAVGV4.19 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C20 - XAVGC4.20) * V20 / XAVGV4.20 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C21 - XAVGC4.21) * V21 / XAVGV4.21 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C22 - XAVGC4.22) * V22 / XAVGV4.22 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C23 - XAVGC4.23) * V23 / XAVGV4.23 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C24 - XAVGC4.24) * V24 / XAVGV4.24 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C25 - XAVGC4.25) * V25 / XAVGV4.25 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C26 - XAVGC4.26) * V26 / XAVGV4.26 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C27 - XAVGC4.27) * V27 / XAVGV4.27 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C28 - XAVGC4.28) * V28 / XAVGV4.28 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C29 - XAVGC4.29) * V29 / XAVGV4.29 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C30 - XAVGC4.30) * V30 / XAVGV4.30 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C31 - XAVGC4.31) * V31 / XAVGV4.31 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C32 - XAVGC4.32) * V32 / XAVGV4.32 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C33 - XAVGC4.33) * V33 / XAVGV4.33 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C34 - XAVGC4.34) * V34 / XAVGV4.34 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C35 - XAVGC4.35) * V35 / XAVGV4.35 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C36 - XAVGC4.36) * V36 / XAVGV4.36 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C37 - XAVGC4.37) * V37 / XAVGV4.37 AND (C4 - XAVGC4.4) * V4 / XAVGV4.4 > (C38 - XAVGC4.38) * V38 / XAVGV4.38