Support & Resistance Calculator

Make your own sheet or you use this excel with all the embedded formulas.

Support – Any point where a falling stock price meets enough buyers to arrest the fall.

Resistance – Any point where a rising stock price meets enough sellers to stop the rising stock price.

Formulas to calculate support, resistances & pivot points

Pivot Point = (Previous Session High + Previous Session Low + Previous Session Close)/3

Resistance Level 1 = (2 x Pivot Point) – Previous Session Low

Support Level 1 = (2 x Pivot Point) – Previous High

Resistance Level 2 = (Pivot Point – Support Level 1) + Resistance Level 1

Support Level 2 = Pivot Point – (Resistance Level 1 – Support Level 1)

Resistance Level 3 = (Pivot Point – Support Level 2) + Resistance Level 2

Support Level 3 = Pivot Point – (Resistance Level 2 – Support Level 2)

FOR INTRADAY

Use previous day high, low & closing price.

FOR SWING OR POSITIONAL

Use previous week (swing) & previous month (positional) candle high, low & closing price.

You can always use "Pivot Points Standard" indicator on tradingview to get these values plotted on chart.

Comment below your doubts. I'll make sure to reply to all of them.

*FOR FULL FEATURES USE IT ON GOOGLE SHEETS. JUST COPY THE SHEET FROM EXCEL AND PASTE IT ON GOOGLE SHEETS