| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/27/2014
Posts: 22
|
I am trying to write a formula for the two following scenarios
1. find stocks that make new 52 week high then reverse and close at low of the week or close at the low over next two or three weeks
2. find stocks that make new 52 week low then reverse and close at the high of the week or higher two to three weeks later
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following as your first formula.
(C < MINL5.1 AND H5 > MAXH251.6) OR (C < MINL6.1 AND H6 > MAXH251.7) OR (C < MINL7.1 AND H7 > MAXH251.8) OR (C < MINL8.1 AND H8 > MAXH251.9) OR (C < MINL9.1 AND H9 > MAXH251.10) OR (C < MINL10.1 AND H10 > MAXH251.11) OR (C < MINL11.1 AND H11 > MAXH251.12) OR (C < MINL12.1 AND H12 > MAXH251.13) OR (C < MINL13.1 AND H13 > MAXH251.14) OR (C < MINL14.1 AND H14 > MAXH251.15) OR (C < MINL15.1 AND H15 > MAXH251.16)
And the following as your second formula.
(C > MAXH5.1 AND H5 < MINL251.6) OR (C > MAXH6.1 AND H6 < MINL251.7) OR (C > MAXH7.1 AND H7 < MINL251.8) OR (C > MAXH8.1 AND H8 < MINL251.9) OR (C > MAXH9.1 AND H9 < MINL251.10) OR (C > MAXH10.1 AND H10 < MINL251.11) OR (C > MAXH11.1 AND H11 < MINL251.12) OR (C > MAXH12.1 AND H12 < MINL251.13) OR (C > MAXH13.1 AND H13 < MINL251.14) OR (C > MAXH14.1 AND H14 < MINL251.15) OR (C > MAXH15.1 AND H15 < MINL251.16)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/27/2014
Posts: 22
|
hi i don't seem to be getting any stocks with the new low scan any thoughts thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I have added parentheses to force the ANDs to happen before the ORs. See if that does what you want.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/27/2014
Posts: 22
|
only one stock came up for reversal for 52 week low
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Do you have reason to believe more stocks should show up?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/27/2014
Posts: 22
|
hi bruce the formula for wash and rinse below at 52 week low is not turning up allot of candidtes. What would formula be for stocks that have reached 52 week low but have now risen above that low by 3% on a daily basis over a two week period. Thanks
(C > MAXH5.1 AND H5 < MINL251.6) OR (C > MAXH6.1 AND H6 < MINL251.7) OR (C > MAXH7.1 AND H7 < MINL251.8) OR (C > MAXH8.1 AND H8 < MINL251.9) OR (C > MAXH9.1 AND H9 < MINL251.10) OR (C > MAXH10.1 AND H10 < MINL251.11) OR (C > MAXH11.1 AND H11 < MINL251.12) OR (C > MAXH12.1 AND H12 < MINL251.13) OR (C > MAXH13.1 AND H13 < MINL251.14) OR (C > MAXH14.1 AND H14 < MINL251.15) OR (C > MAXH15.1 AND H15 < MINL251.16)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Maybe something like the following?
100 * C >= 103 * MINL252 AND MINL10 = MINL252
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |