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

Important

Pivot points enables trader to quickly calculate levels that are likely to cause price movement. Pivot points are short-term trend indicators, useful for one day only,then they need to be recalculated.The success of a pivot-point system, lies only with the trader,with his/her ability to effectively use the pivot-point systems with other forms of technical analysis.

## 11 comments:

this works well, if only we learned to trust TA and not get confused with the mixed signals (noise) that market sends our way!

wat if TA is confused..trust me...

mkt is always right..Analysts everytime wrong...

hehe true!

Nice lucid write-up on Pivots; I'm trying it today GJ. But this ICICIDRECT is not opening. :(

Dear Rajiv - that's a fantastic collection of write-ups on TA. You have put a lot of work into it - I can only bow my head in reverence.

OT

OT dear,

i m happy,u liked formulas...i hope they will work for u too...

happy profits...

You are linked here

thank u OT dear :)

WHT ABT MIDPOINTS HOW IT WORKS CAN U GIVE ME THE FORMULA

This is very nice way to found support and resistance. Does they it working in day trading? I am not raise doubt, but I want to know your opinion. I like to recommand intresting stuff can found on Technical Analysis So one can become independat inday trading rather than fun behind TIPS.

enjoyed reading it. I need to read more on this topic...I admiring time and effort you put in your blog.

pivot point calculator

Post a Comment