## New version 18 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 2 pages: [1] 2
 RMI help Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
mnouri1975
 Posted : Wednesday, October 17, 2012 4:14:51 AM
Registered User
Joined: 3/13/2006
Posts: 25

Hello,

Bruce, could you please help me write the RMI (relative momentum index) PCF for settings 14,5. I have seen this thread http://forums.worden.com/default.aspx?g=posts&t=10910 but could not figure out how to do it.

Bruce_L
 Posted : Wednesday, October 17, 2012 8:42:15 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

Please try the following Indicator Formula:

100 * ((C > C5) * (C5 - C) + 13 / 14 * ((C1 > C6) * (C6 - C1) + 13 / 14 * ((C2 > C7) * (C7 - C2) + 13 / 14 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C5 - C) + 13 / 14 * (ABS(C6 - C1) + 13 / 14 * (ABS(C7 - C2) + 13 / 14 * (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
BobMc
 Posted : Wednesday, October 17, 2012 11:56:16 AM
Registered User
Joined: 10/7/2004
Posts: 816

Hi Bruce

Could you please convert this for stockfinder - with a user input variable for the period.

Many thanks

Regards

Bob Mc

Bruce_L
 Posted : Wednesday, October 17, 2012 12:16:41 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

Please try the following RealCode Indicator:

``````'|******************************************************************
'|*** StockFinder RealCode Indicator - Version 5.0 www.worden.com
'|*** Copy and paste this header and code into StockFinder *********
'|*** Indicator:Relative Momentum Index
'|******************************************************************
'# Smoothing = UserInput.Single = 14
'# Momentum = UserInput.Integer = 5
'# Cumulative
Static sumWeight As Single
Static termRatio As Single
Static weight As Single
Static Num As Single
Static Den As Single
Static RSI As Single
Static Net As Single
If 1 < Smoothing AndAlso 0 < Momentum Then
If isFirstBar Then
sumWeight = 1
termRatio = (Smoothing - 1) / Smoothing
Num = 0
Den = 0
RSI = Single.NaN
Net = 0
Else If CurrentIndex >= Momentum Then
Net = Price.Last - Price.Last(Momentum)
weight = 1 / sumWeight
Num = Num * (1 - Weight) + Weight * System.Math.Max(0, Net)
Den = Den * (1 - Weight) + Weight * System.Math.Abs(Net)
sumWeight = sumWeight * termRatio + 1
If Den > 0 Then
RSI = 100 * Num / Den
Plot = RSI
Else
RSI = 50
End If
End If
Plot = RSI
Else
Plot = Single.NaN
End If``````

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
 Posted : Friday, December 09, 2016 2:39:56 AM
Registered User
Joined: 9/17/2014
Posts: 17

What would the formula be for the RMI (relative momentum index) PCF for settings 6 and 7 period?

 Posted : Friday, December 09, 2016 2:57:05 AM
Registered User
Joined: 9/17/2014
Posts: 17

What would the formula be for the RMI (relative momentum index) PCF for settings 6 and 7 period?

RMI (relative momentum index) PCF for settings 6 and 7 period with smooting settings 1, 2 and 3.

Thanks

Bruce_L
 Posted : Friday, December 09, 2016 10:16:05 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

There will be a lot shorter ways to write these formulas very soon.

RMI6,1 is the same as RSI6.

50 * (C - XAVGC11.1) / 6 / (.16668193 * (ABS(C - C1) + 5 / 6 * (ABS(C1 - C2) + 5 / 6 * (ABS(C2 - C3) + 5 / 6 * (ABS(C3 - C4) + 5 / 6 * (ABS(C4 - C5) + 5 / 6 * (ABS(C5 - C6) + 5 / 6 * (ABS(C6 - C7) + 5 / 6 * (ABS(C7 - C8) + 5 / 6 * (ABS(C8 - C9) + 5 / 6 * (ABS(C9 - C10) + 5 / 6 * (ABS(C10 - C11) + 5 / 6 * (ABS(C11 - C12) + 5 / 6 * (ABS(C12 - C13) + 5 / 6 * (ABS(C13 - C14) + 5 / 6 * (ABS(C14 - C15) + 5 / 6 * (ABS(C15 - C16) + 5 / 6 * (ABS(C16 - C17) + 5 / 6 * (ABS(C17 - C18) + 5 / 6 * (ABS(C18 - C19) + 5 / 6 * (ABS(C19 - C20) + 5 / 6 * (ABS(C20 - C21) + 5 / 6 * (ABS(C21 - C22) + 5 / 6 * (ABS(C22 - C23) + 5 / 6 * (ABS(C23 - C24) + 5 / 6 * (ABS(C24 - C25) + 5 / 6 * (ABS(C25 - C26) + 5 / 6 * (ABS(C26 - C27) + 5 / 6 * (ABS(C27 - C28) + 5 / 6 * (ABS(C28 - C29) + 5 / 6 * (ABS(C29 - C30) + 5 / 6 * (ABS(C30 - C31) + 5 / 6 * (ABS(C31 - C32) + 5 / 6 * (ABS(C32 - C33) + 5 / 6 * (ABS(C33 - C34) + 5 / 6 * (ABS(C34 - C35) + 5 / 6 * (ABS(C35 - C36) + 5 / 6 * (ABS(C36 - C37) + 5 / 6 * (ABS(C37 - C38) + 5 / 6 * (ABS(C38 - C39) + 5 / 6 * (ABS(C39 - C40) + 5 / 6 * (ABS(C40 - C41) + 5 / 6 * (ABS(C41 - C42) + 5 / 6 * (ABS(C42 - C43) + 5 / 6 * (ABS(C43 - C44) + 5 / 6 * (ABS(C44 - C45) + 5 / 6 * (ABS(C45 - C46) + 5 / 6 * (ABS(C46 - C47) + 5 / 6 * (ABS(C47 - C48) + 5 / 6 * (ABS(C48 - C49) + 5 / 6 * (ABS(C49 - C50) + 5 / 6 * (ABS(C50 - C51))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

RMI7,1 is the same as RSI7.

50 * (C - XAVGC13.1) / 7 / (.14287089 * (ABS(C - C1) + 6 / 7 * (ABS(C1 - C2) + 6 / 7 * (ABS(C2 - C3) + 6 / 7 * (ABS(C3 - C4) + 6 / 7 * (ABS(C4 - C5) + 6 / 7 * (ABS(C5 - C6) + 6 / 7 * (ABS(C6 - C7) + 6 / 7 * (ABS(C7 - C8) + 6 / 7 * (ABS(C8 - C9) + 6 / 7 * (ABS(C9 - C10) + 6 / 7 * (ABS(C10 - C11) + 6 / 7 * (ABS(C11 - C12) + 6 / 7 * (ABS(C12 - C13) + 6 / 7 * (ABS(C13 - C14) + 6 / 7 * (ABS(C14 - C15) + 6 / 7 * (ABS(C15 - C16) + 6 / 7 * (ABS(C16 - C17) + 6 / 7 * (ABS(C17 - C18) + 6 / 7 * (ABS(C18 - C19) + 6 / 7 * (ABS(C19 - C20) + 6 / 7 * (ABS(C20 - C21) + 6 / 7 * (ABS(C21 - C22) + 6 / 7 * (ABS(C22 - C23) + 6 / 7 * (ABS(C23 - C24) + 6 / 7 * (ABS(C24 - C25) + 6 / 7 * (ABS(C25 - C26) + 6 / 7 * (ABS(C26 - C27) + 6 / 7 * (ABS(C27 - C28) + 6 / 7 * (ABS(C28 - C29) + 6 / 7 * (ABS(C29 - C30) + 6 / 7 * (ABS(C30 - C31) + 6 / 7 * (ABS(C31 - C32) + 6 / 7 * (ABS(C32 - C33) + 6 / 7 * (ABS(C33 - C34) + 6 / 7 * (ABS(C34 - C35) + 6 / 7 * (ABS(C35 - C36) + 6 / 7 * (ABS(C36 - C37) + 6 / 7 * (ABS(C37 - C38) + 6 / 7 * (ABS(C38 - C39) + 6 / 7 * (ABS(C39 - C40) + 6 / 7 * (ABS(C40 - C41) + 6 / 7 * (ABS(C41 - C42) + 6 / 7 * (ABS(C42 - C43) + 6 / 7 * (ABS(C43 - C44) + 6 / 7 * (ABS(C44 - C45) + 6 / 7 * (ABS(C45 - C46) + 6 / 7 * (ABS(C46 - C47) + 6 / 7 * (ABS(C47 - C48) + 6 / 7 * (ABS(C48 - C49) + 6 / 7 * (ABS(C49 - C50) + 6 / 7 * (ABS(C50 - C51) + 6 / 7 * (ABS(C51 - C52) + 6 / 7 * (ABS(C52 - C53) + 6 / 7 * (ABS(C53 - C54) + 6 / 7 * (ABS(C54 - C55) + 6 / 7 * (ABS(C55 - C56) + 6 / 7 * (ABS(C56 - C57) + 6 / 7 * (ABS(C57 - C58) + 6 / 7 * (ABS(C58 - C59) + 6 / 7 * (ABS(C59 - C60)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

RMI6,2 can be written as follows.

100 * ((C > C2) * (C2 - C) + 5 / 6 * ((C1 > C3) * (C3 - C1) + 5 / 6 * ((C2 > C4) * (C4 - C2) + 5 / 6 * ((C3 > C5) * (C5 - C3) + 5 / 6 * ((C4 > C6) * (C6 - C4) + 5 / 6 * ((C5 > C7) * (C7 - C5) + 5 / 6 * ((C6 > C8) * (C8 - C6) + 5 / 6 * ((C7 > C9) * (C9 - C7) + 5 / 6 * ((C8 > C10) * (C10 - C8) + 5 / 6 * ((C9 > C11) * (C11 - C9) + 5 / 6 * ((C10 > C12) * (C12 - C10) + 5 / 6 * ((C11 > C13) * (C13 - C11) + 5 / 6 * ((C12 > C14) * (C14 - C12) + 5 / 6 * ((C13 > C15) * (C15 - C13) + 5 / 6 * ((C14 > C16) * (C16 - C14) + 5 / 6 * ((C15 > C17) * (C17 - C15) + 5 / 6 * ((C16 > C18) * (C18 - C16) + 5 / 6 * ((C17 > C19) * (C19 - C17) + 5 / 6 * ((C18 > C20) * (C20 - C18) + 5 / 6 * ((C19 > C21) * (C21 - C19) + 5 / 6 * ((C20 > C22) * (C22 - C20) + 5 / 6 * ((C21 > C23) * (C23 - C21) + 5 / 6 * ((C22 > C24) * (C24 - C22) + 5 / 6 * ((C23 > C25) * (C25 - C23) + 5 / 6 * ((C24 > C26) * (C26 - C24) + 5 / 6 * ((C25 > C27) * (C27 - C25) + 5 / 6 * ((C26 > C28) * (C28 - C26) + 5 / 6 * ((C27 > C29) * (C29 - C27) + 5 / 6 * ((C28 > C30) * (C30 - C28) + 5 / 6 * ((C29 > C31) * (C31 - C29) + 5 / 6 * ((C30 > C32) * (C32 - C30) + 5 / 6 * ((C31 > C33) * (C33 - C31) + 5 / 6 * ((C32 > C34) * (C34 - C32) + 5 / 6 * ((C33 > C35) * (C35 - C33) + 5 / 6 * ((C34 > C36) * (C36 - C34) + 5 / 6 * ((C35 > C37) * (C37 - C35) + 5 / 6 * ((C36 > C38) * (C38 - C36) + 5 / 6 * ((C37 > C39) * (C39 - C37) + 5 / 6 * ((C38 > C40) * (C40 - C38) + 5 / 6 * ((C39 > C41) * (C41 - C39) + 5 / 6 * ((C40 > C42) * (C42 - C40) + 5 / 6 * ((C41 > C43) * (C43 - C41) + 5 / 6 * ((C42 > C44) * (C44 - C42) + 5 / 6 * ((C43 > C45) * (C45 - C43) + 5 / 6 * ((C44 > C46) * (C46 - C44) + 5 / 6 * ((C45 > C47) * (C47 - C45) + 5 / 6 * ((C46 > C48) * (C48 - C46) + 5 / 6 * ((C47 > C49) * (C49 - C47) + 5 / 6 * ((C48 > C50) * (C50 - C48) + 5 / 6 * ((C49 > C51) * (C51 - C49) + 5 / 6 * ((C50 > C52) * (C52 - C50)))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C2 - C) + 5 / 6 * (ABS(C3 - C1) + 5 / 6 * (ABS(C4 - C2) + 5 / 6 * (ABS(C5 - C3) + 5 / 6 * (ABS(C6 - C4) + 5 / 6 * (ABS(C7 - C5) + 5 / 6 * (ABS(C8 - C6) + 5 / 6 * (ABS(C9 - C7) + 5 / 6 * (ABS(C10 - C8) + 5 / 6 * (ABS(C11 - C9) + 5 / 6 * (ABS(C12 - C10) + 5 / 6 * (ABS(C13 - C11) + 5 / 6 * (ABS(C14 - C12) + 5 / 6 * (ABS(C15 - C13) + 5 / 6 * (ABS(C16 - C14) + 5 / 6 * (ABS(C17 - C15) + 5 / 6 * (ABS(C18 - C16) + 5 / 6 * (ABS(C19 - C17) + 5 / 6 * (ABS(C20 - C18) + 5 / 6 * (ABS(C21 - C19) + 5 / 6 * (ABS(C22 - C20) + 5 / 6 * (ABS(C23 - C21) + 5 / 6 * (ABS(C24 - C22) + 5 / 6 * (ABS(C25 - C23) + 5 / 6 * (ABS(C26 - C24) + 5 / 6 * (ABS(C27 - C25) + 5 / 6 * (ABS(C28 - C26) + 5 / 6 * (ABS(C29 - C27) + 5 / 6 * (ABS(C30 - C28) + 5 / 6 * (ABS(C31 - C29) + 5 / 6 * (ABS(C32 - C30) + 5 / 6 * (ABS(C33 - C31) + 5 / 6 * (ABS(C34 - C32) + 5 / 6 * (ABS(C35 - C33) + 5 / 6 * (ABS(C36 - C34) + 5 / 6 * (ABS(C37 - C35) + 5 / 6 * (ABS(C38 - C36) + 5 / 6 * (ABS(C39 - C37) + 5 / 6 * (ABS(C40 - C38) + 5 / 6 * (ABS(C41 - C39) + 5 / 6 * (ABS(C42 - C40) + 5 / 6 * (ABS(C43 - C41) + 5 / 6 * (ABS(C44 - C42) + 5 / 6 * (ABS(C45 - C43) + 5 / 6 * (ABS(C46 - C44) + 5 / 6 * (ABS(C47 - C45) + 5 / 6 * (ABS(C48 - C46) + 5 / 6 * (ABS(C49 - C47) + 5 / 6 * (ABS(C50 - C48) + 5 / 6 * (ABS(C51 - C49) + 5 / 6 * (ABS(C52 - C50) )))))))))))))))))))))))))))))))))))))))))))))))))))

RMI7,2 can be written as follows.

100 * ((C > C2) * (C2 - C) + 6 / 7 * ((C1 > C3) * (C3 - C1) + 6 / 7 * ((C2 > C4) * (C4 - C2) + 6 / 7 * ((C3 > C5) * (C5 - C3) + 6 / 7 * ((C4 > C6) * (C6 - C4) + 6 / 7 * ((C5 > C7) * (C7 - C5) + 6 / 7 * ((C6 > C8) * (C8 - C6) + 6 / 7 * ((C7 > C9) * (C9 - C7) + 6 / 7 * ((C8 > C10) * (C10 - C8) + 6 / 7 * ((C9 > C11) * (C11 - C9) + 6 / 7 * ((C10 > C12) * (C12 - C10) + 6 / 7 * ((C11 > C13) * (C13 - C11) + 6 / 7 * ((C12 > C14) * (C14 - C12) + 6 / 7 * ((C13 > C15) * (C15 - C13) + 6 / 7 * ((C14 > C16) * (C16 - C14) + 6 / 7 * ((C15 > C17) * (C17 - C15) + 6 / 7 * ((C16 > C18) * (C18 - C16) + 6 / 7 * ((C17 > C19) * (C19 - C17) + 6 / 7 * ((C18 > C20) * (C20 - C18) + 6 / 7 * ((C19 > C21) * (C21 - C19) + 6 / 7 * ((C20 > C22) * (C22 - C20) + 6 / 7 * ((C21 > C23) * (C23 - C21) + 6 / 7 * ((C22 > C24) * (C24 - C22) + 6 / 7 * ((C23 > C25) * (C25 - C23) + 6 / 7 * ((C24 > C26) * (C26 - C24) + 6 / 7 * ((C25 > C27) * (C27 - C25) + 6 / 7 * ((C26 > C28) * (C28 - C26) + 6 / 7 * ((C27 > C29) * (C29 - C27) + 6 / 7 * ((C28 > C30) * (C30 - C28) + 6 / 7 * ((C29 > C31) * (C31 - C29) + 6 / 7 * ((C30 > C32) * (C32 - C30) + 6 / 7 * ((C31 > C33) * (C33 - C31) + 6 / 7 * ((C32 > C34) * (C34 - C32) + 6 / 7 * ((C33 > C35) * (C35 - C33) + 6 / 7 * ((C34 > C36) * (C36 - C34) + 6 / 7 * ((C35 > C37) * (C37 - C35) + 6 / 7 * ((C36 > C38) * (C38 - C36) + 6 / 7 * ((C37 > C39) * (C39 - C37) + 6 / 7 * ((C38 > C40) * (C40 - C38) + 6 / 7 * ((C39 > C41) * (C41 - C39) + 6 / 7 * ((C40 > C42) * (C42 - C40) + 6 / 7 * ((C41 > C43) * (C43 - C41) + 6 / 7 * ((C42 > C44) * (C44 - C42) + 6 / 7 * ((C43 > C45) * (C45 - C43) + 6 / 7 * ((C44 > C46) * (C46 - C44) + 6 / 7 * ((C45 > C47) * (C47 - C45) + 6 / 7 * ((C46 > C48) * (C48 - C46) + 6 / 7 * ((C47 > C49) * (C49 - C47) + 6 / 7 * ((C48 > C50) * (C50 - C48) + 6 / 7 * ((C49 > C51) * (C51 - C49) + 6 / 7 * ((C50 > C52) * (C52 - C50) + 6 / 7 * ((C51 > C53) * (C53 - C51) + 6 / 7 * ((C52 > C54) * (C54 - C52) + 6 / 7 * ((C53 > C55) * (C55 - C53) + 6 / 7 * ((C54 > C56) * (C56 - C54) + 6 / 7 * ((C55 > C57) * (C57 - C55) + 6 / 7 * ((C56 > C58) * (C58 - C56) + 6 / 7 * ((C57 > C59) * (C59 - C57) + 6 / 7 * ((C58 > C60) * (C60 - C58) + 6 / 7 * ((C59 > C61) * (C61 - C59))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C2 - C) + 6 / 7 * (ABS(C3 - C1) + 6 / 7 * (ABS(C4 - C2) + 6 / 7 * (ABS(C5 - C3) + 6 / 7 * (ABS(C6 - C4) + 6 / 7 * (ABS(C7 - C5) + 6 / 7 * (ABS(C8 - C6) + 6 / 7 * (ABS(C9 - C7) + 6 / 7 * (ABS(C10 - C8) + 6 / 7 * (ABS(C11 - C9) + 6 / 7 * (ABS(C12 - C10) + 6 / 7 * (ABS(C13 - C11) + 6 / 7 * (ABS(C14 - C12) + 6 / 7 * (ABS(C15 - C13) + 6 / 7 * (ABS(C16 - C14) + 6 / 7 * (ABS(C17 - C15) + 6 / 7 * (ABS(C18 - C16) + 6 / 7 * (ABS(C19 - C17) + 6 / 7 * (ABS(C20 - C18) + 6 / 7 * (ABS(C21 - C19) + 6 / 7 * (ABS(C22 - C20) + 6 / 7 * (ABS(C23 - C21) + 6 / 7 * (ABS(C24 - C22) + 6 / 7 * (ABS(C25 - C23) + 6 / 7 * (ABS(C26 - C24) + 6 / 7 * (ABS(C27 - C25) + 6 / 7 * (ABS(C28 - C26) + 6 / 7 * (ABS(C29 - C27) + 6 / 7 * (ABS(C30 - C28) + 6 / 7 * (ABS(C31 - C29) + 6 / 7 * (ABS(C32 - C30) + 6 / 7 * (ABS(C33 - C31) + 6 / 7 * (ABS(C34 - C32) + 6 / 7 * (ABS(C35 - C33) + 6 / 7 * (ABS(C36 - C34) + 6 / 7 * (ABS(C37 - C35) + 6 / 7 * (ABS(C38 - C36) + 6 / 7 * (ABS(C39 - C37) + 6 / 7 * (ABS(C40 - C38) + 6 / 7 * (ABS(C41 - C39) + 6 / 7 * (ABS(C42 - C40) + 6 / 7 * (ABS(C43 - C41) + 6 / 7 * (ABS(C44 - C42) + 6 / 7 * (ABS(C45 - C43) + 6 / 7 * (ABS(C46 - C44) + 6 / 7 * (ABS(C47 - C45) + 6 / 7 * (ABS(C48 - C46) + 6 / 7 * (ABS(C49 - C47) + 6 / 7 * (ABS(C50 - C48) + 6 / 7 * (ABS(C51 - C49) + 6 / 7 * (ABS(C52 - C50) + 6 / 7 * (ABS(C53 - C51) + 6 / 7 * (ABS(C54 - C52) + 6 / 7 * (ABS(C55 - C53) + 6 / 7 * (ABS(C56 - C54) + 6 / 7 * (ABS(C57 - C55) + 6 / 7 * (ABS(C58 - C56) + 6 / 7 * (ABS(C59 - C57) + 6 / 7 * (ABS(C60 - C58) + 6 / 7 * (ABS(C61 - C59)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI6,3 can be written as follows.

100 * ((C > C3) * (C3 - C) + 5 / 6 * ((C1 > C4) * (C4 - C1) + 5 / 6 * ((C2 > C5) * (C5 - C2) + 5 / 6 * ((C3 > C6) * (C6 - C3) + 5 / 6 * ((C4 > C7) * (C7 - C4) + 5 / 6 * ((C5 > C8) * (C8 - C5) + 5 / 6 * ((C6 > C9) * (C9 - C6) + 5 / 6 * ((C7 > C10) * (C10 - C7) + 5 / 6 * ((C8 > C11) * (C11 - C8) + 5 / 6 * ((C9 > C12) * (C12 - C9) + 5 / 6 * ((C10 > C13) * (C13 - C10) + 5 / 6 * ((C11 > C14) * (C14 - C11) + 5 / 6 * ((C12 > C15) * (C15 - C12) + 5 / 6 * ((C13 > C16) * (C16 - C13) + 5 / 6 * ((C14 > C17) * (C17 - C14) + 5 / 6 * ((C15 > C18) * (C18 - C15) + 5 / 6 * ((C16 > C19) * (C19 - C16) + 5 / 6 * ((C17 > C20) * (C20 - C17) + 5 / 6 * ((C18 > C21) * (C21 - C18) + 5 / 6 * ((C19 > C22) * (C22 - C19) + 5 / 6 * ((C20 > C23) * (C23 - C20) + 5 / 6 * ((C21 > C24) * (C24 - C21) + 5 / 6 * ((C22 > C25) * (C25 - C22) + 5 / 6 * ((C23 > C26) * (C26 - C23) + 5 / 6 * ((C24 > C27) * (C27 - C24) + 5 / 6 * ((C25 > C28) * (C28 - C25) + 5 / 6 * ((C26 > C29) * (C29 - C26) + 5 / 6 * ((C27 > C30) * (C30 - C27) + 5 / 6 * ((C28 > C31) * (C31 - C28) + 5 / 6 * ((C29 > C32) * (C32 - C29) + 5 / 6 * ((C30 > C33) * (C33 - C30) + 5 / 6 * ((C31 > C34) * (C34 - C31) + 5 / 6 * ((C32 > C35) * (C35 - C32) + 5 / 6 * ((C33 > C36) * (C36 - C33) + 5 / 6 * ((C34 > C37) * (C37 - C34) + 5 / 6 * ((C35 > C38) * (C38 - C35) + 5 / 6 * ((C36 > C39) * (C39 - C36) + 5 / 6 * ((C37 > C40) * (C40 - C37) + 5 / 6 * ((C38 > C41) * (C41 - C38) + 5 / 6 * ((C39 > C42) * (C42 - C39) + 5 / 6 * ((C40 > C43) * (C43 - C40) + 5 / 6 * ((C41 > C44) * (C44 - C41) + 5 / 6 * ((C42 > C45) * (C45 - C42) + 5 / 6 * ((C43 > C46) * (C46 - C43) + 5 / 6 * ((C44 > C47) * (C47 - C44) + 5 / 6 * ((C45 > C48) * (C48 - C45) + 5 / 6 * ((C46 > C49) * (C49 - C46) + 5 / 6 * ((C47 > C50) * (C50 - C47) + 5 / 6 * ((C48 > C51) * (C51 - C48) + 5 / 6 * ((C49 > C52) * (C52 - C49) + 5 / 6 * ((C50 > C53) * (C53 - C50)))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C3 - C) + 5 / 6 * (ABS(C4 - C1) + 5 / 6 * (ABS(C5 - C2) + 5 / 6 * (ABS(C6 - C3) + 5 / 6 * (ABS(C7 - C4) + 5 / 6 * (ABS(C8 - C5) + 5 / 6 * (ABS(C9 - C6) + 5 / 6 * (ABS(C10 - C7) + 5 / 6 * (ABS(C11 - C8) + 5 / 6 * (ABS(C12 - C9) + 5 / 6 * (ABS(C13 - C10) + 5 / 6 * (ABS(C14 - C11) + 5 / 6 * (ABS(C15 - C12) + 5 / 6 * (ABS(C16 - C13) + 5 / 6 * (ABS(C17 - C14) + 5 / 6 * (ABS(C18 - C15) + 5 / 6 * (ABS(C19 - C16) + 5 / 6 * (ABS(C20 - C17) + 5 / 6 * (ABS(C21 - C18) + 5 / 6 * (ABS(C22 - C19) + 5 / 6 * (ABS(C23 - C20) + 5 / 6 * (ABS(C24 - C21) + 5 / 6 * (ABS(C25 - C22) + 5 / 6 * (ABS(C26 - C23) + 5 / 6 * (ABS(C27 - C24) + 5 / 6 * (ABS(C28 - C25) + 5 / 6 * (ABS(C29 - C26) + 5 / 6 * (ABS(C30 - C27) + 5 / 6 * (ABS(C31 - C28) + 5 / 6 * (ABS(C32 - C29) + 5 / 6 * (ABS(C33 - C30) + 5 / 6 * (ABS(C34 - C31) + 5 / 6 * (ABS(C35 - C32) + 5 / 6 * (ABS(C36 - C33) + 5 / 6 * (ABS(C37 - C34) + 5 / 6 * (ABS(C38 - C35) + 5 / 6 * (ABS(C39 - C36) + 5 / 6 * (ABS(C40 - C37) + 5 / 6 * (ABS(C41 - C38) + 5 / 6 * (ABS(C42 - C39) + 5 / 6 * (ABS(C43 - C40) + 5 / 6 * (ABS(C44 - C41) + 5 / 6 * (ABS(C45 - C42) + 5 / 6 * (ABS(C46 - C43) + 5 / 6 * (ABS(C47 - C44) + 5 / 6 * (ABS(C48 - C45) + 5 / 6 * (ABS(C49 - C46) + 5 / 6 * (ABS(C50 - C47) + 5 / 6 * (ABS(C51 - C48) + 5 / 6 * (ABS(C52 - C49) + 5 / 6 * (ABS(C53 - C50))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI7,3 can be written as follows.

100 * ((C > C3) * (C3 - C) + 6 / 7 * ((C1 > C4) * (C4 - C1) + 6 / 7 * ((C2 > C5) * (C5 - C2) + 6 / 7 * ((C3 > C6) * (C6 - C3) + 6 / 7 * ((C4 > C7) * (C7 - C4) + 6 / 7 * ((C5 > C8) * (C8 - C5) + 6 / 7 * ((C6 > C9) * (C9 - C6) + 6 / 7 * ((C7 > C10) * (C10 - C7) + 6 / 7 * ((C8 > C11) * (C11 - C8) + 6 / 7 * ((C9 > C12) * (C12 - C9) + 6 / 7 * ((C10 > C13) * (C13 - C10) + 6 / 7 * ((C11 > C14) * (C14 - C11) + 6 / 7 * ((C12 > C15) * (C15 - C12) + 6 / 7 * ((C13 > C16) * (C16 - C13) + 6 / 7 * ((C14 > C17) * (C17 - C14) + 6 / 7 * ((C15 > C18) * (C18 - C15) + 6 / 7 * ((C16 > C19) * (C19 - C16) + 6 / 7 * ((C17 > C20) * (C20 - C17) + 6 / 7 * ((C18 > C21) * (C21 - C18) + 6 / 7 * ((C19 > C22) * (C22 - C19) + 6 / 7 * ((C20 > C23) * (C23 - C20) + 6 / 7 * ((C21 > C24) * (C24 - C21) + 6 / 7 * ((C22 > C25) * (C25 - C22) + 6 / 7 * ((C23 > C26) * (C26 - C23) + 6 / 7 * ((C24 > C27) * (C27 - C24) + 6 / 7 * ((C25 > C28) * (C28 - C25) + 6 / 7 * ((C26 > C29) * (C29 - C26) + 6 / 7 * ((C27 > C30) * (C30 - C27) + 6 / 7 * ((C28 > C31) * (C31 - C28) + 6 / 7 * ((C29 > C32) * (C32 - C29) + 6 / 7 * ((C30 > C33) * (C33 - C30) + 6 / 7 * ((C31 > C34) * (C34 - C31) + 6 / 7 * ((C32 > C35) * (C35 - C32) + 6 / 7 * ((C33 > C36) * (C36 - C33) + 6 / 7 * ((C34 > C37) * (C37 - C34) + 6 / 7 * ((C35 > C38) * (C38 - C35) + 6 / 7 * ((C36 > C39) * (C39 - C36) + 6 / 7 * ((C37 > C40) * (C40 - C37) + 6 / 7 * ((C38 > C41) * (C41 - C38) + 6 / 7 * ((C39 > C42) * (C42 - C39) + 6 / 7 * ((C40 > C43) * (C43 - C40) + 6 / 7 * ((C41 > C44) * (C44 - C41) + 6 / 7 * ((C42 > C45) * (C45 - C42) + 6 / 7 * ((C43 > C46) * (C46 - C43) + 6 / 7 * ((C44 > C47) * (C47 - C44) + 6 / 7 * ((C45 > C48) * (C48 - C45) + 6 / 7 * ((C46 > C49) * (C49 - C46) + 6 / 7 * ((C47 > C50) * (C50 - C47) + 6 / 7 * ((C48 > C51) * (C51 - C48) + 6 / 7 * ((C49 > C52) * (C52 - C49) + 6 / 7 * ((C50 > C53) * (C53 - C50) + 6 / 7 * ((C51 > C54) * (C54 - C51) + 6 / 7 * ((C52 > C55) * (C55 - C52) + 6 / 7 * ((C53 > C56) * (C56 - C53) + 6 / 7 * ((C54 > C57) * (C57 - C54) + 6 / 7 * ((C55 > C58) * (C58 - C55) + 6 / 7 * ((C56 > C59) * (C59 - C56) + 6 / 7 * ((C57 > C60) * (C60 - C57) + 6 / 7 * ((C58 > C61) * (C61 - C58) + 6 / 7 * ((C59 > C62) * (C62 - C59))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C3 - C) + 6 / 7 * (ABS(C4 - C1) + 6 / 7 * (ABS(C5 - C2) + 6 / 7 * (ABS(C6 - C3) + 6 / 7 * (ABS(C7 - C4) + 6 / 7 * (ABS(C8 - C5) + 6 / 7 * (ABS(C9 - C6) + 6 / 7 * (ABS(C10 - C7) + 6 / 7 * (ABS(C11 - C8) + 6 / 7 * (ABS(C12 - C9) + 6 / 7 * (ABS(C13 - C10) + 6 / 7 * (ABS(C14 - C11) + 6 / 7 * (ABS(C15 - C12) + 6 / 7 * (ABS(C16 - C13) + 6 / 7 * (ABS(C17 - C14) + 6 / 7 * (ABS(C18 - C15) + 6 / 7 * (ABS(C19 - C16) + 6 / 7 * (ABS(C20 - C17) + 6 / 7 * (ABS(C21 - C18) + 6 / 7 * (ABS(C22 - C19) + 6 / 7 * (ABS(C23 - C20) + 6 / 7 * (ABS(C24 - C21) + 6 / 7 * (ABS(C25 - C22) + 6 / 7 * (ABS(C26 - C23) + 6 / 7 * (ABS(C27 - C24) + 6 / 7 * (ABS(C28 - C25) + 6 / 7 * (ABS(C29 - C26) + 6 / 7 * (ABS(C30 - C27) + 6 / 7 * (ABS(C31 - C28) + 6 / 7 * (ABS(C32 - C29) + 6 / 7 * (ABS(C33 - C30) + 6 / 7 * (ABS(C34 - C31) + 6 / 7 * (ABS(C35 - C32) + 6 / 7 * (ABS(C36 - C33) + 6 / 7 * (ABS(C37 - C34) + 6 / 7 * (ABS(C38 - C35) + 6 / 7 * (ABS(C39 - C36) + 6 / 7 * (ABS(C40 - C37) + 6 / 7 * (ABS(C41 - C38) + 6 / 7 * (ABS(C42 - C39) + 6 / 7 * (ABS(C43 - C40) + 6 / 7 * (ABS(C44 - C41) + 6 / 7 * (ABS(C45 - C42) + 6 / 7 * (ABS(C46 - C43) + 6 / 7 * (ABS(C47 - C44) + 6 / 7 * (ABS(C48 - C45) + 6 / 7 * (ABS(C49 - C46) + 6 / 7 * (ABS(C50 - C47) + 6 / 7 * (ABS(C51 - C48) + 6 / 7 * (ABS(C52 - C49) + 6 / 7 * (ABS(C53 - C50) + 6 / 7 * (ABS(C54 - C51) + 6 / 7 * (ABS(C55 - C52) + 6 / 7 * (ABS(C56 - C53) + 6 / 7 * (ABS(C57 - C54) + 6 / 7 * (ABS(C58 - C55) + 6 / 7 * (ABS(C59 - C56) + 6 / 7 * (ABS(C60 - C57) + 6 / 7 * (ABS(C61 - C58) + 6 / 7 * (ABS(C62 - C59)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
 Posted : Friday, December 09, 2016 7:45:16 PM
Registered User
Joined: 9/17/2014
Posts: 17

What's the formula be for the RMI PCF for 2, 3 and 5 period with smooting settings 2, 3 and 5. Thanks

Aces4Me
 Posted : Friday, December 09, 2016 10:33:23 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

Bruce - what i have read seems the 20,5 is the standard for RMI

Thanks

Aces4Me
 Posted : Saturday, December 10, 2016 11:18:34 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

QUOTE (Bruce_L)

Please try the following Indicator Formula:

100 * ((C > C5) * (C5 - C) + 13 / 14 * ((C1 > C6) * (C6 - C1) + 13 / 14 * ((C2 > C7) * (C7 - C2) + 13 / 14 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C5 - C) + 13 / 14 * (ABS(C6 - C1) + 13 / 14 * (ABS(C7 - C2) + 13 / 14 * (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Bruce this is your RMI 14, 5 from above

Can your Modify  this for the following 3 formulas

RMI 14,5 (1 Bar Ago)

RMI 14,5 (2 Bars Ago)

RMI 14,5 (3 Bars Ago)

Thanks

Aces4Me
 Posted : Wednesday, December 14, 2016 8:07:26 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

Quote

100 * ((C > C2) * (C2 - C) + 6 / 7 * ((C1 > C3) * (C3 - C1) + 6 / 7 * ((C2 > C4) * (C4 - C2) + 6 / 7 * ((C3 > C5) * (C5 - C3) + 6 / 7 * ((C4 > C6) * (C6 - C4) + 6 / 7 * ((C5 > C7) * (C7 - C5) + 6 / 7 * ((C6 > C8) * (C8 - C6) + 6 / 7 * ((C7 > C9) * (C9 - C7) + 6 / 7 * ((C8 > C10) * (C10 - C8) + 6 / 7 * ((C9 > C11) * (C11 - C9) + 6 / 7 * ((C10 > C12) * (C12 - C10) + 6 / 7 * ((C11 > C13) * (C13 - C11) + 6 / 7 * ((C12 > C14) * (C14 - C12) + 6 / 7 * ((C13 > C15) * (C15 - C13) + 6 / 7 * ((C14 > C16) * (C16 - C14) + 6 / 7 * ((C15 > C17) * (C17 - C15) + 6 / 7 * ((C16 > C18) * (C18 - C16) + 6 / 7 * ((C17 > C19) * (C19 - C17) + 6 / 7 * ((C18 > C20) * (C20 - C18) + 6 / 7 * ((C19 > C21) * (C21 - C19) + 6 / 7 * ((C20 > C22) * (C22 - C20) + 6 / 7 * ((C21 > C23) * (C23 - C21) + 6 / 7 * ((C22 > C24) * (C24 - C22) + 6 / 7 * ((C23 > C25) * (C25 - C23) + 6 / 7 * ((C24 > C26) * (C26 - C24) + 6 / 7 * ((C25 > C27) * (C27 - C25) + 6 / 7 * ((C26 > C28) * (C28 - C26) + 6 / 7 * ((C27 > C29) * (C29 - C27) + 6 / 7 * ((C28 > C30) * (C30 - C28) + 6 / 7 * ((C29 > C31) * (C31 - C29) + 6 / 7 * ((C30 > C32) * (C32 - C30) + 6 / 7 * ((C31 > C33) * (C33 - C31) + 6 / 7 * ((C32 > C34) * (C34 - C32) + 6 / 7 * ((C33 > C35) * (C35 - C33) + 6 / 7 * ((C34 > C36) * (C36 - C34) + 6 / 7 * ((C35 > C37) * (C37 - C35) + 6 / 7 * ((C36 > C38) * (C38 - C36) + 6 / 7 * ((C37 > C39) * (C39 - C37) + 6 / 7 * ((C38 > C40) * (C40 - C38) + 6 / 7 * ((C39 > C41) * (C41 - C39) + 6 / 7 * ((C40 > C42) * (C42 - C40) + 6 / 7 * ((C41 > C43) * (C43 - C41) + 6 / 7 * ((C42 > C44) * (C44 - C42) + 6 / 7 * ((C43 > C45) * (C45 - C43) + 6 / 7 * ((C44 > C46) * (C46 - C44) + 6 / 7 * ((C45 > C47) * (C47 - C45) + 6 / 7 * ((C46 > C48) * (C48 - C46) + 6 / 7 * ((C47 > C49) * (C49 - C47) + 6 / 7 * ((C48 > C50) * (C50 - C48) + 6 / 7 * ((C49 > C51) * (C51 - C49) + 6 / 7 * ((C50 > C52) * (C52 - C50) + 6 / 7 * ((C51 > C53) * (C53 - C51) + 6 / 7 * ((C52 > C54) * (C54 - C52) + 6 / 7 * ((C53 > C55) * (C55 - C53) + 6 / 7 * ((C54 > C56) * (C56 - C54) + 6 / 7 * ((C55 > C57) * (C57 - C55) + 6 / 7 * ((C56 > C58) * (C58 - C56) + 6 / 7 * ((C57 > C59) * (C59 - C57) + 6 / 7 * ((C58 > C60) * (C60 - C58) + 6 / 7 * ((C59 > C61) * (C61 - C59))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C2 - C) + 6 / 7 * (ABS(C3 - C1) + 6 / 7 * (ABS(C4 - C2) + 6 / 7 * (ABS(C5 - C3) + 6 / 7 * (ABS(C6 - C4) + 6 / 7 * (ABS(C7 - C5) + 6 / 7 * (ABS(C8 - C6) + 6 / 7 * (ABS(C9 - C7) + 6 / 7 * (ABS(C10 - C8) + 6 / 7 * (ABS(C11 - C9) + 6 / 7 * (ABS(C12 - C10) + 6 / 7 * (ABS(C13 - C11) + 6 / 7 * (ABS(C14 - C12) + 6 / 7 * (ABS(C15 - C13) + 6 / 7 * (ABS(C16 - C14) + 6 / 7 * (ABS(C17 - C15) + 6 / 7 * (ABS(C18 - C16) + 6 / 7 * (ABS(C19 - C17) + 6 / 7 * (ABS(C20 - C18) + 6 / 7 * (ABS(C21 - C19) + 6 / 7 * (ABS(C22 - C20) + 6 / 7 * (ABS(C23 - C21) + 6 / 7 * (ABS(C24 - C22) + 6 / 7 * (ABS(C25 - C23) + 6 / 7 * (ABS(C26 - C24) + 6 / 7 * (ABS(C27 - C25) + 6 / 7 * (ABS(C28 - C26) + 6 / 7 * (ABS(C29 - C27) + 6 / 7 * (ABS(C30 - C28) + 6 / 7 * (ABS(C31 - C29) + 6 / 7 * (ABS(C32 - C30) + 6 / 7 * (ABS(C33 - C31) + 6 / 7 * (ABS(C34 - C32) + 6 / 7 * (ABS(C35 - C33) + 6 / 7 * (ABS(C36 - C34) + 6 / 7 * (ABS(C37 - C35) + 6 / 7 * (ABS(C38 - C36) + 6 / 7 * (ABS(C39 - C37) + 6 / 7 * (ABS(C40 - C38) + 6 / 7 * (ABS(C41 - C39) + 6 / 7 * (ABS(C42 - C40) + 6 / 7 * (ABS(C43 - C41) + 6 / 7 * (ABS(C44 - C42) + 6 / 7 * (ABS(C45 - C43) + 6 / 7 * (ABS(C46 - C44) + 6 / 7 * (ABS(C47 - C45) + 6 / 7 * (ABS(C48 - C46) + 6 / 7 * (ABS(C49 - C47) + 6 / 7 * (ABS(C50 - C48) + 6 / 7 * (ABS(C51 - C49) + 6 / 7 * (ABS(C52 - C50) + 6 / 7 * (ABS(C53 - C51) + 6 / 7 * (ABS(C54 - C52) + 6 / 7 * (ABS(C55 - C53) + 6 / 7 * (ABS(C56 - C54) + 6 / 7 * (ABS(C57 - C55) + 6 / 7 * (ABS(C58 - C56) + 6 / 7 * (ABS(C59 - C57) + 6 / 7 * (ABS(C60 - C58) + 6 / 7 * (ABS(C61 - C59)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Bruce this is your RMI 7 , 2 from above

Can your Modify this for the following 3 formulas

RMI 7,2 (1 Bar Ago)

RMI 7,2  (2 Bars Ago)

RMI 7,2 (3 Bars Ago)

Thanks

Aces4Me
 Posted : Wednesday, December 14, 2016 8:09:35 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

The shorter versions you are mentioning are going to be nice.  Thanks for all you guys work

Bruce_L
 Posted : Wednesday, December 14, 2016 11:09:09 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

OK, since my last answer that is requests for 16 different RMI fomulas. I am working on a bunch of other stuff at the moment, so what I'll do is give you what the formulas will be shortly.

RMI20,5:

100 * (XAVG(IIF(C > C5, C - C5, 0), 39) / XAVG(ABS(C - C5), 39)

RMI14,5:

100 * (XAVG(IIF(C > C5, C - C5, 0), 27) / XAVG(ABS(C - C5), 27)

RMI14,5 from 1 bar ago:

100 * (XAVG(IIF(C1 > C6, C1 - C6, 0), 27) / XAVG(ABS(C1 - C6), 27)

RMI14,5 from 2 bars ago:

100 * (XAVG(IIF(C2 > C7, C2 - C7, 0), 27) / XAVG(ABS(C2 - C7), 27)

RMI14,5 from 3 bars ago:

100 * (XAVG(IIF(C3 > C8, C3 - C8, 0), 27) / XAVG(ABS(C3 - C8), 27)

RMI6,1:

WRSI6

RMI6,2:

100 * (XAVG(IIF(C > C2, C - C2, 0), 11) / XAVG(ABS(C - C2), 11)

RMI6,3:

100 * (XAVG(IIF(C > C3, C - C3, 0), 11) / XAVG(ABS(C - C3), 11)

RMI7,1:

WRSI7

RMI7,2:

100 * (XAVG(IIF(C > C2, C - C2, 0), 13) / XAVG(ABS(C - C2), 13)

RMI7,3:

100 * (XAVG(IIF(C > C3, C - C3, 0), 13) / XAVG(ABS(C - C3), 13)

RMI7,3 from 1 bar ago:

100 * (XAVG(IIF(C1 > C4, C1 - C4, 0), 13) / XAVG(ABS(C1 - C4), 13)

RMI7,3 from 2 bars ago:

100 * (XAVG(IIF(C2 > C5, C2 - C5, 0), 13) / XAVG(ABS(C2 - C5), 13)

RMI7,3 from 3 bars ago:

100 * (XAVG(IIF(C3 > C6, C3 - C6, 0), 13) / XAVG(ABS(C3 - C6), 13)

RMI2,2:

100 * (XAVG(IIF(C > C2, C - C2, 0), 3) / XAVG(ABS(C - C2), 3)

RMI2,3:

100 * (XAVG(IIF(C > C3, C - C3, 0), 3) / XAVG(ABS(C - C3), 3)

RMI2,5:

100 * (XAVG(IIF(C > C5, C - C5, 0), 3) / XAVG(ABS(C - C5), 3)

RMI3,2:

100 * (XAVG(IIF(C > C2, C - C2, 0), 5) / XAVG(ABS(C - C2), 5)

RMI3,3:

100 * (XAVG(IIF(C > C3, C - C3, 0), 5) / XAVG(ABS(C - C3), 5)

RMI3,5:

100 * (XAVG(IIF(C > C5, C - C5, 0), 5) / XAVG(ABS(C - C5), 5)

RMI5,2:

100 * (XAVG(IIF(C > C2, C - C2, 0), 9) / XAVG(ABS(C - C2), 9)

RMI5,3:

100 * (XAVG(IIF(C > C3, C - C3, 0), 9) / XAVG(ABS(C - C3), 9)

RMI5,5:

100 * (XAVG(IIF(C > C5, C - C5, 0), 9) / XAVG(ABS(C - C5), 9)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, December 14, 2016 3:56:08 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

WE JUST need the word go on the new syntax

Thanks

Bruce_L
 Posted : Wednesday, December 14, 2016 4:52:01 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

You're welcome. It should be fairly soon.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
 Posted : Sunday, December 18, 2016 4:35:05 AM
Registered User
Joined: 9/17/2014
Posts: 17

What's the PCF forumla for Relative Momentum Index 25-period as of the Closes C1, C2 and C3? Thanks

 Posted : Sunday, December 18, 2016 4:46:49 AM
Registered User
Joined: 9/17/2014
Posts: 17

What's the PCF forumla for Relative Momentum Index 25-period as of the Closes C1, C2 and C3? Thanks

Actually PCF formula for Relative Momentum Index 14-period as of Closes C1 and C3. Thanks

Bruce_L
 Posted : Monday, December 19, 2016 10:33:16 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

An RMI with only a single period specified is just an RSI. Current formula for current value.

50 * (C - XAVGC27.1) / 14 / (.071435345 * (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

Formula for current production release for 1 bar ago (C1).

50 * (C1 - XAVGC27.2) / 14 / (.071435345 * (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

Formula for current production release for 3 bars ago (C3).

50 * (C3 - XAVGC27.4) / 14 / (.071435345 * (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) + 13 / 14 * (ABS(C126 - C127) + 13 / 14 * (ABS(C127 - C128))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Tuesday, December 20, 2016 4:30:05 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

Is it Very Soon Yet?

Bruce_L
 Posted : Tuesday, December 20, 2016 4:49:07 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

It doesn't appear to be. But my assumption would be that the very next public release will contain changes to the Personal Criteria Formula Language. I don't know how many internal releases there might be between now and then.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, December 21, 2016 2:54:08 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

makes me sad was hoping to use you above short formulas to work and tweak some things during this Low volume holiday stuff next several days

Thanks and you folks have a nice holiday!!!!!!!!!!!!!!!!!!!

 Posted : Wednesday, December 28, 2016 8:17:11 AM
Registered User
Joined: 9/17/2014
Posts: 17

What's the formula for RMI (relative momentum index) PCF for 6 and 7 period with smoothing period 5?

Thanks

Bruce_L
 Posted : Wednesday, December 28, 2016 12:43:00 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

RMI6,5:

Current Formula

100 * ((C > C5) * (C5 - C) + 5 / 6 * ((C1 > C6) * (C6 - C1) + 5 / 6 * ((C2 > C7) * (C7 - C2) + 5 / 6 * ((C3 > C8) * (C8 - C3) + 5 / 6 * ((C4 > C9) * (C9 - C4) + 5 / 6 * ((C5 > C10) * (C10 - C5) + 5 / 6 * ((C6 > C11) * (C11 - C6) + 5 / 6 * ((C7 > C12) * (C12 - C7) + 5 / 6 * ((C8 > C13) * (C13 - C8) + 5 / 6 * ((C9 > C14) * (C14 - C9) + 5 / 6 * ((C10 > C15) * (C15 - C10) + 5 / 6 * ((C11 > C16) * (C16 - C11) + 5 / 6 * ((C12 > C17) * (C17 - C12) + 5 / 6 * ((C13 > C18) * (C18 - C13) + 5 / 6 * ((C14 > C19) * (C19 - C14) + 5 / 6 * ((C15 > C20) * (C20 - C15) + 5 / 6 * ((C16 > C21) * (C21 - C16) + 5 / 6 * ((C17 > C22) * (C22 - C17) + 5 / 6 * ((C18 > C23) * (C23 - C18) + 5 / 6 * ((C19 > C24) * (C24 - C19) + 5 / 6 * ((C20 > C25) * (C25 - C20) + 5 / 6 * ((C21 > C26) * (C26 - C21) + 5 / 6 * ((C22 > C27) * (C27 - C22) + 5 / 6 * ((C23 > C28) * (C28 - C23) + 5 / 6 * ((C24 > C29) * (C29 - C24) + 5 / 6 * ((C25 > C30) * (C30 - C25) + 5 / 6 * ((C26 > C31) * (C31 - C26) + 5 / 6 * ((C27 > C32) * (C32 - C27) + 5 / 6 * ((C28 > C33) * (C33 - C28) + 5 / 6 * ((C29 > C34) * (C34 - C29) + 5 / 6 * ((C30 > C35) * (C35 - C30) + 5 / 6 * ((C31 > C36) * (C36 - C31) + 5 / 6 * ((C32 > C37) * (C37 - C32) + 5 / 6 * ((C33 > C38) * (C38 - C33) + 5 / 6 * ((C34 > C39) * (C39 - C34) + 5 / 6 * ((C35 > C40) * (C40 - C35) + 5 / 6 * ((C36 > C41) * (C41 - C36) + 5 / 6 * ((C37 > C42) * (C42 - C37) + 5 / 6 * ((C38 > C43) * (C43 - C38) + 5 / 6 * ((C39 > C44) * (C44 - C39) + 5 / 6 * ((C40 > C45) * (C45 - C40) + 5 / 6 * ((C41 > C46) * (C46 - C41) + 5 / 6 * ((C42 > C47) * (C47 - C42) + 5 / 6 * ((C43 > C48) * (C48 - C43) + 5 / 6 * ((C44 > C49) * (C49 - C44) + 5 / 6 * ((C45 > C50) * (C50 - C45) + 5 / 6 * ((C46 > C51) * (C51 - C46) + 5 / 6 * ((C47 > C52) * (C52 - C47) + 5 / 6 * ((C48 > C53) * (C53 - C48) + 5 / 6 * ((C49 > C54) * (C54 - C49) + 5 / 6 * ((C50 > C55) * (C55 - C50) + 5 / 6 * ((C51 > C56) * (C56 - C51))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C5 - C) + 5 / 6 * (ABS(C6 - C1) + 5 / 6 * (ABS(C7 - C2) + 5 / 6 * (ABS(C8 - C3) + 5 / 6 * (ABS(C9 - C4) + 5 / 6 * (ABS(C10 - C5) + 5 / 6 * (ABS(C11 - C6) + 5 / 6 * (ABS(C12 - C7) + 5 / 6 * (ABS(C13 - C8) + 5 / 6 * (ABS(C14 - C9) + 5 / 6 * (ABS(C15 - C10) + 5 / 6 * (ABS(C16 - C11) + 5 / 6 * (ABS(C17 - C12) + 5 / 6 * (ABS(C18 - C13) + 5 / 6 * (ABS(C19 - C14) + 5 / 6 * (ABS(C20 - C15) + 5 / 6 * (ABS(C21 - C16) + 5 / 6 * (ABS(C22 - C17) + 5 / 6 * (ABS(C23 - C18) + 5 / 6 * (ABS(C24 - C19) + 5 / 6 * (ABS(C25 - C20) + 5 / 6 * (ABS(C26 - C21) + 5 / 6 * (ABS(C27 - C22) + 5 / 6 * (ABS(C28 - C23) + 5 / 6 * (ABS(C29 - C24) + 5 / 6 * (ABS(C30 - C25) + 5 / 6 * (ABS(C31 - C26) + 5 / 6 * (ABS(C32 - C27) + 5 / 6 * (ABS(C33 - C28) + 5 / 6 * (ABS(C34 - C29) + 5 / 6 * (ABS(C35 - C30) + 5 / 6 * (ABS(C36 - C31) + 5 / 6 * (ABS(C37 - C32) + 5 / 6 * (ABS(C38 - C33) + 5 / 6 * (ABS(C39 - C34) + 5 / 6 * (ABS(C40 - C35) + 5 / 6 * (ABS(C41 - C36) + 5 / 6 * (ABS(C42 - C37) + 5 / 6 * (ABS(C43 - C38) + 5 / 6 * (ABS(C44 - C39) + 5 / 6 * (ABS(C45 - C40) + 5 / 6 * (ABS(C46 - C41) + 5 / 6 * (ABS(C47 - C42) + 5 / 6 * (ABS(C48 - C43) + 5 / 6 * (ABS(C49 - C44) + 5 / 6 * (ABS(C50 - C45) + 5 / 6 * (ABS(C51 - C46) + 5 / 6 * (ABS(C52 - C47) + 5 / 6 * (ABS(C53 - C48) + 5 / 6 * (ABS(C54 - C49) + 5 / 6 * (ABS(C55 - C50) + 5 / 6 * (ABS(C56 - C51)))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI7,5:

Current Formula

100 * ((C > C5) * (C5 - C) + 6 / 7 * ((C1 > C6) * (C6 - C1) + 6 / 7 * ((C2 > C7) * (C7 - C2) + 6 / 7 * ((C3 > C8) * (C8 - C3) + 6 / 7 * ((C4 > C9) * (C9 - C4) + 6 / 7 * ((C5 > C10) * (C10 - C5) + 6 / 7 * ((C6 > C11) * (C11 - C6) + 6 / 7 * ((C7 > C12) * (C12 - C7) + 6 / 7 * ((C8 > C13) * (C13 - C8) + 6 / 7 * ((C9 > C14) * (C14 - C9) + 6 / 7 * ((C10 > C15) * (C15 - C10) + 6 / 7 * ((C11 > C16) * (C16 - C11) + 6 / 7 * ((C12 > C17) * (C17 - C12) + 6 / 7 * ((C13 > C18) * (C18 - C13) + 6 / 7 * ((C14 > C19) * (C19 - C14) + 6 / 7 * ((C15 > C20) * (C20 - C15) + 6 / 7 * ((C16 > C21) * (C21 - C16) + 6 / 7 * ((C17 > C22) * (C22 - C17) + 6 / 7 * ((C18 > C23) * (C23 - C18) + 6 / 7 * ((C19 > C24) * (C24 - C19) + 6 / 7 * ((C20 > C25) * (C25 - C20) + 6 / 7 * ((C21 > C26) * (C26 - C21) + 6 / 7 * ((C22 > C27) * (C27 - C22) + 6 / 7 * ((C23 > C28) * (C28 - C23) + 6 / 7 * ((C24 > C29) * (C29 - C24) + 6 / 7 * ((C25 > C30) * (C30 - C25) + 6 / 7 * ((C26 > C31) * (C31 - C26) + 6 / 7 * ((C27 > C32) * (C32 - C27) + 6 / 7 * ((C28 > C33) * (C33 - C28) + 6 / 7 * ((C29 > C34) * (C34 - C29) + 6 / 7 * ((C30 > C35) * (C35 - C30) + 6 / 7 * ((C31 > C36) * (C36 - C31) + 6 / 7 * ((C32 > C37) * (C37 - C32) + 6 / 7 * ((C33 > C38) * (C38 - C33) + 6 / 7 * ((C34 > C39) * (C39 - C34) + 6 / 7 * ((C35 > C40) * (C40 - C35) + 6 / 7 * ((C36 > C41) * (C41 - C36) + 6 / 7 * ((C37 > C42) * (C42 - C37) + 6 / 7 * ((C38 > C43) * (C43 - C38) + 6 / 7 * ((C39 > C44) * (C44 - C39) + 6 / 7 * ((C40 > C45) * (C45 - C40) + 6 / 7 * ((C41 > C46) * (C46 - C41) + 6 / 7 * ((C42 > C47) * (C47 - C42) + 6 / 7 * ((C43 > C48) * (C48 - C43) + 6 / 7 * ((C44 > C49) * (C49 - C44) + 6 / 7 * ((C45 > C50) * (C50 - C45) + 6 / 7 * ((C46 > C51) * (C51 - C46) + 6 / 7 * ((C47 > C52) * (C52 - C47) + 6 / 7 * ((C48 > C53) * (C53 - C48) + 6 / 7 * ((C49 > C54) * (C54 - C49) + 6 / 7 * ((C50 > C55) * (C55 - C50) + 6 / 7 * ((C51 > C56) * (C56 - C51) + 6 / 7 * ((C52 > C57) * (C57 - C52) + 6 / 7 * ((C53 > C58) * (C58 - C53) + 6 / 7 * ((C54 > C59) * (C59 - C54) + 6 / 7 * ((C55 > C60) * (C60 - C55) + 6 / 7 * ((C56 > C61) * (C61 - C56) + 6 / 7 * ((C57 > C62) * (C62 - C57) + 6 / 7 * ((C58 > C63) * (C63 - C58)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C5 - C) + 6 / 7 * (ABS(C6 - C1) + 6 / 7 * (ABS(C7 - C2) + 6 / 7 * (ABS(C8 - C3) + 6 / 7 * (ABS(C9 - C4) + 6 / 7 * (ABS(C10 - C5) + 6 / 7 * (ABS(C11 - C6) + 6 / 7 * (ABS(C12 - C7) + 6 / 7 * (ABS(C13 - C8) + 6 / 7 * (ABS(C14 - C9) + 6 / 7 * (ABS(C15 - C10) + 6 / 7 * (ABS(C16 - C11) + 6 / 7 * (ABS(C17 - C12) + 6 / 7 * (ABS(C18 - C13) + 6 / 7 * (ABS(C19 - C14) + 6 / 7 * (ABS(C20 - C15) + 6 / 7 * (ABS(C21 - C16) + 6 / 7 * (ABS(C22 - C17) + 6 / 7 * (ABS(C23 - C18) + 6 / 7 * (ABS(C24 - C19) + 6 / 7 * (ABS(C25 - C20) + 6 / 7 * (ABS(C26 - C21) + 6 / 7 * (ABS(C27 - C22) + 6 / 7 * (ABS(C28 - C23) + 6 / 7 * (ABS(C29 - C24) + 6 / 7 * (ABS(C30 - C25) + 6 / 7 * (ABS(C31 - C26) + 6 / 7 * (ABS(C32 - C27) + 6 / 7 * (ABS(C33 - C28) + 6 / 7 * (ABS(C34 - C29) + 6 / 7 * (ABS(C35 - C30) + 6 / 7 * (ABS(C36 - C31) + 6 / 7 * (ABS(C37 - C32) + 6 / 7 * (ABS(C38 - C33) + 6 / 7 * (ABS(C39 - C34) + 6 / 7 * (ABS(C40 - C35) + 6 / 7 * (ABS(C41 - C36) + 6 / 7 * (ABS(C42 - C37) + 6 / 7 * (ABS(C43 - C38) + 6 / 7 * (ABS(C44 - C39) + 6 / 7 * (ABS(C45 - C40) + 6 / 7 * (ABS(C46 - C41) + 6 / 7 * (ABS(C47 - C42) + 6 / 7 * (ABS(C48 - C43) + 6 / 7 * (ABS(C49 - C44) + 6 / 7 * (ABS(C50 - C45) + 6 / 7 * (ABS(C51 - C46) + 6 / 7 * (ABS(C52 - C47) + 6 / 7 * (ABS(C53 - C48) + 6 / 7 * (ABS(C54 - C49) + 6 / 7 * (ABS(C55 - C50) + 6 / 7 * (ABS(C56 - C51) + 6 / 7 * (ABS(C57 - C52) + 6 / 7 * (ABS(C58 - C53) + 6 / 7 * (ABS(C59 - C54) + 6 / 7 * (ABS(C60 - C55) + 6 / 7 * (ABS(C61 - C56) + 6 / 7 * (ABS(C62 - C57) + 6 / 7 * (ABS(C63 - C58))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Thursday, December 29, 2016 3:28:41 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

Hate to see you posting current stuff.  Any word on the release.

Happy New Year to all of you folks.

Bruce_L
 Posted : Thursday, December 29, 2016 3:35:00 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

It should be soon, but I don't have a date. Not sure how much internal testing still needs to be done.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Thursday, December 29, 2016 4:01:36 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

i would gladly be a guinea pig

Aces4Me
 Posted : Monday, January 02, 2017 11:45:03 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

QUOTE (Aces4Me)

QUOTE (Bruce_L)

Please try the following Indicator Formula:

100 * ((C > C5) * (C5 - C) + 13 / 14 * ((C1 > C6) * (C6 - C1) + 13 / 14 * ((C2 > C7) * (C7 - C2) + 13 / 14 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C5 - C) + 13 / 14 * (ABS(C6 - C1) + 13 / 14 * (ABS(C7 - C2) + 13 / 14 * (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Bruce this is your RMI 14, 5 from above

Can your Modify  this for the following 3 formulas

RMI 14,5 (1 Bar Ago)

RMI 14,5 (2 Bars Ago)

RMI 14,5 (3 Bars Ago)

Thanks

Bruce_L
 Posted : Tuesday, January 03, 2017 11:56:00 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

RMI 14,5 (1 Bar Ago):

100 * ((C1 > C6) * (C6 - C1) + 13 / 14 * ((C2 > C7) * (C7 - C2) + 13 / 14 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93) + 13 / 14 * ((C94 > C99) * (C99 - C94))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C6 - C1) + 13 / 14 * (ABS(C7 - C2) + 13 / 14 * (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93) + 13 / 14 * (ABS(C99 - C94)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI 14,5 (2 Bars Ago):

100 * ((C2 > C7) * (C7 - C2) + 13 / 14 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93) + 13 / 14 * ((C94 > C99) * (C99 - C94) + 13 / 14 * ((C95 > C100) * (C100 - C95))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C7 - C2) + 13 / 14 * (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93) + 13 / 14 * (ABS(C99 - C94) + 13 / 14 * (ABS(C100 - C95)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI 14,5 (3 Bars Ago):

100 * ((C3 > C8) * (C8 - C3) + 13 / 14 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93) + 13 / 14 * ((C94 > C99) * (C99 - C94) + 13 / 14 * ((C95 > C100) * (C100 - C95) + 13 / 14 * ((C96 > C101) * (C101 - C96))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C8 - C3) + 13 / 14 * (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93) + 13 / 14 * (ABS(C99 - C94) + 13 / 14 * (ABS(C100 - C95) + 13 / 14 * (ABS(C101 - C96)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Tuesday, January 03, 2017 8:32:13 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

I hate to ask (i was planning on writing these in the short format) when i started putting together my pcf i also need

14,5 4 bars ago

14,5  5 bar ago

Bruce_L
 Posted : Wednesday, January 04, 2017 7:41:54 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

RMI 14,5 (4 bars ago):

100 * ((C4 > C9) * (C9 - C4) + 13 / 14 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93) + 13 / 14 * ((C94 > C99) * (C99 - C94) + 13 / 14 * ((C95 > C100) * (C100 - C95) + 13 / 14 * ((C96 > C101) * (C101 - C96) + 13 / 14 * ((C97 > C102) * (C102 - C97))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C9 - C4) + 13 / 14 * (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93) + 13 / 14 * (ABS(C99 - C94) + 13 / 14 * (ABS(C100 - C95) + 13 / 14 * (ABS(C101 - C96) + 13 / 14 * (ABS(C102 - C97)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

RMI 14,5 (5 bars ago):

100 * ((C5 > C10) * (C10 - C5) + 13 / 14 * ((C6 > C11) * (C11 - C6) + 13 / 14 * ((C7 > C12) * (C12 - C7) + 13 / 14 * ((C8 > C13) * (C13 - C8) + 13 / 14 * ((C9 > C14) * (C14 - C9) + 13 / 14 * ((C10 > C15) * (C15 - C10) + 13 / 14 * ((C11 > C16) * (C16 - C11) + 13 / 14 * ((C12 > C17) * (C17 - C12) + 13 / 14 * ((C13 > C18) * (C18 - C13) + 13 / 14 * ((C14 > C19) * (C19 - C14) + 13 / 14 * ((C15 > C20) * (C20 - C15) + 13 / 14 * ((C16 > C21) * (C21 - C16) + 13 / 14 * ((C17 > C22) * (C22 - C17) + 13 / 14 * ((C18 > C23) * (C23 - C18) + 13 / 14 * ((C19 > C24) * (C24 - C19) + 13 / 14 * ((C20 > C25) * (C25 - C20) + 13 / 14 * ((C21 > C26) * (C26 - C21) + 13 / 14 * ((C22 > C27) * (C27 - C22) + 13 / 14 * ((C23 > C28) * (C28 - C23) + 13 / 14 * ((C24 > C29) * (C29 - C24) + 13 / 14 * ((C25 > C30) * (C30 - C25) + 13 / 14 * ((C26 > C31) * (C31 - C26) + 13 / 14 * ((C27 > C32) * (C32 - C27) + 13 / 14 * ((C28 > C33) * (C33 - C28) + 13 / 14 * ((C29 > C34) * (C34 - C29) + 13 / 14 * ((C30 > C35) * (C35 - C30) + 13 / 14 * ((C31 > C36) * (C36 - C31) + 13 / 14 * ((C32 > C37) * (C37 - C32) + 13 / 14 * ((C33 > C38) * (C38 - C33) + 13 / 14 * ((C34 > C39) * (C39 - C34) + 13 / 14 * ((C35 > C40) * (C40 - C35) + 13 / 14 * ((C36 > C41) * (C41 - C36) + 13 / 14 * ((C37 > C42) * (C42 - C37) + 13 / 14 * ((C38 > C43) * (C43 - C38) + 13 / 14 * ((C39 > C44) * (C44 - C39) + 13 / 14 * ((C40 > C45) * (C45 - C40) + 13 / 14 * ((C41 > C46) * (C46 - C41) + 13 / 14 * ((C42 > C47) * (C47 - C42) + 13 / 14 * ((C43 > C48) * (C48 - C43) + 13 / 14 * ((C44 > C49) * (C49 - C44) + 13 / 14 * ((C45 > C50) * (C50 - C45) + 13 / 14 * ((C46 > C51) * (C51 - C46) + 13 / 14 * ((C47 > C52) * (C52 - C47) + 13 / 14 * ((C48 > C53) * (C53 - C48) + 13 / 14 * ((C49 > C54) * (C54 - C49) + 13 / 14 * ((C50 > C55) * (C55 - C50) + 13 / 14 * ((C51 > C56) * (C56 - C51) + 13 / 14 * ((C52 > C57) * (C57 - C52) + 13 / 14 * ((C53 > C58) * (C58 - C53) + 13 / 14 * ((C54 > C59) * (C59 - C54) + 13 / 14 * ((C55 > C60) * (C60 - C55) + 13 / 14 * ((C56 > C61) * (C61 - C56) + 13 / 14 * ((C57 > C62) * (C62 - C57) + 13 / 14 * ((C58 > C63) * (C63 - C58) + 13 / 14 * ((C59 > C64) * (C64 - C59) + 13 / 14 * ((C60 > C65) * (C65 - C60) + 13 / 14 * ((C61 > C66) * (C66 - C61) + 13 / 14 * ((C62 > C67) * (C67 - C62) + 13 / 14 * ((C63 > C68) * (C68 - C63) + 13 / 14 * ((C64 > C69) * (C69 - C64) + 13 / 14 * ((C65 > C70) * (C70 - C65) + 13 / 14 * ((C66 > C71) * (C71 - C66) + 13 / 14 * ((C67 > C72) * (C72 - C67) + 13 / 14 * ((C68 > C73) * (C73 - C68) + 13 / 14 * ((C69 > C74) * (C74 - C69) + 13 / 14 * ((C70 > C75) * (C75 - C70) + 13 / 14 * ((C71 > C76) * (C76 - C71) + 13 / 14 * ((C72 > C77) * (C77 - C72) + 13 / 14 * ((C73 > C78) * (C78 - C73) + 13 / 14 * ((C74 > C79) * (C79 - C74) + 13 / 14 * ((C75 > C80) * (C80 - C75) + 13 / 14 * ((C76 > C81) * (C81 - C76) + 13 / 14 * ((C77 > C82) * (C82 - C77) + 13 / 14 * ((C78 > C83) * (C83 - C78) + 13 / 14 * ((C79 > C84) * (C84 - C79) + 13 / 14 * ((C80 > C85) * (C85 - C80) + 13 / 14 * ((C81 > C86) * (C86 - C81) + 13 / 14 * ((C82 > C87) * (C87 - C82) + 13 / 14 * ((C83 > C88) * (C88 - C83) + 13 / 14 * ((C84 > C89) * (C89 - C84) + 13 / 14 * ((C85 > C90) * (C90 - C85) + 13 / 14 * ((C86 > C91) * (C91 - C86) + 13 / 14 * ((C87 > C92) * (C92 - C87) + 13 / 14 * ((C88 > C93) * (C93 - C88) + 13 / 14 * ((C89 > C94) * (C94 - C89) + 13 / 14 * ((C90 > C95) * (C95 - C90) + 13 / 14 * ((C91 > C96) * (C96 - C91) + 13 / 14 * ((C92 > C97) * (C97 - C92) + 13 / 14 * ((C93 > C98) * (C98 - C93) + 13 / 14 * ((C94 > C99) * (C99 - C94) + 13 / 14 * ((C95 > C100) * (C100 - C95) + 13 / 14 * ((C96 > C101) * (C101 - C96) + 13 / 14 * ((C97 > C102) * (C102 - C97) + 13 / 14 * ((C98 > C103) * (C103 - C98))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(C10 - C5) + 13 / 14 * (ABS(C11 - C6) + 13 / 14 * (ABS(C12 - C7) + 13 / 14 * (ABS(C13 - C8) + 13 / 14 * (ABS(C14 - C9) + 13 / 14 * (ABS(C15 - C10) + 13 / 14 * (ABS(C16 - C11) + 13 / 14 * (ABS(C17 - C12) + 13 / 14 * (ABS(C18 - C13) + 13 / 14 * (ABS(C19 - C14) + 13 / 14 * (ABS(C20 - C15) + 13 / 14 * (ABS(C21 - C16) + 13 / 14 * (ABS(C22 - C17) + 13 / 14 * (ABS(C23 - C18) + 13 / 14 * (ABS(C24 - C19) + 13 / 14 * (ABS(C25 - C20) + 13 / 14 * (ABS(C26 - C21) + 13 / 14 * (ABS(C27 - C22) + 13 / 14 * (ABS(C28 - C23) + 13 / 14 * (ABS(C29 - C24) + 13 / 14 * (ABS(C30 - C25) + 13 / 14 * (ABS(C31 - C26) + 13 / 14 * (ABS(C32 - C27) + 13 / 14 * (ABS(C33 - C28) + 13 / 14 * (ABS(C34 - C29) + 13 / 14 * (ABS(C35 - C30) + 13 / 14 * (ABS(C36 - C31) + 13 / 14 * (ABS(C37 - C32) + 13 / 14 * (ABS(C38 - C33) + 13 / 14 * (ABS(C39 - C34) + 13 / 14 * (ABS(C40 - C35) + 13 / 14 * (ABS(C41 - C36) + 13 / 14 * (ABS(C42 - C37) + 13 / 14 * (ABS(C43 - C38) + 13 / 14 * (ABS(C44 - C39) + 13 / 14 * (ABS(C45 - C40) + 13 / 14 * (ABS(C46 - C41) + 13 / 14 * (ABS(C47 - C42) + 13 / 14 * (ABS(C48 - C43) + 13 / 14 * (ABS(C49 - C44) + 13 / 14 * (ABS(C50 - C45) + 13 / 14 * (ABS(C51 - C46) + 13 / 14 * (ABS(C52 - C47) + 13 / 14 * (ABS(C53 - C48) + 13 / 14 * (ABS(C54 - C49) + 13 / 14 * (ABS(C55 - C50) + 13 / 14 * (ABS(C56 - C51) + 13 / 14 * (ABS(C57 - C52) + 13 / 14 * (ABS(C58 - C53) + 13 / 14 * (ABS(C59 - C54) + 13 / 14 * (ABS(C60 - C55) + 13 / 14 * (ABS(C61 - C56) + 13 / 14 * (ABS(C62 - C57) + 13 / 14 * (ABS(C63 - C58) + 13 / 14 * (ABS(C64 - C59) + 13 / 14 * (ABS(C65 - C60) + 13 / 14 * (ABS(C66 - C61) + 13 / 14 * (ABS(C67 - C62) + 13 / 14 * (ABS(C68 - C63) + 13 / 14 * (ABS(C69 - C64) + 13 / 14 * (ABS(C70 - C65) + 13 / 14 * (ABS(C71 - C66) + 13 / 14 * (ABS(C72 - C67) + 13 / 14 * (ABS(C73 - C68) + 13 / 14 * (ABS(C74 - C69) + 13 / 14 * (ABS(C75 - C70) + 13 / 14 * (ABS(C76 - C71) + 13 / 14 * (ABS(C77 - C72) + 13 / 14 * (ABS(C78 - C73) + 13 / 14 * (ABS(C79 - C74) + 13 / 14 * (ABS(C80 - C75) + 13 / 14 * (ABS(C81 - C76) + 13 / 14 * (ABS(C82 - C77) + 13 / 14 * (ABS(C83 - C78) + 13 / 14 * (ABS(C84 - C79) + 13 / 14 * (ABS(C85 - C80) + 13 / 14 * (ABS(C86 - C81) + 13 / 14 * (ABS(C87 - C82) + 13 / 14 * (ABS(C88 - C83) + 13 / 14 * (ABS(C89 - C84) + 13 / 14 * (ABS(C90 - C85) + 13 / 14 * (ABS(C91 - C86) + 13 / 14 * (ABS(C92 - C87) + 13 / 14 * (ABS(C93 - C88) + 13 / 14 * (ABS(C94 - C89) + 13 / 14 * (ABS(C95 - C90) + 13 / 14 * (ABS(C96 - C91) + 13 / 14 * (ABS(C97 - C92) + 13 / 14 * (ABS(C98 - C93) + 13 / 14 * (ABS(C99 - C94) + 13 / 14 * (ABS(C100 - C95) + 13 / 14 * (ABS(C101 - C96) + 13 / 14 * (ABS(C102 - C97) + 13 / 14 * (ABS(C103 - C98)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, January 04, 2017 2:27:00 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

bruce, i suppose multiple instances of these long formulas would give me slower chart loads?

Bruce_L
 Posted : Wednesday, January 04, 2017 2:41:52 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

I haven't tested these particular formulas, but yes, the more computationally intensive the layout, the longir the layout will take to load and calculate.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, January 04, 2017 3:02:33 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

UP side, New short formulas coming Booyah

Thanks for these

Aces4Me
 Posted : Tuesday, January 10, 2017 11:45:33 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

Wondering If any discussion on the new release date.

Also these are formulas for std Bollinger Bands 20 , 2 setting 1 BAR ago on Top and Bottom that you made for me a long time ago

WILL THEY HAVE A NEW SHORTER VERSION

Bollinger Band 1 Bar Ago

TOP BBT.1

(AVGC20.1 + 2.00 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19))

BOTTOM BBB.1

(AVGC20.1 - 2.00 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19))

THANKS

Bruce_L
 Posted : Tuesday, January 10, 2017 12:36:53 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

We could have a new beta build available as early as the end of this week, but I really cannot guarantee anything beyond, "soon".

In the most recent company test build to which I have access, the first formula can be written as follows.

BBTOP(2, 20, 1)

And the second fomula can be written as follows.

BBBOT(2, 20, 1)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Tuesday, January 10, 2017 4:20:56 PM
Gold Customer

Joined: 4/30/2015
Posts: 190

Thanks, think i might go ahead and started re write on scribes to help with data lag

Have  a good day

Bruce_L
 Posted : Tuesday, January 10, 2017 4:26:09 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

The shorter formulas should be a lot more efficient than the longer workarounds required by the older syntax.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, January 11, 2017 10:23:23 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

Question occurred to use this morning

These new shorter formulas i.e. BBand. This will help you guys alot as we will not be require so many info from you guys.

Question  When you release this WILL the Traders (me) need to reload our bband indicators to be on the shorter formula, or will the release just automatically become these

Bruce_L
 Posted : Wednesday, January 11, 2017 10:30:05 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,989

The update to the Personal Criteria Formula Language should be backwards compatible in that older formulas should still work, but the program isn't going to automatically replace older syntax with newer syntax.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
 Posted : Wednesday, January 11, 2017 11:47:44 AM
Gold Customer

Joined: 4/30/2015
Posts: 190

Yes i figured that what i am asking is when we add a bollinger band from the standard indicator list of tc2000 I am assuming now your new syntax will be the basis of those

NOT using a pcf just tc2000 stand bollinger band indicator on our chart with current syntax, do we need to remove the bollinger band from the chart and reinstall to install with the new syntax

I understand the plots will still work,  I am pulling so hard on data flow that i need to reduce everything as much as possible (my stuff is so bad that  have not even been able to save layout groups for over year)

Thus i can close 1 and reload a different one midday (which is what i need to be doing) because i cant create anything to open from

Users browsing this topic
Guest-1
 2 pages: [1] 2

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.