| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/2/2011
Posts: 1
|
I need help with correction of the acceleration bands formula below:
David Dunbar] where can I find the acceleration Bands formula (all ready done) or do I have to make my own formula ?
[David Dunbar] Average((high*(1+2*((((high-low)/(high+low)/2))*1000)*.001))),20)
[David Dunbar] with this line I get this error Unmatched Parentheses at position 64:
Help with this problem would be appreciated.
Thank you
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A formula for the Upper 20-Period Width 1 Acceleration Band can be written as:
(H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19))) / 20
A formula for the Lower 20-Period Width 1 Acceleration Band can be written as:
(L * (1 - 4 * (H - L) / (H + L)) + L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19))) / 20
Acceleration Bands
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
Bruce could you provide the formula for Upper and Lower 20-Period Width 0.75
and also Offset formula for 1 bar ago for Upper and Lower 20-Period Width 0.75
Thanks
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
Also i read on another post that you cannot use the moving average on the AC Bands like we do on so many other indicators. will i be able to use the moving average on the Custom PCF?
If not i really need the Offset pcf formula for (1 bar ago, 2 bar ago, 3 bar ago, 4 bar ago, and 5 bar ago) both upper and lower.
I am looking to scan for a break above, then pullback to, and then continue up
Thanks again
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
Disregard 2 previous post, I tested the pcf on your 20 1 period from the June 08, 2011 post and using he moving averages for prior bars works great. So what i need is below
Bruce could you provide the formula for Upper and Lower 20-Period Width 0.75
Bruce could you provide the formula for Upper and Lower 20-Period Width 0.50
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A formula for the Upper 20-Period Width .75 Acceleration Band can be written as:
(H * (1 + 3 * (H - L) / (H + L)) + H1 * (1 + 3 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 3 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 3 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 3 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 3 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 3 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 3 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 3 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 3 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 3 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 3 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 3 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 3 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 3 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 3 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 3 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 3 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 3 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 3 * (H19 - L19) / (H19 + L19))) / 20
A formula for the Lower 20-Period Width .75 Acceleration Band can be written as:
(L * (1 - 3 * (H - L) / (H + L)) + L1 * (1 - 3 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 3 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 3 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 3 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 3 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 3 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 3 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 3 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 3 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 3 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 3 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 3 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 3 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 3 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 3 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 3 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 3 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 3 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 3 * (H19 - L19) / (H19 + L19))) / 20
A formula for the Upper 20-Period Width .5 Acceleration Band can be written as:
(H * (1 + 2 * (H - L) / (H + L)) + H1 * (1 + 2 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 2 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 2 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 2 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 2 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 2 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 2 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 2 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 2 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 2 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 2 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 2 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 2 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 2 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 2 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 2 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 2 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 2 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 2 * (H19 - L19) / (H19 + L19))) / 20
A formula for the Lower 20-Period Width .5 Acceleration Band can be written as:
(L * (1 - 2 * (H - L) / (H + L)) + L1 * (1 - 2 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 2 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 2 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 2 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 2 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 2 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 2 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 2 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 2 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 2 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 2 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 2 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 2 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 2 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 2 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 2 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 2 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 2 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 2 * (H19 - L19) / (H19 + L19))) / 20
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
Thanks
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
QUOTE (Bruce_L) A formula for the Upper 20-Period Width 1 Acceleration Band can be written as:
(H * (1 + 4 * (H - L) / (H + L)) + H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19))) / 20
A formula for the Lower 20-Period Width 1 Acceleration Band can be written as:
(L * (1 - 4 * (H - L) / (H + L)) + L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19))) / 20
Acceleration Bands
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Bruce - Above are your standard 20 1 Formulas
I need each formula (Upper and Lower) for 1 bar ago and 2 bars ago
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A formula for the Upper 20-Period Width 1 Acceleration Band of 1 bar ago can be written as follows.
(H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) + H20 * (1 + 4 * (H20 - L20) / (H20 + L20))) / 20
A formula for the Lower 20-Period Width 1 Acceleration Band of 1 bar ago can be written as follows.
(L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19)) + L20 * (1 - 4 * (H20 - L20) / (H20 + L20))) / 20
A formula for the Upper 20-Period Width 1 Acceleration Band of 2 bars ago can be written as follows.
(H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19)) + H20 * (1 + 4 * (H20 - L20) / (H20 + L20)) + H21 * (1 + 4 * (H21 - L21) / (H21 + L21))) / 20
A formula for the Lower 20-Period Width 1 Acceleration Band of 2 bars ago can be written as follows.
(L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19)) + L20 * (1 - 4 * (H20 - L20) / (H20 + L20)) + L21 * (1 - 4 * (H21 - L21) / (H21 + L21))) / 20
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/23/2013
Posts: 245
|
As always Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |