Tag Archives: spreadsheet

Figuring Out Asset Allocation Across Accounts

Figuring out our desired asset allocation was only the first step – the next was figuring out what trades I needed to make to get that allocation.  Enter Google Spreadsheet – which can pull financial information from Google Finance.  I’ve made it available with somewhat dummy data (The funds we have are accurate, but the number of shares is not), so you too can play with it.  It’s not likely to be immediately useful to you, but you can see it as an example of how we allocated across accounts, and create one for yourself.  The important page is the first one – you just want to categorize your holdings according to the asset classes you’ve defined (which may not be all that easy), then fill in your current amounts.

I used the second sheet for data – I keep track of the number of shares I have, and Google Finance pulls in the current prices and then updates the first sheet.   I have conditional formatting enabled on the second row to show me when my allocation is out of whack by +/- 1%.  If you change your desired allocations, you’ll need to change the conditional formatting – Google won’t let me use a cell as a starting point.

There is no magic linking the first sheet and the data sheet – it’s all manual linking in the formulas.

If you do happen to have more Google Spreadsheet-fu than I do and update it, please let me know so that I can link folks to an updated version.