Gold Customer
Joined: 1/31/2005 Posts: 3
|
I tried converting your NR7 scan to a weekly format using the following formula:
MAXH5 - MAXL5 < MAXH5.5 - MAXL5.5 AND MAXH5 - MAXL5 < MAXH5.10 - MAXL5.10 AND MAXH5 - MAXL5 < MAXH5.15 - MAXL5.15 AND MAXH5 - MAXL5 < MAXH5.20 - MAXL5.20 AND MAXH5 - MAXL5 < MAXH5.25 - MAXL5.25 AND MAXH5 - MAXL5 < MAXH5.30 - MAXL5.30
However, it did not work because the current week's bar was not the narrowest bar for many of the stocks that past the scan. What did I do wrong?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following instead:
MAXH5 - MINL5 < MAXH5.5 - MINL5.5 AND MAXH5 - MINL5 < MAXH5.10 - MINL5.10 AND MAXH5 - MINL5 < MAXH5.15 - MINL5.15 AND MAXH5 - MINL5 < MAXH5.20 - MINL5.20 AND MAXH5 - MINL5 < MAXH5.25 - MINL5.25 AND MAXH5 - MINL5 < MAXH5.30 - MINL5.30
MAXL5 is the highest low of the last five periods. MINL5 is the lowest low of the last five periods.
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 1/31/2005 Posts: 3
|
I knew I was makinga simple mistake. Thanks for the help!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|