Screen & Scan: Your Ultimate Stock Filtering Spreadsheet 📊

Screen & Scan: Your Ultimate Stock Filtering Spreadsheet 📊


Image of the actual spreadsheet

If you're looking for a simple and easy-to-use stock screener or scanner, you've come to the right place! Though they might be called different names, both tools share the same objective: to filter a list of stocks based on one or multiple criteria.

What's the Difference? 🤔

Imagine you have a list of 100 stocks in no particular order and want to find the top 20 based on their trading price. A screener and a scanner will provide you with this list of 20 stocks. However, the scanner will go a step further and rank them for you.

Introducing My Spreadsheet 📈

I made this spreadsheet that can function as both a scanner and a screener. This tool allows you to input your stock database and filter the data based on criteria such as as volume and price. Here’s how you can use it:

  1. Input Your Stock Data: In the “stocks_db” sheet, enter the ticker name or symbol. If the ticker already exists, it will be highlighted with a red background color to avoid duplicates.

  2. View the Report: The second sheet, labeled “report,” contains three sections where stocks are filtered and ranked based on different criteria:

    • The highest 100 stocks based on trading volume 📈.

    • The highest 100 stocks based on trading price 💰.

    • The lowest 100 stocks based on trading price 📉.

Important Reminder 🚨

It's essential to remember that the screener or scanner is not providing buy or sell recommendations. They are simply tools to help you filter and rank stocks based on your chosen parameters.

Side Tip 💡

On a lighter note, you don't commit to the first person who checks any items on your boxes, so treat stock picking with the same caution!

Expanding the Tool 🌐

If you're interested in expanding this tool or using different criteria, you can learn how to fetch current or historical securities information from Google Finance.

I've made this spreadsheet as an alternative to subscription or paid plan options available.

[Grab your copy here]

If you have questions or comments, feel free to email me or leave a comment below.

Comments

Post a Comment

Popular posts from this blog

Calculate Liturgical Dates in Seconds with This Spreadsheet!

Image
Hello! Here is a new spreadsheet designed to help you determine the dates of events in the liturgical calendar. This tool provides the necessary calculations for each event using the Golden Number year.  Image of the actual spreadsheet The spreadsheet includes three sheets: The main sheet is named "Sheet1." Two additional sheets that can be hidden. Demo video Main image How to Use the Spreadsheet Get Your Free Copy :  Use this link to copy the spreadsheet from my Gumroad shop. You will be prompted to make a copy. Enter the Year: On your copy, find cell C2 highlighted in yellow . This is the only cell where you need to enter the year. Automatic Update: Enter the year, and the spreadsheet will automatically update the dates. You can use any year from 1900 to 9998 . For Developers If you are a developer and need data in JSON array format, use this , which generates the data in a read-only API. Feel free to generate as much data as you need, but please do not use the provided...
Read more

Make Holidays Easy: Exploring the US Federal Holidays Year Spreadsheet

Image
  Saving Time with the US Federal Holidays Year Spreadsheet - Here's How! The US Federal Holidays Year Spreadsheet is a tool designed to quickly calculate the dates of federal holidays. Simply input the year in cell C2, and the dates will automatically update. There are 11 federal holidays in the USA. Image of the actual spreadsheet DEMO From Spreadsheet to JSON: Streamlining Federal Holiday Dates for Programmers This spreadsheet is also useful for programmers to generate data in JSON format, functioning like an API. Use the link provided to get the data. Please do not use the link directly in your web or app projects. Image of the actual data This spreadsheet is free for a limited time and can be copied instantly via my Gumroad shop .
Read more