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.

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

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

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.

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

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.