| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 91
|
Hi Bruce,I'm looking to create the following. If at the close today the CCI is HIGHER than the close of 3 days ago, then show me those stocks.Ex: Mon, Tues, Wed and Thurs would be today, and the close of 3 days ago would be the close of Tues.I would use CCI 4.Thank you
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Ryan15) Ex: Mon, Tues, Wed and Thurs would be today, and the close of 3 days ago would be the close of Tues.
This quote does not make sense to me. A Personal Criteria Formula for the current 4-Period CCI could be written as:
(H + L + C - AVGH4 - AVGL4 - AVGC4) * 800 / 3 / (ABS(H + L + C - AVGH4 - AVGL4 - AVGC4) + ABS(H1 + L1 + C1 - AVGH4 - AVGL4 - AVGC4) + ABS(H2 + L2 + C2 - AVGH4 - AVGL4 - AVGC4) + ABS(H3 + L3 + C3 - AVGH4 - AVGL4 - AVGC4) + .000001)
Converting this to 1-Bar Ago would produce:
(H1 + L1 + C1 - AVGH4.1 - AVGL4.1 - AVGC4.1) * 800 / 3 / (ABS(H1 + L1 + C1 - AVGH4.1 - AVGL4.1 - AVGC4.1) + ABS(H2 + L2 + C2 - AVGH4.1 - AVGL4.1 - AVGC4.1) + ABS(H3 + L3 + C3 - AVGH4.1 - AVGL4.1 - AVGC4.1) + ABS(H4 + L4 + C4 - AVGH4.1 - AVGL4.1 - AVGC4.1) + .000001)
Converting this to 2-Bars Ago would produce:
(H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) * 800 / 3 / (ABS(H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H3 + L3 + C3 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H4 + L4 + C4 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H5 + L5 + C5 - AVGH4.2 - AVGL4.2 - AVGC4.2) + .000001)
Converting this to 3-Bars Ago would produce:
(H3 + L3 + C3 - AVGH4.3 - AVGL4.3 - AVGC4.3) * 800 / 3 / (ABS(H3 + L3 + C3 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H4 + L4 + C4 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H5 + L5 + C5 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H6 + L6 + C6 - AVGH4.3 - AVGL4.3 - AVGC4.3) + .000001)
So a PCF for the current CCI being higher than the CCI of 3-Bars Ago would be:
(H + L + C - AVGH4 - AVGL4 - AVGC4) * 800 / 3 / (ABS(H + L + C - AVGH4 - AVGL4 - AVGC4) + ABS(H1 + L1 + C1 - AVGH4 - AVGL4 - AVGC4) + ABS(H2 + L2 + C2 - AVGH4 - AVGL4 - AVGC4) + ABS(H3 + L3 + C3 - AVGH4 - AVGL4 - AVGC4) + .000001) > (H3 + L3 + C3 - AVGH4.3 - AVGL4.3 - AVGC4.3) * 800 / 3 / (ABS(H3 + L3 + C3 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H4 + L4 + C4 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H5 + L5 + C5 - AVGH4.3 - AVGL4.3 - AVGC4.3) + ABS(H6 + L6 + C6 - AVGH4.3 - AVGL4.3 - AVGC4.3) + .000001)
If you actually mean the current CCI being higher than the CCI of 2-Bars Ago as a comparison of Thursday being greater than Tuesday would suggest, then you would want to try the following instead:
(H + L + C - AVGH4 - AVGL4 - AVGC4) * 800 / 3 / (ABS(H + L + C - AVGH4 - AVGL4 - AVGC4) + ABS(H1 + L1 + C1 - AVGH4 - AVGL4 - AVGC4) + ABS(H2 + L2 + C2 - AVGH4 - AVGL4 - AVGC4) + ABS(H3 + L3 + C3 - AVGH4 - AVGL4 - AVGC4) + .000001) > (H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) * 800 / 3 / (ABS(H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H3 + L3 + C3 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H4 + L4 + C4 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H5 + L5 + C5 - AVGH4.2 - AVGL4.2 - AVGC4.2) + .000001)
CCI INDICATOR
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 91
|
Hi Bruce,
Sorry about that I thought that this was a good explanation, I guess I was wrong.
Been wrong many times before so let me try this again.
If the cci at the close on Mon was -102.61 then on Tues it was -2.19 then on Wed it was -59.86 and today ( let's pretend that today is Thurs ) the cci closed at 42.43.
The the figure of 42.43 is higher than negative ( -2.19 ).
I would be using CCI 4 of the close.
Hope this helps.
|
|
Registered User
Joined: 10/7/2004
Posts: 91
|
Hi Bruce,
It would look like the symbol ASX at the close today
|
|
Registered User
Joined: 10/7/2004
Posts: 91
|
Hello again, Bruce.Being that I am not a programmer and that the above formulas that you sent for the CCI indicator are not working out. Does that mean that this TC 2011 versioncannot perform this function or that my explanation is still not clear ?I would appreciate an answer if you don't mind as I am still on the 14 Day Trialand if this is the case.Many thanks to you for your efforts.Gerry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I would have thought my response was complete and straightforward enough to provide you with the correct answer even though I didn't completely understand the question. It provided versions for both the CCI being higher than the CCI of 3-Bars Ago and for CCI on Thursday being higher than the CCI on Tuesday (CCI being higher than the CCI of 2-Bars Ago). It included the components used in an incremental fashion to demonstrate the changes required in the base CCI formula when going back in time.
I'm pretty sure based on your clarification that you want the last formula provided. The one for the CCI being higher than the CCI of 2-Bars Ago:
(H + L + C - AVGH4 - AVGL4 - AVGC4) * 800 / 3 / (ABS(H + L + C - AVGH4 - AVGL4 - AVGC4) + ABS(H1 + L1 + C1 - AVGH4 - AVGL4 - AVGC4) + ABS(H2 + L2 + C2 - AVGH4 - AVGL4 - AVGC4) + ABS(H3 + L3 + C3 - AVGH4 - AVGL4 - AVGC4) + .000001) > (H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) * 800 / 3 / (ABS(H2 + L2 + C2 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H3 + L3 + C3 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H4 + L4 + C4 - AVGH4.2 - AVGL4.2 - AVGC4.2) + ABS(H5 + L5 + C5 - AVGH4.2 - AVGL4.2 - AVGC4.2) + .000001)
If you use it as Custom PCF % True Indicator, you will see that it returns True for ASX on 3/1/11 on a Daily Chart.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |