Bruce (et al),

Is it possible to code a PCF (v12.6) to find WilderRSI (10day) crossing above 30 on any of the last 3 days?

I can do it for the current candle, but am not sure how to code offset days in a "from chart" scan.

Any help?

Thanks

This is a lot easier in TC2000 v17. If you don't care if it is still above 30, then it can be written as follows.

CountTrue(XUP(WRSI10, 30), 3) > 0

If you do care if it still above 30.

WRSI10 > 30 AND CountTrue(WRSI10.1 <= 30, 3) > 0

And if you are willing to settle for above now but below 3 bars ago.

XUP(WRSI10, 30, 3)

But the first of the three formulas above is too long and slow to be practical when converted to TC2000 v12.6. The second is still really long and slow.

50 * (C - XAVGC19.1) / 10 / (.10000941 * (ABS(C - 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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 30 AND (50 * (C1 - XAVGC19.2) / 10 / (.10000941 * (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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88) + .9 * (ABS(C88 - C89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30 OR 50 * (C2 - XAVGC19.3) / 10 / (.10000941 * (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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88) + .9 * (ABS(C88 - C89) + .9 * (ABS(C89 - C90)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30 OR 50 * (C3 - XAVGC19.4) / 10 / (.10000941 * (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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88) + .9 * (ABS(C88 - C89) + .9 * (ABS(C89 - C90) + .9 * (ABS(C90 - C91)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30)

And even the third is pretty long and slow.

50 * (C - XAVGC19.1) / 10 / (.10000941 * (ABS(C - 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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 30 AND 50 * (C3 - XAVGC19.4) / 10 / (.10000941 * (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) + .9 * (ABS(C66 - C67) + .9 * (ABS(C67 - C68) + .9 * (ABS(C68 - C69) + .9 * (ABS(C69 - C70) + .9 * (ABS(C70 - C71) + .9 * (ABS(C71 - C72) + .9 * (ABS(C72 - C73) + .9 * (ABS(C73 - C74) + .9 * (ABS(C74 - C75) + .9 * (ABS(C75 - C76) + .9 * (ABS(C76 - C77) + .9 * (ABS(C77 - C78) + .9 * (ABS(C78 - C79) + .9 * (ABS(C79 - C80) + .9 * (ABS(C80 - C81) + .9 * (ABS(C81 - C82) + .9 * (ABS(C82 - C83) + .9 * (ABS(C83 - C84) + .9 * (ABS(C84 - C85) + .9 * (ABS(C85 - C86) + .9 * (ABS(C86 - C87) + .9 * (ABS(C87 - C88) + .9 * (ABS(C88 - C89) + .9 * (ABS(C89 - C90) + .9 * (ABS(C90 - C91)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 <= 30