Asset allocation software: Application or tool to help me rebalance my investment portfolio?
I'm looking for an application that can help me rebalance my investment portfolio. I'm not looking for something that will suggest percentages for each asset class. I'm looking for something that, given my desired portfolio (% in each class) and current investments, will suggest investments to buy/sell to regain the desired balance. This is complicated by the fact that between myself and my wife, current and past jobs, retirement and taxable accounts, we have about 7 different accounts that need to be considered.
I tried coding something up in Excel, but it made my head hurt. I could try something in a real programming language, but just don't have the time. The stuff I've found seems to either be geared towards investment professionals, or aimed at figuring out what your ideal portfolio should look like.
(5)5 Comments
Sorted by latest first Latest Oldest Best
I use this one in excel :
www.hoadley.net/options/develtoolsoptimize.htm
Regards
Here is another one which does not require any spreadsheets software. It is pretty straight forward just type in your symbols, quantity, allocation. I don't think it works if you have multiple accounts.
www.bowgett.com/Resources/Tools/PortfolioRebalancingTool.aspx
Portfolio Re-balancing Tool Screenshot
Closest thing I know of is the Morningstar Xray report. It's a premium service that will analyze your portfolio and tell you what % you have invested in what categories across all of your accounts. I don't think it will suggest trades to rebalance, but it is the best tool I know of to analyze your current positions in many mutual funds.
Unfortunately, Morningstar Xray is a "premium" feature, price is 9/year.
I've had decent luck with a spreadsheet -- even with a similarly complicated situation like yours. The trick may be that it's just "good enough", I don't try to cover all of the scenarios. I manually categorize each security into the respective asset class, import updated prices from time to time, and then it tells me when one class is too big/small and by how much.
I had the same issue and the calculators I found online weren't easy to understand or use. After starting with a spreadsheet I then created a Rebalancing calculator online. You can evaluate rebalancing by contributing or buying/selling within each asset class. It works offline as well and can save data locally to avoid privacy concerns.
Setup your asset classes and target allocations
Get suggestions on how to rebalance
Edit: Added links to other online calculators
Terms of Use Privacy policy Contact About Cancellation policy © freshhoot.com2025 All Rights reserved.