Skip to content

Importing Data from FinViz Stock Screener to your Google Sheets

FinViz is a very powerful free stock screener available in the market, and different search criteria can be applied to filter the stocks from more than 8000 + stocks in the stock market. Copying across the stocks from FinViz to google sheet is painful task for many, including me. This post provides 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 let’s say “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 All tab on the Filters and apply your desired filters. For this post, we will apply filters so that we will have at least 40 stocks on the list as shown on the following screenshot.

Finviz Stock Screener

Step 3: Import data to Google Sheet

On A2 cell use the IMPORTHTML google sheet function 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 = 13

Finally, the formula should look similar to the following:

=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. 

Google Sheet Allow Access

However, nothing happens the data is not yet visible. I identified this problem during preparing this tutorial that FinViz version 111 (v=111 in the url) doesn’t support this feature, so 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 on the below screenshot:

The stocks from the FinViz Stock Screener to your Google Sheet

As you can notice it has only imported the data from the first page that 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 and copy the URL and insert into the IMPORTHTML function and 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)
FinViz Stock Screener to your Google Sheets page 2

You can then repeat the same steps for further pages.

Step 5: Screener is Updated Regularly

Stock data can change frequently, so this FinViz Stock Screener to your Google Sheets is a dynamic screener, you just need to refresh the spreadsheet to ensure you have the most up-to-date information.

By following these steps, you can create a powerful stock screener in Google Sheets that can help you identify promising investment opportunities.

Check following video for video instructions:

Leave a Reply

Your email address will not be published. Required fields are marked *