Forum Discussion
Need help with formulas calculating cost basis on shares
I'm on to the more complicated version - I have some sells and need to incorporate that into my weighted cost...
Bill
But if you are seeking help, you’d help us (me or one of the other frequent contributors) help you by posting a copy of your workbook. Use OneDrive or equivalent to post, and paste a link here that grants access.
mathetes - First I'm not the best with computers so I hope I get this right...
Data looks like this:
Dashboard (results) looks like this:
Here is a link to the file on Onedrive: Weighted Cost w sell.xlsx
Trying figure out a good way to get the the current weighted cost of a particular stock after I sell some shares. Could be many lots that are used when a stock used dividend reinvestment. I didn't put that is in this table but can if needed.
Any suggestions for doing things better / more efficiently will be appreciated.
Thanks in advance for any help!
What you're doing looks fine, so far as it goes.
So much depends on your goal, how precise you want to be with lots. My main question is whether or not you're doing this in a taxable account, as opposed to an IRA of some kind. If you need to be reporting capital gains to the IRS, that could have implications for how you track sales, whether or not you're able to do FIFO on the shares that are sold, etc. I have no experience with that kind of tracking--I do all my investing in a traditional IRA, so tax consequences are not a factor. I also, frankly, do not do any of the volume of buys and sells on most of the stocks or ETFs I have. Much more long-term-buy-and-hold.
- Thanks Mathetes. Some IRA accounts and some taxable. I've only been doing FIFO so far - easier to work and not spending that much time trying to beat all the angles. I'm selling more now since I've retired, but generally a holder as well. Saving the IRA accounts for last at this point to keep the tax free compounding going. Thanks for looking at it.
