A.I.M. Users Bulletin Board

[Qarel]

Hello Grabber, I don't think you have defined the problem precisely enough. You don't need to balance shares, but to balance dollars, and to calculate the difference in shares. From your example

1) bgt 500 shares @ 5.75 - bgt $2875/500/5.75

2) sld 185 shares @ 6.40 - sld $1184/185. $1184=206@5.75; add to PC (206-185)*5.75; unbalanced: bgt $1691/294/5.75 note: the number of shares left unbalanced reflects the $$$ sold, not the number of shares sold!

3) bgt 170 shares @ 5.00 - bgt $850/170/5 + $1691/294/5.75

4) sld 185 shares @ 7.15 - sld $1323/185. $1323=850 (170@5) + 473 (82@5.75); add to PC (170+82-185) shares * [((170*5)+(82*5.75))/(170+82)]; unbalanced: bgt $1219/212/5.75 [between square brackets: average price calculation]

5) bgt 385 sgares @ 5.50 - bgt $2118/385/5.5 + $1219/212/5.75

6) bgt 319 shares @ 4.75 - bgt $1525/319/4.75 + $2118/385/5.5 + $1219/212/5.75

7) sld 233 shares @ 6.26 - sld $1459/233. $1459=307@4.75; add to PC (307-233)*4.75; unbalanced bgt $57/12 + $2118/385/5.5 + $1219/212/5.75

8) sld 771 shares @ 8.00 - Funny boy! sld 6168/771, but there are only 609 shares left unbalanced, for $3394 total. $3394 is 424 shares @ 8, so you add to PC (609-424)*[((12*4.75)+(385*5.50)+(212*5.75))/(609)]; unbalanced: sld $2776/347/8

In step 8, the amount sold straddles three lots bought, with some left over to be balanced against future buys! Do yourself a favor and go for a percentage approximation! Please!! I cry for you when I see this kind of thing.



[e-mail]