I would like to write a condition formula for RSI14 today is larger than RSI14 yesterday (or one period ago) by more than 20 points. I tried RSI14>RSI14.1+20 BUT THERE IS SOMETHING WRONG WITH IT.   Thanks.

Assming it is the plain RSI indicator without Wilder's Smoothing built in, you could create a Condition Formula for this as:

RSI14 > RSI14.1.1 + 20

If it is the RSI - Wilder's indicator with the built in Wilder's Smoothing, then a Condiiton Formula for this would be quite a bit longer:

50 * (C - XAVGC27.1) / 14 / (.07143535 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 50 * (C1 - XAVGC27.2) / 14 / (.07143535 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125) + 13 / 14 * (ABS(C125 - C126))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 + 20

Thank you, Bruce. I tried to run a custom pcf boolean indicator with the formula above but I get a flat line, not the spikes looking back in time.

You didn't say which formula or what symbols, but I can say for sure that in my testing, I do get spikes in a Custom PCF % True Indicator when the current RSI is more than 20 points above the previous RSI of the correct period and type for both formulas.

You can take a look at JFT, CBOU, VYFC, NKBP and GXP.E as example symbols on a Daily chart to see such spikes.

iT WORKS NOw. I didnt look at enough stocks. but it works. thanks. this is a good way to back test ideas. It's just that some pcfs are impossible to create without your help. it would be great if TC2000 had a feature to back test any idea. I think it would save you so much time since a lot of our questions are about back testing. Thank you again.

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

If you mean a plain RSI without Wilder's Smoothing, then the Up Scan Condition would be:

RSI14 > RSI14.3.1

And the Down Scan Condition would be:

RSI14 < RSI14.3.1

But similar formulas for the Wilder's Smoothed version of RSI are too long and slow to be practical or post in the forums.

I wanted the plain RSI, many thanks.

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.

You have not given the settings or requirements for your DPO and CCI Conditions. I cannot help you create Condition Formulas without such details.

Note that you have indicated getting too many stocks. A 1 of 3 bars Condition will actually return more stocks than a normal Condition. It will still return true if it us currently true, but will also return true if it was true during one of the prior two bars.

The generalized way to create a Condition for passing 1 of 3 bars if you can create a Condition formula for 1 bar is to use the Condition Formula as the Boolean Formula in a Custom PCF % True Indicator. Then set the Average Type to Simple and the Period to 3. Since the Custom PCF % True Indicator will be greater than 0% any time at least one of the three bars is true (33% for 1-bar, 66% for 2-bars and 100% for 3-bars), you can then click on the Custom PCF % True Indicator and select Create Scan Condition to create a Condition for the Custom PCF % True Indicator being greater than 0.

In the case of relatively short formulas and periods such as RSI14 > RSI14.3.1, you could just create the combined formula:

RSI14 > RSI14.3.1 OR RSI14.1.1 > RSI14.3.2 OR RSI14.1.2 > RSI14.3.3

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.

A Condition Formula for a 40-Period DPO being greater than the 40-Period DPO of 1-bar ago could be written as:

C - AVGC40.21 > C1 - AVGC40.22

You could convert this to a 1 of 3 format by repeating incremented versions of it with OR between them:

C - AVGC40.21 > C1 - AVGC40.22 OR C1 - AVGC40.22 > C2 - AVGC40.23 OR C2 - AVGC40.23 > C3 - AVGC40.24

A Condiiton Formula For a 40-Period DPO being less than the 40-Period DPO of 1-bar ago could be written as:

C - AVGC40.21 < C1 - AVGC40.22

You could convert this to a 1 of 3 format by repeating incremented versions of it with OR between them:

C - AVGC40.21 < C1 - AVGC40.22 OR C1 - AVGC40.22 < C2 - AVGC40.23 OR C2 - AVGC40.23 < C3 - AVGC40.24

A Condition Formula for a 50-Period CCI being greater than the 50-Period CCI of 1-bar ago could be written as:

(H + L + C - AVGH50 - AVGL50 - AVGC50) * 10000 / 3 / (ABS(H + L + C - AVGH50 - AVGL50 - AVGC50) + ABS(H1 + L1 + C1 - AVGH50 - AVGL50 - AVGC50) + ABS(H2 + L2 + C2 - AVGH50 - AVGL50 - AVGC50) + ABS(H3 + L3 + C3 - AVGH50 - AVGL50 - AVGC50) + ABS(H4 + L4 + C4 - AVGH50 - AVGL50 - AVGC50) + ABS(H5 + L5 + C5 - AVGH50 - AVGL50 - AVGC50) + ABS(H6 + L6 + C6 - AVGH50 - AVGL50 - AVGC50) + ABS(H7 + L7 + C7 - AVGH50 - AVGL50 - AVGC50) + ABS(H8 + L8 + C8 - AVGH50 - AVGL50 - AVGC50) + ABS(H9 + L9 + C9 - AVGH50 - AVGL50 - AVGC50) + ABS(H10 + L10 + C10 - AVGH50 - AVGL50 - AVGC50) + ABS(H11 + L11 + C11 - AVGH50 - AVGL50 - AVGC50) + ABS(H12 + L12 + C12 - AVGH50 - AVGL50 - AVGC50) + ABS(H13 + L13 + C13 - AVGH50 - AVGL50 - AVGC50) + ABS(H14 + L14 + C14 - AVGH50 - AVGL50 - AVGC50) + ABS(H15 + L15 + C15 - AVGH50 - AVGL50 - AVGC50) + ABS(H16 + L16 + C16 - AVGH50 - AVGL50 - AVGC50) + ABS(H17 + L17 + C17 - AVGH50 - AVGL50 - AVGC50) + ABS(H18 + L18 + C18 - AVGH50 - AVGL50 - AVGC50) + ABS(H19 + L19 + C19 - AVGH50 - AVGL50 - AVGC50) + ABS(H20 + L20 + C20 - AVGH50 - AVGL50 - AVGC50) + ABS(H21 + L21 + C21 - AVGH50 - AVGL50 - AVGC50) + ABS(H22 + L22 + C22 - AVGH50 - AVGL50 - AVGC50) + ABS(H23 + L23 + C23 - AVGH50 - AVGL50 - AVGC50) + ABS(H24 + L24 + C24 - AVGH50 - AVGL50 - AVGC50) + ABS(H25 + L25 + C25 - AVGH50 - AVGL50 - AVGC50) + ABS(H26 + L26 + C26 - AVGH50 - AVGL50 - AVGC50) + ABS(H27 + L27 + C27 - AVGH50 - AVGL50 - AVGC50) + ABS(H28 + L28 + C28 - AVGH50 - AVGL50 - AVGC50) + ABS(H29 + L29 + C29 - AVGH50 - AVGL50 - AVGC50) + ABS(H30 + L30 + C30 - AVGH50 - AVGL50 - AVGC50) + ABS(H31 + L31 + C31 - AVGH50 - AVGL50 - AVGC50) + ABS(H32 + L32 + C32 - AVGH50 - AVGL50 - AVGC50) + ABS(H33 + L33 + C33 - AVGH50 - AVGL50 - AVGC50) + ABS(H34 + L34 + C34 - AVGH50 - AVGL50 - AVGC50) + ABS(H35 + L35 + C35 - AVGH50 - AVGL50 - AVGC50) + ABS(H36 + L36 + C36 - AVGH50 - AVGL50 - AVGC50) + ABS(H37 + L37 + C37 - AVGH50 - AVGL50 - AVGC50) + ABS(H38 + L38 + C38 - AVGH50 - AVGL50 - AVGC50) + ABS(H39 + L39 + C39 - AVGH50 - AVGL50 - AVGC50) + ABS(H40 + L40 + C40 - AVGH50 - AVGL50 - AVGC50) + ABS(H41 + L41 + C41 - AVGH50 - AVGL50 - AVGC50) + ABS(H42 + L42 + C42 - AVGH50 - AVGL50 - AVGC50) + ABS(H43 + L43 + C43 - AVGH50 - AVGL50 - AVGC50) + ABS(H44 + L44 + C44 - AVGH50 - AVGL50 - AVGC50) + ABS(H45 + L45 + C45 - AVGH50 - AVGL50 - AVGC50) + ABS(H46 + L46 + C46 - AVGH50 - AVGL50 - AVGC50) + ABS(H47 + L47 + C47 - AVGH50 - AVGL50 - AVGC50) + ABS(H48 + L48 + C48 - AVGH50 - AVGL50 - AVGC50) + ABS(H49 + L49 + C49 - AVGH50 - AVGL50 - AVGC50) + .000001) > (H1 + L1 + C1 - AVGH50.1 - AVGL50.1 - AVGC50.1) * 10000 / 3 / (ABS(H1 + L1 + C1 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H2 + L2 + C2 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H3 + L3 + C3 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H4 + L4 + C4 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H5 + L5 + C5 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H6 + L6 + C6 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H7 + L7 + C7 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H8 + L8 + C8 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H9 + L9 + C9 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H10 + L10 + C10 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H11 + L11 + C11 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H12 + L12 + C12 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H13 + L13 + C13 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H14 + L14 + C14 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H15 + L15 + C15 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H16 + L16 + C16 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H17 + L17 + C17 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H18 + L18 + C18 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H19 + L19 + C19 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H20 + L20 + C20 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H21 + L21 + C21 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H22 + L22 + C22 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H23 + L23 + C23 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H24 + L24 + C24 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H25 + L25 + C25 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H26 + L26 + C26 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H27 + L27 + C27 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H28 + L28 + C28 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H29 + L29 + C29 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H30 + L30 + C30 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H31 + L31 + C31 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H32 + L32 + C32 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H33 + L33 + C33 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H34 + L34 + C34 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H35 + L35 + C35 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H36 + L36 + C36 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H37 + L37 + C37 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H38 + L38 + C38 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H39 + L39 + C39 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H40 + L40 + C40 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H41 + L41 + C41 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H42 + L42 + C42 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H43 + L43 + C43 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H44 + L44 + C44 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H45 + L45 + C45 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H46 + L46 + C46 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H47 + L47 + C47 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H48 + L48 + C48 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H49 + L49 + C49 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H50 + L50 + C50 - AVGH50.1 - AVGL50.1 - AVGC50.1) + .000001)

A Condition Formula for a 50-Period CCI being less than the 50-Period CCI of 1-bar ago could be written as:

(H + L + C - AVGH50 - AVGL50 - AVGC50) * 10000 / 3 / (ABS(H + L + C - AVGH50 - AVGL50 - AVGC50) + ABS(H1 + L1 + C1 - AVGH50 - AVGL50 - AVGC50) + ABS(H2 + L2 + C2 - AVGH50 - AVGL50 - AVGC50) + ABS(H3 + L3 + C3 - AVGH50 - AVGL50 - AVGC50) + ABS(H4 + L4 + C4 - AVGH50 - AVGL50 - AVGC50) + ABS(H5 + L5 + C5 - AVGH50 - AVGL50 - AVGC50) + ABS(H6 + L6 + C6 - AVGH50 - AVGL50 - AVGC50) + ABS(H7 + L7 + C7 - AVGH50 - AVGL50 - AVGC50) + ABS(H8 + L8 + C8 - AVGH50 - AVGL50 - AVGC50) + ABS(H9 + L9 + C9 - AVGH50 - AVGL50 - AVGC50) + ABS(H10 + L10 + C10 - AVGH50 - AVGL50 - AVGC50) + ABS(H11 + L11 + C11 - AVGH50 - AVGL50 - AVGC50) + ABS(H12 + L12 + C12 - AVGH50 - AVGL50 - AVGC50) + ABS(H13 + L13 + C13 - AVGH50 - AVGL50 - AVGC50) + ABS(H14 + L14 + C14 - AVGH50 - AVGL50 - AVGC50) + ABS(H15 + L15 + C15 - AVGH50 - AVGL50 - AVGC50) + ABS(H16 + L16 + C16 - AVGH50 - AVGL50 - AVGC50) + ABS(H17 + L17 + C17 - AVGH50 - AVGL50 - AVGC50) + ABS(H18 + L18 + C18 - AVGH50 - AVGL50 - AVGC50) + ABS(H19 + L19 + C19 - AVGH50 - AVGL50 - AVGC50) + ABS(H20 + L20 + C20 - AVGH50 - AVGL50 - AVGC50) + ABS(H21 + L21 + C21 - AVGH50 - AVGL50 - AVGC50) + ABS(H22 + L22 + C22 - AVGH50 - AVGL50 - AVGC50) + ABS(H23 + L23 + C23 - AVGH50 - AVGL50 - AVGC50) + ABS(H24 + L24 + C24 - AVGH50 - AVGL50 - AVGC50) + ABS(H25 + L25 + C25 - AVGH50 - AVGL50 - AVGC50) + ABS(H26 + L26 + C26 - AVGH50 - AVGL50 - AVGC50) + ABS(H27 + L27 + C27 - AVGH50 - AVGL50 - AVGC50) + ABS(H28 + L28 + C28 - AVGH50 - AVGL50 - AVGC50) + ABS(H29 + L29 + C29 - AVGH50 - AVGL50 - AVGC50) + ABS(H30 + L30 + C30 - AVGH50 - AVGL50 - AVGC50) + ABS(H31 + L31 + C31 - AVGH50 - AVGL50 - AVGC50) + ABS(H32 + L32 + C32 - AVGH50 - AVGL50 - AVGC50) + ABS(H33 + L33 + C33 - AVGH50 - AVGL50 - AVGC50) + ABS(H34 + L34 + C34 - AVGH50 - AVGL50 - AVGC50) + ABS(H35 + L35 + C35 - AVGH50 - AVGL50 - AVGC50) + ABS(H36 + L36 + C36 - AVGH50 - AVGL50 - AVGC50) + ABS(H37 + L37 + C37 - AVGH50 - AVGL50 - AVGC50) + ABS(H38 + L38 + C38 - AVGH50 - AVGL50 - AVGC50) + ABS(H39 + L39 + C39 - AVGH50 - AVGL50 - AVGC50) + ABS(H40 + L40 + C40 - AVGH50 - AVGL50 - AVGC50) + ABS(H41 + L41 + C41 - AVGH50 - AVGL50 - AVGC50) + ABS(H42 + L42 + C42 - AVGH50 - AVGL50 - AVGC50) + ABS(H43 + L43 + C43 - AVGH50 - AVGL50 - AVGC50) + ABS(H44 + L44 + C44 - AVGH50 - AVGL50 - AVGC50) + ABS(H45 + L45 + C45 - AVGH50 - AVGL50 - AVGC50) + ABS(H46 + L46 + C46 - AVGH50 - AVGL50 - AVGC50) + ABS(H47 + L47 + C47 - AVGH50 - AVGL50 - AVGC50) + ABS(H48 + L48 + C48 - AVGH50 - AVGL50 - AVGC50) + ABS(H49 + L49 + C49 - AVGH50 - AVGL50 - AVGC50) + .000001) < (H1 + L1 + C1 - AVGH50.1 - AVGL50.1 - AVGC50.1) * 10000 / 3 / (ABS(H1 + L1 + C1 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H2 + L2 + C2 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H3 + L3 + C3 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H4 + L4 + C4 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H5 + L5 + C5 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H6 + L6 + C6 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H7 + L7 + C7 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H8 + L8 + C8 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H9 + L9 + C9 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H10 + L10 + C10 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H11 + L11 + C11 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H12 + L12 + C12 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H13 + L13 + C13 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H14 + L14 + C14 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H15 + L15 + C15 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H16 + L16 + C16 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H17 + L17 + C17 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H18 + L18 + C18 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H19 + L19 + C19 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H20 + L20 + C20 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H21 + L21 + C21 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H22 + L22 + C22 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H23 + L23 + C23 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H24 + L24 + C24 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H25 + L25 + C25 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H26 + L26 + C26 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H27 + L27 + C27 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H28 + L28 + C28 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H29 + L29 + C29 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H30 + L30 + C30 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H31 + L31 + C31 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H32 + L32 + C32 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H33 + L33 + C33 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H34 + L34 + C34 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H35 + L35 + C35 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H36 + L36 + C36 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H37 + L37 + C37 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H38 + L38 + C38 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H39 + L39 + C39 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H40 + L40 + C40 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H41 + L41 + C41 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H42 + L42 + C42 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H43 + L43 + C43 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H44 + L44 + C44 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H45 + L45 + C45 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H46 + L46 + C46 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H47 + L47 + C47 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H48 + L48 + C48 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H49 + L49 + C49 - AVGH50.1 - AVGL50.1 - AVGC50.1) + ABS(H50 + L50 + C50 - AVGH50.1 - AVGL50.1 - AVGC50.1) + .000001)

Both of the CCI formulas are too long to create 1 of 3 type formulas. You would need to use them in Custom PCF % True Indicators as described above to do create such a Condition.

RSI14 increasing on 1 of 3 bars would be:

RSI14 > RSI14.1.1 OR RSI14.1.1 > RSI14.1.2 OR RSI14.1.2 > RSI14.1.3

And the down version would be:

RSI14 < RSI14.1.1 OR RSI14.1.1 < RSI14.1.2 OR RSI14.1.2 < RSI14.1.3

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.

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

thanks.

The DPO Up Scan could be written as:

C - AVGC40.21 > AVGC3.1 - AVG(AVGC40.22,3)

And the DPO Down Scan could be written as:

C - AVGC40.21 < AVGC3.1 - AVG(AVGC40.22,3)

It is not possible to create the desired CCI scans as Condition Formulas in a way which would be short or fast enough to be practical or post in the forums.

CCI INDICATOR

That said, it is still possible to create the desired Conditions without using a Condition Formula. Add a 3-Period Simple Moving Average with an Offset of 1 to the desired CCI on the chart. Then click on the CCI and select Create Scan Condition to compare the CCI to its offset moving average.

Create Conditions from Your Chart

Thank you so much, you are very much appreciated.

You're welcome.