| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 4/29/2009
Posts: 31
|
HIi I have been looking for the real code for the volatility squeeze used in TC. Here is the formula for TC. How do I write this for Stockcharts?
((AVGC20 + 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20))) - (AVGC20 - 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20)))) / AVGC20 <= .06
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It's possible to shorten your TeleChart Personal Criteria Formula considerably:
4 * 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) / 20) / AVGC20 <= .06
To do the same thing in StockFinder, add a Bollinger Bandwidth Indicator to the Charts and then right-click on it and select Create Rule | Less Than Value: .06 | Apply | OK.
Rule Basics
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce Thanks for the information. I was trying to use this in the add rule area so I can scan stocks in the que to see what is going on. How can I apply this formula to the add rule area?
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce
Disreguard I found the answer. Thanks again
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce
I checked the formula and it gives me all the stocks which are inside the BB. The formula the way it is written finds stocks which for the last 20 days, are within .06% of the mean avg price. This formula you gave me gives all the stocks between the bb, not the stocks which have been between the BB for the last 20 days within a 6% stock price.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula in your Wednesday, August 26, 2009 3:19:58 PM ET post and the formula in my Wednesday, August 26, 2009 3:33:48 PM ET post both return True when the Bollinger Bandwidth of a Bollinger Band 20,20 expressed as a percentage of the 20-Period Simple Moving Average is less than 6%. They return identical results.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce When I attempted to duplicate the formula in Stockfinder it listed all the stocks using the information on the bottom of the page. It did not limit the number of stocks found matching the criteria as in the formulas you used. If I attempt to put the formula in the real code indicator, it gives me a syntax error
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce
I ran the Standard and Poors 100 stocks in TC using the information from Aug 25, with the prices current, and it returned 21 of the 100 as canadates for this squeeze. If I run it in Stockfinder, with the perameters of Bollinger Bands limiting to .06, it gives me all the stocks in the Standard and Poors 100. Why the difference?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You can't use TeleChart's Personal Criteria Formulas in StockFinder. The directions given for creating a Rule in StockFinder in my Wednesday, August 26, 2009 3:33:48 PM ET post were:
QUOTE (Bruce_L) To do the same thing in StockFinder, add a Bollinger Bandwidth Indicator to the Charts and then right-click on it and select Create Rule | Less Than Value: .06 | Apply | OK.
Rule Basics
If you want to Scan using the Rule, Drag and Drop it to the Watchlist and select Scan. If you want to Filter by the Rule, Drag and Drop it to the Filter.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce
Thanks for the information. Is there a way to add to the rules some of the conditions of the indicators. What I want to do is in the indicators, and I do not know how to apply that to the current chart. When I attempt to show the net change over 20 days, it gives me an indicator at the bottom of the chart. How can I combine this with a rule to run them together to sort the stocks with both perameters?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You create Rules for other Indicators tho same way we created the Rule for Bollinger Bandwidth, right-click on the Indicator and select Create Rule. You can Drag and Drop Rules onto each other and select Create New Combo Rule to combine multiple Rules. The Rule Basics video referenced above goes into this in more detail.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2009
Posts: 31
|
Bruce
I figured it out
Thanks again
|
|
Registered User
Joined: 4/14/2009
Posts: 1
|
Thank you! I was looking for the same volatility squeeze scan instructions. Tracy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |