AIM RE-bal

[karw]

Hi Matt,

Made a spreadsheet similar to your machine. Made a one stock stack(with multiple stocks would have had a tracker share as you described).
Used the portfolio Value and portfolio actual cost in the calculations.

Sell Amount = Value * Sell factor

Buy Amount = Cash * Buy Factor

Buy Factor = (1 - value/actual cost)

Weighted average price per share = WAP

Actual share price = AP

Sell factor = {(value/actual cost - 1) * WAP *WAP } / {AP*AP}

In this way the Buy and Sells are scaled to a similar amount for 4/9 and 9/4.

Please react, K