Registered User Joined: 8/25/2010 Posts: 117
|
Bruce,
Can you please create a formula for:
The narrowest two consecutive days range when compared to any two-day range during the last 20 days.
Thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I can think of quite a few different interpretations of your request, but a Condition Formmula for the total range of the most recent 2 bars being less than the total range of any of the 2 bar ranges ending in the previous 20 bars could be written as:
MAXH2 - MINL2 < MAXH2.1 - MINL2.1 AND MAXH2 - MINL2 < MAXH2.2 - MINL2.2 AND MAXH2 - MINL2 < MAXH2.3 - MINL2.3 AND MAXH2 - MINL2 < MAXH2.4 - MINL2.4 AND MAXH2 - MINL2 < MAXH2.5 - MINL2.5 AND MAXH2 - MINL2 < MAXH2.6 - MINL2.6 AND MAXH2 - MINL2 < MAXH2.7 - MINL2.7 AND MAXH2 - MINL2 < MAXH2.8 - MINL2.8 AND MAXH2 - MINL2 < MAXH2.9 - MINL2.9 AND MAXH2 - MINL2 < MAXH2.10 - MINL2.10 AND MAXH2 - MINL2 < MAXH2.11 - MINL2.11 AND MAXH2 - MINL2 < MAXH2.12 - MINL2.12 AND MAXH2 - MINL2 < MAXH2.13 - MINL2.13 AND MAXH2 - MINL2 < MAXH2.14 - MINL2.14 AND MAXH2 - MINL2 < MAXH2.15 - MINL2.15 AND MAXH2 - MINL2 < MAXH2.16 - MINL2.16 AND MAXH2 - MINL2 < MAXH2.17 - MINL2.17 AND MAXH2 - MINL2 < MAXH2.18 - MINL2.18 AND MAXH2 - MINL2 < MAXH2.19 - MINL2.19 AND MAXH2 - MINL2 < MAXH2.20 - MINL2.20
-Bruce Personal Criteria Formulas TC2000 Support Articles
|