This was my attempt at turning this scan, c1/c2>1.04 and v>3*avgv50.2 and v1 >=200000, into an Easy Scan that would show me any stock that met this criteria over the last 40 days. I only get one stock to return. Can't understand what's not working.

c1/c2>1.04 and v>3*avgv50.2 and v1 >=200000 OR

c2/c3>1.04 and v>3*avgv50.3 and v2 >=200000 OR

c3/c4>1.04 and v>3*avgv50.4 and v3 >=200000 OR

c4/c5>1.04 and v>3*avgv50.5 and v4 >=200000 OR

c5/c6>1.04 and v>3*avgv50.6 and v5 >=200000 OR

c6/c7>1.04 and v>3*avgv50.7 and v6 >=200000 OR

c7/c8>1.04 and v>3*avgv50.8 and v7 >=200000 OR

c8/c9>1.04 and v>3*avgv50.9 and v8 >=200000 OR

c9/c10>1.04 and v>3*avgv50.10 and v9 >=200000 OR

c10/c11>1.04 and v>3*avgv50.11 and v10 >=200000 OR

c11/c12>1.04 and v>3*avgv50.12 and v11 >=200000 OR

c12/c13>1.04 and v>3*avgv50.13 and v12 >= 200000 OR

c13/c14>1.04 and v>3*avgv50.14 and v13 >= 200000 OR

c14/c15>1.04 and v>3*avgv50.15 and v14 >= 200000 OR

c15/c16>1.04 and v>3*avgv50.16 and v15 >= 200000 OR

c16/c17>1.04 and v>3*avgv50.17 and v16 >= 200000 OR

c17/c18>1.04 and v>3*avgv50.18 and v17 >= 200000 OR

c18/c19>1.04 and v>3*avgv50.19 and v18 >= 200000 OR

c19/c20>1.04 and v>3*avgv50.20 and v19 >= 200000 OR

c20/c21>1.04 and v>3*avgv50.21 and v20 >= 200000 OR

c21/c22>1.04 and v>3*avgv50.22 and v21 >= 200000 OR

c22/c23>1.04 and v>3*avgv50.23 and v22 >= 200000 OR

c23/c24>1.04 and v>3*avgv50.24 and v23 >= 200000 OR

c24/c25>1.04 and v>3*avgv50.25 and v24 >= 200000 OR

c25/c26>1.04 and v>3*avgv50.26 and v25 >= 200000 OR

c26/c27>1.04 and v>3*avgv50.27 and v26 >= 200000 OR

c27/c28>1.04 and v>3*avgv50.28 and v27 >= 200000 OR

c28/c29>1.04 and v>3*avgv50.29 and v28 >= 200000 OR

c29/c30>1.04 and v>3*avgv50.30 and v29 >= 200000 OR

c30/c31>1.04 and v>3*avgv50.31 and v30 >= 200000 OR

c31/c32>1.04 and v>3*avgv50.32 and v31 >= 200000 OR

c32/c33>1.04 and v>3*avgv50.33 and v32 >= 200000 OR

c33/c34>1.04 and v>3*avgv50.34 and v33 >= 200000 OR

c34/c35>1.04 and v>3*avgv50.35 and v34 >= 200000 OR

c35/c36>1.04 and v>3*avgv50.36 and v35 >= 200000 OR

c36/c37>1.04 and v>3*avgv50.37 and v36 >= 200000 OR

c37/c38>1.04 and v>3*avgv50.38 and v37 >= 200000 OR

c38/c39>1.04 and v>3*avgv50.39 and v38 >= 200000 OR

c39/c40>1.04 and v>3*avgv50.40 and v39 >= 200000 OR

c40/c41>1.04 and v>3*avgv50.41 and v40 >= 200000

I would do it for 1 day add a 40 period simple average  and check to see if its positive.

Thanks

You can put parentheses around each section to get your formula working the way I expect you want it to work. For example, the first line would be as follows.(c1/c2>1.04 and v>3*avgv50.2 and v1 >=200000) OR

But the technique diceman is suggesting of using the Condition Formula as the Boolean Formula in a Custom PCF % True Indicator with the Period set to 40 and the Average Type set to Simple is going to be better.

You can just click on the indicator and select Create Scan Condition to check for the Custom PCF % True Indicator having a value greater than 0 to create the condition.