I've been stumped by this because the netted profit doesn't add up to the transaction values so it equals with the total cost in the table below. It's a very simple example with no trading fees.
| Name of Stock | No. bought/sold | No. Remaining | Current Price | Transaction Value | Total Cost | Avg. Cost | P/L |
|---|---|---|---|---|---|---|---|
| EXAMPLE | 100 | 100 | $10 | $1000 | $1000 | $10 | $0 |
| EXAMPLE | -150 | -50 | $12 | -$1800 | -$600 | -$12 | -$200 |
| EXAMPLE | 200 | 150 | $10 | $2000 | $1500 | $10 | $100 |
| TOTAL | $1200 | $1500 | -$100 |
I know that if I do not flip between long/short then this calculation method works fine. What am I missing here?
Leave a Reply