Hello,
I have changed image type to save bandwidth and faster access. I have added VIX Coloumn in Nifty Spot table.
Thanks for sharing this excel. I will suggest to include SUPPORT & RESISTANCE Points based on Nifty data.
Pivot (Classic) Calculation:
The rule to calculate the floor (classical) pivot points is as follows:
Pivot (P) = (H + L + C) / 3
Resistance 1 (P1) = (2 * P) - L
Resistance 2 (R2) = P + H - L
Resistance 3 (R3) = H + 2 * (P - L)
Support 1 (S1) = (2 * P) - H
Support 2 (S2) = P - H + L
Support 3 (S3) = L - 2 * (H - P)
(H: high; L: low; C: close; P: pivot)
Above is its calculation.
Would U share its new version.
Sagar