Gold Customer
Joined: 1/24/2005 Posts: 97
|
Hi-I am trying to create a pullback to the 75 sma scan after about 60-days being above it...when I use the scan below-I'm getting a few weird ones showing up in the scan:
(L < AVGC75 AND AVGC1.5 > AVGC75 AND AVGC1.55.5 > AVGC75 AND MAXH60 > 1.5*MINL60.50 AND MAXH40.6 > MAXH126.50 AND C < MAXH40.20 AND C > 10 AND AVGV30 > 1000) OR (L < AVGC75 AND AVGC1.5 > AVGC75 AND AVGC1.55.5 > AVGC75 AND MAXH60 > 1.30*MINL60.50 AND MAXH40.6 > MAXH126.50 AND C < MAXH40.20 AND C > 10 AND AVGV30 > 500)
Ideally I would like to model this after AKBA's August pullback...The scan above is pulling in these two: TVTY, ZGNX which shouldn't be there...
Am I missing a better way of doing this? Thanks for any help
Paul
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm not sure about all of the other requirements, but you could just check directly. The formula in TC2000 v17 is a lot shorter.
L <= AVGC75 AND TrueInRow(L1 > AVGC75.1, 60) = 60
But the formula in TC2000 v7 isn't all that bad.
L <= AVGC75 AND L1 > AVGC75.1 AND L2 > AVGC75.2 AND L3 > AVGC75.3 AND L4 > AVGC75.4 AND L5 > AVGC75.5 AND L6 > AVGC75.6 AND L7 > AVGC75.7 AND L8 > AVGC75.8 AND L9 > AVGC75.9 AND L10 > AVGC75.10 AND L11 > AVGC75.11 AND L12 > AVGC75.12 AND L13 > AVGC75.13 AND L14 > AVGC75.14 AND L15 > AVGC75.15 AND L16 > AVGC75.16 AND L17 > AVGC75.17 AND L18 > AVGC75.18 AND L19 > AVGC75.19 AND L20 > AVGC75.20 AND L21 > AVGC75.21 AND L22 > AVGC75.22 AND L23 > AVGC75.23 AND L24 > AVGC75.24 AND L25 > AVGC75.25 AND L26 > AVGC75.26 AND L27 > AVGC75.27 AND L28 > AVGC75.28 AND L29 > AVGC75.29 AND L30 > AVGC75.30 AND L31 > AVGC75.31 AND L32 > AVGC75.32 AND L33 > AVGC75.33 AND L34 > AVGC75.34 AND L35 > AVGC75.35 AND L36 > AVGC75.36 AND L37 > AVGC75.37 AND L38 > AVGC75.38 AND L39 > AVGC75.39 AND L40 > AVGC75.40 AND L41 > AVGC75.41 AND L42 > AVGC75.42 AND L43 > AVGC75.43 AND L44 > AVGC75.44 AND L45 > AVGC75.45 AND L46 > AVGC75.46 AND L47 > AVGC75.47 AND L48 > AVGC75.48 AND L49 > AVGC75.49 AND L50 > AVGC75.50 AND L51 > AVGC75.51 AND L52 > AVGC75.52 AND L53 > AVGC75.53 AND L54 > AVGC75.54 AND L55 > AVGC75.55 AND L56 > AVGC75.56 AND L57 > AVGC75.57 AND L58 > AVGC75.58 AND L59 > AVGC75.59 AND L60 > AVGC75.60
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 1/24/2005 Posts: 97
|
Thanks Bruce-apparently TVTY did work on my other PC (it was set to simple whereas the PC I had the problem on was "exponential"...
ZGNX still shouldn't show up but I think your version ironed out the wrinkle on it...not showing up on that scan...thanks for the help!!!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|