| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/3/2006
Posts: 278
|
Good Morning - I know when you hit the period key you can bring up the price points of your moving averages on the chart - question is, I'd also like the price points of the Bollinger Bands - is this possible?
Thanks - Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It won't display the Bollinger Bands, but since it will display Custom Indicators, it would be possible to display these values by using Custom Indicators to display the Bollinger Bands instead of the Bollinger Band Indicator (the exact setup would depend on your Bollinger Band settings).
Plotting Custom Indicators with Examples
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Thanks Bruce - I'll give this some study!
Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. If you provide your Bollinger Band settings we can help you write the formulas.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Thank you - I'm using 20 and 2 with the 20 sma - I'd like to know the ends of both bands - thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I've provided both BB20,2 and BB20,20 formulas (since I suspect you actually want BB20,20):
Upper Bollinger Band 20,2:
AVGC20 + .2 * 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 - 20 * AVGC20 ^ 2) / 19)
Lower Bollinger Band 20,2:
AVGC20 - .2 * 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 - 20 * AVGC20 ^ 2) / 19)
Upper Bollinger Band 20,20:
AVGC20 + 2 * 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 - 20 * AVGC20 ^ 2) / 19)
Lower Bollinger Band 20,20:
AVGC20 - 2 * 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 - 20 * AVGC20 ^ 2) / 19)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Thanks Sir - you are right!!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Hi Bruce - I plotted the BB's as custom indicators and marked using the price scale in my middle window but when I scroll thru the charts, the prices don't seem to match the bands. Does this have an overlay like the price chart for last price? Am I doing something wrong? Your advice please!
Thanks - Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
They match on my system. Could you provide some examples?
You can add Price to the Middle Pane as a Line by using a Custom Indicator (the formula for the Close would be C). You would need to Plot using Price Scale for this Custom Indicator as well.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Morning Bruce - I must be doing something wrong if your system matches. Please try CPT for this example - my upper band looks to be between 51.12 and 54.54. My lower band is between 47.69 and 44.27 - neither pointing to a specific price. I added C as an indicator also and it's between prices too???
Thanks - Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I don't understand what you are talking about, but if the confusion is simply that you are attempting to get the exact values of the Bollinger Bands, you should Plotting the Custom Indicators in the Top Pane (they don't need to be visible). When they are in the Top Pane, you can select the Period Key (.) on your keyboard twice to bring up the Pointer Mode Data Box (and press it once more to exit Pointer Mode).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Hello again - that's what I am trying to do - get the values of the BB's - I have them plotted in the top pane and when I hit the period key it pulls up the dialog box with the date, o-h-l-c, vol, %change and that's it - no BB's. Am I following your instructions correctly??
Thanks Again - Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It won't display the values of the built in Bollinger Bands Indicator, it will display the values of the Custom Indicator versions of the Bollinger Bands when Plotted in the Top Pane.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/3/2006
Posts: 278
|
Thank you - that did it!!
Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/31/2007
Posts: 10
|
Hi, What would the formula be for a bollinger band setting of 50, 25 upper and lower bands to plot as a custom indicator. Thank you very much
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
21dful,
One way to write the formulas for the Upper and Lower BB50,25 would be:
Upper BB 50,25:
AVGC50 + 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 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2 + C45 ^ 2 + C46 ^ 2 + C47 ^ 2 + C48 ^ 2 + C49 ^ 2 - 50 * AVGC50 ^ 2) / 49)
Lower BB 50,25:
AVGC50 - 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 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2 + C45 ^ 2 + C46 ^ 2 + C47 ^ 2 + C48 ^ 2 + C49 ^ 2 - 50 * AVGC50 ^ 2) / 49)
That said, it is generally easier to just add the Bollinger Band Indicator to the Chart if you want to Plot it in TeleChart. You may wish to review the following:
Plotting Custom Indicators with Examples
Adding, removing and saving indicators to a chart template
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |