Registered User Joined: 12/15/2004 Posts: 20
|
Would you have the PCF for a Bollinger Band with a 30 period SMA with 2.5 standard deviation?
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Bruce could probably get that for you but he's on vacation until the 28th. How are you planning to use it? Might be able to get what you need from the indicator on the chart.
|
Registered User Joined: 12/15/2004 Posts: 20
|
I wanted to calculate the % difference between the Upper Band and the last price
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The percent that the Upper Bollinger Band 30,2.50 is above or below price could be written as:
100 * ((AVGC30 + 2.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 29)) / C - 1)
The percent that price is above or below the Upper Bollinger Band 30,2.50 could be written as:
100 * (C / (AVGC30 + 2.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 29)) - 1)
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
-Bruce Personal Criteria Formulas TC2000 Support Articles
|