Hi Bruce.

Could you please write me a PCF for a True Strength Index 5 20 on a 3Day time frame

that I can use to search any of my watch lists for the following:

TRSI 5 20 has crossed below its 0 line any time in the last 42 Days and is now

in the last 3 Days crossing up over its EMA 5.

We can create a Condition Formula for TSI 5,20 crossing below zero:

(XAVG(XAVGC20,5) - XAVG(XAVGC20.1,5)) / (.1207444 * (ABS(C - C1) + 19 / 21 * (ABS(C1 - C2) + 19 / 21 * (ABS(C2 - C3) + 19 / 21 * (ABS(C3 - C4) + 19 / 21 * (ABS(C4 - C5) + 19 / 21 * (ABS(C5 - C6) + 19 / 21 * (ABS(C6 - C7) + 19 / 21 * (ABS(C7 - C8) + 19 / 21 * (ABS(C8 - C9) + 19 / 21 * (ABS(C9 - C10) + 19 / 21 * (ABS(C10 - C11) + 19 / 21 * (ABS(C11 - C12) + 19 / 21 * (ABS(C12 - C13) + 19 / 21 * (ABS(C13 - C14) + 19 / 21 * (ABS(C14 - C15) + 19 / 21 * (ABS(C15 - C16) + 19 / 21 * (ABS(C16 - C17) + 19 / 21 * (ABS(C17 - C18) + 19 / 21 * (ABS(C18 - C19) + 19 / 21 * (ABS(C19 - C20) + 19 / 21 * (ABS(C20 - C21) + 19 / 21 * (ABS(C21 - C22) + 19 / 21 * (ABS(C22 - C23) + 19 / 21 * (ABS(C23 - C24) + 19 / 21 * (ABS(C24 - C25) + 19 / 21 * (ABS(C25 - C26) + 19 / 21 * (ABS(C26 - C27) + 19 / 21 * (ABS(C27 - C28) + 19 / 21 * (ABS(C28 - C29) + 19 / 21 * (ABS(C29 - C30) + 19 / 21 * (ABS(C30 - C31) + 19 / 21 * (ABS(C31 - C32) + 19 / 21 * (ABS(C32 - C33) + 19 / 21 * (ABS(C33 - C34) + 19 / 21 * (ABS(C34 - C35) + 19 / 21 * (ABS(C35 - C36) + 19 / 21 * (ABS(C36 - C37) + 19 / 21 * (ABS(C37 - C38) + 19 / 21 * (ABS(C38 - C39) + 19 / 21 * (ABS(C39 - C40) + 19 / 21 * (ABS(C40 - C41) + 19 / 21 * (ABS(C41 - C42) + 19 / 21 * (ABS(C42 - C43) + 19 / 21 * (ABS(C43 - C44) + 19 / 21 * (ABS(C44 - C45) + 19 / 21 * (ABS(C45 - C46) + 19 / 21 * (ABS(C46 - C47) + 19 / 21 * (ABS(C47 - C48) + 19 / 21 * (ABS(C48 - C49) + 19 / 21 * (ABS(C49 - C50) + 19 / 21 * (ABS(C50 - C51) + 19 / 21 * (ABS(C51 - C52) + 19 / 21 * (ABS(C52 - C53) + 19 / 21 * (ABS(C53 - C54) + 19 / 21 * (ABS(C54 - C55) + 19 / 21 * (ABS(C55 - C56) + 19 / 21 * (ABS(C56 - C57) + 19 / 21 * (ABS(C57 - C58) + 19 / 21 * (ABS(C58 - C59) + 19 / 21 * (ABS(C59 - C60) + 19 / 21 * (ABS(C60 - C61) + 19 / 21 * (ABS(C61 - C62) + 19 / 21 * (ABS(C62 - C63) + 19 / 21 * (ABS(C63 - C64) + 19 / 21 * (ABS(C64 - C65) + 19 / 21 * (ABS(C65 - C66) + 19 / 21 * (ABS(C66 - C67) + 19 / 21 * (ABS(C67 - C68) + 19 / 21 * (ABS(C68 - C69) + 19 / 21 * (ABS(C69 - C70))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - .08894908 * (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)))))))))))))))))))) < 0 AND (XAVG(XAVGC20.1,5) - XAVG(XAVGC20.2,5)) / (.1207444 * (ABS(C1 - C2) + 19 / 21 * (ABS(C2 - C3) + 19 / 21 * (ABS(C3 - C4) + 19 / 21 * (ABS(C4 - C5) + 19 / 21 * (ABS(C5 - C6) + 19 / 21 * (ABS(C6 - C7) + 19 / 21 * (ABS(C7 - C8) + 19 / 21 * (ABS(C8 - C9) + 19 / 21 * (ABS(C9 - C10) + 19 / 21 * (ABS(C10 - C11) + 19 / 21 * (ABS(C11 - C12) + 19 / 21 * (ABS(C12 - C13) + 19 / 21 * (ABS(C13 - C14) + 19 / 21 * (ABS(C14 - C15) + 19 / 21 * (ABS(C15 - C16) + 19 / 21 * (ABS(C16 - C17) + 19 / 21 * (ABS(C17 - C18) + 19 / 21 * (ABS(C18 - C19) + 19 / 21 * (ABS(C19 - C20) + 19 / 21 * (ABS(C20 - C21) + 19 / 21 * (ABS(C21 - C22) + 19 / 21 * (ABS(C22 - C23) + 19 / 21 * (ABS(C23 - C24) + 19 / 21 * (ABS(C24 - C25) + 19 / 21 * (ABS(C25 - C26) + 19 / 21 * (ABS(C26 - C27) + 19 / 21 * (ABS(C27 - C28) + 19 / 21 * (ABS(C28 - C29) + 19 / 21 * (ABS(C29 - C30) + 19 / 21 * (ABS(C30 - C31) + 19 / 21 * (ABS(C31 - C32) + 19 / 21 * (ABS(C32 - C33) + 19 / 21 * (ABS(C33 - C34) + 19 / 21 * (ABS(C34 - C35) + 19 / 21 * (ABS(C35 - C36) + 19 / 21 * (ABS(C36 - C37) + 19 / 21 * (ABS(C37 - C38) + 19 / 21 * (ABS(C38 - C39) + 19 / 21 * (ABS(C39 - C40) + 19 / 21 * (ABS(C40 - C41) + 19 / 21 * (ABS(C41 - C42) + 19 / 21 * (ABS(C42 - C43) + 19 / 21 * (ABS(C43 - C44) + 19 / 21 * (ABS(C44 - C45) + 19 / 21 * (ABS(C45 - C46) + 19 / 21 * (ABS(C46 - C47) + 19 / 21 * (ABS(C47 - C48) + 19 / 21 * (ABS(C48 - C49) + 19 / 21 * (ABS(C49 - C50) + 19 / 21 * (ABS(C50 - C51) + 19 / 21 * (ABS(C51 - C52) + 19 / 21 * (ABS(C52 - C53) + 19 / 21 * (ABS(C53 - C54) + 19 / 21 * (ABS(C54 - C55) + 19 / 21 * (ABS(C55 - C56) + 19 / 21 * (ABS(C56 - C57) + 19 / 21 * (ABS(C57 - C58) + 19 / 21 * (ABS(C58 - C59) + 19 / 21 * (ABS(C59 - C60) + 19 / 21 * (ABS(C60 - C61) + 19 / 21 * (ABS(C61 - C62) + 19 / 21 * (ABS(C62 - C63) + 19 / 21 * (ABS(C63 - C64) + 19 / 21 * (ABS(C64 - C65) + 19 / 21 * (ABS(C65 - C66) + 19 / 21 * (ABS(C66 - C67) + 19 / 21 * (ABS(C67 - C68) + 19 / 21 * (ABS(C68 - C69) + 19 / 21 * (ABS(C69 - C70) + 19 / 21 * (ABS(C70 - C71))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - .08894908 * (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)))))))))))))))))))) >= 0

We can then use this as the Boolean Formula in a Custom PCF % True Indicator with the Period set to 42 and the Average Type set to Simple. The value of this Custom PCF % True Indicator will be greater than 0 if the Boolean Formula was true at any time during the most recent 42 bars. This allows us to click on the Custom PCF % True Indicator and select Create Scan Condition while using a 3-Day Time Frame to create a Condition for the value greater than 0 to create a Condition for your first requirement.

Create Scan Conditions from Your Chart

We cannot do anything similar for your second requirement however as a Conditon Formula for TSI 5,20 crossing up through its own EMA is too long and slow to be practical or post in the forums. This means we have to use another technique for this.

We will add two 1-Period Simple Moving Averages to both TSI and its EMA (for four 1-Period Simple Moving Averages total). The first set of moving averages to TSI and its EMA will have the Offset set to 1 and the second set of moving averages to TSI and its EMA will have the Offset set to 2.

We can then click on the TSI to create a Condition for TSI crossing up through its own EMA. We will also click on the moving average which is offset by 1 to create a Condition for the TSI Offset 1 crossing up through the EMA Offset 1 and the moving average which is offset by 2 to create a Condition for the TSI Offset 2 crossing up through the EMA Offset 2.

We should now have 4 Conditions total. We can add them all to same EasyScan as EasyScan Conditions to get a list of symbols meeting your requirements.

Build a Scan with Multiple Conditions

Hi Bruce.

Thank you for your prompt reply and the pointer for those videos, I might be able to work

something out with them.

Thanks again hheiden.

You're welcome.