Indzara - Simple and Effective Templates | Simple Moving Average Stock Screener Demo - Spreadsheet with Live Market Data @indzara | Uploaded 2 years ago | Updated October 03 2023
Stock Screener in Excel to identify stocks to sell or buy using Simple Moving Average indicator.
Download Stock Screener Excel Template: https://indzara.com/product/simple-moving-average-stock-screener/
Stock Market Templates: https://indzara.com/stock-market-templates/
Chapters
00:00 Introduction to the Simple Moving Average stock screener in Excel
00:39 Setting a baseline stock
01:09 Entering stocks in a watchlist
02:04 Getting latest stock price - requires Microsoft 365 subscription
02:30 Stock Market Data refresh - Settings
03:13 Setting periods or lengths for the 3 Simple Moving Averages
04:10 Setting timeframe to be Daily, Weekly or Monthly
05:25 Trading signals (Buy/Sell) & SMA Rating (Strong Sell, Strong Buy, Buy, Sell, Neutral)
06:45 Custom Attribute column
07:38 Conditional formatting for stock price change %
08:23 Adding more stocks to watchlist
09:20 Slicer to select stocks for Buy or Sell
Stock Screener in Excel to identify stocks to sell or buy using Simple Moving Average indicator.
Download Stock Screener Excel Template: https://indzara.com/product/simple-moving-average-stock-screener/
Stock Market Templates: https://indzara.com/stock-market-templates/
Chapters
00:00 Introduction to the Simple Moving Average stock screener in Excel
00:39 Setting a baseline stock
01:09 Entering stocks in a watchlist
02:04 Getting latest stock price - requires Microsoft 365 subscription
02:30 Stock Market Data refresh - Settings
03:13 Setting periods or lengths for the 3 Simple Moving Averages
04:10 Setting timeframe to be Daily, Weekly or Monthly
05:25 Trading signals (Buy/Sell) & SMA Rating (Strong Sell, Strong Buy, Buy, Sell, Neutral)
06:45 Custom Attribute column
07:38 Conditional formatting for stock price change %
08:23 Adding more stocks to watchlist
09:20 Slicer to select stocks for Buy or Sell