14) Scan Functions: Query Examples

Here are some examples of how to write scan queries. Some are more complicated than others. See other sections for guidelines and directions for use.

• Price crosses above 50-day moving average. Both are upward-sloping.
• 12-day %K crosses above 20 & is above %D.
• 50-day moving average is within 10% of 200-day moving average.
• Price is at 40-day high, but Williams' %R did not reach new high.
• Bearish candlestick pattern with bullish IQC zone or money flow.
• Bollinger band penetration as bands are tightening.
• For Nasdaq stocks that closed up, let today's money-flow-to-money-flow average ratio be higher than volume-to-volume average ratio.

Price crosses above 50-day moving average. Both are upward-sloping.

LINE1:    CLOSE > MAC50 AND CLOSE1 <= MAC50_1

LINE2:    CLOSE > CLOSE1 AND MAC50 > MAC50_1

12-day %K crosses above 20 & is above %D.

LINE1:    STO12_K > 20 AND STO12_K_1 <= 20

LINE2:    STO12_K > STO12_D

50-day moving average is within 10% of 200-day moving average.

LINE1:    MAC50 > (.9*MAC200) AND MAC50 < (1.1*MAC200)

Price is at 40-day high, but Williams' %R did not reach new high.

LINE1:    CLOSE = MAX40 AND PCTR20 < PCTR20_1

Bearish candlestick pattern with bullish IQC zone or money flow.

LINE1:    CANDLE_1 = 3 OR CANDLE_1 = 7 OR CANDLE_1 = 12

LINE2:    IQC = 1 OR MF > 0

Bollinger band penetration as bands are tightening.

LINE1:    CLOSE > BBU20 AND CLOSE1 < BBU20_1

LINE2:    (BBU20_1 - BBL20_1) < (BBU20_5 - BBL20_5)

For Nasdaq stocks that closed up, let today's money-flow-to-money-flow average ratio be higher than volume-to-volume average ratio.

LINE1:    EXCHANGE = 122 AND CLOSE > OPEN

LINE2:    (MF/MFA5) > (VOLUME/MAV5)

NOTE: LINE2 COULD ALSO BE WRITTEN (MF*MAV5) > (VOLUME*MFA5)