Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Columns Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
yms1
Posted : Friday, December 9, 2011 6:11:46 PM
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
Bruce_L
Posted : Monday, December 12, 2011 8:54:26 AM


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
yms1
Posted : Wednesday, December 14, 2011 12:56:25 AM
Registered User
Joined: 8/21/2010
Posts: 9
Thanks Bruce,
Appreciate it. 
Bruce_L
Posted : Wednesday, December 14, 2011 7:29:16 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.