This Excel spreadsheet lets you compare critical financial data for up to 10 stocks. Use this spreadsheet to validate your existing investment strategy or pick out the strongest stocks.
UPDATE: This spreadsheet is now unlocked! Please reference investexcel.net if you adapt or modify this tool.
It automatically retrieves financial data for over 6800 stocks from finviz.com. The data is saved inside the spreadsheet so you only need to download updated data if you want the latest information.
This data includes market capitalization, P/E Ratio, Dividend, Return on Equity, weekly volatilities, gross and operating margins, beta, the average true range and more. There are over 60 key facts for each of the 10 stocks.
The spreadsheet is easy to use. Simply write a ticker symbol into one of the ten cells highlighted in blue (you can’t change anything else). A table will be populated with financial data for each ticker as they’re typed in.
The spreadsheet automatically highlights the most favorible information (such as the lowest P/E ratio, or the highest dividend for each of the ten stocks). This feature lets you quickly locate the most favorable stocks.
The spreadsheet also calculates if the stock is undervalued or overvalued using the technique outlined in this article. Along with the other indicators in the spreadsheet, you use this information to screen for stocks worth investing in.
Please let me know if you have any comments.
This spreadsheet is now unlocked – all protection has been removed.