Simple Moving Average Stock Screener Google Sheet Template

Description
A simple & effective Stock Screener using Google Sheets based on Simple Moving Average: Simple Moving Average Stock Screener Google Sheet Template


Just enter your stocks and see automatically calculated trading signals to buy or sell stocks based on the moving averages for each stock.


Customize multiple Simple Moving Average Periods
Firstly, you’ll have to enter a baseline stock for the exchange you are interested in.
Enter 3 different Simple Moving Average periods to calculate an aggregate SMA rating (Strong Buy, Buy, Sell, Strong Sell)


Add stocks easily
Enter up to 500 stocks in this watch list in the Simple Moving Average Stock Screener Google Sheet Template.
Filter stocks instantly

Use slicer to quickly see stocks to buy or sell.
Choose your timeframe

Change timeframe between daily and weekly.
For each of the stock, you can look at its various attributes like 52 week high or Beta, Change, Change % etc. in the attribute column.



To use this stock screener template, follow the below given simple steps:
1. Enter a baseline stock

To ensure that we obtain the correct holidays in the stock exchange, please enter a stock that belongs to the exchange that you will be interested in tracking.

2. Enter Simple Moving Average (SMA) Periods to track.
The template can handle 3 different SMA periods/lengths.
3. You can also change the timeframe between Daily, Weekly and Monthly.

4. Enter stocks to track in the table

6. View Results
The three SMAs, their Signals and an overall SMA Rating are automatically calculated.