Brigitte Werfel February 17, 2020 Mutual Fund
Spreadsheets & Formulas I have known plenty of investors who have invested extensive time, money and research into choosing their mutual funds. They have devised their own systems, using complex formulas and spreadsheets to allow them to make the right choice about their mutual funds. Ultimately however, this begs the question: If you have to do all this research, why are you buying mutual funds in the first place? For the amount of time you are spending on your decisions, you could buy individual stocks and not pay a money manager a fee.
Here is what I think you should consider doing. First unless you are a real expert, consider buying Index Funds, as opposed to investing in funds that carry a high load, or sales charge associated with them. If you pay a big commission, you simply have less dollars in the investment to work with. Studies show that for most mutual funds, the commission or load simply is not worth it. Do not let a good or even a great salesman talk you into a load fund, unless you have checked for yourself, that the returns over several different periods of time have been outstanding.
Watch for a solid record of returns, rather than funds showing spurts of great years followed by fits of lousy ones. Compare the funds returns to a relevant benchmark index, (large-cap vs. S&P 500, small-cap to the Russell Index, etc.) Solid funds should not only consistently beat the benchmarks, they should also beat their peers.
Technical analysis removes all emotional and subjective aspects of your decisions. This method can be based on many means of analyzing a funds price performance. You can do it with a spreadsheet if you have lots of time, or with a software program. Programs will tell you what fund is the most likely best performer and also indicate if your current holdings are continuing to grow.