Wrong calculation of avg. per share and total gain pct
Yahoo can't calculate avg. per share and total gain pct right.
In a given portfolio I have bought and sold a given stock several times.
Bought lots are marked with a positive "No. of shares" and sold lots are marked with a negative "No. of shares".
In the given portfolio the "Average per share" and "Total gain pct." are way off.
The Avg. cost per share is listed as -1568 and the "Total gain pct." listed as -142%
The real "Avg. cost per share is however 38 and the total gain is 686%
The right way to calculate cost per share is by adding the costs of each lot (Bought shares * purchase price) and divide with the accumulated number of shares bought.
The right way to calculate the total gain in percent is by this formula:
(Current market price on owned stocks) + (Accumulated gains from sold shares) - (Accumulated costs from buying stocks)
all this must be divided with the accumulated costs from buying stocks