Simple Moving Average Stock Screener Excel Template
Originally published: 05/09/2022 07:54
Publication number: ELQ-72255-1
View all versions & Certificate
certified

Simple Moving Average Stock Screener Excel Template

A simple & effective Stock Screener using Excel based on Simple Moving Average

Description
Looking for a simple yet effective Stock screener, this Google sheets template is just for you. The Simple Moving Average Stock screener shows the trading signals to either buy or sell stocks.


In few steps you can visualize the trend-following of any stock:
1.  Enter a baseline stock
2. Enter Simple Moving Average (SMA) periods to track: this template can handle three different SMA periods and lengths. 
3. You can also change the time frame (daily/ weekly/ monthly)
4. Enter stocks to trade in the table
5. Refresh to update market data
6. View The results: 
Signal Logic: If SMA > price, then SELL. If SMA < price then BUY.
Rating Logic: Average of 3 SMA Signals; SELL signal is given -1 and BUY signal is given +1 value. 


You can also customize the Conditional formatting rule and we also have a column at the end that you can customize to pull from a list of attributes/properties of the stock.


We hope you find this Excel template useful to effectively analyze selling and buying decisions.
● Do you have any suggestions on how this template can be improved further?



Get In Touch with us & feel free to contact us at any time regarding any queries:
● Contact us for all product or purchase-related queries
● Contact us if any customization is required on our products

This Best Practice includes
1 Excel Template

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...