#### shareking

##### Member
I was testing the pivot point method on SBIN for last month. See the amazing result.

#### mew

##### Member
I was testing the pivot point method on SBIN for last month. See the amazing result.
how to calculate pivot res and sup.yesterday high,low,close use for tommorow trading?

#### Taiki

##### Well-Known Member
how to calculate pivot res and sup.yesterday high,low,close use for tommorow trading?
There are different types of pivot points. ex: Floor pivot, Fib. pivot etc.
Lets say
H- Yesterday's high
L - Yesterday's Low
C = Yesterday's Close

Floor pivot formula

Pivot = (H+L+C)/3
Res 1 = 2 * Pivot - L
Res 2 = Pivot + (H-L)
Res 3 = H + (2*(Pivot-L))
Sup 1 = 2 * Pivot - H
Sup 2 = Pivot - (H-L)
Sup 3 = L - (2*(h-Pivot))

Fib Pivot

Pivot = (H+L+C)/3
Res 1 = Pivot + (0.382*(H-L))
Res 2 = Pivot + (0.618*(H-L))
Res 3 = Pivot + (1*(H-L))
Sup 1 = Pivot - (0.382*(H-L))
Sup 2 = Pivot - (0.618*(H-L))
Sup 3 = Pivot - (1*(H-L))

Regards
Taiki

#### mastermind007

##### Well-Known Member
how to calculate pivot res and sup.yesterday high,low,close use for tommorow trading?
Here is Excel Code. Copy both lines a new excel sheet in Cell A1. First 4 columns are OHLC of previous day. rest 9 columns are computations.

Code:
``````O	H	L	C	PP	S1	S2	S3	S4	R1	R2	R3	R4
2081.9	2089	2042.05	2046.75	=(B2+C2+D2)/3	=E2*2-B2	=E2-(B2-C2)	=E2*2-(2*B2-C2)	=E2*3-(B2*3-C2)	=E2*2-C2	=E2+(B2-C2)	=E2*2+B2-2*C2	=E2*3+B2-3*C2``````