Thank you so much, you are very much appreciated.

Please use 40 period for DPO and 50 period for CCI.

thanks.

Thanks so much Bruce, you have been such a big help towards my successful trading. But I am a bit confused though with the very long CCI Formula. Anyway what I wanted was for similar formula like the quote above. 

For DPO: Current DPO value greater than the average value of the last 3 bars DPO values for Up scan. And current DPO value lesser than the average value of the last 3 bars DPO values for Down scan.

For CCI: Current CCI value greater than the average value of the last 3 bars CCI values for Up scan. And current CCI value lesser than the average value of the last 3 bars CCI values for Down scan.

Many thanks.

My apologies for omitting the requirement; the DPO is 40 period and the CCI is 50 period for both up and down scan conditions. I also realise that the condition ''passing 1 of 3 bars'' is not what I need for my strategy.

Please I will like you to help me create a condition within the previous 4 bars from the current bar with these complimentary conditions. 

For RSI14 scan up condition let any one of these conditions be true in the previous 4 candle bars;

        The 4th bar RSI14 value be greater than 3rd bar RSI14 value OR

        The 3rd bar RSI14 value be greater than 2nd bar RSI14 value OR

        The 2nd bar RSI14 value be greater than 1st previous bar RSI14 value.

For RSI14 scan down condition;

        The 4th bar RSI14 value be lesser than 3rd bar RSI14 value OR

        The 3rd bar RSI14 value be lesser than 2nd bar RSI14 value OR

        The 2nd bar RSI14 value be lesser than 1st previous bar RSI14 value.

Thanks in advance.

The RSI Average scan above works well but it generates too much stocks. Please help with restricting it to ''Passing 1 of 3 bars''.

PLEASE I will also like you to help with creating a similar down and up scan like the one above for Detrended Price Oscillator and Commodity Channel Index along with the Passing 1 of 3 bars condition.

Many thanks in advance for all of my request.

I wanted the plain RSI, many thanks.

RSI < (rsi14.1 + rsi14.2 + rsi14.3)/3 for down scan condition

You are a great help. It seems you went back to correct the formulas on your post.

Many thanks Bruce.

Same error for CCI crossing down. Please help amend.

Many thanks.

A Condition Formula for a 100-Period CCI crossing up through zero:

H + L + C > AVGH100 - AVGL100 - AVGC100 AND H1 + L1 + C1 <= AVGH100.1 - AVGL100.1 - AVGC100.1

I tested the formula above and it showed a value = false. And, when I also tried it as a scan condition it did not generate any signal. I used the normal CCI in the tc2000 and it generated 6 stocks of 100-Period CCI crossing up through zero. 

Please help check for correction.

Thanks.