Registered User Joined: 8/25/2010 Posts: 117
|
Bruce,
Can you please create a formula for:
The narrowest three-day price range within the previous 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 3 bars being less than the total range of any of the 3 bar ranges ending in the previous 20 bars could be written as:
MAXH3 - MINL3 < MAXH3.1 - MINL3.1 AND MAXH3 - MINL3 < MAXH3.2 - MINL3.2 AND MAXH3 - MINL3 < MAXH3.3 - MINL3.3 AND MAXH3 - MINL3 < MAXH3.4 - MINL3.4 AND MAXH3 - MINL3 < MAXH3.5 - MINL3.5 AND MAXH3 - MINL3 < MAXH3.6 - MINL3.6 AND MAXH3 - MINL3 < MAXH3.7 - MINL3.7 AND MAXH3 - MINL3 < MAXH3.8 - MINL3.8 AND MAXH3 - MINL3 < MAXH3.9 - MINL3.9 AND MAXH3 - MINL3 < MAXH3.10 - MINL3.10 AND MAXH3 - MINL3 < MAXH3.11 - MINL3.11 AND MAXH3 - MINL3 < MAXH3.12 - MINL3.12 AND MAXH3 - MINL3 < MAXH3.13 - MINL3.13 AND MAXH3 - MINL3 < MAXH3.14 - MINL3.14 AND MAXH3 - MINL3 < MAXH3.15 - MINL3.15 AND MAXH3 - MINL3 < MAXH3.16 - MINL3.16 AND MAXH3 - MINL3 < MAXH3.17 - MINL3.17 AND MAXH3 - MINL3 < MAXH3.18 - MINL3.18 AND MAXH3 - MINL3 < MAXH3.19 - MINL3.19 AND MAXH3 - MINL3 < MAXH3.20 - MINL3.20
-Bruce Personal Criteria Formulas TC2000 Support Articles
|