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


• New account application • Trading resources
• Margin rates • Stock & option commissions

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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » RMI help

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

Hello,

 

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

 

Appreciate your ususal support
Back to top
Bruce_L
Posted : Wednesday, October 17, 2012 8:42:15 AM


Worden Trainer

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

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
Back to top
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
Back to top
Bruce_L
Posted : Wednesday, October 17, 2012 12:16:41 PM


Worden Trainer

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

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
Back to top
akadre20
Posted : Friday, December 9, 2016 2:39:56 AM
Registered User
Joined: 9/17/2014
Posts: 18

What would the formula be for the RMI (relative momentum index) PCF for settings 6 and 7 period?
Back to top
akadre20
Posted : Friday, December 9, 2016 2:57:05 AM
Registered User
Joined: 9/17/2014
Posts: 18

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
Back to top
Bruce_L
Posted : Friday, December 9, 2016 10:16:05 AM


Worden Trainer

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

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
Back to top
akadre20
Posted : Friday, December 9, 2016 7:45:16 PM
Registered User
Joined: 9/17/2014
Posts: 18

What's the formula be for the RMI PCF for 2, 3 and 5 period with smooting settings 2, 3 and 5. Thanks
Back to top
Aces4Me
Posted : Friday, December 9, 2016 10:33:23 PM
Registered User
Joined: 4/30/2015
Posts: 197

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
Back to top
Aces4Me
Posted : Saturday, December 10, 2016 11:18:34 AM
Registered User
Joined: 4/30/2015
Posts: 197

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
Back to top
Aces4Me
Posted : Wednesday, December 14, 2016 8:07:26 AM
Registered User
Joined: 4/30/2015
Posts: 197

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

 
 
Back to top
Aces4Me
Posted : Wednesday, December 14, 2016 8:09:35 AM
Registered User
Joined: 4/30/2015
Posts: 197

The shorter versions you are mentioning are going to be nice.  Thanks for all you guys work
Back to top
Bruce_L
Posted : Wednesday, December 14, 2016 11:09:09 AM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, December 14, 2016 3:56:08 PM
Registered User
Joined: 4/30/2015
Posts: 197

WE JUST need the word go on the new syntax

Thanks
Back to top
Bruce_L
Posted : Wednesday, December 14, 2016 4:52:01 PM


Worden Trainer

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

You're welcome. It should be fairly soon.


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

What's the PCF forumla for Relative Momentum Index 25-period as of the Closes C1, C2 and C3? Thanks
Back to top
akadre20
Posted : Sunday, December 18, 2016 4:46:49 AM
Registered User
Joined: 9/17/2014
Posts: 18

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
Back to top
Bruce_L
Posted : Monday, December 19, 2016 10:33:16 AM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Tuesday, December 20, 2016 4:30:05 PM
Registered User
Joined: 4/30/2015
Posts: 197

Is it Very Soon Yet?
Back to top
Bruce_L
Posted : Tuesday, December 20, 2016 4:49:07 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, December 21, 2016 2:54:08 PM
Registered User
Joined: 4/30/2015
Posts: 197

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!!!!!!!!!!!!!!!!!!!
Back to top
akadre20
Posted : Wednesday, December 28, 2016 8:17:11 AM
Registered User
Joined: 9/17/2014
Posts: 18

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

Thanks
Back to top
Bruce_L
Posted : Wednesday, December 28, 2016 12:43:00 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Thursday, December 29, 2016 3:28:41 PM
Registered User
Joined: 4/30/2015
Posts: 197


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

 

Happy New Year to all of you folks.
Back to top
Bruce_L
Posted : Thursday, December 29, 2016 3:35:00 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Thursday, December 29, 2016 4:01:36 PM
Registered User
Joined: 4/30/2015
Posts: 197

i would gladly be a guinea pig
Back to top
Aces4Me
Posted : Monday, January 2, 2017 11:45:03 PM
Registered User
Joined: 4/30/2015
Posts: 197

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
 
Back to top
Bruce_L
Posted : Tuesday, January 3, 2017 11:56:00 AM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Tuesday, January 3, 2017 8:32:13 PM
Registered User
Joined: 4/30/2015
Posts: 197


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
Back to top
Bruce_L
Posted : Wednesday, January 4, 2017 7:41:54 AM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, January 4, 2017 2:27:00 PM
Registered User
Joined: 4/30/2015
Posts: 197

bruce, i suppose multiple instances of these long formulas would give me slower chart loads?
Back to top
Bruce_L
Posted : Wednesday, January 4, 2017 2:41:52 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, January 4, 2017 3:02:33 PM
Registered User
Joined: 4/30/2015
Posts: 197

UP side, New short formulas coming Booyah

Thanks for these
Back to top
Aces4Me
Posted : Tuesday, January 10, 2017 11:45:33 AM
Registered User
Joined: 4/30/2015
Posts: 197

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
Back to top
Bruce_L
Posted : Tuesday, January 10, 2017 12:36:53 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Tuesday, January 10, 2017 4:20:56 PM
Registered User
Joined: 4/30/2015
Posts: 197

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

 

Have  a good day
Back to top
Bruce_L
Posted : Tuesday, January 10, 2017 4:26:09 PM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, January 11, 2017 10:23:23 AM
Registered User
Joined: 4/30/2015
Posts: 197

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
Back to top
Bruce_L
Posted : Wednesday, January 11, 2017 10:30:05 AM


Worden Trainer

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

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
Back to top
Aces4Me
Posted : Wednesday, January 11, 2017 11:47:44 AM
Registered User
Joined: 4/30/2015
Posts: 197

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
Back to top
Users browsing this topic
Guest-1
2 pages: [1] 2

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.