StockFetcher Forums · Filter Exchange · Stocks trading below or above X dma<< >>Post Follow-up
legacyinvesting
1 posts
msg #54187
Ignore legacyinvesting
8/18/2007 4:06:30 PM

I'm sure this is easy but I can't figure out how to get stocks below a certain moving average. Not just when they cross or touch. Any help?

TheRumpledOne
6,359 posts
msg #54188
Ignore TheRumpledOne
modified
8/18/2007 5:13:07 PM

Fetcher[
/* select stocks below their 50 period moving average */
close below ma(50)

/* select for price, volume and market */
price above 50
volume above 1000000
market is nasdaq

/* compute and display how far price is below the moving average */

set{diff, ma(50) - close}
add column diff


/* descending sort of the difference column */
sort column 5 descending
]



HTH.

TheRumpledOne
6,359 posts
msg #54189
Ignore TheRumpledOne
modified
8/18/2007 5:17:58 PM

Fetcher[
/* select stocks below their 50 period moving average and above 200 ma*/
close below ma(50)
close above ma(200)

/* select for price, volume and market */
price above 50
volume above 1000000
market is nasdaq

/* compute and display how far price is below/above the moving average */

set{diff50, ma(50) - close}
set{diff200, close - ma(200)}
add column diff50
add column diff200

/* descending sort of the difference column */
sort column 5 descending
]



HTH.

TheRumpledOne
6,359 posts
msg #54190
Ignore TheRumpledOne
modified
8/18/2007 5:22:56 PM

From the BASIC FILTER DISPLAY:

Fetcher[

/* select for price, volume and market */
price above 50
volume above 1000000
market is nasdaq


set{E50b,days(close is above ma(50),100)}
set{E50a,days(close is below ma(50),100)}
set{CxM50, E50a - E50b}

set{E200b,days(close is above ma(200),100)}
set{E200a,days(close is below ma(200),100)}
set{CxM200, E200a - E200b}

set{E50200b,days(ma(50) is above ma(200),100)}
set{E50200a,days(ma(50) is below ma(200),100)}
set{M50xM200, E50200a - E50200b}

and add column CxM50
and add column CxM200
and add column M50xM200

sort column 5 ascending
]



Now you know how many days the close has been above/below the moving averages.

Of course, a "1" or "-1" means a cross over just occurred.

HTH.

StockFetcher Forums · Filter Exchange · Stocks trading below or above X dma<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus