Use Excel to calculate stock split cost basis

[CalGrizzlyBear]

Does MrExcel have a spreadsheet that shows the calculation of stock split cost basis? If not, do you know of any sites that provide spreadsheet? Thank you.

 

[pbornemeier]

Found this via Google:
http://www.officekb.com/Uwe/Forum.aspx/ms-excel/18133/Excel-Spreadsheet-for-Cost-Basis-of-Stock

 

[CalGrizzlyBear]

Hi Phil,

Thank you for the reply. Yes, I say that web site too before I sent my question to MrExce. The website states, "Look for links in http://www.mvps.org/dmcritchie/excel/stocks.htm
for Sheldon Koepf's downloadable spreadsheets." Doing a 'find on page" returns one hit "Record of stock purchase and sales. txt, download which was presented by Sheldon Koepf" and clicking on that link returned http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=stock+requires+excel+tools which I could not find the txt file. I will e-mail David McRitchie.

Thanks again Phil

 

[pbornemeier]

Some other possibilities here:
http://www.fatpitchfinancials.com/330/excel-financial-data-add-in/
http://www.mathtools.net/Excel/Finance_and_Economics/index.html
http://www.stocktrading.net/2010/09/popular-stock-trading-excel-templates-and-spreadsheets/
http://www.fool.com/workshop/2000/workshop000323.htm
http://www.tetonsoftware.com/