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

CCI Indicator Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Michaelc1507
Posted : Wednesday, February 27, 2019 1:52:22 PM
Registered User
Joined: 12/3/2006
Posts: 278

Morning Bruce - I was wondering if I could use the lower two panes in my Version 7 chart for a 10 day CCI in one pane for the daily and then you build a weekly version of this to go in the lower pane - so I could see both at a glance - instead of clicking back and forth on the daily/weekly???  If this is possible, would you please send me the details for the custom indicators.

 

Thanks - Mike

Bruce_L
Posted : Wednesday, February 27, 2019 2:44:01 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The daily formula is fairly straightforward.

(H + L + C - AVGH10 - AVGL10 - AVGC10) * 2000 / 3 / (ABS(H + L + C - AVGH10 - AVGL10 - AVGC10) + ABS(H1 + L1 + C1 - AVGH10 - AVGL10 - AVGC10) + ABS(H2 + L2 + C2 - AVGH10 - AVGL10 - AVGC10) + ABS(H3 + L3 + C3 - AVGH10 - AVGL10 - AVGC10) + ABS(H4 + L4 + C4 - AVGH10 - AVGL10 - AVGC10) + ABS(H5 + L5 + C5 - AVGH10 - AVGL10 - AVGC10) + ABS(H6 + L6 + C6 - AVGH10 - AVGL10 - AVGC10) + ABS(H7 + L7 + C7 - AVGH10 - AVGL10 - AVGC10) + ABS(H8 + L8 + C8 - AVGH10 - AVGL10 - AVGC10) + ABS(H9 + L9 + C9 - AVGH10 - AVGL10 - AVGC10) + .000001)

But the weekly formula is quite a bit less so.

(10 * (MAXH5 + MINL5 + C) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) * 2000 / 3 / (ABS(10 * (MAXH5 + MINL5 + C) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.5 + MINL5.5 + C5) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.10 + MINL5.10 + C10) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.15 + MINL5.15 + C15) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.20 + MINL5.20 + C20) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.25 + MINL5.25 + C25) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.30 + MINL5.30 + C30) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.35 + MINL5.35 + C35) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.40 + MINL5.40 + C40) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + ABS(10 * (MAXH5.45 + MINL5.45 + C45) - MAXH5 - MAXH5.5 - MAXH5.10 - MAXH5.15 - MAXH5.20 - MAXH5.25 - MAXH5.30 - MAXH5.35 - MAXH5.40 - MAXH5.45 - MINL5 - MINL5.5 - MINL5.10 - MINL5.15 - MINL5.20 - MINL5.25 - MINL5.30 - MINL5.35 - MINL5.40 - MINL5.45 - C - C5 - C10 - C15 - C20 - C25 - C30 - C35 - C40 - C45) + .000001)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Michaelc1507
Posted : Wednesday, February 27, 2019 3:47:29 PM
Registered User
Joined: 12/3/2006
Posts: 278

Thanks Bruce - that was sure speedy - I'm sure it will give me lots to play with!

donv98
Posted : Monday, March 4, 2019 11:41:38 AM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

    Is it possible to do this Daily and Weekly on the same chart for other indicators?

Eg. regular, not Wilder's  RSI 2,     D, 3D, and Weekly on same chart?

 

 

Thank you for any help.

 

Don

donv98
Posted : Monday, March 4, 2019 11:59:51 AM
Registered User
Joined: 7/29/2010
Posts: 417

QUOTE (donv98)

Bruce,

    Is it possible to do this Daily and Weekly on the same chart for other indicators?

Eg. regular, not Wilder's  RSI 2,     D, 3D, and Weekly on same chart?

 

 

Thank you for any help.

 

Don

Bruce, 

    I forgot to mention that I am trying to do this on V19 not V7

So far the CCI 10 example seems to work fine on V19.

Bruce_L
Posted : Monday, March 4, 2019 12:12:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Well the previous example is specifically for v7 and not for v19. It is not that the formula will not work in v19, just that the formula is going to match the rolling 5 trading day "weeks" in TC2000 v7 instead of the calendar weeks in TC2000 v19.

There is not a way to mix the time frame of TC2000 v19 together. What you can do (in some cases and not others) is to match what the value would be for the rolling time frames in TC2000 v7. These v7 indicators for other time frames can be plotted in either v7 or v19, but the values are only going to match what is returned by v7 and not match what is returned in v19.

With that in mind, the basic 2-period non-Wilder's RSI is just:

RSI2

With the 3 day version (matching v7 but not v19) being:

100 * ((C > C3) * (C3 - C) + (C3 > C6) * (C6 - C3)) / (ABS(C - C3) + ABS(C3 - C6) + .00001)

And the weekly version (matching v7 but not v19) being:

100 * ((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5)) / (ABS(C - C5) + ABS(C5 - C10) + .00001)

One thing to note is that all of these indicators where we are plotting rolling multiple day per bar indicators on a daily time frame can look kind of "saw toothy". This is especially true if the periods are short.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donv98
Posted : Monday, March 4, 2019 12:13:43 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

  Is it correct that your example with CCI 10 above plotting both the Daily and weekly on the daily chart will be valid on any chart time frame with the "weekly" CCI 10 plot being for a time frame 5X greater than whatever is being displayed on the chart?

Bruce_L
Posted : Monday, March 4, 2019 12:28:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

That is kind of what they do. The "weekly" formula would match a rolling 5-bar time frame sampled from whatever time frame is being displayed currently.

They work to match rolling v7 values because in most cases we can derive the data for the longer time frames from the available daily data because in for example a weekly time frame the weekly value (before the equals) is the same as the daily value (after the equals).

O = O4
H = MAXH5
L = MINL5
C = C
O1 = O9
H1 = MAXH5.5
L1 = MINL5.5
C1 = C5

We don't have any similar conversions which can be done in v19. In fact, you may just be better off multiplying the period by 5 than in using the formulas designed to match the v7 results. Neither will exactly match the v19 time frames, but multiplying the period by 5 instead of using the v7 formulas will usually provide a smoother indicator with more granulated results with less whipsawing.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donv98
Posted : Monday, March 4, 2019 12:39:00 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

    Many thanks for your efforts with this.

I appreciate your pcfs and  explanations.

 

Don

donv98
Posted : Monday, March 11, 2019 2:11:34 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

  Please create a non-Wilder's RSI 5 indicator for 3 days and Weekly similar to the RSI 2 you did above.

 

Thank you,

Don

Bruce_L
Posted : Monday, March 11, 2019 2:19:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

3-day

100 * ((C > C3) * (C3 - C) + (C3 > C6) * (C6 - C3) + (C6 > C9) * (C9 - C6) + (C9 > C12) * (C12 - C9) + (C12 > C15) * (C15 - C12)) / (ABS(C0 - C3) + ABS(C3 - C6) + ABS(C6 - C9) + ABS(C9 - C12) + ABS(C12 - C15) + .00001)

Weekly

100 * ((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20)) / (ABS(C0 - C5) + ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + .00001)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donv98
Posted : Tuesday, March 12, 2019 10:44:18 AM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

    Many thanks for creating these for RSI 5.

Please create 9 day and 20 day versions if that is possible.

Thank you very much.

Don

 

 

Bruce_L
Posted : Tuesday, March 12, 2019 10:54:04 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

9-day

100 * ((C > C9) * (C9 - C) + (C9 > C18) * (C18 - C9) + (C18 > C27) * (C27 - C18) + (C27 > C36) * (C36 - C27) + (C36 > C45) * (C45 - C36)) / (ABS(C - C9) + ABS(C9 - C18) + ABS(C18 - C27) + ABS(C27 - C36) + ABS(C36 - C45) + .00001)

20-day

100 * ((C > C20) * (C20 - C) + (C20 > C40) * (C40 - C20) + (C40 > C60) * (C60 - C40) + (C60 > C80) * (C80 - C60) + (C80 > C100) * (C100 - C80)) / (ABS(C - C20) + ABS(C20 - C40) + ABS(C40 - C60) + ABS(C60 - C80) + ABS(C80 - C100) + .00001)

I am also including a 21-day version because that is a monthly time frame in TC2000 v7.

100 * ((C > C21) * (C21 - C) + (C21 > C42) * (C42 - C21) + (C42 > C63) * (C63 - C42) + (C63 > C84) * (C84 - C63) + (C84 > C105) * (C105 - C84)) / (ABS(C - C21) + ABS(C21 - C42) + ABS(C42 - C63) + ABS(C63 - C84) + ABS(C84 - C105) + .00001)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donv98
Posted : Tuesday, March 12, 2019 11:00:28 AM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

   Wonderful! 

Thank you so much.

Thank you for including the 21 day version for the monthly.

Don

donv98
Posted : Wednesday, March 13, 2019 1:59:24 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

    Please create a 3 Day version for the CCI 10 similar to your weekly version above.

Thank you for your fine work.

Don

Bruce_L
Posted : Wednesday, March 13, 2019 2:50:39 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following Personal Criteria Formula.

(10 * (MAXH3 + MINL3 + C) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) * 2000 / 3 / ( ABS(10 * (MAXH3 + MINL3 + C) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.3 + MINL3.3 + C3) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.6 + MINL3.6 + C6) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.9 + MINL3.9 + C9) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.12 + MINL3.12 + C12) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.15 + MINL3.15 + C15) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.18 + MINL3.18 + C18) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.21 + MINL3.21 + C21) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.24 + MINL3.24 + C24) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + ABS(10 * (MAXH3.27 + MINL3.27 + C27) - MAXH3 - MAXH3.3 - MAXH3.6 - MAXH3.9 - MAXH3.12 - MAXH3.15 - MAXH3.18 - MAXH3.21 - MAXH3.24 - MAXH3.27 - MINL3 - MINL3.3 - MINL3.6 - MINL3.9 - MINL3.12 - MINL3.15 - MINL3.18 - MINL3.21 - MINL3.24 - MINL3.27 - C - C3 - C6 - C9 - C12 - C15 - C18 - C21 - C24 - C27) + .000001)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donv98
Posted : Thursday, March 14, 2019 12:19:45 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

 

    Many thanks for creating this and  all of your very helpful posts.

Don

Bruce_L
Posted : Thursday, March 14, 2019 1:00:19 PM


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.