Feature Archives

Buying a Computer

Trends in the computing industry and issues to consider before purchasing a new computer or upgrading your current system.

ETFs

Analyzing, selecting and trading exchange-traded funds

Investor Sentiment

Using investor sentiment to indentify tops and bottoms in the market.

Market Breadth & Timing

Market breadth and momentum indicators to gauge the market's overall direction.

Mutual Fund Screening & Analysis

Screening for and analyzing mutual funds.

Portfolio Management

Constructing a portfolio of investments and the issues involved, including risk management.

Software Reviews

In-depth reviews of some of the most popular investment-related software.

Stock Screening & Analysis

Using quantitative stock screening filters to identify possible investment and analyzing individual stocks.

Stock Valuation

Determining the "true worth" of a company.

Technical Analysis & Charting

Using technical indicators and charts to help time your buy and sell decisions.

Tax Preparation

Using computerized tools and resources to prepare and file your personal income taxes.
Computerized Investing > Fourth Quarter 2011

The Top Portfolio Management Software

PRINT | | | | COMMENTS (23) | A A   Reset

by Joe Lan, CFA

Portfolio management software programs are one of the tools most widely used by individual investors. As an investor’s personal portfolio grows over the years, it often encompasses several investment accounts, including 401(k)s, IRAs, brokerage accounts and savings accounts. Tracking all these accounts accurately is an arduous task, and many investors need help. Luckily, the continuing development of technology has led to increasingly powerful portfolio management software aimed at providing just that.

In this issue’s Comparison, we examine three portfolio management software programs—Quicken Premier 2011, Investment Account Manager Version 2 and Fund Manager 11. These three software programs have each made appearances in our previous Comparison articles. They continue to be updated and improved, and we believe they still represent the best portfolio management software programs for individual investors.

Why Might You Want Software?

The development and expansion of high-speed Internet means that sophisticated tools can now be run from your Web browser. Over the years, Web-based portfolio trackers have become very popular, and there are now significantly more Web-based programs than portfolio tracking software programs. Web-based portfolio trackers offer real-time price updates (usually for a fee) and up-to-the-minute news articles on holdings in your portfolio. The best online portfolio managers can sync directly with your investment accounts, meaning you do not need to enter updates manually. However, while Web-based portfolio trackers are capable tools, software-based portfolio managers still represent a significant upgrade in a majority of areas of functionality.

This comparison is geared toward software-based portfolio management programs (we last compared online portfolio managers in the Fourth Quarter 2010 issue of Computerized Investing, available at www.comput

erizedinvesting.com). Software programs still offer the most powerful performance reporting, and they also offer a better ability to calculate gains and losses. The top software-based portfolio trackers are also able to handle more types of securities and transactions and will almost certainly offer a far greater variety of reports.

Features & Functionality

Most capable portfolio management programs offer similar features. But software is rarely free, so matching your personal needs is a more important issue when choosing software than it is when you are choosing between the free online portfolio trackers.

Our comparison grid on pages 24 and 25 details the features offered by our three top picks.

Costs and Time Commitments

Investing in portfolio management software will inevitably come with certain costs. In addition to monetary costs, you need to consider the time you will spend learning to use the program. What it takes to configure the program, how easy it is to use and how well it can handle your personal needs will eventually become larger factors than the monetary cost of the program.

In order to accurately gauge each program’s (or website’s) strengths and weaknesses, we make an effort to thoroughly use each service. Luckily, two of the three programs we review here offer fully functioning demos, allowing all potential users to try the software for themselves before purchasing (Quicken Premier 2011 does not offer a demo or trial version).

Securities/Assets Handled

The importance of a program’s ability to handle a wealth of different securities cannot be overstated. When you are looking at a program, especially if you have a long investment horizon, consider not only whether it can handle the investments you currently own, but also whether it will be able to track investments that you may likely own in the future.

Programs that specialize in certain areas, such as options, are available, but for the purposes of this comparison our focus is on programs that support the securities that most individual investors own, including stocks, bonds, mutual funds, exchange-traded funds and real estate.

A program’s ability to distinguish between asset types is particularly important, as it ensures that asset allocation and industry reports will be generated correctly.

Transactions Handled

The transactions supported by the program are closely related to the types of securities that the program handles. All of the programs discussed here handle standard transactions such as buying, selling and cash dividends. However, the ability to handle data points such as short sales and return of capital is important, and the programs vary in their functionality.

All of these programs allow you to specify security lot assignments for a transaction. This feature can be useful for tax liability issues and for tracking performance. A lot is the total number of units involved in a given trade. If you reinvest dividends from your mutual funds and stocks, you will find yourself tracking numerous lots over a long period of time. Any solid portfolio management package will automatically match buy and sell lots for different accounting strategies for the purpose of reducing tax exposure. The strategies include first in, first out (FIFO); average cost; and specific lot. Having a program that can handle all three is convenient.

Reports

Reports allow you to analyze your portfolio and investments. The three programs covered here vary in the type and flexibility of reporting they offer. When choosing a program, be sure to check whether the program generates not only the types of reports you want, but also other types of reports you may not currently use in your analysis. These extra reports might enhance your overall evaluation of your portfolio. While you want to be sure that a program provides enough flexibility and functionality to complete your analysis, again, you should consider possible future needs with regard to reporting capabilities.

The comparison grid lists the main report types offered by the top portfolio management programs. The current holdings report lays out the composition of your portfolio. At a minimum, programs will list the securities that are held, along with units, costs and current market value. Most software programs will also provide certain asset allocation and gain/loss data right on the main page. The holdings by lots report breaks down portfolio composition into finer increments, indicating each purchase at a specific date and price. This gives you a detailed history of your transactions and provides guidance for selling.

Tax schedules pertain to the Schedule B and Schedule D IRS forms. Designed for computing interest and dividends received from a portfolio, Schedule B reports allow you to estimate tax debt (or credit) before year-end statements arrive. Tax Schedule D reports compute long- and short-term capital gains and match assets that will yield capital gains with tax liabilities. Ideally, the program should also track foreign taxes withheld on your securities to help ensure that proper credit is accounted for when filling out your taxes. Tax reports are provided for a given tax year, so programs generally include a dialog to select the year to report upon. Tax reports can be tricky and, if your situation is complex, it may be prudent to consult with a tax professional. None of these programs specializes in tax reporting, so their capabilities may be limited depending on your investments and trading behavior.

The projected cash flow report serves as a forecast of the expected portfolio cash income from dividends, interest and bond maturities. This report is especially useful for investors who rely heavily on income-related investments, such as investors in retirement. Bond maturity schedules can assist investors in redeploying capital that is coming due.

Report customization can be content-related (for example, allowing you to choose the time period) or cosmetics-related (for example, allowing you to select column and row headings or even font size).

Portfolio alerts let you know when a security has crossed some predetermined price threshold. Such an alert may highlight a need for investigation that might otherwise go unnoticed.

Performance Reports

A basic part of the portfolio management process is to determine and analyze performance. The comparison grid summarizes each program’s performance reporting capabilities. Performance reports are discussed more fully in the individual program summaries that follow.

A program should provide reports for securities, industries and asset classes; these reports should include performance and asset allocation analysis. Some programs allow for an examination among various asset classes, while others provide industry, section and individual security breakdowns. Reports covering single and multiple portfolios are important in order to fully address the diversified aspects of all your accounts.

All three programs discussed here also offer reports based on between-period returns, which allow you to monitor security performance during a known market environment. The programs store snapshots of your portfolios at various times and provide information on how portfolios perform during different market cycles.

Certain portfolio management programs offer the ability to calculate both a value-weighted (also referred to as a dollar-weighted) internal rate of return (IRR) and a time-weighted rate of return. The IRR tends to be the best gauge because it represents the rate of return earned by your investments. It considers the time when inflows and outflows are made to the portfolio, the amounts of these flows, and the combined impact upon the overall rate of return. The time-weighted return is most often used to analyze the performance of investment decisions made by a money manager. A time-weighted calculation directly ignores the impact of any cash added to or removed from the portfolio. However, inflows and outflows should be considered by individual investors, not only because an individual does have control over them, but also because they are very common in retirement accounts and will have a large impact on the portfolio’s rate of return.

Tax-adjusted return reports generate pretax and aftertax returns, calculating the tax liabilities of your transactions and reporting the impact on the rate of return.

COMPARISON: The Top Portfolio Management Programs
Program Name
Quicken Premier 2011 Investment Account Manager Version 2 Fund Manager 11
Company
Intuit, Inc. Quant IX Software, Inc. Beiley Software, Inc.
Telephone
  800/247-6354 480/705-0129
Website
www.quicken.com  www.investmentaccountmanager.com www.fundmanagersoftware.com
Price
$89.99 for Premier $139/$119 for AAII members $69, personal; $295, professional
Demo Available (Cost) No Yes (30 days free) Yes (free)
Platform (Mac, Windows) Windows Windows Windows
Maximum Portfolios/Securities per Portfolio 1,000+/1,500+ unlimited/unlimited personal, unlimited/500; pro, unlimited/2,000
Maximum Securities/Transactions per Security
1,500+/unlimited unlimited/unlimited unlimited/unlimited
Securities/ 
Assets
Handled
Cash/Stocks/Mutual Funds/ETFs Yes yes Yes
Bonds (Fixed/Variable/Zero/PIK) Yes (fixed/variable/zero) Yes Yes
Annuities No Yes No
Options/Futures/Warrants No Yes (options) Yes (options, futures)
Real Estate/Partnerships No Yes No
User-Defined No Yes Yes
Security 
Classification
Identification (Name/Ticker/CUSIP) Yes (name/ticker) Yes Yes
Account Number/Management Firm Yes Yes Yes
Asset Class (Predefined/User-Defined) Yes (predefined) Yes (predefined) Yes (user-defined)
Industry (SIC Codes/User-Defined) No Yes No
Transactions
Handled
Deposit/Withdrawal; Buy/Sell Yes Yes Yes
Short/Cover Yes Yes No
Margin Yes Yes No
Receive/Deliver Security Yes Yes Yes
Return of Capital Yes Yes Yes
Dividends (Cash/Stock/Splits/Reinvest) Yes Yes Yes
Interest Income Yes Yes Yes
Bond (Discount/Premium/Amortization) Yes Yes (discount/premium) No
Treatment of Fees/Commissions Yes Yes Yes
Security Lot Assignments (Avg. Cost/FIFO/Specific Lot) Yes (FIFO/specific lot) Yes Yes
Automatic Security Lot Assignment Yes (FIFO/specific lot) Yes Yes
Reports
Current Holdings Yes Yes Yes
Holdings by Lots Yes Yes Yes
Tax Schedules (Interest/Dividend/Capital Gains) Yes Yes Yes
Projected Cash Flow Yes Yes No
Customized Reports Yes Yes Yes
Portfolio Alerts Yes Yes Yes
Performance Reports 
Security/Industry/Asset Yes Yes Yes (security, asset)
Portfolio (Single/Multiple) Yes Yes Yes
Holding-Period/Between-Period Returns Yes Yes Yes
Value-Weighted IRR/Time-Weighted Returns Yes (value-weighted) Yes Yes (time-weighted)
Tax-Adjusted Returns Yes No No
Benchmark Comparison Yes Yes Yes (professional version)
Follows GIPS Standards No Yes Yes
Data Support
Data Services Supported Quicken BetterInvesting, StockCentral,Yahoo!,  Internet

  Stock Investor Pro, Manifest Investing  
Imports Brokerage Transactions Yes Yes Yes
Import Formats Supported* OFX, QFX, TurboTax Captools, QIF, QFX, OFX OFX, QFX, QIF, PRN, CSV, TXT
Export Formats Supported* QIF XLS, PDF, TXT, CSV, DOC  ASCII, CSV, QIF
 

Data Support

Portfolio software programs are able to download prices and portfolio values from the Internet. Furthermore, they are usually able to directly download transactions and holdings from brokerage accounts, which is an invaluable time-saving feature; however, users must provide their brokerage login information and account number.

Certain programs also allow for data importing without directly syncing with a brokerage account. This method does not require that users provide brokerage login and account information.

Top Portfolio Management Programs

Quicken Premier 2011

Quicken Premier is one of the most well-known personal finance software programs available. The newest version offered includes some significant changes from the 2009 version, which was out when we last reviewed portfolio management software programs in the Fourth Quarter 2009 issue of Computerized Investing. Keep in mind that Quicken Premier is designed as a comprehensive money management tool. Therefore, the program is proficient at handling investment accounts as well as all sorts of banking accounts, including checking and savings.

Quicken has expanded the number of banks and brokerages it can automatically sync to. According to its website, over 12,000 banks and brokerages can be synced to the accounts list in Quicken. Another useful upgrade is that Quicken now automatically categorizes most expenses after syncing with an online account. Furthermore, portfolio values are updated every 15 minutes.

Creating your account is very simple. The easiest way to create an investment portfolio is to add an account and allow Quicken to sync directly with your brokerage account. The setup wizard will walk you through the process. If you do not wish to provide the necessary account information, you may also use the advanced setup function to enter your transactions manually. If you do choose to allow Quicken to automatically sync with your accounts, all of your transactions will be loaded into each account in your accounts list.

When we tested Quicken Premier, the account syncing went smoothly, and account values and transactions were all correctly updated in Quicken Premier for both our checking and investment accounts. Our checking account synced transactions going back three months, while our brokerage account synced transactions back one year (to when the account was opened). For each sale, you are able to allocate specific lots to sell, and you can track interest, dividends, capital gains, stock splits and commissions.

The program can handle cash, stocks, bonds, mutual funds and exchange-traded funds. Unfortunately, there is no support for real estate investments, annuities or user-defined securities. Asset classes are assigned to each investment, but you can change assignments as you see fit.

Quicken Premier offers the most comprehensive listing of reports among the three portfolio management software programs compared here. Nine separate reports are provided for investments, including capital gains, investing activity, maturity date for fixed income, portfolio value, portfolio cost basis, asset allocation, income, performance and transactions.

While these reports are generally self-explanatory, there are a few worth highlighting. The investing activity report displays your interest, dividends, capital gains and realized gains each quarter, quarter-to-date and year-to-date. The report outlines the general trends in income and capital gains through the year, which can be valuable for investors who occasionally want to change their portfolio’s focus in this regard or who wish to see the income schedule of their portfolio.

Quicken Premier’s report showing the maturity date of fixed-income investments is worth noting. Usually, this type of information is provided by a broker only if you have a full-service account. Having this data at your fingertips allows you reinvest your fixed-income capital when it comes due.

Six reports are also available in the tax section. These reports assist users in determining their capital gains and, for those who use itemized deductions, the program provides a Schedule A. A tax schedule and a tax summary are also provided, outlining your investment transactions and their tax consequences.

As previously stated, Quicken Premier is a personal finance management program and offers functions beyond portfolio management. Reports are also available for banking, spending and comparison purposes. Cash flow summaries and itemized spending reports are very useful. Needless to say, purchasing this software will provide users with access to all the reports offered by Quicken Premier.

Investment Account Manager Version 2

Investment Account Manager is a pure portfolio management program, which is slightly different from Quicken Premier. The program costs $139, but there is a $20 discount for members of AAII (see the Special Offers section under Member Benefits at www.aaii.com for more details on the discount). A free 30-day trial is also available that provides a fully working version of the program.

Creating a portfolio is straight-forward, and the program walks you through the process. You are able to download transaction data directly from a brokerage account. The program allows you to choose the time period of transactions to download. The brokerage account that we tested was opened one year ago, and the program downloaded all the transactions made in the account. During our test, the process of downloading transactions was simple and the data retrieved was accurate. You must provide the program with your broker account number and login information in order for it to download your data. As always, you can also enter your transactions manually.

In addition to stocks, bonds, mutual funds and exchange-traded funds, the program can also handle real estate investments, options and user-defined securities. Furthermore, you can track buys, sells, dividends, short sales, margin transactions, stock splits, reinvestments, interest, commissions, and bond premiums and discounts.

After you create your portfolios (you can populate a portfolio with unlimited holdings), they will be listed on the left-hand side of the page. Clicking on a single portfolio will load all of its relevant data. The current value, unrealized gain and loss, estimated income and last update date are presented at the top-left of the screen, and the year-to-date activity for the portfolio is provided underneath. There are also five separate tabs for data on the portfolio selected. The Portfolio Values tab shows your holdings along with the quantity owned, unit and total cost, market value, and gains and losses. The Income Received tab provides a breakdown of your income-generating investments along with their tax consequences. A listing of the securities sold during the current year is also provided. The Holdings Summary and Allocation Summary tabs provide useful information on your portfolio as a whole, presenting a breakdown of portfolio asset allocation and transaction history. In addition, holdings are all shown as a percent of your total portfolio.

Portfolio values are not automatically updated. To update portfolio values, click on the Update Prices button at the top of the program, which updates figures using Yahoo! Finance.

Numerous reports are also provided by Investment Account Manager. Certain reports are ubiquitous among the top programs, and others are unique and worth noting. Investment Account Manager provides an upside-downside report that can also be charted. The upside-downside ratio is one of BetterInvesting’s classic measures of risk. It measures the ratio of a stock’s upside if things go “right” to its downside if things go “wrong.” In essence, it measures risk against reward, providing an assessment of the risk/reward trade-off for investments in your portfolio. The program also provides a fund diversification characteristics report that shows a comprehensive dissection of each fund a user owns. The report provides asset class composition, stock composition, and sector and company size analyses. A bond maturity schedule is also provided, just as with Quicken Premier. For each report, you can specify the portfolio(s) and date range. For the performance reports, users can calculate value-weighted or time-weighted returns and view performance by asset class, sector and industry. The reports can also be saved in PDF format.

The help section of Investment Account Manager was very useful, covering most areas of the program.

Fund Manager 11

There are three versions of Fund Manager—personal, professional and advisor. The personal version suits the needs of most individual investors, while investors who trade frequently may opt to go with professional. For the most part, the advisor version is for professional investors, such as financial advisors and broker/dealers and is priced accordingly.

The personal version of the program targets individual investors and provides all the features that assist users in managing a personal portfolio, such as retrieving values using the Internet, providing a number of graphs and reports, and listing bond and income schedules. The professional version, targeted for traders, includes technical analysis tools, risk/reward scatter plots and real-time quotes. The advisor version includes a variety of client management features. There are also significant price differences associated with each version. The personal version costs $69, while the professional version is $295 and the advisor version is $1,295. The professional version was tested for this review, and it is the version covered in the remainder of this section.

Fund Manager, like Investment Account Manager, is a pure investment management software program, with no personal finance capabilities. This program is not as intuitive as Investment Account Manager or Quicken Premier, but it offers some great reports and performance tools.

There are a few ways to create a portfolio. Using the New Portfolio Wizard, which can be found in the File drop-down menu, is the easiest method. You have the option of downloading the positions and transactions directly from your brokerage firm by providing your account number and login information. In our test, we were able to download all transactions going back to when the brokerage account was created, one year ago. If you are uncomfortable with this, you may also export your transactions from your brokerage account to a compatible file and then import the transactions into the program. This method does not require users to provide login information and is more convenient than manually inputting all the data (though you can do so if you choose).

Asset types are automatically assigned for important positions and transactions. Users can also manually change the asset type. There are 25 separate asset type choices provided by the program, and users can also specify their own. Make sure that each holding is labeled correctly before using the asset allocation reports.

After importing or manually creating your portfolio, you can choose from a wide variety of graphs to display in the program. Highlight the portfolio you wish to display on the left-hand side of the program before selecting the graph. There are several graphs worth noting. Risk/reward scatter plots can be graphed for each investment, asset type, investment goal, symbol or portfolio. These scatter plots graph the time-weighted return against the standard deviation of monthly returns, enabling users to quickly identify items that are under-performing based on the volatility of the investment. A customizable technical analysis graph is also provided. The graph is divided into a top and a bottom section, and the user defines which technical indicator is displayed in each section. Indicators offered by Fund Manager include moving averages, Bollinger bands, MACD (moving average convergence-divergence) and relative strength index, among others.

Fund Manager offers several reports that are useful to individual investors. Time-weighted returns can be calculated for specified time ranges as well as for individual securities and asset allocations. The distribution summary displays distributions paid for a time period and includes dividends, short- and long-term capital gains and foreign tax distributions. The program also provides a rebalance report that outlines the differences between your asset allocation and a target asset allocation. Bond maturity schedules are also provided.

Since our last portfolio management software article, Fund Manager has undergone two major updates. Notably, the program now works with Windows 7. Also, the risk/reward scatter plots and monthly performance reports are new additions. A complete list of updates can be found at the Fund Manager website.

  Performance Documentation Ease of Use Price Pros Cons
Quicken Premier 2011
www.quicken.com
4 5 5 $89.99 for Windows,
$69.99 for Mac -2007
+ more budget & net
    worth tools & reports
+ Mac version
+ tax-adj. returns & reports
–no free demo
 
 
 
Investment Account Manager
www.investmentaccountmanager.com
5 5 5 $139
($119 AAII members)
+ unlimited portfolios,
    securities & transactions
+ easy to use
+ in-depth report tools
–predefined asset 
  classifications
–no tax-adjusted returns
 
Fund Manager 11
www.fundmanagersoftware.com
4 5 3 $69 personal/
$295 professional
+ customization of
    asset classification
+ great reporting tools
–broker download may not
   be accurate
–no tax-adjusted returns
–no view of all transactions

Conclusion

Overall, each of the three programs reviewed here provides users with excellent tools for tracking their investments. Two of the programs offer trial accounts, and we suggest making use of them. Hands-on experience is the only way to get a feel for a program’s ease of use, as well as the types of reports that it can generate.

While Fund Manager and Investment Account Manager are true portfolio management software programs, Quicken Premier provides additional personal finance capabilities. This added dimension makes Quicken Premier worth considering. Unfortunately, Quicken Premier is the only program out of the three reviewed that does not offer a trial account.


Discussion

Edward from OR posted over 3 years ago:

Like prior software comparative reviews, this is a helpful beginning yet is incomplete and for me software covered lacks critical features.

1) Grid indicates that IAM (v2) calculates both Value-Weighted IRR/Time-Weighted Returns but having downloaded trial and looked at manual it seems to only do Value Weighted. For me being able to evaluate performance on same portfolio using both gives better insight.

2) While all 3 compare performance to Benchmarks, this would be much more meaningful if it simultaneously calculated Sharpe ratio or other measure. If out performance of benchmark is not on a risk adjusted basis (similar to how Hulbert does things)then it really isn't apples to apples and true out performance.

3) Since most of my portfolios are in taxable account, Quicken is the only one that does after tax performance analysis. However while I use Quicken for checking acct. I do not trust it to keep features of portfolio module constant over time and have read elsewhere people's frustrations with using Quicken as portfolio tracker.

Years ago I used Captools and recall that while there was a steep learning curve it did both time and asset weighted rate of return, as well as simultaneously doing it for before and after taxes (with your own personal tax rates entered for ST and LT). Current software seem to lack important features.


Joe from IL posted over 3 years ago:

Hi Edward,

Thanks for your comments.

IAM does in fact perform time-weighted return calculations. Page 385 of the user's manual goes over the definition used. It can be found in the Portfolio Summary Report.

I do agree that Sharpe ratio would be helpful when comparing performance because risk/volatility can be taken into account. Unfortunately, risk/volatility ratios such as Sharpe, Jensen's Alpha and Treynor are beyond the scope of most portfolio management software. We will, however, keep an eye out.

Quicken is better as a money management software. Portfolio tracking is just one of its areas. Captools was, and remains, a great program. Unfortunately, it is no longer being supported for individual investors and was replaced by a program significantly more expensive.


Peter from TN posted over 3 years ago:

It should be noted that the Quicken product for Mac is not Quicken Premier. The grid shows Quicken-2007 for Mac but in fact the current product is Quicken Essentials for Mac which does not do portfolio management. The old product Quicken 2007 did do portfolio management but is no longer offered and will not run on OS-X Lion.


Leon from AZ posted over 3 years ago:

I want my wife to learn Quickin Preimer 2011,
but i have not been able to find any instruction books. Do you know of any?


Edward from OR posted over 3 years ago:

Joe (article author?) thx for comment. I think you missed the point of my original post.

1) The chart of features indicates that IAM calculates both types of rate of return (Asset Weighted, AND Time Weighted); however it only does Asset Weighted even though you, I believe incorrectly indicate that it does Time Weighted. For me, both calculations are helpful insights into the portfolio. Of course most people want to know how their portfolio has been doing and Asset Weighted IRR gives this taking in to consideration asset flows for the portfolio.

2) Time Weighted return ignores inflows and outflows and is typically used to evaluate the performance of a manager who it is assumed has not discretion over when there are inflows and outflows AND therefore should NOT be penalized/rewarded in their performance evaluation due to these changes in assets which might have been on a great/terrible time period for the market. Yet as an individual I am also interested in Time Weighted IRR because for example I wish to compare several of my portfolios each of which follows the advice of a different financial newsletter. Using Time Weighted IRR for this comparison is the best approach. In addition, by comparing the Time Weighted and Asset Weighted IRR for a single portfolio I can get a sense whether my inflows/outflows helped or hindered performance. If I am adding to portfolio periodically, but chose to only purchase non-money market positions when say both 50 and 200 day moving averages are exceeded, then I can evaluate this timing rule.

3) It has been a long while since I looked at the formula for the two calculations, but the Asset weighted IRR is more complicated, and I believe already contains all of the data needed to all for ignoring asset flows and calculating the Time Weighted IRR. If this is so, it surprises me that when I spoke to IAM tech support that they indicated that they only do the Asset Weighted IRR, have no plans to include the other calc, and that it is very rare that any of their customers have asked for that as a feature. Unfortunately based on the chart in this review I wasted a bunch of time down loading, trying, and reading parts of the manual before finding out that for my purposes it is very inadequate. Given that AAII gives Members a discount on IAM (and hence indirectly is endorsing it as a "good" choice I urge AAII to "lobby" for getting both calcs into the program).

4) To AAII, I'd suggest future articles make it somewhat clearer how software rates regarding some of the different goals that a user might have:
a) Track my portfolio quickly and easily with little manual input from my AND calculate its rate of return.

b) Do above and compare performance to a benchmark; c) to a benchmark that I can define e.g. a spliced benchmark using for example 40% SP500 20% MSCI and 40% 5 year treasuries.

d) Do above and calculate the Time Weighted return

e) Do above and calculate return after certain tax assumptions or e) allow me to enter my estimated LT and ST cap gains tax rate as well as state tax rate for CG.

Somewhere in this hierarchy I'd also put calculate the Sharpe ratio. I have assumed that all software will do a good job at supporting one at tax preparation time with Schedule D.

If one is investing in a taxable acct all that you can "live on" is your after tax return. If one's return does not beat an appropriate benchmark (and most people do not so a passive asset allocated index approach makes most sense). Even if one beats a benchmark then the question that Hulbert FInancial Digest raises appropriately is - is the excess return due to taking more risk than the index?

FWIW, for the time being rather than creating my own Excel spreadsheet, the portfolio tracker of Morningstar is fairly good on the features I need.


Peter from TN posted over 3 years ago:

Leon, there are many Quicken books offered for sale at Amazon. I have been using Quicken for many years. I don't remember if I ever had a manual. I think maybe the help and users guide included with the software may have been better in days gone by.


Edward from OR posted over 3 years ago:

In my 2nd post I incorrectly commented on Joe's comment - IAM calculates only a Time Weighted IRR as he reported. Nonetheless, it only does the one type of IRR calc. Unfortunately AAII does not allow one to edit comments. Sorry for any confusion I may have caused, I believe the rest of my comments are accurate.


David from HI posted over 3 years ago:

I agree with Edward that the IRR calculations are of great interest. If there are corrections to be make from the original article, could we get an update? Thanks.


Saul from NY posted over 3 years ago:

Although I don't recall a mention of this in the review, IAM handles options and related transactions very well. As far as I know, this is a feature that is not included in the other two programs reviewed. Option traders should try IAM for this feature alone.


Edward from ON posted over 2 years ago:

Do any of these programs deal with foreign exchange issues? I hold stocks denominated in both $CDN and $US and the ability to handle differenrt currencies woudl be an important consideration.


Ron from ON posted over 2 years ago:

I have the same question as Edward. Can any of the portfolio management programs handle transactions, portfolios and reporting in more than one currency? It should be possible to track transactions and/or portfolios in different currencies and then to automatically convert to a single user-selected currency using FX rates available on the internet and display consolidated reports.


Jeffrey from VT posted over 2 years ago:

I'm back looking at reviews. I use Quicken 2010 and find it's such a pain, so many transactions don't download properly and need manual attention. I've got so many Placeholder Entries that it will take hours to clear them up. Anyone have experience with programs that do the downloads (from Scottrade and Vanguard) more easily?


William from VA posted over 2 years ago:

As noted on Quicken's site, unlike past versions, Mac users cannot use the current version of Quicken Premier for stocks and bonds unless you are running a Windows emulator - a pain. You should correct your table to reflect that.


Brad from Singapore posted over 2 years ago:

It looks like Captools is still the only one offering Multi-Currency Portfolio Management.

Is that correct?

:Brad

.


R Rhodes from TX posted over 2 years ago:

Your own surveys show a dramatic increase in the use of Apple computers. I suggest in the future that Windows or MAc usability be noted right at the top of every comaprison study. It will save the MAc users valuable time.

Bob


Ivan Hipschman from CA posted over 2 years ago:

I have used both FundManager and a version of Investment Account Manager (actually Portfolio Manager 5, a clone of Investment Account Manager which was marketed by BetterInvesting). Having used both, I would like to give my opinion.

I actually find FM easier to use than IAM. It has excellent documentation and help facilities. Both programs have excellent, personal suppport. IAM used email and FM has an online forum. Both responded quickly and helpfully, but the forum format is very helpful in making other users' questions and the responses to them available.

The major feature which makes FM more useful is it's excellent graphic capabilities, which are totally absent from IAM and are not referenced in the review. The graphic capabilities I use include simple plots of investments showing close, high, low and volume for the day and can include dividends if desired; moving averages; allocation pie charts and stack charts, which show the change in allocation over time; overlay, for comparison, of multiple investments with or without dividends; portfolio value; investment or portfolio gain; investment cost - value; investment cost - price, which includes a line showing my break even point for the investment on any date; and a great many more graphs which some may find useful. All the appropriate graphs include symbols which show my purchases, sales and dividends for that security. The professional version, which I do not own, adds more sophisticated technical analysis graphs. It is also helpful that FM allows price data download from multiple sites, which is valuable if Yahoo is down or does not cover the securities you want information on.

FM's reporting capabilities are also superior to IAM and include custom report capabilities using about 200 predefined columns which can be built into a custom report. The professional version, again which I do not own, reportedly allows creation of custom report columns using formulas of your own design.


Mark from AZ posted over 2 years ago:

I am a representative of Fund Manager. A few comments on our product:

1) Fund Manager supports multiple currencies in all versions of the product. You can track investments in up to 25 different currencies. There is a tutorial on this here:

http://www.fundmanagersoftware.com/tutor_currency_video.html

2) Fund Manager supports calculating Sharpe Ratio and many other statistics in the Professional and Advisor versions. See the Custom report.

3) Fund Manager calculates both Time Weighted Returns (TWR) and Return on Investment (ROI) yields. The online documentation has a discussion of each, and the equations used here:

http://www.fundmanagersoftware.com/help/yields.html

4) The review's feature comparison table incorrectly states that Fund Manager doesn't support short positions. It does support short positions. For a FAQ on this topic, see:

http://www.fundmanagersoftware.com/faq_short_positions.php

5) The review also incorrectly states Fund Manager doesn't support bond premiums, discounts and amortization. It does support all these, and the Professional version has an amortization/accretion calculator.

6) The review summary has a note about our broker downloads maybe not being correct? I don't believe this is true, nor is it mentioned in the review of our product.

Thanks,
Mark


Bruce Stowe from WA posted about 1 year ago:

I've used IAM for a number of years - back to it's PRK days. Over the past two years it has become increasingly buggy with frequent crashes, and in one instance randomly doubling my position in a single portfolio. I suspect that by the nature of the errors and time frame the program has not been properly upgraded to Windows 7. Upon query support has told me at various times that the program could not have made the errors; that support does not know why these events happened, or that the problem is Norton. I have now had to remove and re-install IAM three times over the past 18-24 months. FM clearly has more flexability in user defined fields and reports - including IRR/ROI by objective that IAM does not offer. Further the file formats supported by FM for import/export are more useful.
IAM is due for a good dusting and cleaning, and strong upgrade. IAM's current status is such that I would strongly encourage a good look at FM before investing the time and money to properly set-up you portfolios in either program


Kevin Ryan from FL posted about 1 year ago:

After reading all of these posts I'm convinced that the best software is my lot history sheet and macro enabled work books that I have developed in excel. I'd like to invest in something professionally developed but the pros and cons don't add up so I'll wait it out until "there's an app for that"!


Teck from Loading... posted about 1 year ago:

i am a recent reader of the comments - and i need help from any user of IAM on
constructing portfolios as opposed to ex-post portfolio reporting and performance analysis - and
if anyone has used the IAM's data feed from QuoteMedia (any issues)
does IAM do multi currency?


Jason from Hawaii posted 9 months ago:

I found Fund Manager 12.9 to be a very intuitive, powerful investment management program. It has that satisfying feel of wanting the program to do something, and then realizing on the next click, it exceeded your expectations. The discussion board is very help. The most difficult part is understanding and setting up the portfolio structure so it can sync with online sources shared sweep accounts work correctly. It took most of a Saturday to setup the software, consolidate six accounts and load 15 years of history. Time very well spent!


John from CA posted 9 months ago:

I have been using IAM since December, 2013, replacing the AWFUL Quicken Premier which I still use ONLY for downloading data from banks and credit cards.

IAM handles data download fairly well for Schwab and Fidelity. But it requires manual input of new purchases from Vanguard. It clashes when using Trend Micro anti virus, which necessitates my turning the anti virus off BEFORE I can load IAM. Their tech support via phone is great. Will answer your QUESTION briefly.

I subscribe to stockcharts.com for graphs. Basically IAM does what it suppose to do. I use it mainly to find out one of the many Preferred stock I may hold on cost. And it does that very quickly using their program, written in the FoxBsse language (a compiled version of old dBase).

Quicken Premier asked numerous SILLY questions when you download, even asking you whether you want to use average cost or FIFO for a money market fund. Awful software in everyway. This is happens when Intuit has the monopoly. I can say the same on their awful Turbo Tax, gets more bossy (force you to go through interview. extremely rigid on the Form 8949, which is a must for any stock trading.


John Kiang from CA posted 7 months ago:

Re: IAM, Investment Account Manager, the owner of IAM and I have worked together and isolated the bug. Many antivirus program such as the one I used, Trend Micro Platinum will DISALLOW software such as IAM to make changes (giving data info)your PC. After numerous phone calls to Trend Micro, we have finally make IAM exe file AND the FOLDER where IAM files reside as EXCEPTION. I can run IAM with my Trend Micro fully protected without crash.

It now runs almost reliably without crash. On rare occasions with zillions of window internet connections (tabs) open, IAM may crash BUT I have never lost any data.

I use Windows 7 with lots RAMS.


You need to log in as a registered AAII user before commenting.
Create an account

Log In