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
|
|
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
|
|
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!
|
|
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
|
|
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.
|
|
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
|
|
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?
|
|
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
|
|
Registered User
Joined: 7/29/2010
Posts: 417
|
Bruce,
Many thanks for your efforts with this.
I appreciate your pcfs and explanations.
Don
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User
Joined: 7/29/2010
Posts: 417
|
Bruce,
Many thanks for creating this and all of your very helpful posts.
Don
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |