Indzara - Simple and Effective Templates | Building a Dynamic & Interactive Stock Screener in Excel based on Simple Moving Average @indzara | Uploaded 2 years ago | Updated October 03 2023
Step by step tutorial to build a Stock Screener in Excel based on Simple Moving Average.
Download Stock Screener Excel Template: https://indzara.com/product/simple-moving-average-stock-screener/
Video: https://youtu.be/Nxi_qpuYmhY

Stock Market Templates: https://indzara.com/stock-market-templates/

Build a stock screener to identify stocks with Buy or Sell Signals based on Simple Moving Average indicator.

00:00 Introduction - Scope and Objective of the video
02:48 Step 1 - Calculate starting and ending dates for stock history to be pulled
07:30 How to handle missing dates in StockHistory due to holidays and weekends
15:55 How to include today's price when it is a trading day, while calculating simple moving average
23:32 Step 2 - Pulling stock history for stocks in our watch list
30:15 Step 3 - Calculating Simple Moving Average value for our stocks
35:36 Step 4 - Make the Stock screener dynamic and interactive
Adding more properties or attributes like previous close price, change, change %
37:35 Adding trading strategy signal - Buy or Sell
38:40 How to insert slicers or filter
39:30 How to make the screener dynamic for any simple moving average length or period
44:07 Adding counters to count the number of buy and sell signal stocks
47:02 How to add more stocks to watchlist and accommodate in our calculations
51:49 How to do weekly timeframe or monthly timeframe, instead of daily timeframe
52:34 Make sure that the history pulled in first step is long enough to find the starting and ending dates
54:08 Newer Stocks which do not have enough history
55:15 Stocks should belong to same Time Zone


Requires Microsoft 365 subscription plan to pull live stock market data.

https://indzara.com/stock-market-templates/