When calculating pivot points, the pivot point itself is the primary Support/resistance.This means the largest price movement is expected to occur at this price.The other support and resistance levels are less influential, but may still generate significant price movements.

To Calculate Pivots in MS Excel:.

Column, values to enter, formulas U have to enter

A = Company Name/date

B = Open

C = High

D = Low

E = LTP/close

*Volume is not required in calculation of pivots

F = Pivot Number = (High+Close +Low )/3 [u can also include "Open" Value also so it will be = (Open+High+Close+Low)/4],so formula is =(C2+D2+E2)/3

normal trading range

G= Resistance 1 = 2*Pivot number-Low,so formula is =(2*F2)-D2

H= Support 1 = 2*Pivot-High ,so formula is =(2*F2)-C2

for volatile trading range:

I= Resistance 2 = Pivot+(Resistance1-Support1),so formula is =F2+(G2-H2)

J= Support 2 = Pivot-(Resistance1-Support1),so formula is =F2-(G2-H2)

for extreme trading range:

K= Resistance 3 = High+2*(Pivot-Low),so formula is =C2+2*(F2-D2)

L= Support 3 = Low-2*(High-Pivot),so formula is =D2-2*(C2-F2)

Target for next trading day

M= Resistance 2,so formula = I1 (previous days Resistance2)

Support for next trading day

O= Support 1,so formula = J1 (previous days Support1)

Tips to use in Intraday-Trade:

for bulls:

if a stock goes above R1 then he can buy above the R1 with stoploss at S1

if a stock falls below S1 (and finds support there),then he can buy above the S1 with stoploss at S2

for bears:

if a stock falls below S1 then he can Short sell with stoploss at R1

if a stock goes above R1 (and finds Resistance there),then he can Short sell with stoploss at R2

Using Pivot Points for Targets

When calculating pivot points, the pivot point itself is the primary Support/resistance.This means the largest price movement is expected to occur at this price.The other support and resistance levels are less influential, but may still generate significant price movements.

To Calculate Pivots in MS Excel:.

Column, values to enter, formulas U have to enter

A = Company Name/date

B = Open

C = High

D = Low

E = LTP/close

*Volume is not required in calculation of pivots

F = Pivot Number = (High+Close +Low )/3 [u can also include "Open" Value also so it will be = (Open+High+Close+Low)/4],so formula is =(C2+D2+E2)/3

normal trading range

G= Resistance 1 = 2*Pivot number-Low,so formula is =(2*F2)-D2

H= Support 1 = 2*Pivot-High ,so formula is =(2*F2)-C2

for volatile trading range:

I= Resistance 2 = Pivot+(Resistance1-Support1),so formula is =F2+(G2-H2)

J= Support 2 = Pivot-(Resistance1-Support1),so formula is =F2-(G2-H2)

for extreme trading range:

K= Resistance 3 = High+2*(Pivot-Low),so formula is =C2+2*(F2-D2)

L= Support 3 = Low-2*(High-Pivot),so formula is =D2-2*(C2-F2)

Target for next trading day

M= Resistance 2,so formula = I1 (previous days Resistance2)

Support for next trading day

O= Support 1,so formula = J1 (previous days Support1)

Tips to use in Intraday-Trade:

for bulls:

if a stock goes above R1 then he can buy above the R1 with stoploss at S1

if a stock falls below S1 (and finds support there),then he can buy above the S1 with stoploss at S2

for bears:

if a stock falls below S1 then he can Short sell with stoploss at R1

if a stock goes above R1 (and finds Resistance there),then he can Short sell with stoploss at R2

To Calculate Pivots in MS Excel:.

Column, values to enter, formulas U have to enter

A = Company Name/date

B = Open

C = High

D = Low

E = LTP/close

*Volume is not required in calculation of pivots

F = Pivot Number = (High+Close +Low )/3 [u can also include "Open" Value also so it will be = (Open+High+Close+Low)/4],so formula is =(C2+D2+E2)/3

normal trading range

G= Resistance 1 = 2*Pivot number-Low,so formula is =(2*F2)-D2

H= Support 1 = 2*Pivot-High ,so formula is =(2*F2)-C2

for volatile trading range:

I= Resistance 2 = Pivot+(Resistance1-Support1),so formula is =F2+(G2-H2)

J= Support 2 = Pivot-(Resistance1-Support1),so formula is =F2-(G2-H2)

for extreme trading range:

K= Resistance 3 = High+2*(Pivot-Low),so formula is =C2+2*(F2-D2)

L= Support 3 = Low-2*(High-Pivot),so formula is =D2-2*(C2-F2)

Target for next trading day

M= Resistance 2,so formula = I1 (previous days Resistance2)

Support for next trading day

O= Support 1,so formula = J1 (previous days Support1)

Tips to use in Intraday-Trade:

for bulls:

if a stock goes above R1 then he can buy above the R1 with stoploss at S1

if a stock falls below S1 (and finds support there),then he can buy above the S1 with stoploss at S2

for bears:

if a stock falls below S1 then he can Short sell with stoploss at R1

if a stock goes above R1 (and finds Resistance there),then he can Short sell with stoploss at R2

Using Pivot Points for Targets

When calculating pivot points, the pivot point itself is the primary Support/resistance.This means the largest price movement is expected to occur at this price.The other support and resistance levels are less influential, but may still generate significant price movements.

To Calculate Pivots in MS Excel:.

Column, values to enter, formulas U have to enter

A = Company Name/date

B = Open

C = High

D = Low

E = LTP/close

*Volume is not required in calculation of pivots

F = Pivot Number = (High+Close +Low )/3 [u can also include "Open" Value also so it will be = (Open+High+Close+Low)/4],so formula is =(C2+D2+E2)/3

normal trading range

G= Resistance 1 = 2*Pivot number-Low,so formula is =(2*F2)-D2

H= Support 1 = 2*Pivot-High ,so formula is =(2*F2)-C2

for volatile trading range:

I= Resistance 2 = Pivot+(Resistance1-Support1),so formula is =F2+(G2-H2)

J= Support 2 = Pivot-(Resistance1-Support1),so formula is =F2-(G2-H2)

for extreme trading range:

K= Resistance 3 = High+2*(Pivot-Low),so formula is =C2+2*(F2-D2)

L= Support 3 = Low-2*(High-Pivot),so formula is =D2-2*(C2-F2)

Target for next trading day

M= Resistance 2,so formula = I1 (previous days Resistance2)

Support for next trading day

O= Support 1,so formula = J1 (previous days Support1)

Tips to use in Intraday-Trade:

for bulls:

if a stock goes above R1 then he can buy above the R1 with stoploss at S1

if a stock falls below S1 (and finds support there),then he can buy above the S1 with stoploss at S2

for bears:

if a stock falls below S1 then he can Short sell with stoploss at R1

if a stock goes above R1 (and finds Resistance there),then he can Short sell with stoploss at R2