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

RSI Wilder PCF code Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
502beta
Posted : Thursday, December 26, 2013 3:24:13 PM
Registered User
Joined: 11/29/2008
Posts: 5

In the Tradelist columns I have a column labeled "rsi3 < 30" and the code for the PCF is rsi3 < 30. If I want to use the RSI Wilder's ( rather than the plain RSI) what code should I use? I tried "wrsi3" and "rsiw3" but those don't work.

Bruce_L
Posted : Thursday, December 26, 2013 4:58:10 PM


Worden Trainer

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

A Wilder's Smoothed RSI is not built into the Personal Criteria Formula Language.

PCF Formula Descriptions

You need to manual construct a Wilder's Smoothed RSI from the syntax which is available. So a 3-period Wilder's smoothed RSI being < 30 would be:

50 * (C - XAVGC5.1) / 3 / (.333363 * (ABS(C - C1) + 2 / 3 * (ABS(C1 - C2) + 2 / 3 * (ABS(C2 - C3) + 2 / 3 * (ABS(C3 - C4) + 2 / 3 * (ABS(C4 - C5) + 2 / 3 * (ABS(C5 - C6) + 2 / 3 * (ABS(C6 - C7) + 2 / 3 * (ABS(C7 - C8) + 2 / 3 * (ABS(C8 - C9) + 2 / 3 * (ABS(C9 - C10) + 2 / 3 * (ABS(C10 - C11) + 2 / 3 * (ABS(C11 - C12) + 2 / 3 * (ABS(C12 - C13) + 2 / 3 * (ABS(C13 - C14) + 2 / 3 * (ABS(C14 - C15) + 2 / 3 * (ABS(C15 - C16) + 2 / 3 * (ABS(C16 - C17) + 2 / 3 * (ABS(C17 - C18) + 2 / 3 * (ABS(C18 - C19) + 2 / 3 * (ABS(C19 - C20) + 2 / 3 * (ABS(C20 - C21) + 2 / 3 * (ABS(C21 - C22) + 2 / 3 * (ABS(C22 - C23))))))))))))))))))))))))) + 50 < 30



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
gordonerlebach
Posted : Saturday, March 1, 2014 8:19:51 AM
Gold Customer Gold Customer

Joined: 9/7/2012
Posts: 34

Hi, 

 

I would like the know the rationale through which some formulas are included as PCFs and some not? I would like the 15 and 75 days Wilder RSI as a formula and cannot do this. Is it because you have a higher price product that allows it? I'd be most interested in knowing. If you do not know, perhaps you could find out? 

   Thanks,

    Gordon

 

    

Bruce_L
Posted : Tuesday, March 4, 2014 10:32:00 AM


Worden Trainer

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

The reason is that the Personal Criteria Formula Language has not been expanded at all since the early days of TC2000 version 7. So any indicators or features added after the PCF Language was developed are not in the language. The "Use Wilder's Smoothing" option in the Wilder's RSI in TC2000 version 7 was added after this point, so it is not part of the language.

In TC2000 version 12.4, you should generally click on an indicator and select Create Scan Condition or Add Column to WatchList instead of creating a formula. It is not only easier to do, but the results are more efficient than a formula to do the same thing.

Create Conditions from Your Chart

A 15-Period Wilder's Smoothed RSI can be written as:

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

But a formula for a 75-period Wilder's Smoothed RSI is too long and slow to be practical or post in the forums.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
gordonerlebach
Posted : Sunday, March 30, 2014 11:57:56 AM
Gold Customer Gold Customer

Joined: 9/7/2012
Posts: 34

Thank you Bruce. So the next question is: 

Are there any plans whatsoever to expand the indicators? Ideally, there should be a general mechanism to handle any of the built-in indicators you have provided, as opposed to a case by case basis. 

Is expansion of the list of indicators in a PCF hard to do, or is it a conscious decision not to expand? Wouldn't a more expansive list of formulas in PCFs increase the appeal of TC2000? 

Finally, I'd like to calculate RSI15-RSI75 using Wilder RSI. Does not have to be with PCFs. I believe it is simply not possible. At best, I can have a column in a watchlist/scan for RSI15 and one for RSI75 (wilder), but I cannot subract the two. Please correct me if I am mistaken. 

 

   Gordon

Bruce_L
Posted : Monday, March 31, 2014 10:31:34 AM


Worden Trainer

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

I do not think it is a conscious decision, but expanding the Personal Criteria Formula Language has certainly not been a priority. PCFs are currently seen as a last resort option when clicking on an indicator will not do what you want.

You are correct that it is not possible to create the desired calculation by clicking on the chart. It is theoretically possible to create an Indicator Formula for this, but the resulting formula is too long and slow to be practical or post in the forums.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
JordanS
Posted : Monday, March 31, 2014 11:41:07 AM
Registered User
Joined: 8/1/2006
Posts: 97
Oddly enough, I was actually about to ask a question about scanning with RSI using Wilder's Smoothing as well, so I guess I migth as well do it in this thread.  Basically, the is how I have the indicator set up on my charts -- the Wilder's Smoothing option is checked.  However, I just wrote a pcf using RSI, and got very different results from what I got when sorting by right-clicking on the RSI indicator on my charts and selecting "Actual Value."  I realized fairly quickly that the reason for this is that the "RSI" build into the pcf language apparently does NOT use Wilder's Smoothing. 
 
My question, therefore, is, is there a way to reflect in pcf language an RSI with a period of 2, average of Avg Period of 1, Exponential average type, and, of course, Wilder's Smoothing?  Furthermore, if so, what would be the formula for yesterday's value?  What I'm trying to get at is "yesterday's RSI value (with the settings I listed) above 95."  Obviously, the "above 95" part isn't the problem -- what comes before it is.  Thanks.
Bruce_L
Posted : Monday, March 31, 2014 1:56:37 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The current 2-Period Wilder's RSI can be written as:
 
50 * (C - XAVGC3.1) / 2 / (.5000305 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50
 
And the previous 2-Period Wilder's RSI can be written as:
 
50 * (C1 - XAVGC3.2) / 2 / (.5000305 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50


-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.