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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Wilders RSI PCF problem

Wilders RSI PCF problem Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
wbunn
Posted : Wednesday, November 2, 2011 11:29:15 AM
Registered User
Joined: 10/7/2004
Posts: 39
 I am having trouble obtaining the correct results for a Wilder RSI pcf, in particular for bar0 (the last daily bar). For example, whenI entering "RSI14,1 < 10" in the PCF Editor using the Russell 1000 watchlist,  I obtained these three stocks:
HLF, TW, DLTR.  However, none displayed a WRSI value below 50.  Can you see why I'm not getting the correct results.
Thanks,

William
Back to top
Bruce_L
Posted : Wednesday, November 2, 2011 11:42:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 The normal syntax to separate parameters in RSI14.1 would be a period, not a comma (you don't need the 1 in case as a 1-Period Simple Moving Average is the same as its parent). Is the indicator the plain RSI or RSI - Wilders? The syntax built into the Personal Criteria Formula Language is specifically for the plain RSI and not a Wilder's Smoothed RSI.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

In TC2000 version 12, it is generally better to click on the indicator and select Create Condition to create Conditions than to write a formula. The resulting Condition is usually faster and more likely to match the charts.

If you really want to create a formula for a 14-Period Wilder's Smoothed RSI being less than 10, the formula would be quite a bit longer.

50 * (C - XAVGC27.1) / 14 / (.071435345156143 * (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 < 10

Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
billion
Posted : Monday, April 9, 2012 4:20:22 PM
Registered User
Joined: 2/8/2005
Posts: 81

QUOTE (Bruce_L)
The normal syntax to separate parameters in RSI14.1 would be a period, not a comma (you don't need the 1 in case as a 1-Period Simple Moving Average is the same as its parent). Is the indicator the plain RSI or RSI - Wilders? The syntax built into the Personal Criteria Formula Language is specifically for the plain RSI and not a Wilder's Smoothed RSI.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

In TC2000 version 12, it is generally better to click on the indicator and select Create Condition to create Conditions than to write a formula. The resulting Condition is usually faster and more likely to match the charts.
Cascades of Moving Averages

I am using TC2000 v12 and want to create a condition of "Wilder's RSI 10 > Wilder's RSI 21". I have both indicators on the chart but I could not figure out how to create the condition on both.

Thanks -
Back to top
Bruce_L
Posted : Monday, April 9, 2012 4:27:57 PM


Worden Trainer

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

The indicators have to actually be in the same scale to create a Condition this way which compares the indicators.

Even though both RSIs are on a scale which runs from 0 to 100, each RSI has its own scale. This means you will need to use a Condition Formula for this:

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

 


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.