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.
|
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?
|
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
|
Gold Customer
Joined: 1/18/2008 Posts: 209
|
Ah'll be damt.
|