Advanced Portfolio and basis calculation - errors in calculations or errors in data entry?

[Frank H. Ellenberger]

Hi,

Am Donnerstag 26. März 2009 08:23:10 schrieb Pierre Constantineau:
> ___________________________________________________________________________
>________ 2006-08-03   Purchase    Stock XYZ    Shares 1700  Price 3.31  Buy
> 5627.00 Commissions
>              Buy     51.00
>                                      Cash
>                                                   Sell 5678.00
> ___________________________________________________________________________
>________ 2008-06-20   Add Shares  Stock XYZ   Shares 823   Price 0       Buy
> 823
> ___________________________________________________________________________
>________ 2008-06-21  Purchase      Stock XYZ    Shares 1500  Price 4.11  Buy
> 6165.00 Cash
>                                                   Sell 6165.00
> ___________________________________________________________________________
>________
>
> As far as I know, the above is how I think it should be coded. I only
> have a commission on one transaction and the 823 shares didn't cost me
> anything - they were given to me by my employer as a stock purchase
> incentive...

Also the incentives should have a price. The transaction should be done 
against something like income:wages:incentives instead of cash.


> I obtain the following information from the Advanced Portfolio report:
>
> Shares: 4023
> Basis : 11792.23
> Value: 8026 (current price is 2$)
> Money In 11843
> Money out 0
> Realized Gain (50.77)
> Unrealized Gain (3746.23)
> Total Gain (3797)
> Total return -32.06% (ouch!)
> Brokerage Fees 51

11792.23
-5627.00
-6165.00
________

    0.23 instead of 823[.00]
some typo?

Cheers
Frank