| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/11/2004
Posts: 38
|
I am interested in establishing a (bullish) easy scan that will do the following: 
1-Check that the 2SMA is greater than the 4SMA on the daily
1A-Check that the 2SMA is greater than the 4SMA on the weekly
2-Check that the 8,13,5 MACD is either positive or crossing to positive on the daily
2A-Check that the 8,13,5 MACD is either positive or crossing to positive on the weekly
3-Check that todays closing price is within +/-10% of the lower boll band (21,20) on the daily
3A-Check that todays closing price is within +/-10% of the lower boll band (21,20) on the weekly
Inversely for a bearish scan:
1-Check that the 2SMA is less than the 4SMA on the daily
1A-Check that the 2SMA is less than the 4SMA on the weekly
2-Check that the 8,13,5 MACD is either negative or crossing to negative on the daily
2A-Check that the 8,13,5 MACD is either negative or crossing to negative on the weekly
3-Check that todays closing price is within +/-10% of the upper boll band (21,20) on the daily
3A-Check that todays closing price is within +/-10% of the upper boll band (21,20) on the weekly
Thanks in advance for your help. You assistance has been enormously generous! 
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try using the following Personal Criteria Formulas as EasyScan Conditions:
Bullish Scan:
AVGC2 > AVGC4 AND XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) > 0 AND ABS(C / (AVGC21 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) - 1) < .1 AND C + C5 > C10 + C15 AND .0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) > 0 AND ABS(C / ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21 - 2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) - 1) < .1
Bearish Scan:
AVGC2 < AVGC4 AND XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) < 0 AND ABS(C / (AVGC21 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) - 1) < .1 AND C + C5 < C10 + C15 AND .0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) < 0 AND ABS(C / ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21 + 2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) - 1) < .1
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Understanding MACD
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
Thanks again. I'll give these a try.
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
OK. All is in good order but, the C relative to the Boll bands. I likely didn't state the objective well enough. Per yesterday's close, LLY is above the upper BB on the daily but much nearer the lower BB on the weekly.
How do we change the scan to capture the close nearer the boll bands for both time frames? Perhaps the percentage approach isn't best--maybe have the C within +/- $2 of the value of the lower band [and the upper for the bearish scans].
P.S. COF, and WMI are other examples.
Thanks
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A dollar value would probably produce the same issues. Maybe you want it to be at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline)?
Bullish Scan:
AVGC2 > AVGC4 AND XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) > 0 AND (C - AVGC21) / (2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) <= ( - .8) AND C + C5 > C10 + C15 AND .0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) > 0 AND (C - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) / (2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) <= ( - .8)
Bearish Scan:
AVGC2 < AVGC4 AND XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) < 0 AND (C - AVGC21) / (2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) >= .8 AND C + C5 < C10 + C15 AND .0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) < 0 AND (C - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) / (2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) >= .8
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
I shall try again--and thanks.
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
Would you review and repost the bearsih PCF? I tried to correct the 2SMA < 4SMA but have corrupted the PCF! MACD also needs to be 0 or negative for both daily and weekly.
Again i appreciate your help.
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I've adjusted the formula above. Please try it again.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
Would you please segment the PCF for me as below?
2A-Check that the 8,13,5 MACD is either negative or crossing to negative on the weekly. PCF = _____
3-Check that todays closing price is within at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline) on the daily. PCF = _______
3A-Check that todays closing price is within +/-10% of the upper boll band (21,20) on the weekly. PCF = _____
I have confused myself completely!! 
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
First set of formulas:
Bullish Scan:
1-Check that the 2SMA is greater than the 4SMA on the daily:
AVGC2 > AVGC4
1A-Check that the 2SMA is greater than the 4SMA on the weekly:
C + C5 > C10 + C15
2-Check that the 8,13,5 MACD is either positive or crossing to positive on the daily:
XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) > 0
2A-Check that the 8,13,5 MACD is either positive or crossing to positive on the weekly:
.0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) > 0
3-Check that todays closing price is within +/-10% of the lower boll band (21,20) on the daily:
ABS(C / (AVGC21 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) - 1) < .1
3A-Check that todays closing price is within +/-10% of the lower boll band (21,20) on the weekly:
ABS(C / ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21 - 2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) - 1) < .1
Bearish Scan:
1-Check that the 2SMA is less than the 4SMA on the daily:
AVGC2 < AVGC4
1A-Check that the 2SMA is less than the 4SMA on the weekly:
C + C5 < C10 + C15
2-Check that the 8,13,5 MACD is either negative or crossing to negative on the daily:
XAVGC8 - XAVGC13 - XAVG(XAVGC8,5) + XAVG(XAVGC13,5) < 0
2A-Check that the 8,13,5 MACD is either negative or crossing to negative on the weekly:
.0714980240281964 * (C + 6 / 7 * (C5 + 6 / 7 * (C10 + 6 / 7 * (C15 + 6 / 7 * (C20 + 6 / 7 * (C25 + 6 / 7 * (C30 + 6 / 7 * (C35 + 6 / 7 * (C40 + 6 / 7 * (C45 + 6 / 7 * (C50 + 6 / 7 * (C55 + 6 / 7 * (C60 + 6 / 7 * (C65 + 6 / 7 * (C70 + 6 / 7 * (C75 + 6 / 7 * (C80 + 6 / 7 * (C85 + 6 / 7 * (C90 + 6 / 7 * (C95 + 6 / 7 * (C100 + 6 / 7 * (C105 + 6 / 7 * (C110 + 6 / 7 * (C115 + 6 / 7 * (C120 + 6 / 7 * (C125 + 6 / 7 * (C130 + 6 / 7 * (C135 + 6 / 7 * (C140 + 6 / 7 * (C145 + 6 / 7 * (C150 + 6 / 7 * (C155 + 6 / 7 * (C160 + 6 / 7 * (C165 + 6 / 7 * (C170 + 6 / 7 * (C175 + 6 / 7 * (C180 + 6 / 7 * (C185 + 6 / 7 * (C190 + 6 / 7 * (C195 + 6 / 7 * (C200 + 6 / 7 * (C205 + 6 / 7 * (C210 + 6 / 7 * (C215 + 6 / 7 * (C220))))))))))))))))))))))))))))))))))))))))))))) - .296556949436677 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) + .277965860454332 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) < 0
3-Check that todays closing price is within +/-10% of the upper boll band (21,20) on the daily:
ABS(C / (AVGC21 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) - 1) < .1
3A-Check that todays closing price is within +/-10% of the upper boll band (21,20) on the weekly:
ABS(C / ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21 + 2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) - 1) < .1
The replacements in the second set of formulas are:
Bullish Scan:
3-Check that todays closing price is within at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline) on the daily:
(C - AVGC21) / (2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) <= ( - .8)
3A-Check that todays closing price is within at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline) on the weekly:
(C - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) / (2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) <= ( - .8)
Bearish Scan:
3-Check that todays closing price is within at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline) on the daily:
(C - AVGC21) / (2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20)) >= .8
3A-Check that todays closing price is within at least a certain percentage of the BB Width away from the BB Centerline (adjust the .8s to adjust the distance from the centerline) on the weekly:
(C - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) / (2 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - 21 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 21) ^ 2) / 20)) >= .8
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/11/2004
Posts: 38
|
Your help, and patience, for a novice are appreciated. 
RS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |