Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

New Request Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Ryan15
Posted : Saturday, November 3, 2007 11:58:04 AM
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
Ryan15
Posted : Sunday, November 4, 2007 9:57:07 AM
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.


.  

Ryan15
Posted : Monday, November 5, 2007 9:18:10 AM
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
            


Ryan15
Posted : Monday, November 5, 2007 9:18:48 AM
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
            


Bruce_L
Posted : Monday, November 5, 2007 10:22:22 AM


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 734 time(s).
Ryan15-26708b.scond - 13 KB, downloaded 713 time(s).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Ryan15
Posted : Monday, November 5, 2007 2:03:34 PM
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
Bruce_L
Posted : Monday, November 5, 2007 2:12:14 PM


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
Ryan15
Posted : Monday, November 5, 2007 5:41:18 PM
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

 

 

Bruce_L
Posted : Tuesday, November 6, 2007 11:08:13 AM


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
Ryan15
Posted : Tuesday, November 6, 2007 11:41:49 AM
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
Bruce_L
Posted : Tuesday, November 6, 2007 11:53:45 AM


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
letgo
Posted : Tuesday, November 6, 2007 12:26:12 PM
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
Bruce_L
Posted : Tuesday, November 6, 2007 1:06:28 PM


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