9 Free Stock Spreadsheets for Stock Analysis that Others Would Pay For
Stock Spreadsheets for Stock Analysis
Some of the free stock spreadsheets make use of the of the Stock Market Functions Excel Add-in which is available for free.
All spreadsheets are automated, that is, the data is downloaded automatically into the spreadsheet. The add-in is required because it will extract and download data from the internet and load it onto the spreadsheet. This saves you from having to perform manual copy and paste labor.
The downside is that if a website changes their design or layout, the spreadsheet must also be updated to reflect the changes. As websites become more dynamic, the source of free data where you can get publicly available data is also disappearing. Something to keep in mind.
That is why I came out with the stock valuation spreadsheets that connects directly to a professional feed and downloads 10 years of annual and 5 quarterly statements.
How to Download the Stock Spreadsheets
In order to download the excel spreadsheets, you must first sign up with your email and you will receive an email with the list of stock spreadsheets once you have confirmed. By signing up with your email, you will also receive my blog articles via email.
There are a couple of spreadsheets that are based on Google Spreadsheets which you can immediately copy to your account.
A PDF install manual and links to install related videos are included.
Stock Spreadsheets for Valuation and Analysis
The Graham stock spreadsheet uses the formula Graham outlined in his book, The Intelligent Investor, to calculate the intrinsic value of the company.
This spreadsheet is different to the one above. This stock spreadsheet calculates the net net value of a stock which is what the company would be worth if the company liquidated everything in a massive sale.
The Altman Z spreadsheet calculates whether a business is at the risk of going bankrupt.
The Piostroki score is a 9 point scoring system based on the accounting trends of the company.
The Altman, Piotroski and Beneish score make up a nice trio in determining the quality of a company. The Beneish M score looks to see whether a company is manipulating earnings based on the numbers reported in the financial statements.
>> (No Sign Up Required) IPO Analysis Spreadsheet
This is a spreadsheet template of analyzing an IPO.
>> (No Sign Up Required) Competitor Comparison Spreadsheet with Google Docs
A free stock spreadsheet where you can enter multiple tickers and compare side by side. This is a google docs stock spreadsheet. Nothing to install. You just need a google docs account. Follow the instructions in the page to see how you can copy it to your account.
Portfolio Tracking Spreadsheets
>> (No Sign Up Required) The Best Free Stock Portfolio Tracking Spreadsheet
This has got to be the best free portfolio tracking spreadsheet available. It is another google docs spreadsheet and makes tracking portfolio, transactions, performance, dividends and other features so much easier.
Two More Sites with Great Stock Spreadsheets
In addition to what I have provided, here are two sites that feature a truckload of spreadsheet templates.
The majority of the spreadsheets are very complex, but there should be something of interest.
Please Share if You Find this Useful
If you find this useful, please help out Old School Value by sharing this article using the social sharing buttons.
The more you share, the more I know what type of content you really like and I will be able to provide more quality content.