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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » 50 Day EMA of CCI 20

50 Day EMA of CCI 20 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rlschapman
Posted : Wednesday, September 2, 2009 12:22:35 PM
Registered User
Joined: 7/7/2009
Posts: 15
 I have struggled with this during my off time for more than two weeks. I have a lot of syntax, but I am not getting the same results as I do on FSC or visually on TC

I am trying to create a PCF that calculates the 50-day EMA for comparisons.

Formula for CCI 20: **Hopefully correct**
(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)
Back to top
Bruce_L
Posted : Wednesday, September 2, 2009 12:24:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 I can't think of a way to make a Personal Criteria Formula short enough to be practical in the current version of TeleChart. It should be possible to add a Moving Average to a Custom Indicator version of CCI and use Comparison Sorts however.

Comparing indicators using Visual Difference sorts
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
rlschapman
Posted : Thursday, September 3, 2009 2:18:42 AM
Registered User
Joined: 7/7/2009
Posts: 15
 Thank you for the reply.

I suppose I will have to do this outside of Telechart. What is the formula for CCI 20 in Stockfinder? I am completely new to the syntax.

Thank you in advance
Back to top
Bruce_L
Posted : Thursday, September 3, 2009 8:13:04 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 You don't need a formula for CCI20 in in StockFinder. You can add it as an Indicator by selecting Add Indicator | Select... | Commodity Channel Index CCI | OK. You can add a 50-Period Exponential Moving Average by selecting Add Indicator | Select... | Moving Average | OK | Price History | OK and then left-clicking on the Moving Average to bring up the Main tab of its Edit window so you can adjust the settings.

You can display the Values by bringing up the Pointer Mode Data Box (selecting the period key (.) on your keyboard twice) or by Dragging and Dropping the Indicators to the Watchlist and selecting Raw Value.

You can create Rules for an Indicator by right-clicking on the Indicator and selecting Create Rule or compare two Indicators by Dragging and Dropping one Indicator onto the other Indicator.

Quick Start Card
Navigating StockFinder
Chart Basics
WatchList Basics
Rule Basics
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.