I want help in creating a program like the one in the picture to calculate the lines related to the pivot points

[Akram Hassan]

 

[shamimarita]

Hello Akram Hassan,

To create a program that calculates pivot points and related levels (R1, R2, S1, S2, etc.), you can implement this in Excel using formulas. Here's how you can approach both:

Pivot Point Formula:

Pivot Point (PP)=(High+Low+Close)/3

Resistance Levels:

1. R1=(2×PP)−Low
2. R2=PP+(High−Low)

Support Levels:

1. S1=(2×PP)−High
2. S2=PP−(High−Low)

Add these formulas to the respective cells in Excel.