What Are The Easiest Ways to Track My Investments?
Some Options to Help You Keep Track of Your Investments
In the years prior to 2009, the best option for the typical investor who wanted to track investments was a software program called Microsoft Money. It allowed average men and women to track their portfolio of stocks, bonds, mutual funds, real estate, cash equivalents, certificates of deposit. It was capable of keeping records on the individual account basis, such as for a specific 401(k) or Roth IRA, as well as the entire household.
It handled dividend reinvestment programs, calculated each position's tax basis, and pulled real-time updates from Internet stock quotes to give you up-to-date information on the state of your fortune.
In the years that have passed since Microsoft announced it was ending the program, several alternatives have become available, some of which are hosted online under the software as a service model while others are programs you can install on your computer. Here are a few of the most popular options that you might want to consider if you want to track your investments.
Tracking Your Investments Online with Software as a Service
The following service providers allow you to log into your account online anywhere in the world as long as you have an Internet connection.
- Client Portals - If you are an affluent or high net worth investor, you probably work with either a financial advisor or an asset management group directly. These days, it is common for them to have online portals for clients that allow the client to track his or her entire financial life, including so-called "held away" assets at different firms. These portals are powerful tools that make life much easier and are often covered by the investment advisory fees you pay your professional.
- Personal Capital - In recent years, Personal Capital has become one of the most popular ways to track investments among those not working with a more traditional Registered Investment Advisor. It currently has more than 1,000,000 people using it, tracking $226 billion in assets. The free software-as-a-service creates beautiful charts and graphs mapping out your income, spending, and portfolio holdings. It can compare your performance to your preferred stock market index. It can analyze your assets to give you an idea of your true exposure to certain companies across multiple accounts and institutions. It digs into your 401(k) plan to help you understand the mutual fund expense ratio you are paying on your retirement package.
- Mint.com - Another very popular investment tracking website, Mint.com allows you to enter your account information from other institutions and have it all aggregated on a single screen. You can then set budgets for yourself, see how much you are spending on specific categories, track the investment fees you are paying, and compare your individual accounts to benchmarks such as the S&P 500 or Dow Jones Industrial Average.
- Morningstar.com - Those who subscribe to Morningstar.com can not only get access to their ratings on stocks and mutual funds but set up online portfolios, as well. When I first wrote this article, it didn't integrate with other sites so you needed to enter all of your information manually from your brokerage statements, but it has a special feature that none of the others offer called X-Ray. This X-Ray tool lets you enter your mutual funds and it then shows you what your actual portfolio holdings are by breaking down the underlying stocks held within each of those funds. For example, if you owned $1,000,000 worth of the Vanguard S&P 500 index fund across your 401(k), Roth IRA, SEP-IRA, and brokerage account, as of the first time I wrote this article back in July of 2009, you really owned $33,400 worth of Apple shares, $24,700 worth of Exxon Mobil shares, $18,800 worth of Microsoft shares, $16,400 worth of Johnson & Johnson shares, $14,600 worth of General Electric shares, $14,300 worth of Chevron shares, $14,200 worth of Wells Fargo shares, et cetera. This is because the index doesn't actually exist, you're buying individual stocks through a pooled structure.
Tracking Your Investments with Spreadsheets
For those who want an added measure of control over their investment tracking, custom spreadsheets are among the best options. There are typically two major choices in this category.
- Microsoft Excel - Though its ability to import real-time stock quotes is woefully inadequate for the average investor, Microsoft Excel can be used to track the cost basis for taxes on individual lots, as well as calculate aggregate dividend income or map it out on a dividend schedule, including warning you about an ex-dividend date.
- Google Spreadsheets - Google's free online spreadsheet program isn't as powerful as Excel, but it does make it easier to have your documents automatically update with information taken from public finance such as Yahoo. In addition, because it's an Internet-based program, you can log into your Google account anywhere in the world to access your Google spreadsheets.
Using Software to Track Your Investments
Many investors still want software installed on their local system (in several instances, the desktop software includes additional features that aren't available through online programs). Generally, there are a few options.
- Quicken - If you purchase the investment version of Quicken, the typical retail investor will largely find that it meets most of his or her needs.
- QuickBooks - Accountants or sophisticated investors who are comfortable with GAAP will like the flexibility of using a traditional accounting software program to manage their investment holdings. Personally, I use a mixture of spreadsheets and QuickBooks Pro to monitor my estate's assets. These days, Intuit is working hard to push everyone to their online based platform, QuickBooks Online, which is available in multiple tiers and at multiple price points.
- Fund Manager - There is a software program called Fund Manager. It's the closest thing to professional investment tracking for retail investors. It can be very powerful, especially for those who invest in municipal bonds or corporate bonds, tracking things such as interest accrued, the next coupon date, and yield to maturity.
Pick the Investment Tracking Program That Works Best for Your Family
In the end, the best investment tracking program is one that works for you. The best program in the world is worthless if you don't use it or you find it too much of a hassle.