No registration required! (Why?)

# 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

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.

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:

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

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..

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:

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)

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)

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

R= ((H+L+C+L)/2)-L

S= ((H+L+C+L)/2)-H

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

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?

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)

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.

Copyright © 2004-2017, MyPivots. All rights reserved.