Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 91
|
Hello guys,
I was wondering if you could write up some formula that goes as follows:
Using the CCI Indicator ( close, 8 ) that if on Mon it is at +50.00 or Higher and on Tues it is at +100.00 or Higher and at the close on Wed the CCI closes Below the close of Mon, then show me that stock.
At the opposite end I would want to see if the CCI Indicator ( close, 8 ) on Mon is at +50.00 or LOWER and on Tues it is at -100.00 or Lower and at the close on Wed the CCI closes Above the close of Mon, then show me that stock.
Thanking you in advance,
Gerry Grenier
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Good Mornig All,
Has anyone gotten a chance to review testerday's request?
Thanks again,
Gerry
PS. Please let me know if I'm forgetting to add something in my formula request.
.
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Hello again,
Just following up and wondering why I have not heard if I needed more info in my request to you ?
Basically, all this boils down to is a formula that would show me stocks that at the close today the CCI using close, 8 closes below the reading of 3 days ago.
Example Mon the CCI closes a a certain number
Tues the CCI closes at a certain number
Now, say today is Wed the CCI closes below the reading of Monday's number. Show me that stock.
This would be at a potential Top area.
Now at the opposite end I would want to see the CCI using close, 8 close above the close of 3 days ago.
Example Mon the CCI closes at a certain number
Tues the CCI closes at a certain number
Now, say today is Wed the CCI closes above the reading of Monday's number. Show me that stock.
This would be a potential Bottom area.
Thanking you in advance,
Gerry
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Hello again,
Just following up and wondering why I have not heard if I needed more info in my request to you ?
Basically, all this boils down to is a formula that would show me stocks that at the close today the CCI using close, 8 closes below the reading of 3 days ago.
Example Mon the CCI closes a a certain number
Tues the CCI closes at a certain number
Now, say today is Wed the CCI closes below the reading of Monday's number. Show me that stock.
This would be at a potential Top area.
Now at the opposite end I would want to see the CCI using close, 8 close above the close of 3 days ago.
Example Mon the CCI closes at a certain number
Tues the CCI closes at a certain number
Now, say today is Wed the CCI closes above the reading of Monday's number. Show me that stock.
This would be a potential Bottom area.
Thanking you in advance,
Gerry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It can take some time for a post to receive a response, especially a request that is made over the weekend. Bumbing a topic or posting another topic referencing the original topic will not affect the response time. Please download the attached .scond files to:
\My Documents\Blocks Files\Tool Parts\Strategy Conditions
Once downloaded, you should be able to select Add Condition | My Computer when adding a Strategy Condition to access them.
You can use QuickEdit to adjust the settings or view the Block Diagram.Attachments: Ryan15-26708a.scond - 13 KB, downloaded 730 time(s). Ryan15-26708b.scond - 13 KB, downloaded 709 time(s).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Hello Bruce,
What you sent me I am told is ti be used with the Block Program.
I presently do not have that software.
Can it be written for the regular Tc 2000 ?
Thanks,
Gerry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) * 1600 / 3 / (ABS(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H3 + L3 + C3 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H4 + L4 + C4 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H5 + L5 + C5 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H6 + L6 + C6 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H7 + L7 + C7 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H8 + L8 + C8 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H9 + L9 + C9 - AVGH8.2 - AVGL8.2 - AVGC8.2) + .000001) >= 50 AND (H1 + L1 + C1 - AVGH8.1 - AVGL8.1 - AVGC8.1) * 1600 / 3 / (ABS(H1 + L1 + C1 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H2 + L2 + C2 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H3 + L3 + C3 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H4 + L4 + C4 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H5 + L5 + C5 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H6 + L6 + C6 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H7 + L7 + C7 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H8 + L8 + C8 - AVGH8.1 - AVGL8.1 - AVGC8.1) + .000001) >= 100 AND (H + L + C - AVGH8 - AVGL8 - AVGC8) * 1600 / 3 / (ABS(H + L + C - AVGH8 - AVGL8 - AVGC8) + ABS(H1 + L1 + C1 - AVGH8 - AVGL8 - AVGC8) + ABS(H2 + L2 + C2 - AVGH8 - AVGL8 - AVGC8) + ABS(H3 + L3 + C3 - AVGH8 - AVGL8 - AVGC8) + ABS(H4 + L4 + C4 - AVGH8 - AVGL8 - AVGC8) + ABS(H5 + L5 + C5 - AVGH8 - AVGL8 - AVGC8) + ABS(H6 + L6 + C6 - AVGH8 - AVGL8 - AVGC8) + ABS(H7 + L7 + C7 - AVGH8 - AVGL8 - AVGC8) + .000001) < (H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) * 1600 / 3 / (ABS(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H3 + L3 + C3 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H4 + L4 + C4 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H5 + L5 + C5 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H6 + L6 + C6 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H7 + L7 + C7 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H8 + L8 + C8 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H9 + L9 + C9 - AVGH8.2 - AVGL8.2 - AVGC8.2) + .000001)
(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) * 1600 / 3 / (ABS(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H3 + L3 + C3 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H4 + L4 + C4 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H5 + L5 + C5 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H6 + L6 + C6 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H7 + L7 + C7 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H8 + L8 + C8 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H9 + L9 + C9 - AVGH8.2 - AVGL8.2 - AVGC8.2) + .000001) <= ( - 50) AND (H1 + L1 + C1 - AVGH8.1 - AVGL8.1 - AVGC8.1) * 1600 / 3 / (ABS(H1 + L1 + C1 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H2 + L2 + C2 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H3 + L3 + C3 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H4 + L4 + C4 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H5 + L5 + C5 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H6 + L6 + C6 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H7 + L7 + C7 - AVGH8.1 - AVGL8.1 - AVGC8.1) + ABS(H8 + L8 + C8 - AVGH8.1 - AVGL8.1 - AVGC8.1) + .000001) <= ( - 100) AND (H + L + C - AVGH8 - AVGL8 - AVGC8) * 1600 / 3 / (ABS(H + L + C - AVGH8 - AVGL8 - AVGC8) + ABS(H1 + L1 + C1 - AVGH8 - AVGL8 - AVGC8) + ABS(H2 + L2 + C2 - AVGH8 - AVGL8 - AVGC8) + ABS(H3 + L3 + C3 - AVGH8 - AVGL8 - AVGC8) + ABS(H4 + L4 + C4 - AVGH8 - AVGL8 - AVGC8) + ABS(H5 + L5 + C5 - AVGH8 - AVGL8 - AVGC8) + ABS(H6 + L6 + C6 - AVGH8 - AVGL8 - AVGC8) + ABS(H7 + L7 + C7 - AVGH8 - AVGL8 - AVGC8) + .000001) > (H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) * 1600 / 3 / (ABS(H2 + L2 + C2 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H3 + L3 + C3 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H4 + L4 + C4 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H5 + L5 + C5 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H6 + L6 + C6 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H7 + L7 + C7 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H8 + L8 + C8 - AVGH8.2 - AVGL8.2 - AVGC8.2) + ABS(H9 + L9 + C9 - AVGH8.2 - AVGL8.2 - AVGC8.2) + .000001)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
CCI INDICATOR
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Thanks Bruce,
Would it be possible for you to send me the same formula but using CCI close, 4 for both formulas.
Reason being is that I want to try to run these for the next few weeks and see which one works best for me.
Thanking you in advance,
Gerry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm just guessing at what you mean by "CCI Close". My thought is to remove High and Low prices from the computations, but I'm not sure this is what you want or not since CCI seems to be based on Typical Price by definition:
(C2 - AVGC8.2) * 1600 / 3 / (ABS(C2 - AVGC8.2) + ABS(C3 - AVGC8.2) + ABS(C4 - AVGC8.2) + ABS(C5 - AVGC8.2) + ABS(C6 - AVGC8.2) + ABS(C7 - AVGC8.2) + ABS(C8 - AVGC8.2) + ABS(C9 - AVGC8.2) + .000001) >= 50 AND (C1 - AVGC8.1) * 1600 / 3 / (ABS(C1 - AVGC8.1) + ABS(C2 - AVGC8.1) + ABS(C3 - AVGC8.1) + ABS(C4 - AVGC8.1) + ABS(C5 - AVGC8.1) + ABS(C6 - AVGC8.1) + ABS(C7 - AVGC8.1) + ABS(C8 - AVGC8.1) + .000001) >= 100 AND (C - AVGC8) * 1600 / 3 / (ABS(C - AVGC8) + ABS(C1 - AVGC8) + ABS(C2 - AVGC8) + ABS(C3 - AVGC8) + ABS(C4 - AVGC8) + ABS(C5 - AVGC8) + ABS(C6 - AVGC8) + ABS(C7 - AVGC8) + .000001) < (C2 - AVGC8.2) * 1600 / 3 / (ABS(C2 - AVGC8.2) + ABS(C3 - AVGC8.2) + ABS(C4 - AVGC8.2) + ABS(C5 - AVGC8.2) + ABS(C6 - AVGC8.2) + ABS(C7 - AVGC8.2) + ABS(C8 - AVGC8.2) + ABS(C9 - AVGC8.2) + .000001)
(C2 - AVGC8.2) * 1600 / 3 / (ABS(C2 - AVGC8.2) + ABS(C3 - AVGC8.2) + ABS(C4 - AVGC8.2) + ABS(C5 - AVGC8.2) + ABS(C6 - AVGC8.2) + ABS(C7 - AVGC8.2) + ABS(C8 - AVGC8.2) + ABS(C9 - AVGC8.2) + .000001) <= ( - 50) AND (C1 - AVGC8.1) * 1600 / 3 / (ABS(C1 - AVGC8.1) + ABS(C2 - AVGC8.1) + ABS(C3 - AVGC8.1) + ABS(C4 - AVGC8.1) + ABS(C5 - AVGC8.1) + ABS(C6 - AVGC8.1) + ABS(C7 - AVGC8.1) + ABS(C8 - AVGC8.1) + .000001) <= ( - 100) AND (C - AVGC8) * 1600 / 3 / (ABS(C - AVGC8) + ABS(C1 - AVGC8) + ABS(C2 - AVGC8) + ABS(C3 - AVGC8) + ABS(C4 - AVGC8) + ABS(C5 - AVGC8) + ABS(C6 - AVGC8) + ABS(C7 - AVGC8) + .000001) > (C2 - AVGC8.2) * 1600 / 3 / (ABS(C2 - AVGC8.2) + ABS(C3 - AVGC8.2) + ABS(C4 - AVGC8.2) + ABS(C5 - AVGC8.2) + ABS(C6 - AVGC8.2) + ABS(C7 - AVGC8.2) + ABS(C8 - AVGC8.2) + ABS(C9 - AVGC8.2) + .000001)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 91
|
Hello Bruce,
Yes, I'm looking at CCI (close, 4 ) but I believe what you just sent is still CCI Close 8 instead of the CCI close 4 in my last request.
Thanks,
Gerry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You seem to be understanding the formula fairly well. You could probably write them on your own at this point.
(C2 - AVGC4.2) * 800 / 3 / (ABS(C2 - AVGC4.2) + ABS(C3 - AVGC4.2) + ABS(C4 - AVGC4.2) + ABS(C5 - AVGC4.2) + .000001) >= 50 AND (C1 - AVGC4.1) * 800 / 3 / (ABS(C1 - AVGC4.1) + ABS(C2 - AVGC4.1) + ABS(C3 - AVGC4.1) + ABS(C4 - AVGC4.1) + .000001) >= 100 AND (C - AVGC4) * 800 / 3 / (ABS(C - AVGC4) + ABS(C1 - AVGC4) + ABS(C2 - AVGC4) + ABS(C3 - AVGC4) + .000001) < (C2 - AVGC4.2) * 800 / 3 / (ABS(C2 - AVGC4.2) + ABS(C3 - AVGC4.2) + ABS(C4 - AVGC4.2) + ABS(C5 - AVGC4.2) + .000001)
(C2 - AVGC4.2) * 800 / 3 / (ABS(C2 - AVGC4.2) + ABS(C3 - AVGC4.2) + ABS(C4 - AVGC4.2) + ABS(C5 - AVGC4.2) + .000001) <= ( - 50) AND (C1 - AVGC4.1) * 800 / 3 / (ABS(C1 - AVGC4.1) + ABS(C2 - AVGC4.1) + ABS(C3 - AVGC4.1) + ABS(C4 - AVGC4.1) + .000001) <= ( - 100) AND (C - AVGC4) * 800 / 3 / (ABS(C - AVGC4) + ABS(C1 - AVGC4) + ABS(C2 - AVGC4) + ABS(C3 - AVGC4) + .000001) > (C2 - AVGC4.2) * 800 / 3 / (ABS(C2 - AVGC4.2) + ABS(C3 - AVGC4.2) + ABS(C4 - AVGC4.2) + ABS(C5 - AVGC4.2) + .000001)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/14/2004 Posts: 5
|
Hello Bruce,
Thank you for all the work on the CCI 5 and CCI 20, I use both of them.
I would like to ask you for a 5 week CCI.
Thank you,
michael
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
letgo,
Please try the following:
(4 * (MAXH5 + MINL5 + C) - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) * 1000 / 3 / (ABS(4 * (MAXH5 + MINL5 + C) - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.5 + MINL5.5 + C5) - MAXH5 - MINL5 - C - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.10 + MINL5.10 + C10) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.15 + MINL5.15 + C15) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.20 + MINL5.20 + C20) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15) + .000001)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |