Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

RSI CONDITION Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
julian1000
Posted : Monday, February 25, 2013 3:21:43 PM
Registered User
Joined: 9/12/2010
Posts: 121

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.

Bruce_L
Posted : Monday, February 25, 2013 3:25:55 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
julian1000
Posted : Monday, February 25, 2013 3:41:23 PM
Registered User
Joined: 9/12/2010
Posts: 121

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.

Bruce_L
Posted : Monday, February 25, 2013 4:00:46 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
julian1000
Posted : Monday, February 25, 2013 4:17:05 PM
Registered User
Joined: 9/12/2010
Posts: 121

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.

oritzbaba
Posted : Thursday, May 9, 2013 6:49:01 PM
Registered User
Joined: 2/23/2012
Posts: 21

 

Please help with a current RSI that is greater than the average of the last 3 RSI bars. And a current RSI that is less than the average of the last 3 RSI. I tried to create the formula below but it looks like something is missing.
 
RSI > (rsi14.1 + rsi14.2 + rsi14.3)/3 for up scan condition
 

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

 
Is there a shorter way I could have written this condition?
 
Many thanks in advance.
Bruce_L
Posted : Friday, May 10, 2013 10:12:12 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
oritzbaba
Posted : Saturday, May 11, 2013 4:54:18 AM
Registered User
Joined: 2/23/2012
Posts: 21

I wanted the plain RSI, many thanks.

oritzbaba
Posted : Tuesday, May 14, 2013 12:54:02 PM
Registered User
Joined: 2/23/2012
Posts: 21

QUOTE (Bruce_L)

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.

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.

Bruce_L
Posted : Tuesday, May 14, 2013 1:02:59 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
oritzbaba
Posted : Wednesday, May 15, 2013 12:31:14 PM
Registered User
Joined: 2/23/2012
Posts: 21

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.

Bruce_L
Posted : Wednesday, May 15, 2013 1:31:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
oritzbaba
Posted : Wednesday, May 15, 2013 7:37:43 PM
Registered User
Joined: 2/23/2012
Posts: 21

QUOTE (Bruce_L)

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.

 

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.

oritzbaba
Posted : Wednesday, May 15, 2013 7:40:12 PM
Registered User
Joined: 2/23/2012
Posts: 21

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

thanks.

Bruce_L
Posted : Thursday, May 16, 2013 8:06:36 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
oritzbaba
Posted : Thursday, May 16, 2013 12:01:29 PM
Registered User
Joined: 2/23/2012
Posts: 21

Thank you so much, you are very much appreciated.

Bruce_L
Posted : Thursday, May 16, 2013 12:02:07 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.