Birgit Kuester February 25, 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.
This formula shows the value of the shares in that fund. The second column will be offer price, which is what an investor would pay that day to buy more shares. If a fund is no-load, you will see an NL in that column, meaning you would just pay what the NAV is. The last column is the change column. A plus sign here will indicate that the funds value has gone up since the previous day, and a minus sign means that it has declined.
Index Funds Of course for many of us, our primary investment vehicles are index funds. These are funds which are designed to match the performance of a major stock index. This takes the decision making away from a money manager. It also makes deciding on a fund very easy. If I want to match the market, I simply buy the index I want to match and move on with my life. In many ways this is a win-win.
Once you have discovered which index your fund tends to follow it will be obvious on the charts then pick one or two funds that follow the $RUT, one or two that follow the $MID, one or two that follow the EFA foreign funds are usually easy to spot by their names , and finally one or two that follow the NASDAQ.