Computer Screening for Up Trend
Source: http://feedproxy.google.com/~r/qvmgroup/yrMF/~3/wdKl2o6DvWQ/2406Posted on Sunday, April 5th, 2009 | In Market Commentary
If you follow a limited number of securities, a manual review of their charts is a feasible and perhaps practical way to monitor price trends. However, if you wish to scan the universe of listed stocks and funds, you have to use a computer to get the job done.
In the end, of course, one-by-one chart inspection is necessary to determine that whatever trend or price pattern you seek is in place.
Note that price action is just one dimension of investment decisions. You need to consider multiple dimensions, such as:
- the “story” – what the company or fund is all about, and the prospects that creates
- the financial health of the company (balance sheet, income and cash flow factors)
- the valuation level (multiples such a EV/EBITDA, P/S, P/E, Yield, etc.)
- the price behavior (current or prospective up trends being better than down trends for long positions)
For investors, as opposed to traders, price action and valuation levels are more about when to enter a security than what security you wish to own or why, which is more a function of the “story” and the financial health of the company.
Continuing with the price behavior dimension, let’s consider the search for short-term up trends. That may be helpful in finding stocks that are beginning a trend reversal process. Even though the market overall is still in a downward motion, there are individual stocks that have done quite well recently.
Here is an example rules-based screen that quantitatively identifies securities that may be in up trends. You could use different rules, of course, but this set of rules seems to produce pretty good results.
For the last market close, all listed stocks with…
- 20-day Simple Moving Average of Volume for today is greater than 100000
- 60-day Simple Moving Average of Close for today is greater than 1
- Daily Close for today is greater than Daily Close for yesterday
- Daily Close for today is greater than 5-day Simple Moving Average of Close for today
- 5-day Simple Moving Average of Close for today is greater than 20-day Simple Moving Average of Close for today
- 20-day Simple Moving Average of Close for today is greater than 50-day Simple Moving Average of Close for today
- 5-day Simple Moving Average of Close for 5 days ago is greater than 20-day Simple Moving Average of Close for 5 days ago
- 20-day Simple Moving Average of Close for 5 days ago is greater than 50-day Simple Moving Average of Close for 5 days ago
- 20-day Simple Moving Average of Close for 5 days ago is greater than 20-day Simple Moving Average of Close for 10 days ago
- 50-day Simple Moving Average of Close for 5 days ago is greater than 50-day Simple Moving Average of Close for 10 days ago
- 20-day Simple Moving Average of Close for 10 days ago is greater than 20-day Simple Moving Average of Close for 15 days ago
- 50-day Simple Moving Average of Close for 10 days ago is greater than 50-day Simple Moving Average of Close for 15 days ago
- 50-day Simple Moving Average of Close for 15 days ago is greater than 50-day Simple Moving Average of Close for 20 days ago
When this filter is run against the thousands of stocks and funds listed on the NYSE, NASDAQ and TSE, there are 263 that come up as potentially in a short-term up trend. If you would like to have the entire list, send us an email and we will pass it along to you.
There are certainly other filters that could be devised for the same general purposes, but this one seems to work fairly well by rendering a manageable number of prospects to consider.
One way to use such a list would be to see which stocks on your “shopping list” show up. Another would be to run that reduced list through a fundamental computer screen for the quantitative attributes you seek in a security. And, of course, you could just be looking for securities that are going up for whatever reason.
As with any computer screen, it just narrows the field to those securities that “might”, but may not, be suitable for your purposes. Additional inspection and review is always necessary.
Of the 263 securities that passed the filter as of the market close April 3rd, 8 are funds: CAF, DBB, EWT, EWZ, PTM, SMH, XRT, and XSD.
The 10 highest volume individual stocks are: MS, GLW, TSM, NVDA, PBR, GS, AAPL, TXN, FCX, MRVL.
Some of the charts show the securities pretty much flat, by just barely passing the filter criteria. However, some have impressive short-term upward slopes. Here are three funds and three individual stocks as examples of filter results:






Here is an example of a fund and of an individual stock among the thousands that did not pass the filter. Even though each has participated in the current rally, that has not been enough to cause their moving averages to meet the slope requirements of this particular filter.
Remember that moving averages are lagging indicators, and you must give up some of the early new trend to get moving average confirmation. There are other approaches that could catch a new trend at an earlier stage, but they have a higher rate of false signals. For most investors, catching a good long trend is the best option, and moving averages are generally good enough for that purpose.


We are not suggesting that being in a short-term up trend necessarily makes a security a good investment, or even a continuing good trade. Neither are we suggesting that a stock in a flat or down trend is a bad investment. This article merely illustrates a tool. Whether and how you use it, is entirely up to you.
Summary note - while some stocks have done quite well recently, the vast majority are not yet in an up trend.
Richard Shaw
QVM Group LLC
Last 5 posts by Richard Shaw
- Are negative yield money funds next? - November 19th, 2009
- Old Normal Allocation Becomes New Normal? - November 17th, 2009
- Very Long-Term Asset Allocation Results - November 8th, 2009
- U.S. Healthcare Legislation Investment Impact - November 8th, 2009
- Quality Individual U.S. Companies - November 7th, 2009
![]() About Richard Shaw (http://www.QVMgroup.com)
Richard is a principal of QVM Group LLC, a fee-based investment advisor based in Connecticut with clients across the country. He provides investment coaching to "do-it-yourself" investors, and manages portfolios for those who prefer not to make their own decisions. His investment approach is based on value, asset allocation, benchmarking, expense control, risk management, customizing portfolios to each client's specific circumstances, and regular communication about strategy and performance. The QVM Group team also provides municipal refinance services, strategic business planning and financial analysis service for new ventures, private acquisition analysis, and custom investment research. Richard's extensive experience, includes serving on the Board of Directors of Aberdeen Asset Management PLC (London Stock Exchange: ADN), membership on the Board of Directors of Phoenix Investment Counsel (renamed Virtus Investment Advisors), a U.S. pension manager and investment advisor to the Phoenix Funds (renamed Virtus Funds), as well as serving as Managing Director of a series of offshore investment funds based in Luxembourg. He has led institutional asset management sales and had overall responsibility for management of a U.S. mutual funds broker-dealer. He was a charter investor and member of the Board of Directors of several internet companies, including Lending Tree prior to its IPO. He is a graduate of Dartmouth College. QVM Group LLC is a Registered Investment Advisor. Visit the QVM Group website http://www.qvmgroup.com/QVMinvest/ |



