| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/21/2010
Posts: 9
|
I am presently a Gold TC2000 member and I would like to create a column with a scan I created whereas
the CCI(20) is between -75 and above -100 Daily.
Is there a way to create this column since the CCI doesn't give the option of selecting the parameter of "between".
Thanks,
Yvonne
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There isn't a way to create a single WatchList Column based on more than one Condition, but you should be able to use the following Condition Formula instead:
CCI INDICATOR
Indicators, Sorting & Scanning
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) + .000001) + 87.5) <= 12.5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/21/2010
Posts: 9
|
Thanks Bruce,
Appreciate it. 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |