Pivot Points


Guy,

Two questions:

1. I find that your Classic numbers for R3/S3 and R4/S4 come up different than a handful of the other Calculators on the internet. Any help explaining why this would be, would be appreciated.

2. I am trying to input your formula's into my own Excell spreadsheet. I am somehow making a mistake typing in your Camarilla formula's. I'm not understanding how to type "C=RANGE*1.1/12" into an Excell spreadsheet. Could you explain that formula? What is "1.1/12", "1.1/6" and "1.1/4" ?

You have done a great thing with you efforts.

Thank you,

Kevin
Hi Kevin,

Yes, R3/S3 and R4/S4 appear to have more than one way to calculate them. As such there is a pivot page which shows a number of these variations for the daily pivots here:
http://www.deltat1.com/DailyNotes/pivotpoints.htm
and also a pivot calculator which allows you to select the formulae that you want to use here:
http://www.deltat1.com/Education/tools/pivot-calculator/index.htm
(If you have cookies enabled then your settings on the pivot calculator are saved the next time you visit the page.)

To use Excel to calculate the pivot values you need to reference the cells with the prices that you are going to use. Say that you have the following set-up in your spreadsheet:
A1: high
B1: low
C1: close

Then you would enter a formula as:
=C1+(A1-B1)*1.1/12

and that should calculate it for you. Remember that RANGE is high-low.

Let me know if that helps.

RE: [url]http://www.deltat1.com/Education/tools/pivot-calculator/index.htm[/url]

Guy,
Camarila is not correctly calculated:
i.e:
O - 500
H - 600
L - 300
C - 400

S1=C-Range*1.1/12
S1=400-300*1.1/12
S1=100*1.1/12=108.3333

At the site the same calculation shows S1=372.50
Is there something wrong with the formula, or the form?

These are the fromulas I found so far:

Camarilla Pivots
R4= C*((H/L)+1)/2)
R3= C*((H/L)+3)/4)
R2= C*((H/L)+5)/6)
R1= C*((H/L)+10)/11)
PP= (H+L+C)/3
S1= C-(R1-C)
S2= C-(R2-C)
S3= C-(R3-C)
S4= C-(R4-C)

You can see that the Range is specifed as H/L
What do you think?

Chrz


Hi Chrz, this is Guy. I have never seen the Camarilla formulae like that before. Where did you get that formula? It's very possible that the formula that you posted is a variation or another version of the Camarilla...
[url]http://ddata.over-blog.com/xxxyyy/0/00/38/66/calculator1.html[/url]

and here is another one

[url]http://www.isc7.com/forex/calcu.php[/url]

you didn't said anything about your formula, could you please check doing a manual calculation and compare it to your form. I am still wondering..
quote:
Originally posted by mkzzz

RE: [url]http://www.deltat1.com/Education/tools/pivot-calculator/index.htm[/url]

Guy,
Camarila is not correctly calculated:
i.e:
O - 500
H - 600
L - 300
C - 400

S1=C-Range*1.1/12
S1=400-300*1.1/12
S1=100*1.1/12=108.3333

At the site the same calculation shows S1=372.50
Is there something wrong with the formula, or the form?


Apologies for not responding to the "incorrectly function formula" part of your post:

S1=C-Range*1.1/12
S1=400-300*1.1/12
S1=100*1.1/12=108.3333

In math, the * takes precedence over the - and so is executed first. The * implies parenthesis:

i.e S1=C-Range*1.1/12
is S1=C-(Range*1.1/12)

So: S1=400-300*1.1/12
is S1=400-(300*1.1/12)

Which gives us:
S1=372.50

Hope that explains that part. I'll get to the rest shortly...
quote:
Originally posted by mkzzz

[url]http://ddata.over-blog.com/xxxyyy/0/00/38/66/calculator1.html[/url]

and here is another one

[url]http://www.isc7.com/forex/calcu.php[/url]



One of your links doesn't list the formula and the other one lists the same formula that I'm using.
Re:[url]http://ddata.over-blog.com/xxxyyy/0/00/38/66/calculator1.html[/url]

Ok sorry. The formulas are not actually listed. I reverse engineered the form and this is what it is:

Floor Pivots
R3= PP+(2*H)-(2*L)
R2= PP-S1+R1
R1= (2*PP)-L)
PP= (H+L+C)/3
S1= 2*(PP)-H)
S2= PP-R1+S1
S3= PP-(2*H)+(2*L)

Camarilla Pivots
R4= ((H/L)+1)/2)*C
R3= ((H/L)+3)/4)*C
R2= ((H/L)+5)/6)*C
R1= ((H/L)+10)/11)*C
PP= (H+L+C)/3
S1= C-(R1-C)
S2= C-(R2-C)
S3= C-(R3-C)
S4= C-(R4-C)

Woodie Pivots
R3= H+(2*PP)-(2*L)
S3= L-(2*H)+(2*PP)
S1= 2*(PP)-H
PP= (H+L+(2*TodaysO))/4
R1= (2*PP)-L
R2= PP-S1+R1
S2= PP-R1+S1

Demark HiLo Projections
R= ((H+L+C+L)/2)-L
S= ((H+L+C+L)/2)-H
In math, the * takes precedence over the - and so is executed first.

The * implies parenthesis:
i.e S1=C-Range*1.1/12
is S1=C-(Range*1.1/12)

So: S1=400-300*1.1/12
is S1=400-(300*1.1/12)

Which gives us:
S1=372.50


I thought the formula uses fractions 1 1/12, not 1.1 divided by 12 :)
Ah... I see where you went wrong.

I wonder where the formula for that calculator came from?
Actually I found one more:

HL5 = (hi/lo)*close
HL4 = ( ((hi/lo)+0.83)/1.83 ) *close
HL3 = ( ((hi/lo)+2.66)/3.66 ) *close
LL3 = close - (HL3-close)
LL4 = close - (HL4-close)
LL5 = close - (HL5-close)

quote:
Originally posted by iso

Hi guys,

In the demark equation, is O = previous open or todays open?

Thanks,

- iso



I believe that it is the previous open.