12

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.

Chris W. Rea
  • 31,999
  • 17
  • 103
  • 191
KeithB
  • 5,005
  • 24
  • 29

5 Answers5

3

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.

bstpierre
  • 10,034
  • 4
  • 33
  • 65
3

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.

  1. Setup your asset classes and target allocations Setup your asset classes

  2. Get suggestions on how to rebalance Get suggestions on how to rebalance

Edit: Added links to other online calculators

bencode
  • 131
  • 3
2

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 $179/year.

Alex B
  • 17,394
  • 11
  • 58
  • 108
1

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.

http://www.bowgett.com/Resources/Tools/PortfolioRebalancingTool.aspx

Portfolio Re-balancing Tool Screenshot enter image description here

GµårÐïåñ
  • 1,481
  • 4
  • 18
  • 24
A. Petrochuk
  • 11
  • 3
0

I use this one in excel :

http://www.hoadley.net/options/develtoolsoptimize.htm

Regards

Eduardo
  • 1