Stock Screener Excel Template

Description
Screen the stock signals, and filter stock indicators for a particular stock, based on required values.
All with the ease of using a single excel file. Make analysis-based smart trading decisions quickly.

Choose the stocks you are interested in and screen them based on multiple, commonly used stock market indicators.
Analyse options of buy/sell for the stocks based on parameter values, using the value screener within minutes.

Simple Process
Enter the ticker symbols of different stocks in the signal screener sheet, to run the screener. Immediately view: sell or buy or neutral signals based on live market data for different indicators.

Customize the Indicators:
You can modify the parameters of the indicators anytime. By this way, you can do the analysis as you prefer in the settings sheet.

5 Charts – You can view up to 5 indicators at a time
1. Candlestick Chart: View candles for any specific date range for your favorite stock.
2. Signal Chart: Choose a technical indicator and see the trading signals (Buy/Sell/Neutral).
3. Multiple Indicators Chart: Choose two different indicators to view along with price line.
4. More Charts: You can also view 2 charts with one indicator each.

25 Technical Indicators
The following technical indicators are included in the template.
1. Simple Moving Average
2. Weighted Moving Average
3. Exponential Moving Average
4. EMA Envelope
5. EMA Crossover
6. SMA Crossover
7. Bollinger Bands
8. Donchian Channels
9. Keltner Channels
10. Supertrend Indicator
11. Parabolic SAR
12. Momentum
13. Rate of Change
14. Awesome Oscillator
15. MACD
16. Relative Strength Index
17. Average True Range
18. Williams %R
19. Stochastic
20. On Balance Volume
21. Commodity Channel Index
22. Average Directional Index
23. Ultimate Oscillator
24. Chaikin Money Flow
25. Balance of Power

DISCLAIMER: We do not provide any trading or financial advice. The template uses Excel formulas to calculate the technical indicator values mathematically and applies specific rules or conditions to determine the Buy/Sell signal. 

Requirements:
You can download the template, and open using Microsoft Excel in your computer (PC or Mac). Also works in browser (Excel for Web).
The template performs all the calculations of the indicators, however the stock market history data comes from Microsoft’s service. You will need a Microsoft 365 subscription to get live market data into the template.
If you already have a subscription, you don’t need to purchase anything new. Stock market history data is already included in your Microsoft 365 subscription.