Then for any sales use a first in first out basis. Second additional purchase (added shares total) = lot #3 That lot number then has a date and a cost associated with it.įirst additional purchase (added shares total) = lot #2 What you have to do is, as suggested already, treat whatever you're left holding after each new share purchase transaction as a new individual lot. Those bought have none and need to be calculated from their purchase date.Īll that matters is what number of shares you're left with after all the transactions and what that amount of shares, and only that amount, has each individually returned. you've already had their profit so don't need to keep accounting for it. It's very complex, remember the shares sold take their total returns with them, ie. Your total profit would then be $320 + $1018.20 = $1338.20 or 75% (note that this profit neglects any brokerage or other fees, as you have not provided any). With the current share price at $6.06 then the profit on these 387 shares would be $2.631 per share or $1018.20 or 77%. Your total profit would then be $320 + $ 607.92 = $927.92 or 47% (note that this profit neglects any brokerage or other fees, as you have not provided any).Įdit due to new info. Then the profit on these 387 shares would be $1.571 per share or $607.92 or 46%. We don't know what the current share price is as you haven't provided it, nor do we know what the company is, so lets say that the current price is $5 (or that you sell the remaining 387 shares for $5 per share). So your remaining shares have a average cost of $3.429 per share ($1,327.08/387). So your profit on those 200 shares is $1.60 per share or $320 or 51%.įrom that you have 110 shares left that cost you $3.15 and 277 shares that cost you $3.54. You have only sold 200 shares for $4.75 from those bought for $3.15. See my post in this thread: How can I calculate a "running" return using XIRR in a spreadsheet? It treats these positions, plus the cash they represent, as a whole portfolio. If you wish to calculate your return over time on the whole series of trades, consider using TWIRR. You can't derive an annualized number for ALL the lots as a group, because there's no common timeframe that they share. For each lot, simply calculate return based on cost and proceeds. This allows you to track each buy/sell pairing. If you then sell the entire position, you'll be closing out all the remaining lots. If you were to then buy a few more shares, create a third lot. The quantities in each are the amount sold, and the amount remaining. But if you sell a partial quantity, you need to create a new lot. If you sell the whole position, then the lot is closed. Each time you open a position, a new lot of shares is created. Treat each position or partial position as a separate LOT.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |