Can you recommend a spreadsheet for tracking my stock purchases?

I started investing in this stock in 1986 and reinvested the dividends until 2014.

Since 1986 this stock has split 3 times. Reading IRS pub 590, I need to allocate the stock dividends to an adjusted cost. I may want to start selling this stock in 2015 and I need to recalculate the adjusted cost of this stock.

Asked by Michael

2 Answers

Log in or sign up with email
By submitting you agree to our Terms of Service
Answered by Kim Miller, CFP®PRO+ in Redmond, WA
Hi -
You can usually obtain information about splits from the company's website - look under "Investor Relations".. Another good source is Yahoo Finance - they have historical information going back as far as you want (usually). Type the stock symbol in the search box on their home page and then click on Historical Prices on the left side. You can then enter the date range you need. The information is downloadable into Excel or other spreadsheet program so you can make sense of it - look for the link at the bottom of the page. The custodian for your shares should also be able to provide the needed information. You will need to know how many shares each dividend purchased and at what share price. Keep in mind that reinvested dividends add to the cost basis of the shares. When you sell, you have several choices about which shares you sell and in what order you sell. If you use the specific identification method you can pick and choose which shares you sell which can help you minimize income taxes. Your custodian can help with this part too. Good luck! | 01.14.15 @ 22:08
Comment
Log in or sign up with email
By submitting you agree to our Terms of Service
$commenter.renderDisplayableName() — {comment} | 12.07.16 @ 10:57
Answered by Pamela J. Horack, , CFP®PRO+ in Lake Wylie, SC
Hi Michael! Kim has great info for you, so definitely use that. There is a web service that can calculate the cost basis for you called Your Old Money. http://www.youroldmoney.com/ . This may be a good resource for you to find the info you are looking for. | 01.16.15 @ 21:08
Comment
Log in or sign up with email
By submitting you agree to our Terms of Service
$commenter.renderDisplayableName() — {comment} | 12.07.16 @ 10:57
Log in or sign up with email
By submitting you agree to our Terms of Service
Free MoneyTips Membership!

Get FREE, full access to MoneyTips.com

Answered by

Kim Miller
Kim Miller, CFP®PRO+ in Redmond, WA