| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/30/2004
Posts: 369
|
Hello,
I am trying to write an "OR" "Percent True" 13 Period Force Index crossing a zero line. I was able to do it with CCI and MACD but when I add the Force Index formula either as an "AND" or an "OR" what I get is a squared off sign wave instead of spike. Please help.
Thanks,
-amberpax
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
I am using this formula:
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))))))))))))))))))))))))))))))))))))))))))))) >0
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
That's because your formula isn't a crossover formula. It just tests if the Force Index is greater than zero. Please try the following instead:
SGN(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)))))))))))))))))))))))))))))))))))))))))))))) - SGN(14.2996048056393 * ((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)))))))))))))))))))))))))))))))))))))))))))))) <> 0
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Bruce,
As always. Thank you!
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Hello Again,
I've copied and pasted the formula, but now I am getting an indication (bottom window) where the zero line for the force index was not crossed.
In the price field I have the force index (purple) and the zero line is indicated by the green line.
Here is the URL so you can take a look.
Copy and paste the URL into the address bar and when it comes up hit the left mouse botton to enlarge.
http://img263.imageshack.us/img263/4416/percenttruetw0.png
Thanks,
-amberpax
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Correction: Just click on the URL and then left click the mouth botton to enlarge.
Thank,
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You don't appear to be plotting anything in the other panes that's being tested in the bottom pane. None of the Custom Indicators in the top or middle panes start the same way as the Custom Percent True in the bottom pane.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
"You don't appear to be plotting anything in the other panes that's being tested in the bottom pane. None of the Custom Indicators in the top or middle panes start the same way as the Custom Percent True in the bottom pane."
I don't understand. I have Force Index plotted in the price window with the center line zero (green)
The force index formula that I am using is:
0.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))))))))
which matches stocharts*com exactly.
Please go to the jan 17th post and click on the link to see what I have.
Thank you,
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (amberpax) I don't understand.
The formula from your Tuesday, January 16, 2007 11:26:43 PM ET and my Wednesday, January 17, 2007 8:50:40 AM ET posts are based on the formula for a 13-Period Exponential Force Index:
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)))))))))))))))))))))))))))))))))))))))))))))
QUOTE (amberpax) I have Force Index plotted in the price window with the center line zero (green)
The force index formula that I am using is:
0.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))))))))
This formula is for a 2-Period Exponential Force Index (except that I believe it is normally multiplied by 100). You have then applied a 13-Period Exponential Moving Average to this. One way to write a Personal Criteria Formula for this is:
.155995688788792 * ((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))))))))))))))))))))))))))))))))))))))))))))) - .0606337852449472 * ((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)))))))
One way to write a crossover PCF based on this would be:
SGN(.155995688788792 * ((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))))))))))))))))))))))))))))))))))))))))))))) - .0606337852449472 * ((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)))))))) - SGN(.155995688788792 * ((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))))))))))))))))))))))))))))))))))))))))))))) - .0606337852449472 * ((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)))))))) <> 0
QUOTE (amberpax) which matches stocharts*com exactly.
This is very odd considering the above.
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Force Indes
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Bruce,
Thank you again. I will try it tonight.
-amberpax
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Hello Bruce,
Yes Sir, your latest formula WORKS!
Thank You!
Now, I have one more formula (previous post) on the same subject, that does not work, so I will ask you about that next.
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |