Bruce,

Can you please help me write a PCF for tc 2012:

I am trying to create a condition where  the 5 period wilders rsi of today is below 30 and the 5 period wilders rsi of yesterday was above 30.  

Thanks for your help 

Kirk

You are far better off just clicking on Wilder's RSI and selecting Create Scan Condition to create a Condition for a 5-Period Wilder's RSI crossing down through 30.

Create Scan and Sort Conditions

That said, it is possible to create a Condition Formula for this instead (but it is more difficult to do and the result will less efficient, slower and use more resources):

50 * (C - XAVGC9.1) / 5 / (.20001701556587 * (ABS(C - C1) + .8 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31) + .8 * (ABS(C31 - C32) + .8 * (ABS(C32 - C33) + .8 * (ABS(C33 - C34) + .8 * (ABS(C34 - C35) + .8 * (ABS(C35 - C36) + .8 * (ABS(C36 - C37) + .8 * (ABS(C37 - C38) + .8 * (ABS(C38 - C39) + .8 * (ABS(C39 - C40) + .8 * (ABS(C40 - C41) + .8 * (ABS(C41 - C42)))))))))))))))))))))))))))))))))))))))))))) + 50 < 30 AND 50 * (C1 - XAVGC9.2) / 5 / (.20001701556587 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31) + .8 * (ABS(C31 - C32) + .8 * (ABS(C32 - C33) + .8 * (ABS(C33 - C34) + .8 * (ABS(C34 - C35) + .8 * (ABS(C35 - C36) + .8 * (ABS(C36 - C37) + .8 * (ABS(C37 - C38) + .8 * (ABS(C38 - C39) + .8 * (ABS(C39 - C40) + .8 * (ABS(C40 - C41) + .8 * (ABS(C41 - C42) + .8 * (ABS(C42 - C43)))))))))))))))))))))))))))))))))))))))))))) + 50 > 30

Personal Criteria Formula Conditions
Cascades of Moving Averages
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Bruce,

Thank you very much code works great!!

Kirk

You're welcome.