Registered User Joined: 1/6/2018 Posts: 4
|
Hi there! I need a formula to indicate:
a weekly bar with a positive change of 50% (within the last 20 bars)
after that bar, all the closes of the next weekly bars are lower than that.
Thank You and have a nice weekend!
VG
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If those 20 bars include the current bar (so if it is the current bar, there are no lower bars after it yet).
2 * C >= 3 * C1 OR (2 * C1 >= 3 * C2 AND C < C1) OR (2 * C2 >= 3 * C3 AND MINC2 < C2) OR (2 * C3 >= 3 * C4 AND MINC3 < C3) OR (2 * C4 >= 3 * C5 AND MINC4 < C4) OR (2 * C5 >= 3 * C6 AND MINC5 < C5) OR (2 * C6 >= 3 * C7 AND MINC6 < C6) OR (2 * C7 >= 3 * C8 AND MINC7 < C7) OR (2 * C8 >= 3 * C9 AND MINC8 < C8) OR (2 * C9 >= 3 * C10 AND MINC9 < C9) OR (2 * C10 >= 3 * C11 AND MINC10 < C10) OR (2 * C11 >= 3 * C12 AND MINC11 < C11) OR (2 * C12 >= 3 * C13 AND MINC12 < C12) OR (2 * C13 >= 3 * C14 AND MINC13 < C13) OR (2 * C14 >= 3 * C15 AND MINC14 < C14) OR (2 * C15 >= 3 * C16 AND MINC15 < C15) OR (2 * C16 >= 3 * C17 AND MINC16 < C16) OR (2 * C17 >= 3 * C18 AND MINC17 < C17) OR (2 * C18 >= 3 * C19 AND MINC18 < C18) OR (2 * C19 >= 3 * C20 AND MINC19 < C19)
If those 20 bars exclude the current bar (so at least one lower close).
(2 * C1 >= 3 * C2 AND C < C1) OR (2 * C2 >= 3 * C3 AND MINC2 < C2) OR (2 * C3 >= 3 * C4 AND MINC3 < C3) OR (2 * C4 >= 3 * C5 AND MINC4 < C4) OR (2 * C5 >= 3 * C6 AND MINC5 < C5) OR (2 * C6 >= 3 * C7 AND MINC6 < C6) OR (2 * C7 >= 3 * C8 AND MINC7 < C7) OR (2 * C8 >= 3 * C9 AND MINC8 < C8) OR (2 * C9 >= 3 * C10 AND MINC9 < C9) OR (2 * C10 >= 3 * C11 AND MINC10 < C10) OR (2 * C11 >= 3 * C12 AND MINC11 < C11) OR (2 * C12 >= 3 * C13 AND MINC12 < C12) OR (2 * C13 >= 3 * C14 AND MINC13 < C13) OR (2 * C14 >= 3 * C15 AND MINC14 < C14) OR (2 * C15 >= 3 * C16 AND MINC15 < C15) OR (2 * C16 >= 3 * C17 AND MINC16 < C16) OR (2 * C17 >= 3 * C18 AND MINC17 < C17) OR (2 * C18 >= 3 * C19 AND MINC18 < C18) OR (2 * C19 >= 3 * C20 AND MINC19 < C19) OR (2 * C20 >= 3 * C21 AND MINC20 < C20)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 1/6/2018 Posts: 4
|
Thank You Bruce!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|