Registered User Joined: 10/13/2011 Posts: 38
|
Hello!
I'm looking for a modification to the following pocket pivot formula to make it so it only triggers when the open of the candle that the pocket pivot occurs on is within 3% above or below:
the 50 day moving average
and/or the 10 day moving average.
And if it opens below the average, is it possible to only trigger if it crosses above the average?
Is it possible to combine the two moving average conditions (and/or 10ma or 50ma) into one formula?
Current pocket pivot formula:
C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10
Thank you!
Yi
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A Condition Formula for this can be written as follows in TC2000 v17.
C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10) AND ((ABS(O / AVGC10 - 1) <= .03 AND (O >= AVGC10 OR (O < AVGC10 AND C > AVGC10))) OR (ABS(O / AVGC50 - 1) <= .03 AND (O >= AVGC50 OR (O < AVGC50 AND C > AVGC50))))
The formula is a bit longer in earlier versions of TC2000.
C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10 AND ((ABS(O / AVGC10 - 1) <= .03 AND (O >= AVGC10 OR (O < AVGC10 AND C > AVGC10))) OR (ABS(O / AVGC50 - 1) <= .03 AND (O >= AVGC50 OR (O < AVGC50 AND C > AVGC50))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/13/2011 Posts: 38
|
QUOTE (Bruce_L)
A Condition Formula for this can be written as follows in TC2000 v17.
C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10) AND ((ABS(O / AVGC10 - 1) <= .03 AND (O >= AVGC10 OR (O < AVGC10 AND C > AVGC10))) OR (ABS(O / AVGC50 - 1) <= .03 AND (O >= AVGC50 OR (O < AVGC50 AND C > AVGC50))))
The formula is a bit longer in earlier versions of TC2000.
C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10 AND ((ABS(O / AVGC10 - 1) <= .03 AND (O >= AVGC10 OR (O < AVGC10 AND C > AVGC10))) OR (ABS(O / AVGC50 - 1) <= .03 AND (O >= AVGC50 OR (O < AVGC50 AND C > AVGC50))))
Thanks Bruce! can we also add to v17 "close of candle is above 50dma in both cases?" Appreciate it.
Yi
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
That should actually shorten the formulas slightly. A Condition Formula for this can be written as follows in TC2000 v17.
C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10) AND ((ABS(O / AVGC10 - 1) <= .03 AND C > AVGC10) OR (ABS(O / AVGC50 - 1) <= .03 AND C > AVGC50))
The formula is a bit longer in earlier versions of TC2000.
C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10 AND ((ABS(O / AVGC10 - 1) <= .03 AND C > AVGC10) OR (ABS(O / AVGC50 - 1) <= .03 AND C > AVGC50))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|