[HELP] Pivot Point and Fibonacci Calculator

[sunnyillion]

Anybody here knows how to find the formula for the Pivot Point and Fibonacci Calculator from https://www.investing.com/
I would like to create an excel-sheet for my own use using the formula from their online calculator.

Fibonacci Calculator

Code:

https://www.investing.com/tools/fibonacci-calculator

Pivot Point Calculator

Code:

https://www.investing.com/tools/pivot-point-calculator

[v555]

You may wish to look into this, which I got from some course:



Thanks.

[v555]

Also, taken from somewhere:

==============

Standard Pivot Points:

Pivot Point (PP) = (High + Low + Close) / 3
Support 1 (S1) = (2 x PP) - High
Support 2 (S2) = PP - (High - Low)
Resistance 1 (R1) = (2 x PP) - Low
Resistance 2 (R2) = PP + (High - Low)

Fibonacci Pivot Points:

Pivot Point (PP) = (High + Low + Close) / 3
Support 1 (S1) = PP - 0.382 x (High - Low)
Support 2 (S2) = PP - 0.618 x (High - Low)
Resistance 1 (R1) = PP + 0.382 x (High - Low)
Resistance 2 (R2) = PP + 0.618 x (High - Low)

Camarilla Pivot Points:

Pivot Point (PP) = (High + Low + 2 x Close) / 4
Support 1 (S1) = Close - (High - Low) x 1.0833
Support 2 (S2) = Close - (High - Low) x 1.1666
Support 3 (S3) = Close - (High - Low) x 1.25
Support 4 (S4) = Close - (High - Low) x 1.5
Resistance 1 (R1) = Close + (High - Low) x 1.0833
Resistance 2 (R2) = Close + (High - Low) x 1.1666
Resistance 3 (R3) = Close + (High - Low) x 1.25
Resistance 4 (R4) = Close + (High - Low) x 1.5

==============

Fibonacci retracement levels are calculated by identifying the highest point of the trend (peak) and the lowest point of the trend (trough), and then applying the following ratios to the vertical distance between the two points:

23.6% retracement level = vertical distance x 0.236
38.2% retracement level = vertical distance x 0.382
50% retracement level = vertical distance x 0.5
61.8% retracement level = vertical distance x 0.618
78.6% retracement level = vertical distance x 0.786

61.8% extension level = vertical distance x 1.618
100% extension level = vertical distance x 2
161.8% extension level = vertical distance x 2.618
261.8% extension level = vertical distance x 4.236

==============

[sunnyillion]

(05-05-2023 11:43 PM)v555 Wrote:  Also, taken from somewhere:

==============

Standard Pivot Points:

Pivot Point (PP) = (High + Low + Close) / 3
Support 1 (S1) = (2 x PP) - High
Support 2 (S2) = PP - (High - Low)
Resistance 1 (R1) = (2 x PP) - Low
Resistance 2 (R2) = PP + (High - Low)

Fibonacci Pivot Points:

Pivot Point (PP) = (High + Low + Close) / 3
Support 1 (S1) = PP - 0.382 x (High - Low)
Support 2 (S2) = PP - 0.618 x (High - Low)
Resistance 1 (R1) = PP + 0.382 x (High - Low)
Resistance 2 (R2) = PP + 0.618 x (High - Low)

Camarilla Pivot Points:

Pivot Point (PP) = (High + Low + 2 x Close) / 4
Support 1 (S1) = Close - (High - Low) x 1.0833
Support 2 (S2) = Close - (High - Low) x 1.1666
Support 3 (S3) = Close - (High - Low) x 1.25
Support 4 (S4) = Close - (High - Low) x 1.5
Resistance 1 (R1) = Close + (High - Low) x 1.0833
Resistance 2 (R2) = Close + (High - Low) x 1.1666
Resistance 3 (R3) = Close + (High - Low) x 1.25
Resistance 4 (R4) = Close + (High - Low) x 1.5

==============

Fibonacci retracement levels are calculated by identifying the highest point of the trend (peak) and the lowest point of the trend (trough), and then applying the following ratios to the vertical distance between the two points:

23.6% retracement level = vertical distance x 0.236
38.2% retracement level = vertical distance x 0.382
50% retracement level = vertical distance x 0.5
61.8% retracement level = vertical distance x 0.618
78.6% retracement level = vertical distance x 0.786

61.8% extension level = vertical distance x 1.618
100% extension level = vertical distance x 2
161.8% extension level = vertical distance x 2.618
261.8% extension level = vertical distance x 4.236

==============

I just tried the Fibonacci formulas, and only 2 of it matches with the investing.com formula, it seems that I have to trial and error manually to get the exact match.