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.
This looks like a great resource. However, when I try to update data, all new comma separated values are placed on first column (A) on Data Tab. Using Excel 2010. Already tried using US formatting for workbook, same result. Any idea?
I discovered that if I update using the buttton “Update Stock Quotes”, data is updated with no problems at all. Errors appear if update is done from Data > Refresh All. Great tool!
I’ve only ever tested the worksheet with “Update Stock Quotes” (never thought about using Data > Refresh All). In fact, I explicitly state in the worksheet that you should use “Update Stock Quotes” to get new data.
Hi Samir,
Is there a way of getting this same data for Australian stocks from Yahoo, for the stock screener for Excel spreadsheet, as FINVIZ only has about 11 AU stocks listed. I would like to get data of all stocks for the following AU indices:
Symbol Name Last Trade Change Related Info
^AORD ALL ORDINARIES
^ATOI S&P/ASX 100
^ATLI S&P/ASX 20
^AXJO S&P/ASX 200
^AXKO S&P/ASX 300
^AFLI S&P/ASX 50
^AXMD S&P/ASX MIDCAP50 4
^AXSO S&P/ASX SMALL ORDINARIES
Is this possible. Any help/comments on this would be greatly appreciated.
Regards,
Ron.
Is it possible to modify the excel to include extra tickers that are currently not part of the excel?
If I could find a web-service providing similar data for the not-present tickers, then yes, I could modify the spreadsheet accordingly.
Samir,
Thank you so much for the great file.
On the “data” tab, is there any way I can insert a custom column within the sheet (EX. VOL/AVG. Daily VOL)? When I attempted to do this it would not drag the value down. It’d be great if you knew a way that I could do this and have the column update when I update the sheet. Let me know your thoughts.
Thank you