Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Relative Momentum Index PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ericsimpson1
Posted : Thursday, April 25, 2013 10:39:07 PM
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.

Bruce_L
Posted : Friday, April 26, 2013 8:19:40 AM


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
ericsimpson1
Posted : Friday, April 26, 2013 2:20:12 PM
Registered User
Joined: 4/25/2013
Posts: 2

Thank you Bruce!

dtwchu
Posted : Sunday, May 25, 2014 1:53:15 PM
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.

Bruce_L
Posted : Tuesday, May 27, 2014 4:11:06 PM


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
diceman
Posted : Wednesday, May 28, 2014 9:29:59 AM
Registered User
Joined: 1/28/2005
Posts: 6,049

The above PCF goes well over 100.

 

 

 

 

Thanks

 

Bruce_L
Posted : Wednesday, May 28, 2014 9:50:21 AM


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
dtwchu
Posted : Wednesday, May 28, 2014 8:43:57 PM
Registered User
Joined: 2/10/2010
Posts: 26

Wow, this will take me some time to digest.  Thanks.

Bruce_L
Posted : Thursday, May 29, 2014 8:19:28 AM


Worden Trainer

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

You're welcome.



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