| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/14/2005
Posts: 77
|
(H+L+C-AVGH20-AVGL20-AVGC20)*4000/3/ (ABS(H+L+C-AVGH20-AVGL20-AVGC20)+ABS(H1+L1+C1-AVGH20-AVGL20-AVGC20) +ABS(H2+L2+C2-AVGH20-AVGL20-AVGC20)+ABS(H3+L3+C3-AVGH20-AVGL20-AVGC20) +ABS(H4+L4+C4-AVGH20-AVGL20-AVGC20)+ABS(H5+L5+C5-AVGH20-AVGL20-AVGC20) +ABS(H6+L6+C6-AVGH20-AVGL20-AVGC20)+ABS(H7+L7+C7-AVGH20-AVGL20-AVGC20) +ABS(H8+L8+C8-AVGH20-AVGL20-AVGC20)+ABS(H9+L9+C9-AVGH20-AVGL20-AVGC20) +ABS(H10+L10+C10-AVGH20-AVGL20-AVGC20)+ABS(H11+L11+C11-AVGH20-AVGL20-AVGC20) +ABS(H12+L12+C12-AVGH20-AVGL20-AVGC20)+ABS(H13+L13+C13-AVGH20-AVGL20-AVGC20) +ABS(H14+L14+C14-AVGH20-AVGL20-AVGC20)+ABS(H15+L15+C15-AVGH20-AVGL20-AVGC20) +ABS(H16+L16+C16-AVGH20-AVGL20-AVGC20)+ABS(H17+L17+C17-AVGH20-AVGL20-AVGC20) +ABS(H18+L18+C18-AVGH20-AVGL20-AVGC20)+ABS(H19+L19+C19-AVGH20-AVGL20-AVGC20)+.00001)
i am using this cci(20) formula for my custom indicator.
Qustion 1
can i plot this cci(20) by %, now it display by actual value but i want by % only with +-100 line?
Question 2
is there any way to use it for easy scan but i only want those stock with cci turning from a spike back to about +-100?
thank you
rapheal
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
When you say by percent do you mean the percent change or a stochastic of the CCI?
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (happy1398) can i plot this cci(20) by %, now it display by actual value but i want by % only with +-100 line?
As a percentage of what? The formula already incorporates Lambert's .015 scaling constant which is designed to force most of the values to fall between -100 and +100. You probably want to have Center Zero Line checked in the Custom Indicator.
TeleChart doesn't really have a way of drawing straight lines at -100 and +100 on a Custom Indicator such as this one because the scaling is going to change based on the extreme values and pretty much any other Custom Indicator you add will be drawn on a different scale. The following method draws two lines at -100 and +100 that "deflect" to take in the extremes and force them to the same scale, but I personally did not find the results to be entirely satisfying (and it can really slow things down with a long indicator like this):
Select Chart Template | Add Indicator | Indicator
-Draw Color: Different than the CCI Custom Indicator (white)?
-Draw Style: You may want to dashed or dotted to make it different than the CCI.
-Center Zero Line: Checked
-Plot using price scale: Unchecked
-Smoothing Average: 1
-Indicator Formula: (ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) > 100) * ( - 1) * ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) - (ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) <= 100) * 100
Select Chart Template | Add Indicator | Indicator
-Draw Color: Different than the CCI Custom Indicator (white)?
-Draw Style: You may want to dashed or dotted to make it different than the CCI.
-Center Zero Line: Checked
-Plot using price scale: Unchecked
-Smoothing Average: 1
-Indicator Formula: (ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) > 100) * ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) + (ABS((H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)) <= 100) * 100
Select Chart Template | Add Indicator | Indicator
-Draw Color: Whatever color you want the CCI to be.
-Draw Style: Normal or Wide
-Center Zero Line: Checked
-Plot using price scale: Unchecked
-Smoothing Average: 1
-Indicator Formula: (H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001)
If you want the CCI to be on top of the scale instead of having the scale cover up the CCI, it is important to add it last as in my example. The scale will only display properly if the CCI falls outside the -100 or +100 lines at least once during the displayed period.
QUOTE (happy1398) is there any way to use it for easy scan but i only want those stock with cci turning from a spike back to about +-100?
You might want to create the following in addition to your original formula as Personal Criteria Formulas:
Yesterday's CCI:
(H1 + L1 + C1 - AVGH20.1 - AVGL20.1 - AVGC20.1) * 4000 / 3 / (ABS(H1 + L1 + C1 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H2 + L2 + C2 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H3 + L3 + C3 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H4 + L4 + C4 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H5 + L5 + C5 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H6 + L6 + C6 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H7 + L7 + C7 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H8 + L8 + C8 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H9 + L9 + C9 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H10 + L10 + C10 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H11 + L11 + C11 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H12 + L12 + C12 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H13 + L13 + C13 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H14 + L14 + C14 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H15 + L15 + C15 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H16 + L16 + C16 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H17 + L17 + C17 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H18 + L18 + C18 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H19 + L19 + C19 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H20 + L20 + C20 - AVGH20.1 - AVGL20.1 - AVGC20.1) + .00001)
You can then add both as conditions to an EasyScan and set the Rangefinder to Values you think constitute a "spike" for Yesterday's CCI PCF and to about +-100 for Today's CCI PCF. You will probably want to create a different EasyScan for above +100 and below -100, but you might be able to test for both at the same time by placing ABS() around both formulas when creating the Personal Criteria Formulas.
You may be interested in the following (the first includes examples of Boolean tests for +100/-100 CCI crossovers):
CCI INDICATOR
Using EasyScan to find stocks that meet your own criteria
How to create a Personal Criteria Forumula (PCF)
Plotting Custom Indicators with Examples
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/18/2004
Posts: 15
|
QUOTE (Bruce_L)
As a percentage of what? The formula already incorporates Lambert's .015 scaling constant which is designed to force most of the values to fall between -100 and +100. You probably want to have Center Zero Line checked in the Custom Indicator.
In your reply to Happy you made the above statement. Where is Lambert's scaling factor specified? I can't find it.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It's here:
* 4000 / 3 /
4000 / 3 = 20 (the period) / .015 (Lambert's scaling constant)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/18/2004
Posts: 15
|
QUOTE (Bruce_L) It's here:
* 4000 / 3 /
4000 / 3 = 20 (the period) / .015 (Lambert's scaling constant)
HUH? I do not understand your reply, Please explain furthur and identify where in Happy's formula the .015 is specified.
|
|
Registered User
Joined: 10/18/2004
Posts: 15
|
Bruce,
I think I see your explanation. Now I understans why I see some formulas use the 0.015 constant and others use a number that is 200 times the period divide by 3 (which equates to the constant). Addiional explanation from you may help others uderstand.
Thanks,
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It's a result of combining terms to shorten the formula.
4000 / 3 = 1333.33333333
20 / .015 = 1333.33333333
Multiplying the numerator by twenty or dividing the denominator by twenty is required because the denominator should be an average and not a sum.
.015 is Lambert's factor. Another way to write it is 3 / 200. But since the result is actually divided by .015, the 3 / 200 form would need to be put in parentheses for use in division or inverted for multiplication which results in 200 / 3.
20 * 200 / 3 = 4000 / 3
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |