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

TSI with WMA calculations? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Onecap
Posted : Friday, October 4, 2013 11:10:32 PM
Registered User
Joined: 7/14/2007
Posts: 9

Bruce responded to a prior post about creating a True Strength Index (TSI) with Weighted Moving Averages (WMA) at http://forums.worden.com/default.aspx?g=posts&t=57323

Could you indicate how to change the parameters for (any) different lengths of WMA in a TSI?

More specifically, the TSI formula to create a PCF and chart plot is: 

TSI = WMA(WMA(NetChange,Long),Short) / WMA(WMA(AbsNetChange(n),Long),Short)

Where:  WMA = (front) Weighted Moving Average

The periods I want to evaluate are:  Long = Long Period = 63 bars, and Short = Short Period = 21 bars

NetChange = Typical Price - Typical Price 1 bar ago = (H+L+C)/3 - (H1+L1+C1)/3

AbsNetChange = Absolute value of Typical Price - Typical Price 1 bar ago = ABS((H+L+C)/3 - (H1+L1+C1)/3)

So, substituting values:

TSI = WMA(WMA((H+L+C)/3 - (H1+L1+C1)/3, 63),21) / WMA(WMA(ABS((H+L+C)/3 - (H1+L1+C1)/3), 63),21)

Thanks in advance for help with this.

Onecap
Posted : Friday, October 4, 2013 11:15:51 PM
Registered User
Joined: 7/14/2007
Posts: 9

Also:  The question refers to TC 2007 software.  Also, how can the same TSI with WMA be created in TC 2000 latest version?

Bruce_L
Posted : Monday, October 7, 2013 12:32:57 PM


Worden Trainer

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

I cannot think of a simple way to change the parameters. I had to re-write the entire formula from scratch:

(1323 * (H + L + C) + 1239 * (H1 + L1 + C1) + 1156 * (H2 + L2 + C2) + 1074 * (H3 + L3 + C3) + 993 * (H4 + L4 + C4) + 913 * (H5 + L5 + C5) + 834 * (H6 + L6 + C6) + 756 * (H7 + L7 + C7) + 679 * (H8 + L8 + C8) + 603 * (H9 + L9 + C9) + 528 * (H10 + L10 + C10) + 454 * (H11 + L11 + C11) + 381 * (H12 + L12 + C12) + 309 * (H13 + L13 + C13) + 238 * (H14 + L14 + C14) + 168 * (H15 + L15 + C15) + 99 * (H16 + L16 + C16) + 31 * (H17 + L17 + C17) - 36 * (H18 + L18 + C18) - 102 * (H19 + L19 + C19) - 167 * (H20 + L20 + C20) - 9933 * (AVGH43.21 + AVGL43.21 + AVGC43.21) - 210 * (H64 + L64 + C64) - 190 * (H65 + L65 + C65) - 171 * (H66 + L66 + C66) - 153 * (H67 + L67 + C67) - 136 * (H68 + L68 + C68) - 120 * (H69 + L69 + C69) - 105 * (H70 + L70 + C70) - 91 * (H71 + L71 + C71) - 78 * (H72 + L72 + C72) - 66 * (H73 + L73 + C73) - 55 * (H74 + L74 + C74) - 45 * (H75 + L75 + C75) - 36 * (H76 + L76 + C76) - 28 * (H77 + L77 + C77) - 21 * (H78 + L78 + C78) - 15 * (H79 + L79 + C79) - 10 * (H80 + L80 + C80) - 6 * (H81 + L81 + C81) - 3 * (H82 + L82 + C82) - H83 - L83 - C83) / (1323 * ABS(H + L + C - H1 - L1 - C1) + 2562 * ABS(H1 + L1 + C1 - H2 - L2 - C2) + 3718 * ABS(H2 + L2 + C2 - H3 - L3 - C3) + 4792 * ABS(H3 + L3 + C3 - H4 - L4 - C4) + 5785 * ABS(H4 + L4 + C4 - H5 - L5 - C5) + 6698 * ABS(H5 + L5 + C5 - H6 - L6 - C6) + 7532 * ABS(H6 + L6 + C6 - H7 - L7 - C7) + 8288 * ABS(H7 + L7 + C7 - H8 - L8 - C8) + 8967 * ABS(H8 + L8 + C8 - H9 - L9 - C9) + 9570 * ABS(H9 + L9 + C9 - H10 - L10 - C10) + 10098 * ABS(H10 + L10 + C10 - H11 - L11 - C11) + 10552 * ABS(H11 + L11 + C11 - H12 - L12 - C12) + 10933 * ABS(H12 + L12 + C12 - H13 - L13 - C13) + 11242 * ABS(H13 + L13 + C13 - H14 - L14 - C14) + 11480 * ABS(H14 + L14 + C14 - H15 - L15 - C15) + 11648 * ABS(H15 + L15 + C15 - H16 - L16 - C16) + 11747 * ABS(H16 + L16 + C16 - H17 - L17 - C17) + 11778 * ABS(H17 + L17 + C17 - H18 - L18 - C18) + 11742 * ABS(H18 + L18 + C18 - H19 - L19 - C19) + 11640 * ABS(H19 + L19 + C19 - H20 - L20 - C20) + 11473 * ABS(H20 + L20 + C20 - H21 - L21 - C21) + 11242 * ABS(H21 + L21 + C21 - H22 - L22 - C22) + 11011 * ABS(H22 + L22 + C22 - H23 - L23 - C23) + 10780 * ABS(H23 + L23 + C23 - H24 - L24 - C24) + 10549 * ABS(H24 + L24 + C24 - H25 - L25 - C25) + 10318 * ABS(H25 + L25 + C25 - H26 - L26 - C26) + 10087 * ABS(H26 + L26 + C26 - H27 - L27 - C27) + 9856 * ABS(H27 + L27 + C27 - H28 - L28 - C28) + 9625 * ABS(H28 + L28 + C28 - H29 - L29 - C29) + 9394 * ABS(H29 + L29 + C29 - H30 - L30 - C30) + 9163 * ABS(H30 + L30 + C30 - H31 - L31 - C31) + 8932 * ABS(H31 + L31 + C31 - H32 - L32 - C32) + 8701 * ABS(H32 + L32 + C32 - H33 - L33 - C33) + 8470 * ABS(H33 + L33 + C33 - H34 - L34 - C34) + 8239 * ABS(H34 + L34 + C34 - H35 - L35 - C35) + 8008 * ABS(H35 + L35 + C35 - H36 - L36 - C36) + 7777 * ABS(H36 + L36 + C36 - H37 - L37 - C37) + 7546 * ABS(H37 + L37 + C37 - H38 - L38 - C38) + 7315 * ABS(H38 + L38 + C38 - H39 - L39 - C39) + 7084 * ABS(H39 + L39 + C39 - H40 - L40 - C40) + 6853 * ABS(H40 + L40 + C40 - H41 - L41 - C41) + 6622 * ABS(H41 + L41 + C41 - H42 - L42 - C42) + 6391 * ABS(H42 + L42 + C42 - H43 - L43 - C43) + 6160 * ABS(H43 + L43 + C43 - H44 - L44 - C44) + 5929 * ABS(H44 + L44 + C44 - H45 - L45 - C45) + 5698 * ABS(H45 + L45 + C45 - H46 - L46 - C46) + 5467 * ABS(H46 + L46 + C46 - H47 - L47 - C47) + 5236 * ABS(H47 + L47 + C47 - H48 - L48 - C48) + 5005 * ABS(H48 + L48 + C48 - H49 - L49 - C49) + 4774 * ABS(H49 + L49 + C49 - H50 - L50 - C50) + 4543 * ABS(H50 + L50 + C50 - H51 - L51 - C51) + 4312 * ABS(H51 + L51 + C51 - H52 - L52 - C52) + 4081 * ABS(H52 + L52 + C52 - H53 - L53 - C53) + 3850 * ABS(H53 + L53 + C53 - H54 - L54 - C54) + 3619 * ABS(H54 + L54 + C54 - H55 - L55 - C55) + 3388 * ABS(H55 + L55 + C55 - H56 - L56 - C56) + 3157 * ABS(H56 + L56 + C56 - H57 - L57 - C57) + 2926 * ABS(H57 + L57 + C57 - H58 - L58 - C58) + 2695 * ABS(H58 + L58 + C58 - H59 - L59 - C59) + 2464 * ABS(H59 + L59 + C59 - H60 - L60 - C60) + 2233 * ABS(H60 + L60 + C60 - H61 - L61 - C61) + 2002 * ABS(H61 + L61 + C61 - H62 - L62 - C62) + 1771 * ABS(H62 + L62 + C62 - H63 - L63 - C63) + 1540 * ABS(H63 + L63 + C63 - H64 - L64 - C64) + 1330 * ABS(H64 + L64 + C64 - H65 - L65 - C65) + 1140 * ABS(H65 + L65 + C65 - H66 - L66 - C66) + 969 * ABS(H66 + L66 + C66 - H67 - L67 - C67) + 816 * ABS(H67 + L67 + C67 - H68 - L68 - C68) + 680 * ABS(H68 + L68 + C68 - H69 - L69 - C69) + 560 * ABS(H69 + L69 + C69 - H70 - L70 - C70) + 455 * ABS(H70 + L70 + C70 - H71 - L71 - C71) + 364 * ABS(H71 + L71 + C71 - H72 - L72 - C72) + 286 * ABS(H72 + L72 + C72 - H73 - L73 - C73) + 220 * ABS(H73 + L73 + C73 - H74 - L74 - C74) + 165 * ABS(H74 + L74 + C74 - H75 - L75 - C75) + 120 * ABS(H75 + L75 + C75 - H76 - L76 - C76) + 84 * ABS(H76 + L76 + C76 - H77 - L77 - C77) + 56 * ABS(H77 + L77 + C77 - H78 - L78 - C78) + 35 * ABS(H78 + L78 + C78 - H79 - L79 - C79) + 20 * ABS(H79 + L79 + C79 - H80 - L80 - C80) + 10 * ABS(H80 + L80 + C80 - H81 - L81 - C81) + 4 * ABS(H81 + L81 + C81 - H82 - L82 - C82) + ABS(H82 + L82 + C82 - H83 - L83 - C83))

You would need to create a Custom PCF Indicator in TC2000 version 12.3 for this as well. The built in TSI indicator uses exponential smoothing and there is no setting available to change the type of moving averages used in the calculations.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sharppolly
Posted : Saturday, October 26, 2013 12:23:25 PM
Gold Customer Gold Customer

Joined: 1/18/2008
Posts: 209

Ah'll be damt.

Users browsing this topic
Guest-1

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