This Excel spreadsheet provides a stock screener that automatically downloads stock quotes for over 6800 ticker symbols. The data is downloaded from finviz.com into the “Data” sheet, and a filter table is automatically created.
All the data for the 6800 ticker symbols is saved in the spreadsheet. This means you only need to update the quotes once a day, or whenever you want updated quotes.
The data includes over 60 items for each ticker symbol, including the P/E Ratio, Dividends, EPS, Sales growth over the last five years, stock beta, 20- and 50-day moving average and much more. There’s a real wealth of data and technical indicators.
If you type in a ticker symbol into the “Parameters” sheet, the spreadsheet will pull out the appropriate stock quotes. More over, the spreadsheet will also give stock quotes for all the companies in the same industry as the ticker symbol.
This lets you quickly see how well (or badly) your chosen company is doing with respect to its industry competitors.
The data download and screening is automated in VBA. Please let me know if you have any comments.