Registered User Joined: 3/18/2005 Posts: 1
|
Please help write a scan for stocks that have fallen to support; MACD divergence (moving up for at least the last 2 days) with 12, 26, 9 criteria. Volume over 1 million; price below 40. Daily price bar close to or crossing up over the lower BBand(15,15). Too much? Is this possible to do with an Easy Scan? Appreciate your help. Thank you. Marco
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You may wish to try including the following Personal Criteria Formulas as EasyScan Conditions (you could also AND many of them together into a single PCF). Some additional clarification may be required to help you completely formulate your EasyScan.
QUOTE (Marco) stocks that have fallen to support I'm not sure if this one of the conditions or being defined by the rest of the conditions. If it is one of the conditions, you would need to provide a objective definitions of "support" and "fallen to support".
QUOTE (Marco) MACD divergence (moving up for at least the last 2 days) with 12, 26, 9 criteria
Raw MACD 12,26,9 (Fast) falling for at least two days:
XAVGC12 - XAVGC26 < XAVGC12.1 - XAVGC26.1 AND XAVGC12.1 - XAVGC26.1 < XAVGC12.2 - XAVGC26.2
MACD Trigger 12,26,9 (Slow) falling for at least two days:
XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) < XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9)
MACD Histogram 12,26,9 falling for at least two days:
XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9) AND XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9) < XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9)
If you want price to be falling over the same period:
C < C1 AND C1 < C2
QUOTE (Marco) Volume over 1 million There is a built in Volume Criteria that could be used for this with the EasyScan Rangefinder. You could also use the following Boolean PCF:
V > 10000
QUOTE (Marco) price below 40 There is a built in Price Per Share Criteria that could be used for this with the EasyScan Rangefinder. You could also use the following Boolean PCF:
C < 40
QUOTE (Marco) Daily price bar close to or crossing up over the lower BBand(15,15). Price xUp Lower BB (15,15):
C > AVGC15 - 1.5 * 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 - 15 * AVGC15 ^ 2) / 14) AND C1 <= AVGC15.1 - 1.5 * SQR(ABS(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 - 15 * AVGC15.1 ^ 2) / 14)
You would need to objectively define "close to" in order for us to help you write the other portion.
You may wish to review the following:
Understanding MACD Using EasyScan to find stocks that meet your own criteria Definitions of all built in scanning and sorting criteria How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs! PCF Formula Descriptions Evaluating "Closeness" in PCF's - relative to Equity &/or Risk Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
-Bruce Personal Criteria Formulas TC2000 Support Articles
|