FinViz is a very powerful free stock screener available in the market. Different search criteria can be applied to filter stocks from more than 8000 stocks in the stock market. Copying across the stocks from FinViz to Google Sheets is a painful task for many, including me. This post provides a step-by-step guide on importing data from FinViz Stock Screener to your Google Sheets that updates automatically.
Step 1: Set Up Your Google Sheet
Login to your Google Sheet using your Google account – https://sheets.google.com/
Open a new Google Sheet and give the name. For This Post, we have named it “FinViz-Screener”
Add a Title for the Screener call it “FinViz Screener Results for my Favourite SCAN” on A1.
Step 2: Screen for Stocks
Go To Free Sock Screener – Free Stock Screener (finviz.com) to Screen for Stocks
Press the All tab on the Filters and apply your desired filters. For this post, we will apply filters. Our goal is to have at least 40 stocks on the list. This is shown in the next screenshot.
Step 3: Import data to Google Sheet
On A2 cell use the IMPORTHTML Google sheet feature to import the data from FinViz Screener.
=IMPORTHTML(url, query, index,locale)
To fulfil the formula above following information, have to be provided:
- url = copy the url of the FinViz screener from the address bar of your browser
- query = "table"
- Index = 13Finally, the formula should look like the next:
=IMPORTHTML("https://finviz.com/screener.ashx?v=111&f=fa_epsqoq_high,fa_estltgrowth_high,fa_sales5years_high,fa_salesqoq_pos&ft=4","table",13)Then Google Sheet asks to allow access to fetch data from external URLs, press Allow Access.
Nonetheless, nothing happens because the data is not yet visible. I identified this problem while preparing this tutorial. FinViz version 111 (v=111 in the link) doesn’t support this feature. You need to change the version to 150. Please change the version and the code should look like the following:
=IMPORTHTML("https://finviz.com/screener.ashx?v=150&f=fa_epsqoq_high,fa_estltgrowth_high,fa_sales5years_high,fa_salesqoq_pos&ft=4","table",13)Now the stocks from the FinViz Stock Screener to your Google Sheets are imported successfully as shown in the below screenshot:
As you can notice, it has imported the data only from the first page. This is 20 out of 54 stocks from the list.
Step 4: Import Multiple pages of filtered FinViz Stock Screener to your Google Sheets
Go to the Next page of the FinViz Screener. Copy the link and insert it into the IMPORTHTML formula. Remember to change the version to 150.
On Cell A23 the formula should look like the following:
=IMPORTHTML("https://finviz.com/screener.ashx?v=150&f=fa_epsqoq_high,fa_estltgrowth_high,fa_sales5years_high,fa_salesqoq_pos&ft=4&r=21","table",13)
You can then repeat the same steps for further pages.
Step 5: Screener is Updated Regularly
Stock data can change often. This FinViz Stock Screener added to your Google Sheets is a dynamic screener. You need to refresh the spreadsheet to make sure you have the most up-to-date information.
Follow these steps to create a powerful stock screener in Google Sheets. It can help you find promising investment opportunities.
Check the next video for video instructions:
Tired of manually adding tickers one by one to your TradingView watchlist? Check out my blog post below to bulk copy scanned stocks to the Tradingview watchlist from the Google sheet.
How do you find the table number?
You have to check the HTML content of the site to find the table number of the site you are planning to import.