| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 69
|
Would you please provide formula for ((c-c1)*v) c/o it's 13d xavg (and 2d xavg). Thank you.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm not sure if it is what you are requested or not, but you may wish to review the Percent True Force Index topic (it seems to be using the same Moving Average Periods).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 69
|
Hi Bruce, Thanks, I did a search but didn't find the link. I am trying to update and stuck at the " compiling 1of 1 PCF" stage. Can I use the same formula for the 2d (using only the first 2 factors)?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
No. Exponential Moving Averages aren't like Simple Moving Averages in the sense that they are calculated using a number of bars equal to their period. The formula for the 13-Period Exponential Moving Average of the Force Index would be:
14.2996048056393 * ((C - C1) * V + 6 / 7 * ((C1 - C2) * V1 + 6 / 7 * ((C2 - C3) * V2 + 6 / 7 * ((C3 - C4) * V3 + 6 / 7 * ((C4 - C5) * V4 + 6 / 7 * ((C5 - C6) * V5 + 6 / 7 * ((C6 - C7) * V6 + 6 / 7 * ((C7 - C8) * V7 + 6 / 7 * ((C8 - C9) * V8 + 6 / 7 * ((C9 - C10) * V9 + 6 / 7 * ((C10 - C11) * V10 + 6 / 7 * ((C11 - C12) * V11 + 6 / 7 * ((C12 - C13) * V12 + 6 / 7 * ((C13 - C14) * V13 + 6 / 7 * ((C14 - C15) * V14 + 6 / 7 * ((C15 - C16) * V15 + 6 / 7 * ((C16 - C17) * V16 + 6 / 7 * ((C17 - C18) * V17 + 6 / 7 * ((C18 - C19) * V18 + 6 / 7 * ((C19 - C20) * V19 + 6 / 7 * ((C20 - C21) * V20 + 6 / 7 * ((C21 - C22) * V21 + 6 / 7 * ((C22 - C23) * V22 + 6 / 7 * ((C23 - C24) * V23 + 6 / 7 * ((C24 - C25) * V24 + 6 / 7 * ((C25 - C26) * V25 + 6 / 7 * ((C26 - C27) * V26 + 6 / 7 * ((C27 - C28) * V27 + 6 / 7 * ((C28 - C29) * V28 + 6 / 7 * ((C29 - C30) * V29 + 6 / 7 * ((C30 - C31) * V30 + 6 / 7 * ((C31 - C32) * V31 + 6 / 7 * ((C32 - C33) * V32 + 6 / 7 * ((C33 - C34) * V33 + 6 / 7 * ((C34 - C35) * V34 + 6 / 7 * ((C35 - C36) * V35 + 6 / 7 * ((C36 - C37) * V36 + 6 / 7 * ((C37 - C38) * V37 + 6 / 7 * ((C38 - C39) * V38 + 6 / 7 * ((C39 - C40) * V39 + 6 / 7 * ((C40 - C41) * V40 + 6 / 7 * ((C41 - C42) * V41 + 6 / 7 * ((C42 - C43) * V42 + 6 / 7 * ((C43 - C44) * V43 + 6 / 7 * ((C44 - C45) * V44)))))))))))))))))))))))))))))))))))))))))))))
The formula for a 2-Period Exponential Moving Average of the Force Index would be:
66.6971637694419 * ((C - C1) * V + 1 / 3 * ((C1 - C2) * V1 + 1 / 3 * ((C2 - C3) * V2 + 1 / 3 * ((C3 - C4) * V3 + 1 / 3 * ((C4 - C5) * V4 + 1 / 3 * ((C5 - C6) * V5 + 1 / 3 * ((C6 - C7) * V6)))))))
In the referenced topic, there's actually a 13-Period Exponential Moving Average of a 2-Period Exponential Moving Average of the Force Index as well:
15.5995688788792 * ((C - C1) * V + 6 / 7 * ((C1 - C2) * V1 + 6 / 7 * ((C2 - C3) * V2 + 6 / 7 * ((C3 - C4) * V3 + 6 / 7 * ((C4 - C5) * V4 + 6 / 7 * ((C5 - C6) * V5 + 6 / 7 * ((C6 - C7) * V6 + 6 / 7 * ((C7 - C8) * V7 + 6 / 7 * ((C8 - C9) * V8 + 6 / 7 * ((C9 - C10) * V9 + 6 / 7 * ((C10 - C11) * V10 + 6 / 7 * ((C11 - C12) * V11 + 6 / 7 * ((C12 - C13) * V12 + 6 / 7 * ((C13 - C14) * V13 + 6 / 7 * ((C14 - C15) * V14 + 6 / 7 * ((C15 - C16) * V15 + 6 / 7 * ((C16 - C17) * V16 + 6 / 7 * ((C17 - C18) * V17 + 6 / 7 * ((C18 - C19) * V18 + 6 / 7 * ((C19 - C20) * V19 + 6 / 7 * ((C20 - C21) * V20 + 6 / 7 * ((C21 - C22) * V21 + 6 / 7 * ((C22 - C23) * V22 + 6 / 7 * ((C23 - C24) * V23 + 6 / 7 * ((C24 - C25) * V24 + 6 / 7 * ((C25 - C26) * V25 + 6 / 7 * ((C26 - C27) * V26 + 6 / 7 * ((C27 - C28) * V27 + 6 / 7 * ((C28 - C29) * V28 + 6 / 7 * ((C29 - C30) * V29 + 6 / 7 * ((C30 - C31) * V30 + 6 / 7 * ((C31 - C32) * V31 + 6 / 7 * ((C32 - C33) * V32 + 6 / 7 * ((C33 - C34) * V33 + 6 / 7 * ((C34 - C35) * V34 + 6 / 7 * ((C35 - C36) * V35 + 6 / 7 * ((C36 - C37) * V36 + 6 / 7 * ((C37 - C38) * V37 + 6 / 7 * ((C38 - C39) * V38 + 6 / 7 * ((C39 - C40) * V39 + 6 / 7 * ((C40 - C41) * V40 + 6 / 7 * ((C41 - C42) * V41 + 6 / 7 * ((C42 - C43) * V42 + 6 / 7 * ((C43 - C44) * V43 + 6 / 7 * ((C44 - C45) * V44))))))))))))))))))))))))))))))))))))))))))))) - 6.06337852449472 * ((C - C1) * V + 1 / 3 * ((C1 - C2) * V1 + 1 / 3 * ((C2 - C3) * V2 + 1 / 3 * ((C3 - C4) * V3 + 1 / 3 * ((C4 - C5) * V4 + 1 / 3 * ((C5 - C6) * V5 + 1 / 3 * ((C6 - C7) * V6)))))))
The above formulas are just for values of these lines, not crossovers. I'm still not sure from your question which lines need to be crossing each other (and it what direction).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 69
|
From you response should these give info similar to a simple sort (i.e., +/0/- values)? If so, great, but in answer to your question, I'm interested in c/o 's of the zero line.
|
|
Registered User
Joined: 10/7/2004
Posts: 69
|
Ammend: I'm interested in force c/o it's 13 xavg and 2 xavg. Sorry for the error.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, the formuals provided just return the value of the Exponential Moving Averages of the Force Index. Please try the following:
Force xUp its own EMA2:
(C - C1) * V > .666971637694419 * ((C - C1) * V + 1 / 3 * ((C1 - C2) * V1 + 1 / 3 * ((C2 - C3) * V2 + 1 / 3 * ((C3 - C4) * V3 + 1 / 3 * ((C4 - C5) * V4 + 1 / 3 * ((C5 - C6) * V5 + 1 / 3 * ((C6 - C7) * V6))))))) AND (C1 - C2) * V1 <= .666971637694419 * ((C1 - C2) * V1 + 1 / 3 * ((C2 - C3) * V2 + 1 / 3 * ((C3 - C4) * V3 + 1 / 3 * ((C4 - C5) * V4 + 1 / 3 * ((C5 - C6) * V5 + 1 / 3 * ((C6 - C7) * V6 + 1 / 3 * ((C7 - C8) * V7)))))))
Force xUp its own EMA13:
(C - C1) * V > .142996048056393 * ((C - C1) * V + 6 / 7 * ((C1 - C2) * V1 + 6 / 7 * ((C2 - C3) * V2 + 6 / 7 * ((C3 - C4) * V3 + 6 / 7 * ((C4 - C5) * V4 + 6 / 7 * ((C5 - C6) * V5 + 6 / 7 * ((C6 - C7) * V6 + 6 / 7 * ((C7 - C8) * V7 + 6 / 7 * ((C8 - C9) * V8 + 6 / 7 * ((C9 - C10) * V9 + 6 / 7 * ((C10 - C11) * V10 + 6 / 7 * ((C11 - C12) * V11 + 6 / 7 * ((C12 - C13) * V12 + 6 / 7 * ((C13 - C14) * V13 + 6 / 7 * ((C14 - C15) * V14 + 6 / 7 * ((C15 - C16) * V15 + 6 / 7 * ((C16 - C17) * V16 + 6 / 7 * ((C17 - C18) * V17 + 6 / 7 * ((C18 - C19) * V18 + 6 / 7 * ((C19 - C20) * V19 + 6 / 7 * ((C20 - C21) * V20 + 6 / 7 * ((C21 - C22) * V21 + 6 / 7 * ((C22 - C23) * V22 + 6 / 7 * ((C23 - C24) * V23 + 6 / 7 * ((C24 - C25) * V24 + 6 / 7 * ((C25 - C26) * V25 + 6 / 7 * ((C26 - C27) * V26 + 6 / 7 * ((C27 - C28) * V27 + 6 / 7 * ((C28 - C29) * V28 + 6 / 7 * ((C29 - C30) * V29 + 6 / 7 * ((C30 - C31) * V30 + 6 / 7 * ((C31 - C32) * V31 + 6 / 7 * ((C32 - C33) * V32 + 6 / 7 * ((C33 - C34) * V33 + 6 / 7 * ((C34 - C35) * V34 + 6 / 7 * ((C35 - C36) * V35 + 6 / 7 * ((C36 - C37) * V36 + 6 / 7 * ((C37 - C38) * V37 + 6 / 7 * ((C38 - C39) * V38 + 6 / 7 * ((C39 - C40) * V39 + 6 / 7 * ((C40 - C41) * V40 + 6 / 7 * ((C41 - C42) * V41 + 6 / 7 * ((C42 - C43) * V42 + 6 / 7 * ((C43 - C44) * V43 + 6 / 7 * ((C44 - C45) * V44))))))))))))))))))))))))))))))))))))))))))))) AND (C1 - C2) * V1 <= .142996048056393 * ((C1 - C2) * V1 + 6 / 7 * ((C2 - C3) * V2 + 6 / 7 * ((C3 - C4) * V3 + 6 / 7 * ((C4 - C5) * V4 + 6 / 7 * ((C5 - C6) * V5 + 6 / 7 * ((C6 - C7) * V6 + 6 / 7 * ((C7 - C8) * V7 + 6 / 7 * ((C8 - C9) * V8 + 6 / 7 * ((C9 - C10) * V9 + 6 / 7 * ((C10 - C11) * V10 + 6 / 7 * ((C11 - C12) * V11 + 6 / 7 * ((C12 - C13) * V12 + 6 / 7 * ((C13 - C14) * V13 + 6 / 7 * ((C14 - C15) * V14 + 6 / 7 * ((C15 - C16) * V15 + 6 / 7 * ((C16 - C17) * V16 + 6 / 7 * ((C17 - C18) * V17 + 6 / 7 * ((C18 - C19) * V18 + 6 / 7 * ((C19 - C20) * V19 + 6 / 7 * ((C20 - C21) * V20 + 6 / 7 * ((C21 - C22) * V21 + 6 / 7 * ((C22 - C23) * V22 + 6 / 7 * ((C23 - C24) * V23 + 6 / 7 * ((C24 - C25) * V24 + 6 / 7 * ((C25 - C26) * V25 + 6 / 7 * ((C26 - C27) * V26 + 6 / 7 * ((C27 - C28) * V27 + 6 / 7 * ((C28 - C29) * V28 + 6 / 7 * ((C29 - C30) * V29 + 6 / 7 * ((C30 - C31) * V30 + 6 / 7 * ((C31 - C32) * V31 + 6 / 7 * ((C32 - C33) * V32 + 6 / 7 * ((C33 - C34) * V33 + 6 / 7 * ((C34 - C35) * V34 + 6 / 7 * ((C35 - C36) * V35 + 6 / 7 * ((C36 - C37) * V36 + 6 / 7 * ((C37 - C38) * V37 + 6 / 7 * ((C38 - C39) * V38 + 6 / 7 * ((C39 - C40) * V39 + 6 / 7 * ((C40 - C41) * V40 + 6 / 7 * ((C41 - C42) * V41 + 6 / 7 * ((C42 - C43) * V42 + 6 / 7 * ((C43 - C44) * V43 + 6 / 7 * ((C44 - C45) * V44 + 6 / 7 * ((C45 - C46) * V45)))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 69
|
Bruce bless you. Can I write a superlative commendation to your boss?!
SC
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Thank you for the thought, but my boss already reads the forums and even answers questions.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |