| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 13
|
Hi - This Custom Indicator:
Trend Entry: ( (H+L+2*(O+C))/6 > AvgC10 + SQR(( ( C*C +C1*C1 +C2*C2 +C3*C3 +C4* C4 +C5*C5 +C6*C6 +C7*C7 +C8*C8 +C9*C9 ) - ( 10 * AvgC10 *AvgC10 ) ) / 9 ) ) * ( H < AvgC40 + 3*SQR(((C0*C0 +C1*C1 +C2 *C2 +C3*C3 +C4*C4 +C5*C5 +C6*C6 +C7 *C7 +C8*C8 +C9*C9 +C10*C10 +C11*C11 +C12*C12 +C13*C13 +C14*C14 +C15*C15 +C16*C16 +C17*C17 +C18*C18 +C19*C19 +C20*C20 +C21*C21 +C22*C22 +C23*C23 +C24*C24 +C25*C25 +C26*C26 +C27*C27 +C28*C28 +C29*C29 +C30*C30 +C31*C31 +C32*C32 +C33*C33 +C34*C34 +C35*C35 +C36*C36 +C37*C37 +C38*C38 +C39*C39 ) - ( 40 * AvgC40*AvgC40 ) ) / 39 ) ) * (2 - ( H-C < (H-L)/3 ) - ( SQR((( C*C +C1 *C1 +C2*C2 +C3*C3 +C4*C4 +C5*C5 +C6 *C6 +C7*C7 +C8*C8 +C9*C9 +C10*C10 +C11*C11 +C12*C12 +C13*C13 +C14*C14 +C15*C15 +C16*C16 +C17*C17 +C18*C18 +C19*C19 ) - ( 20 * AvgC20*AvgC20 ) ) / 19 ) > SQR((( C1*C1 +C2*C2 +C3*C3 +C4*C4 +C5*C5 +C6*C6 +C7*C7 +C8*C8 +C9*C9 +C10*C10 +C11*C11 +C12 *C12 +C13*C13 +C14*C14 +C15*C15 +C16 *C16 +C17*C17 +C18*C18 +C19*C19 +C20 *C20 ) - ( 20 * AvgC20.1*AvgC20.1 ) ) / 19 ) ) )
works on all time frames down through 15 minutes. But in 10,5,or 1 minute time frames, instead of displaying on the screen, the title of the CI in the lower windows shows:
FORMULA ERROR Trig Error)1 Period.
When I edit the CI and click on "Test", the CI value is calculated, but it isn't displayed on the screen. (The visible box is checked.)
I don't see anything which might be mistaken for a trigonometry reference in the formula.
Can you help?
Thanks,
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I believe the error message is resulting from an attempt to take the square root of a negative number. Please try the following instead:
((H + L + 2 * (O + C)) / 6 > AVGC10 + SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9)) * ( H < AVGC40 + 3 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 - 40 * AVGC40 ^ 2) / 39)) * (2 - (H - C < (H - L)/3) - (SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 19) > SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19)))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 13
|
Bruce - Your solution worked just fine.
Thank you, Pat
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |