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
|