New version 17 available now


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


New account application Trading resources
Margin rates Stock & option commissions

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

RMI help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mnouri
Posted : Wednesday, October 17, 2012 4:14:51 AM
Gold Customer Gold Customer

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.

 

Appreciate your ususal support

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


Worden Trainer

Joined: 10/7/2004
Posts: 60,672

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: 60,672

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
akadre20
Posted : Friday, December 09, 2016 2:39:56 AM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

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

akadre20
Posted : Friday, December 09, 2016 2:57:05 AM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

QUOTE (akadre20)

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: 60,672

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
akadre20
Posted : Friday, December 09, 2016 7:45:16 PM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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

 

Could you please help me write the RMI (relative momentum index) PCF for settings 20,5.

 

Thanks

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

Joined: 4/30/2015
Posts: 176

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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: 60,672

You're welcome. It should be fairly soon.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
akadre20
Posted : Sunday, December 18, 2016 4:35:05 AM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

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

akadre20
Posted : Sunday, December 18, 2016 4:46:49 AM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

QUOTE (akadre20)

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

Is it Very Soon Yet?

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


Worden Trainer

Joined: 10/7/2004
Posts: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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

akadre20
Posted : Wednesday, December 28, 2016 8:17:11 AM
Gold Customer Gold Customer

Joined: 9/17/2014
Posts: 16

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176


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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

i would gladly be a guinea pig

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

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176


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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

UP side, New short formulas coming Booyah

Thanks for these

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

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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: 60,672

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
Platinum Customer Platinum Customer

Joined: 4/30/2015
Posts: 176

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

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.