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
At which level do you place a buy for a 1 year term investment?