Forum Discussion
Need help with formulas calculating cost basis on shares
Hi All Was hoping to get some help in creating a trading log to track my stock purchases over time. I am stuck in not being able to get the formula for calculating my weighted average cost basis ...
Your question is, I would suggest, less of an Excel question than it is an accounting question. So let me refer you to this answer I got via Google.
If you need help with implementing that in Excel, feel free to come back, but come back with a sample (attached to your inquiry) of the spreadsheet you've created to track your " buys, sales, dividends paid, dividends reinvested" in a particular stock.
