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

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)

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

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.

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,

  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?

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).

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,

    Many thanks for your efforts with this.

I appreciate your pcfs and  explanations.

Don

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

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,

    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

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,

   Wonderful! 

Thank you so much.

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

Don

Bruce,

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

Thank you for your fine work.

Don

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,

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

Don

You're welcome.