Trading Indicators Explained: RSI, MACD, Bollinger Bands and VWAP, with Live Values in Excel
Trading indicators explained: RSI, MACD, Bollinger Bands, VWAP, pivot points, support and resistance, Fibonacci retracements and Heikin Ashi candles, with live indicator values available in Excel.
- 1Technical Indicators: Meaning & Application
Technical indicators are formulas applied to past price and volume. What Bollinger Bands, SMA, EMA, golden and death crosses, MACD, and RSI measure and how traders read them.
- 2RSI: How to Read and Use It
RSI (Relative Strength Index) is a 0 to 100 momentum indicator: above 70 is considered overbought, below 30 oversold. How it is calculated and how traders use it.
- 3MACD Indicator Explained
MACD is the 12-day EMA minus the 26-day EMA, with a 9-day EMA signal line. How to read crossovers, the histogram and divergence, and pull MACD into Excel.
- 4MACD Settings
MACD is the 12-day EMA minus the 26-day EMA, with a 9-day EMA signal line. How to set it up, read crossovers and the histogram, and calculate it in Excel.
- 5Bollinger Bands Trading Strategy
Bollinger Bands are a 20-day moving average with bands two standard deviations above and below it. Learn the squeeze, double bottom, and M top, and how to calculate them in Excel.
- 6Bollinger Band Trading Rules
Bollinger Bands plot a band two standard deviations above and below a 20-day moving average. How to read them, their limits, and how to calculate them in Excel.
- 7VWAP for Options Trades
VWAP Strategy uses the volume weighted average price to identify fair value, time entries, and improve execution in options trading. Learn to calculate VWAP and combine it with options strategies using MarketXLS.
- 8Pivot Point Trading: Strategy Guide with Excel Formulas and Examples (2026)
A pivot point is (prior high + low + close) / 3; support and resistance levels are derived from it. How to calculate standard, Woodie, Camarilla, and Fibonacci pivots in Excel.
- 9Support and Resistance Indicators
Support and resistance are price levels where a move tends to stall or reverse. How to find them, confirm them with volume and candlesticks, and calculate them in Excel.
- 10Fibonacci Trading Strategies
Fibonacci retracement levels (23.6%, 38.2%, 50%, 61.8%) mark where a trending price may pull back before resuming. How to calculate and use them.
- 11Trading Using the Fibonacci Retracement Strategy
Fibonacci retracement marks 23.6%, 38.2%, 50% and 61.8% pullback levels between a swing low and high. How the levels are calculated and how traders use them.
- 12Heikin Ashi Candles
Heikin Ashi candles average price data to smooth noise and make trends easier to read. Learn the formulas and how traders use them for trend direction and reversals.