Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 5/13/2010 Posts: 146
|
Bruce,
I try to use your TSI PCF, XAVG(XAVG(C - C1, 3), 9) / XAVG(XAVG(ABS(C - C1), 3), 9), but get a syntax error. How do I fix it?
Thanks,
Vince
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The formula for any version prior to TC2000 v17 is quite a bit longer.
(XAVG(XAVGC9,3) - XAVG(XAVGC9.1,3)) / (.266931 * (ABS(C - C1) + .8 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31)))))))))))))))))))))))))))))))) - .1668296 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 5/13/2010 Posts: 146
|
Wow!
|
|
Gold Customer
Joined: 5/13/2010 Posts: 146
|
Bruce,
Would you know if the TSI formula tha you provided above is the same ast that used by Marketguge?
Also, I read somewhere tha you said that SMI was the sme as TSI, but when I plot them they are differrent. Can you exlpain te difference in terms of what each inicator is supposed to do?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I have no idea how another program does its calcualtions.
There is no difference in what the SMI Ergodic Indicator and True Strength Index are "supposed to do" as they are in fact the same. Please make sure the short period and long period of both indicators match when comparing them.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 5/13/2010 Posts: 146
|
In your super long TSI formula, how do you identify the long and short periods? I need 9,26.
Thanks,
Vince
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is not just a matter of swapping out a few numbers. That works in the numerator, but not in the denominator. This is because the moving averages need to be manually expanded in the denominator.
(XAVG(XAVGC26, 9) - XAVG(XAVGC26.1, 9)) / (.10903948 * (ABS(C1 - C2) + 25 / 27 * (ABS(C2 - C3) + 25 / 27 * (ABS(C3 - C4) + 25 / 27 * (ABS(C4 - C5) + 25 / 27 * (ABS(C5 - C6) + 25 / 27 * (ABS(C6 - C7) + 25 / 27 * (ABS(C7 - C8) + 25 / 27 * (ABS(C8 - C9) + 25 / 27 * (ABS(C9 - C10) + 25 / 27 * (ABS(C10 - C11) + 25 / 27 * (ABS(C11 - C12) + 25 / 27 * (ABS(C12 - C13) + 25 / 27 * (ABS(C13 - C14) + 25 / 27 * (ABS(C14 - C15) + 25 / 27 * (ABS(C15 - C16) + 25 / 27 * (ABS(C16 - C17) + 25 / 27 * (ABS(C17 - C18) + 25 / 27 * (ABS(C18 - C19) + 25 / 27 * (ABS(C19 - C20) + 25 / 27 * (ABS(C20 - C21) + 25 / 27 * (ABS(C21 - C22) + 25 / 27 * (ABS(C22 - C23) + 25 / 27 * (ABS(C23 - C24) + 25 / 27 * (ABS(C24 - C25) + 25 / 27 * (ABS(C25 - C26) + 25 / 27 * (ABS(C26 - C27) + 25 / 27 * (ABS(C27 - C28) + 25 / 27 * (ABS(C28 - C29) + 25 / 27 * (ABS(C29 - C30) + 25 / 27 * (ABS(C30 - C31) + 25 / 27 * (ABS(C31 - C32) + 25 / 27 * (ABS(C32 - C33) + 25 / 27 * (ABS(C33 - C34) + 25 / 27 * (ABS(C34 - C35) + 25 / 27 * (ABS(C35 - C36) + 25 / 27 * (ABS(C36 - C37) + 25 / 27 * (ABS(C37 - C38) + 25 / 27 * (ABS(C38 - C39) + 25 / 27 * (ABS(C39 - C40) + 25 / 27 * (ABS(C40 - C41) + 25 / 27 * (ABS(C41 - C42) + 25 / 27 * (ABS(C42 - C43) + 25 / 27 * (ABS(C43 - C44) + 25 / 27 * (ABS(C44 - C45) + 25 / 27 * (ABS(C45 - C46) + 25 / 27 * (ABS(C46 - C47) + 25 / 27 * (ABS(C47 - C48) + 25 / 27 * (ABS(C48 - C49) + 25 / 27 * (ABS(C49 - C50) + 25 / 27 * (ABS(C50 - C51) + 25 / 27 * (ABS(C51 - C52) + 25 / 27 * (ABS(C52 - C53) + 25 / 27 * (ABS(C53 - C54) + 25 / 27 * (ABS(C54 - C55) + 25 / 27 * (ABS(C55 - C56) + 25 / 27 * (ABS(C56 - C57) + 25 / 27 * (ABS(C57 - C58) + 25 / 27 * (ABS(C58 - C59) + 25 / 27 * (ABS(C59 - C60) + 25 / 27 * (ABS(C60 - C61) + 25 / 27 * (ABS(C61 - C62) + 25 / 27 * (ABS(C62 - C63) + 25 / 27 * (ABS(C63 - C64) + 25 / 27 * (ABS(C64 - C65) + 25 / 27 * (ABS(C65 - C66) + 25 / 27 * (ABS(C66 - C67) + 25 / 27 * (ABS(C67 - C68) + 25 / 27 * (ABS(C68 - C69) + 25 / 27 * (ABS(C69 - C70) + 25 / 27 * (ABS(C70 - C71) + 25 / 27 * (ABS(C71 - C72) + 25 / 27 * (ABS(C72 - C73) + 25 / 27 * (ABS(C73 - C74) + 25 / 27 * (ABS(C74 - C75) + 25 / 27 * (ABS(C75 - C76) + 25 / 27 * (ABS(C76 - C77) + 25 / 27 * (ABS(C77 - C78) + 25 / 27 * (ABS(C78 - C79) + 25 / 27 * (ABS(C79 - C80) + 25 / 27 * (ABS(C80 - C81) + 25 / 27 * (ABS(C81 - C82) + 25 / 27 * (ABS(C82 - C83) + 25 / 27 * (ABS(C83 - C84) + 25 / 27 * (ABS(C84 - C85) + 25 / 27 * (ABS(C85 - C86) + 25 / 27 * (ABS(C86 - C87) + 25 / 27 * (ABS(C87 - C88) + 25 / 27 * (ABS(C88 - C89) + 25 / 27 * (ABS(C89 - C90) + 25 / 27 * (ABS(C90 - C91))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - .094210949 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31) + .8 * (ABS(C31 - C32)))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |