Creating a Stock Screener on Google Sheets: Step-by-Step Guide

Creating a Stock Screener on Google Sheets

Are you a stock investor looking for up-to-date insights and market information? Create your own Google Sheets stock screener and start making more informed investment decisions! This step-by-step guide will teach you how to set up and use this powerful tool to quickly find stocks that match your criteria. Start using the Google Sheets stock Screener today and take charge of your investments.

What is a stock screener, and why it's important?

A stock screener is a tool that helps you narrow down your search for specific stocks. It is essential when researching companies, as it allows you to quickly identify the stocks that meet your criteria. For example, if you are looking for stocks with a high dividend yield or low P/E ratio, then using a screener can help you find them faster.

At the same time, screening for stocks allows you to compare stocks across many different metrics to decide which ones have the best potential for investment. By comparing companies in the same sector or industry, you can often identify the ones that are best to research further and eventually invest in.

Step-by-step guide to creating a stock screener on Google Sheets

There are different ways to create a custom screener in Google Sheets. In this blog, we will describe the most straightforward way that provides the most powerful functionality. To follow along, you will need the following:

  • A Google account with access to Google Sheets
  • Access to a Wisesheets account
  • An understanding of stock market metrics and financial ratios
  • A stock list to compare and get data for

Step 1: Find the stocks you want to analyze

The first step is to identify the stocks you want to analyze. You can find potential stocks by using a variety of methods, such as screening for specific metrics or doing market research on companies that match your criteria. Once you have identified the list of stocks, add them and their ticker symbols to your Google Sheets spreadsheet.

A good way of doing this is to search on Google companies by industries, for example, "semi-conductor stock list." If you want to analyze international companies, be sure to use the same ticker system as Yahoo Finance for this method to work.

Find stock list

Step 2: Define the metrics and data you would like to analyze

With this method, you can retrieve company financials, price data, and hundreds of key metrics on an annual, quarterly, and TTM basis. You can find all the data supported by clicking here. After browsing through the data, enter the parameter you would like to get as well as the period. LY stands for the latest annual data, LQ is the latest quarterly data, and TTM is the trailing twelve months.

screener stock metrics

After you have the stock list along with the data you would like to access, you are ready to populate the table with data.

Step 3: Get the data for your stock list

Unlike other methods of building custom stock screeners, getting the data is super simple. Using the Wisesheets add-in navigate to the screener function. Once there, simply select the range of tickers and parameters in your spreadsheet. Then click on get data and watch how the data will automatically populate for you.

Screener Excel and Google Sheets

You can continue to add more parameters and stocks to your screener and modify it as you wish. Just remember to adjust the screener's ticker range and parameter range.

Step 3: Refresh the stock data

If you noticed, when you click on get data, automatically, a bucket is created for you that contains the ticker and parameter range of your data. This allows you t simply press the refresh bucket button to get the latest data available for your screener.

refresh data

You may press this button at any time. The only thing to note is that it will only refresh the data if you are on the same tab where you have the stock list and parameters.

Step 3: Add conditional formatting (optional)

With all the data in your screener, you can now use conditional formatting to quickly identify stocks that meet your criteria. To do this, select the cells of the metric/s you want to apply formatting for and then go to "Format" in google sheets and click on conditional formatting.

From here, you can assign a specific color depending on which values you would like to highlight. For example, if you are looking for stocks with a P/E ratio below 20, you may select the cells of your screener's P/E ratio and then enter less than 20.

conditional formatting

This will enable you to quickly identify stocks that meet your criteria and get more insight in a matter of seconds.

Step 3: Apply filters and sort the data (optional)

You can also use filters and sort the data to quickly filter out the results that you are looking for. By clicking on Data in the top menu bar and then choosing filter views, you can apply multiple filters and sorting options. For example, you can filter for stocks with a dividend yield above 3% or sort by P/E Ratio from low to high.

adding data filters

This is great if you want to get an overview of your stock's performance across different metrics.

Tips for creating a powerful stock screener in Google Sheets

  • Try to use conditional formatting to quickly identify stocks that match your criteria.
  • Use filters and sorting options in order to quickly get an overview of your stock performance across different metrics.
  • Remember to refresh your data regularly in order to get the latest information available for your screener.
  • Make sure to use the same ticker system as Yahoo Finance when researching international stocks.

By following these steps, you can easily create a powerful custom stock screener using Google Sheets. Doing so will save you time and improve your trading decisions by quickly identifying stocks that match your criteria and comparing them across different metrics.

Conclusion

Creating a custom stock screener in Google Sheets is an easy and free way of quickly filtering out stocks that meet your criteria. The Wisesheets add-in allows you to quickly retrieve data, apply conditional formatting, filters, and sorting options, and refresh all the data at the click of a button.

By using some simple steps, you can create a powerful custom stock screener with the help of Google Sheets and improve your trading decisions.

Happy investing!

Guillermo Valles

Guillermo Valles

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing deals and learning the ropes.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies. That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Leave a Reply

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

Related Posts