Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

RSI - Wilder's PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thewealthpilot
Posted : Tuesday, July 30, 2013 12:19:41 PM
Registered User
Joined: 7/28/2013
Posts: 31

Is it possible to get the PCF for Wilder's RSI, at 10 and 14, when it crosses above/below the 70, and above/below the 30?

StockGuy
Posted : Tuesday, July 30, 2013 1:37:54 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Do you want to know if either RSI is crossing up or down through 70 or 30, all in one condition? Or do you want to know specifically when RSI 10 crosses up through 70?  When it crosses down through 70, etc.

 

thewealthpilot
Posted : Tuesday, July 30, 2013 2:27:44 PM
Registered User
Joined: 7/28/2013
Posts: 31

yes, individually would be fine. 4 separate conditions, OR two separate conditions, one being a +/- the 70, and the other +/- the 30.

Bruce_L
Posted : Monday, August 5, 2013 10:54:44 AM


Worden Trainer

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

A Condition Formula for a Wilder's Smoothed RSI crossing up or down through 30 could be written as:

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

Changing this to 70 instead of 30 involves changing the - 30 near the end of both halfs of the formula to - 70 instead:

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

A Condition Formula for the 10-Period Wilder's Smoothed RSI crossing through 30 in either direction is a bit shorter:

SGN(50 * (C - XAVGC19.1) / 10 / (.100009 * (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) <> SGN(50 * (C1 - XAVGC19.2) / 10 / (.100009 * (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)

And again, we just need to change the - 30 at the end of each half to - 70 to check for crossing through the 70 instead:

SGN(50 * (C - XAVGC19.1) / 10 / (.100009 * (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 - 70) <> SGN(50 * (C1 - XAVGC19.2) / 10 / (.100009 * (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 - 70)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tcalhoun
Posted : Sunday, November 30, 2014 11:05:19 PM
Gold Customer Gold Customer

Joined: 9/21/2014
Posts: 3

Bruce I can usually find all these answers i need here on the forum but the programming of this one is beyond my scope. I am looking for the same thing here. a 5 period RSI crossing up above 70 and below 30 so i can plot it as a histogram that gives me a bar on the chart as to when this occures.

Thank you in advance.

Terry

PLatinum member.

Bruce_L
Posted : Monday, December 1, 2014 2:34:48 PM


Worden Trainer

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

Please try the following Condition Formula for a 5-period Wilder's smoothed RSI crossing up through 70.

50 * (C - XAVGC9.1) / 5 / (.200017 * (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 > 70 AND 50 * (C1 - XAVGC9.2) / 5 / (.200017 * (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 <= 70

And the following Condition Formula to check for crossing down through 30.

50 * (C - XAVGC9.1) / 5 / (.200017 * (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 / (.200017 * (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



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