deleted

[henders]

deleted

[barbaz]

The problem is that it's not clear where that "Funds to transfer" money is coming from. Every time you buy stocks, your total is increasing which changes the target values.

Instead, you should have a "cash" row that shows your available un-invested money and has a target of 0%. Then, when you buy a stock you reduce your cash amount accordingly. This way, the total and the target values remain constant.

[SuperSecretName]

make the cash cell dynamic.

also stocks 5-9 you need to liquidate, so they should have negative numbers in the funds to transfer column.

[barbaz]

Making the cash cell dynamic would not work, because it would let your cash vanish when the stock prices grow.

Also, there is now way the sheet can know what you actually paid for your stocks (including fees etc).

I have inserted a cash row. Target value is now a % of total cash / target %.

Target value must remain percentage of total sum, it's just that the total sum should include cash (and all stock values).

[scojo]

I made a copy and edited it towards what I think you are trying to accomplish

https://docs.google.com/spreadsheets/d/1Qu8EJytI262nnqKMflQjS9ATjAoeRnsZq4UsOmjoI3s/edit?usp=sharing

of course, I could be way off.

[cakie]

I found this thread a couple of weeks ago, and used it to do up my own rebalancing spreadsheet. It's a bit different to the others. I like the fact that it can auto update ETF prices with googlefinance :)

Thought I would share in case anyone finds it useful:

https://docs.google.com/spreadsheets/d/1_TmuvAVE8nnzAqhexihaBz6eIsEaE12mISbfjX8HuX8/edit?usp=sharing

[MDM]

See also
https://www.bogleheads.org/wiki/Using_a_spreadsheet_to_maintain_a_portfolio
https://www.bogleheads.org/wiki/Rebalancing
https://www.bogleheads.org/forum/viewtopic.php?f=1&t=150267