Volatility, Volume & Price Levels: True Range & ATR, Stochastic Oscillator, VWAP, On-Balance Volume, Pivot Points, Retracement Levels & ATR-Based Stops
Compute the indicators that technical traders talk about, on a fictional instrument. You will build true range and the average true range with smoothing, the stochastic oscillator and its signal line, a cumulative volume-weighted average price, on-balance volume, classic pivot levels, retracement and extension levels between swing points and stop distances based on volatility, then test a simple rule against buy-and-hold, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course builds the volatility, volume and price-level indicators of technical analysis step by step in a spreadsheet, using a fictional share. You compute the true range with MAX and ABS, a 14-day ATR and its smoothed version, and turn ATR into a percentage of price to rank instruments and flag quiet or volatile days. You place each close in its 14-day window as stochastic %K with a %D signal line, build a session VWAP with SUMPRODUCT, add up on-balance volume and check for divergences, derive pivot, support and resistance levels and count touches, and find retracement and extension levels. The capstone sizes trades with ATR-based stops. Illustrative numbers only – not investment advice.
Lessons
- True Range & ATR: Measuring How Far Prices Really Move Pro
- ATR in Context: ATR % of Price, Volatility Ranking & a Regime Flag Pro
- Stochastic Oscillator: %K from the 14-Day Window, %D Signal Line & Zones Pro
- Volume-Weighted Average Price: Cumulative VWAP per Session & Distance from It Pro
- On-Balance Volume: Running Volume Total by Price Direction & Divergence Check Pro
- Pivot Points: Pivot, Support & Resistance Levels and How Often They Are Touched Pro
- Retracement & Extension Levels: Swing High/Low, Fixed Ratios & the Nearest Level Pro
- Capstone: Volatility-Based Stops, Position Size from Fixed Risk & a Rule vs Buy-and-Hold Pro