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 enterA = Company Name/dateB = OpenC = HighD = LowE = LTP/close*Volume is not required in calculation of pivotsF = Pivot Number = (High+Close +Low )/3 [u can also include "Open" Value also so it will...