Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 4/25/2013 Posts: 2
|
Hi, I want to make a PCF for RMI(4,2). Any help would be much appreciated.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Indicator Formula:
momentum index
100 * (ABS(C > C2) * (C - C2) + .75 * (ABS(C1 > C3) * (C1 - C3) + .75 * (ABS(C2 > C4) * (C2 - C4) + .75 * (ABS(C3 > C5) * (C3 - C5) + .75 * (ABS(C4 > C6) * (C4 - C6) + .75 * (ABS(C5 > C7) * (C5 - C7) + .75 * (ABS(C6 > C8) * (C6 - C8) + .75 * (ABS(C7 > C9) * (C7 - C9) + .75 * (ABS(C8 > C10) * (C8 - C10) + .75 * (ABS(C9 > C11) * (C9 - C11) + .75 * (ABS(C10 > C12) * (C10 - C12) + .75 * (ABS(C11 > C13) * (C11 - C13) + .75 * (ABS(C12 > C14) * (C12 - C14) + .75 * (ABS(C13 > C15) * (C13 - C15) + .75 * (ABS(C14 > C16) * (C14 - C16) + .75 * (ABS(C15 > C17) * (C15 - C17) + .75 * (ABS(C16 > C18) * (C16 - C18) + .75 * (ABS(C17 > C19) * (C17 - C19) + .75 * (ABS(C18 > C20) * (C18 - C20) + .75 * (ABS(C19 > C21) * (C19 - C21) + .75 * (ABS(C20 > C22) * (C20 - C22) + .75 * (ABS(C21 > C23) * (C21 - C23) + .75 * (ABS(C22 > C24) * (C22 - C24) + .75 * (ABS(C23 > C25) * (C23 - C25) + .75 * (ABS(C24 > C26) * (C24 - C26) + .75 * (ABS(C25 > C27) * (C25 - C27) + .75 * (ABS(C26 > C28) * (C26 - C28) + .75 * (ABS(C27 > C29) * (C27 - C29) + .75 * (ABS(C28 > C30) * (C28 - C30) + .75 * (ABS(C29 > C31) * (C29 - C31) + .75 * (ABS(C30 > C32) * (C30 - C32) + .75 * (ABS(C31 > C33) * (C31 - C33) + .75 * (ABS(C32 > C34) * (C32 - C34)))))))))))))))))))))))))))))))))) / (ABS(C - C2) + .75 * (ABS(C1 - C3) + .75 * (ABS(C2 - C4) + .75 * (ABS(C3 - C5) + .75 * (ABS(C4 - C6) + .75 * (ABS(C5 - C7) + .75 * (ABS(C6 - C8) + .75 * (ABS(C7 - C9) + .75 * (ABS(C8 - C10) + .75 * (ABS(C9 - C11) + .75 * (ABS(C10 - C12) + .75 * (ABS(C11 - C13) + .75 * (ABS(C12 - C14) + .75 * (ABS(C13 - C15) + .75 * (ABS(C14 - C16) + .75 * (ABS(C15 - C17) + .75 * (ABS(C16 - C18) + .75 * (ABS(C17 - C19) + .75 * (ABS(C18 - C20) + .75 * (ABS(C19 - C21) + .75 * (ABS(C20 - C22) + .75 * (ABS(C21 - C23) + .75 * (ABS(C22 - C24) + .75 * (ABS(C23 - C25) + .75 * (ABS(C24 - C26) + .75 * (ABS(C25 - C27) + .75 * (ABS(C26 - C28) + .75 * (ABS(C27 - C29) + .75 * (ABS(C28 - C30) + .75 * (ABS(C29 - C31) + .75 * (ABS(C30 - C32) + .75 * (ABS(C31 - C33) + .75 * (ABS(C32 - C34))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 4/25/2013 Posts: 2
|
Thank you Bruce!
|
|
Registered User Joined: 2/10/2010 Posts: 26
|
Hi, I am trying to learn about RMI and I would need a PCF for RMI(20,3). Please help. Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you are really looking to learn more about the RMI instead of just getting the formula, you might want to read through the momentum index topic referenced in my original response or seach the internet.
You can extend the pattern in both the numerator and denominator further if you need a more accurate version of RMI(20,3), but this is the longest version which is short and fast enough to be practical or post in the forums:
100 * ((C > C4) * (C4 - C) + .95 * ((C1 > C5) * (C5 - C1) + .95 * ((C2 > C6) * (C6 - C2) + .95 * ((C3 > C7) * (C7 - C3) + .95 * ((C4 > C8) * (C8 - C4) + .95 * ((C5 > C9) * (C9 - C5) + .95 * ((C6 > C10) * (C10 - C6) + .95 * ((C7 > C11) * (C11 - C7) + .95 * ((C8 > C12) * (C12 - C8) + .95 * ((C9 > C13) * (C13 - C9) + .95 * ((C10 > C14) * (C14 - C10) + .95 * ((C11 > C15) * (C15 - C11) + .95 * ((C12 > C16) * (C16 - C12) + .95 * ((C13 > C17) * (C17 - C13) + .95 * ((C14 > C18) * (C18 - C14) + .95 * ((C15 > C19) * (C19 - C15) + .95 * ((C16 > C20) * (C20 - C16) + .95 * ((C17 > C21) * (C21 - C17) + .95 * ((C18 > C22) * (C22 - C18) + .95 * ((C19 > C23) * (C23 - C19) + .95 * ((C20 > C24) * (C24 - C20) + .95 * ((C21 > C25) * (C25 - C21) + .95 * ((C22 > C26) * (C26 - C22) + .95 * ((C23 > C27) * (C27 - C23) + .95 * ((C24 > C28) * (C28 - C24) + .95 * ((C25 > C29) * (C29 - C25) + .95 * ((C26 > C30) * (C30 - C26) + .95 * ((C27 > C31) * (C31 - C27) + .95 * ((C28 > C32) * (C32 - C28) + .95 * ((C29 > C33) * (C33 - C29) + .95 * ((C30 > C34) * (C34 - C30) + .95 * ((C31 > C35) * (C35 - C31) + .95 * ((C32 > C36) * (C36 - C32) + .95 * ((C33 > C37) * (C37 - C33) + .95 * ((C34 > C38) * (C38 - C34) + .95 * ((C35 > C39) * (C39 - C35) + .95 * ((C36 > C40) * (C40 - C36) + .95 * ((C37 > C41) * (C41 - C37) + .95 * ((C38 > C42) * (C42 - C38) + .95 * ((C39 > C43) * (C43 - C39) + .95 * ((C40 > C44) * (C44 - C40) + .95 * ((C41 > C45) * (C45 - C41) + .95 * ((C42 > C46) * (C46 - C42) + .95 * ((C43 > C47) * (C47 - C43) + .95 * ((C44 > C48) * (C48 - C44) + .95 * ((C45 > C49) * (C49 - C45) + .95 * ((C46 > C50) * (C50 - C46) + .95 * ((C47 > C51) * (C51 - C47) + .95 * ((C48 > C52) * (C52 - C48) + .95 * ((C49 > C53) * (C53 - C49) + .95 * ((C50 > C54) * (C54 - C50) + .95 * ((C51 > C55) * (C55 - C51) + .95 * ((C52 > C56) * (C56 - C52) + .95 * ((C53 > C57) * (C57 - C53) + .95 * ((C54 > C58) * (C58 - C54) + .95 * ((C55 > C59) * (C59 - C55) + .95 * ((C56 > C60) * (C60 - C56) + .95 * ((C57 > C61) * (C61 - C57) + .95 * ((C58 > C62) * (C62 - C58) + .95 * ((C59 > C63) * (C63 - C59) + .95 * ((C60 > C64) * (C64 - C60) + .95 * ((C61 > C65) * (C65 - C61) + .95 * ((C62 > C66) * (C66 - C62) + .95 * ((C63 > C67) * (C67 - C63) + .95 * ((C64 > C68) * (C68 - C64) + .95 * ((C65 > C69) * (C69 - C65) + .95 * ((C66 > C70) * (C70 - C66) + .95 * ((C67 > C71) * (C71 - C67) + .95 * ((C68 > C72) * (C72 - C68) + .95 * ((C69 > C73) * (C73 - C69) + .95 * ((C70 > C74) * (C74 - C70) + .95 * ((C71 > C75) * (C75 - C71) + .95 * ((C72 > C76) * (C76 - C72) + .95 * ((C73 > C77) * (C77 - C73) + .95 * ((C74 > C78) * (C78 - C74) + .95 * ((C75 > C79) * (C79 - C75) + .95 * ((C76 > C80) * (C80 - C76) + .95 * ((C77 > C81) * (C81 - C77) + .95 * ((C78 > C82) * (C82 - C78) + .95 * ((C79 > C83) * (C83 - C79) + .95 * ((C80 > C84) * (C84 - C80) + .95 * ((C81 > C85) * (C85 - C81) + .95 * ((C82 > C86) * (C86 - C82) + .95 * ((C83 > C87) * (C87 - C83) + .95 * ((C84 > C88) * (C88 - C84) + .95 * ((C85 > C89) * (C89 - C85) + .95 * ((C86 > C90) * (C90 - C86) + .95 * ((C87 > C91) * (C91 - C87) + .95 * ((C88 > C92) * (C92 - C88) + .95 * ((C89 > C93) * (C93 - C89) + .95 * ((C90 > C94) * (C94 - C90) + .95 * ((C91 > C95) * (C95 - C91) + .95 * ((C92 > C96) * (C96 - C92) + .95 * ((C93 > C97) * (C97 - C93) + .95 * ((C94 > C98) * (C98 - C94) + .95 * ((C95 > C99) * (C99 - C95) + .95 * ((C96 > C100) * (C100 - C96) + .95 * ((C97 > C101) * (C101 - C97) + .95 * ((C98 > C102) * (C102 - C98) + .95 * ((C99 > C103) * (C103 - C99) + .95 * ((C100 > C104) * (C104 - C100) + .95 * ((C101 > C105) * (C105 - C101) + .95 * ((C102 > C106) * (C106 - C102) + .95 * ((C103 > C107) * (C107 - C103) + .95 * ((C104 > C108) * (C108 - C104) + .95 * ((C105 > C109) * (C109 - C105) + .95 * ((C106 > C110) * (C110 - C106) + .95 * ((C107 > C111) * (C111 - C107) + .95 * ((C108 > C112) * (C112 - C108) + .95 * ((C109 > C113) * (C113 - C109) + .95 * ((C110 > C114) * (C114 - C110) + .95 * ((C111 > C115) * (C115 - C111) + .95 * ((C112 > C116) * (C116 - C112) + .95 * ((C113 > C117) * (C117 - C113) + .95 * ((C114 > C118) * (C118 - C114) + .95 * ((C115 > C119) * (C119 - C115) + .95 * ((C116 > C120) * (C120 - C116) + .95 * ((C117 > C121) * (C121 - C117) + .95 * ((C118 > C122) * (C122 - C118) + .95 * ((C119 > C123) * (C123 - C119) + .95 * ((C120 > C124) * (C124 - C120) + .95 * ((C121 > C125) * (C125 - C121) + .95 * ((C122 > C126) * (C126 - C122) + .95 * ((C123 > C127) * (C127 - C123) + .95 * ((C124 > C128) * (C128 - C124) + .95 * ((C125 > C129) * (C129 - C125) + .95 * ((C126 > C130) * (C130 - C126) + .95 * ((C127 > C131) * (C131 - C127) + .95 * ((C128 > C132) * (C132 - C128) + .95 * ((C129 > C133) * (C133 - C129) + .95 * ((C130 > C134) * (C134 - C130) + .95 * ((C131 > C135) * (C135 - C131) + .95 * ((C132 > C136) * (C136 - C132) + .95 * ((C133 > C137) * (C137 - C133) + .95 * ((C134 > C138) * (C138 - C134) + .95 * ((C135 > C139) * (C139 - C135) + .95 * ((C136 > C140) * (C140 - C136) + .95 * ((C137 > C141) * (C141 - C137) + .95 * ((C138 > C142) * (C142 - C138) + .95 * ((C139 > C143) * (C143 - C139) + .95 * ((C140 > C144) * (C144 - C140) + .95 * ((C141 > C145) * (C145 - C141) + .95 * ((C142 > C146) * (C146 - C142) + .95 * ((C143 > C147) * (C147 - C143) + .95 * ((C144 > C148) * (C148 - C144) + .95 * ((C145 > C149) * (C149 - C145) + .95 * ((C146 > C150) * (C150 - C146) + .95 * ((C147 > C151) * (C151 - C147) + .95 * ((C148 > C152) * (C152 - C148) + .95 * ((C149 > C153) * (C153 - C149) + .95 * ((C150 > C154) * (C154 - C150) + .95 * ((C151 > C155) * (C155 - C151) + .95 * ((C152 > C156) * (C156 - C152) + .95 * ((C153 > C157) * (C157 - C153) + .95 * ((C154 > C158) * (C158 - C154) + .95 * ((C155 > C159) * (C159 - C155))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C - C4) + .95 * (ABS(C1 - C5) + .95 * (ABS(C2 - C6) + .95 * (ABS(C3 - C7) + .95 * (ABS(C4 - C8) + .95 * (ABS(C5 - C9) + .95 * (ABS(C6 - C10) + .95 * (ABS(C7 - C11) + .95 * (ABS(C8 - C12) + .95 * (ABS(C9 - C13) + .95 * (ABS(C10 - C14) + .95 * (ABS(C11 - C15) + .95 * (ABS(C12 - C16) + .95 * (ABS(C13 - C17) + .95 * (ABS(C14 - C18) + .95 * (ABS(C15 - C19) + .95 * (ABS(C16 - C20) + .95 * (ABS(C17 - C21) + .95 * (ABS(C18 - C22) + .95 * (ABS(C19 - C23) + .95 * (ABS(C20 - C24) + .95 * (ABS(C21 - C25) + .95 * (ABS(C22 - C26) + .95 * (ABS(C23 - C27) + .95 * (ABS(C24 - C28) + .95 * (ABS(C25 - C29) + .95 * (ABS(C26 - C30) + .95 * (ABS(C27 - C31) + .95 * (ABS(C28 - C32) + .95 * (ABS(C29 - C33) + .95 * (ABS(C30 - C34) + .95 * (ABS(C31 - C35) + .95 * (ABS(C32 - C36) + .95 * (ABS(C33 - C37) + .95 * (ABS(C34 - C38) + .95 * (ABS(C35 - C39) + .95 * (ABS(C36 - C40) + .95 * (ABS(C37 - C41) + .95 * (ABS(C38 - C42) + .95 * (ABS(C39 - C43) + .95 * (ABS(C40 - C44) + .95 * (ABS(C41 - C45) + .95 * (ABS(C42 - C46) + .95 * (ABS(C43 - C47) + .95 * (ABS(C44 - C48) + .95 * (ABS(C45 - C49) + .95 * (ABS(C46 - C50) + .95 * (ABS(C47 - C51) + .95 * (ABS(C48 - C52) + .95 * (ABS(C49 - C53) + .95 * (ABS(C50 - C54) + .95 * (ABS(C51 - C55) + .95 * (ABS(C52 - C56) + .95 * (ABS(C53 - C57) + .95 * (ABS(C54 - C58) + .95 * (ABS(C55 - C59) + .95 * (ABS(C56 - C60) + .95 * (ABS(C57 - C61) + .95 * (ABS(C58 - C62) + .95 * (ABS(C59 - C63) + .95 * (ABS(C60 - C64) + .95 * (ABS(C61 - C65) + .95 * (ABS(C62 - C66) + .95 * (ABS(C63 - C67) + .95 * (ABS(C64 - C68) + .95 * (ABS(C65 - C69) + .95 * (ABS(C66 - C70) + .95 * (ABS(C67 - C71) + .95 * (ABS(C68 - C72) + .95 * (ABS(C69 - C73) + .95 * (ABS(C70 - C74) + .95 * (ABS(C71 - C75) + .95 * (ABS(C72 - C76) + .95 * (ABS(C73 - C77) + .95 * (ABS(C74 - C78) + .95 * (ABS(C75 - C79) + .95 * (ABS(C76 - C80) + .95 * (ABS(C77 - C81) + .95 * (ABS(C78 - C82) + .95 * (ABS(C79 - C83) + .95 * (ABS(C80 - C84) + .95 * (ABS(C81 - C85) + .95 * (ABS(C82 - C86) + .95 * (ABS(C83 - C87) + .95 * (ABS(C84 - C88) + .95 * (ABS(C85 - C89) + .95 * (ABS(C86 - C90) + .95 * (ABS(C87 - C91) + .95 * (ABS(C88 - C92) + .95 * (ABS(C89 - C93) + .95 * (ABS(C90 - C94) + .95 * (ABS(C91 - C95) + .95 * (ABS(C92 - C96) + .95 * (ABS(C93 - C97) + .95 * (ABS(C94 - C98) + .95 * (ABS(C95 - C99) + .95 * (ABS(C96 - C100) + .95 * (ABS(C97 - C101) + .95 * (ABS(C98 - C102) + .95 * (ABS(C99 - C103) + .95 * (ABS(C100 - C104) + .95 * (ABS(C101 - C105) + .95 * (ABS(C102 - C106) + .95 * (ABS(C103 - C107) + .95 * (ABS(C104 - C108) + .95 * (ABS(C105 - C109) + .95 * (ABS(C106 - C110) + .95 * (ABS(C107 - C111) + .95 * (ABS(C108 - C112) + .95 * (ABS(C109 - C113) + .95 * (ABS(C110 - C114) + .95 * (ABS(C111 - C115) + .95 * (ABS(C112 - C116) + .95 * (ABS(C113 - C117) + .95 * (ABS(C114 - C118) + .95 * (ABS(C115 - C119) + .95 * (ABS(C116 - C120) + .95 * (ABS(C117 - C121) + .95 * (ABS(C118 - C122) + .95 * (ABS(C119 - C123) + .95 * (ABS(C120 - C124) + .95 * (ABS(C121 - C125) + .95 * (ABS(C122 - C126) + .95 * (ABS(C123 - C127) + .95 * (ABS(C124 - C128) + .95 * (ABS(C125 - C129) + .95 * (ABS(C126 - C130) + .95 * (ABS(C127 - C131) + .95 * (ABS(C128 - C132) + .95 * (ABS(C129 - C133) + .95 * (ABS(C130 - C134) + .95 * (ABS(C131 - C135) + .95 * (ABS(C132 - C136) + .95 * (ABS(C133 - C137) + .95 * (ABS(C134 - C138) + .95 * (ABS(C135 - C139) + .95 * (ABS(C136 - C140) + .95 * (ABS(C137 - C141) + .95 * (ABS(C138 - C142) + .95 * (ABS(C139 - C143) + .95 * (ABS(C140 - C144) + .95 * (ABS(C141 - C145) + .95 * (ABS(C142 - C146) + .95 * (ABS(C143 - C147) + .95 * (ABS(C144 - C148) + .95 * (ABS(C145 - C149) + .95 * (ABS(C146 - C150) + .95 * (ABS(C147 - C151) + .95 * (ABS(C148 - C152) + .95 * (ABS(C149 - C153) + .95 * (ABS(C150 - C154) + .95 * (ABS(C151 - C155) + .95 * (ABS(C152 - C156) + .95 * (ABS(C153 - C157) + .95 * (ABS(C154 - C158) + .95 * (ABS(C155 - C159)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
The above PCF goes well over 100.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Thank you for bringing it to my attention. I had the somehow switched the numerator and denominator when I pasted them into the forums.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 2/10/2010 Posts: 26
|
Wow, this will take me some time to digest. Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |