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 |

CCI (5) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
winwon
Posted : Tuesday, April 3, 2007 6:52:59 AM
Registered User
Joined: 11/19/2004
Posts: 130
Worden
I have your formula for the CCI (5)
Question:
What is the formula for your CCI (5) to be lower
today than it was the previous day?

Thanks

Craig_S
Posted : Tuesday, April 3, 2007 9:17:20 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Post the formula you are using and we can adjust it.

- Craig
Here to Help!
Bruce_L
Posted : Tuesday, April 3, 2007 9:22:51 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
winwon,
Please try the following:

(H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000 / 3 / (ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) + ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) + ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) + ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) + ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5) + .000001) < (H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) * 1000 / 3 / (ABS(H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H2 + L2 + C2 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H3 + L3 + C3 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H4 + L4 + C4 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H5 + L5 + C5 - AVGH5.1 - AVGL5.1 - AVGC5.1) + .000001)

You may wish to review the following:

CCI INDICATOR
Handy PCF example formulas to help you learn the syntax of PCFs!
How to create a Personal Criteria Forumula (PCF)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
winwon
Posted : Tuesday, April 3, 2007 9:23:00 AM
Registered User
Joined: 11/19/2004
Posts: 130
Craig:
this is the CCI (5) formula


(H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000 / 3 / (ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) + ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) + ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) + ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) + ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5))
winwon
Posted : Tuesday, April 3, 2007 10:17:03 AM
Registered User
Joined: 11/19/2004
Posts: 130
Bruce:
Once again your formula works well.

Thanks
WinWon
winwon
Posted : Tuesday, April 3, 2007 10:07:18 PM
Registered User
Joined: 11/19/2004
Posts: 130
Bruce
Your CCI(5)formula works and again thanks.

I tried to put the formula into a 3 day format and
can't seem to find the right combo. Again
I need your help.

I need 2 days ago to be lower than 1 day ago and,
today to be lower than 1 day ago and today
to be higher than 2 days ago

2 days ago < 1 day ago and today < 1 day ago and
today > 2 days ago

The formula is above

Many Thanks,
WinWon



Winnie
Posted : Wednesday, April 4, 2007 12:15:58 AM
Registered User
Joined: 10/7/2004
Posts: 1,006
WinWon,

Try to combine each PCF with AND and < and > for Today, Yesterday and 2 Days Ago as noted in your request below. I believe the PCFs are correct, if not Bruce or Craig will certainly let you know.

Hope this helps
Winnie

5-Period Commodity Channel Index, Today:
(H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000/3 / (
ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) +
ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) +
ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) +
ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) +
ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5) + .00001)

5-Period Commodity Channel Index, Yesterday:
(H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) * 1000 / 3 / (
ABS(H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) +
ABS(H2 + L2 + C2 - AVGH5.1 - AVGL5.1 - AVGC5.1) +
ABS(H3 + L3 + C3 - AVGH5.1 - AVGL5.1 - AVGC5.1) +
ABS(H4 + L4 + C4 - AVGH5.1 - AVGL5.1 - AVGC5.1) +
ABS(H5 + L5 + C5 - AVGH5.1 - AVGL5.1 - AVGC5.1) + .00001)

5-Period Commodity Channel Index, Two Days Ago:
(H2 + L2 + C2 - AVGH5.2 - AVGL5.2 - AVGC5.2) * 1000 / 3 / (
ABS(H2 + L2 + C2 - AVGH5.2 - AVGL5.2 - AVGC5.2) +
ABS(H3 + L3 + C3 - AVGH5.2 - AVGL5.2 - AVGC5.2) +
ABS(H4 + L4 + C4 - AVGH5.2 - AVGL5.2 - AVGC5.2) +
ABS(H5 + L5 + C5 - AVGH5.2 - AVGL5.2 - AVGC5.2) +
ABS(H6 + L6 + C6 - AVGH5.2 - AVGL5.2 - AVGC5.2) + .00001)

You requested the following:
5 Period CCI, 2 Days Ago < 5 Period CCI, Yesterday AND
5 Period CCI, Today < 5 Period CCI, Yesterday AND
5 Period CCI, Today > 5 Period CCI, 2 Days Ago

5 Period CCI, 2 Days Ago < 5 Period CCI Today AND
5 Period CCI, Today < 5 Period CCI, Yesterday AND
5 Period CCI, Today > 5 Period CCI, 2 Days Ago
winwon
Posted : Wednesday, April 4, 2007 6:31:59 AM
Registered User
Joined: 11/19/2004
Posts: 130
Winnie
I don't know who you are. Have seen your name time to time over 7/8 years. But I do know one thing. You were up burning the midnight oil to help me. And I do appreciate it very much.

I have tried the CCI (5) formula you provided and it works well.

Many many thanks,
WinWon
Craig_S
Posted : Wednesday, April 4, 2007 6:44:10 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I met Winnie at one of my classes. He has been meticulous in recording PCFs.

- Craig
Here to Help!
winwon
Posted : Wednesday, April 4, 2007 7:18:37 AM
Registered User
Joined: 11/19/2004
Posts: 130
Craig
Winnie is everything you say he is and a credit to have as a Worden subscriber. My thanks to him.

You my friend have helped me many many times and it
has been appreciated.

We met at the last Ft. Lauderdale seminar.
"You're the doctor as always."

Thanks
WinWon
patonet
Posted : Monday, December 2, 2013 8:31:15 AM
Registered User
Joined: 12/12/2007
Posts: 10

Hello There. 

 

Can you help me updating this code for TC2000?  I need exactly this, but I copy and paste into PCF formula and display an error. 

 

Thanks for your support. 

 

Regards

 

Bruce_L
Posted : Monday, December 2, 2013 12:03:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You did not specify exactly what you were attempting when you received the error message or the content of the error message. That said, none of the formula given above seem to generate any error messages for me.

Winnie did not actually put together a completed formula for winmon, but doing so would result in:

(H2 + L2 + C2 - AVGH5.2 - AVGL5.2 - AVGC5.2) * 1000 / 3 / (ABS(H2 + L2 + C2 - AVGH5.2 - AVGL5.2 - AVGC5.2) + ABS(H3 + L3 + C3 - AVGH5.2 - AVGL5.2 - AVGC5.2) + ABS(H4 + L4 + C4 - AVGH5.2 - AVGL5.2 - AVGC5.2) + ABS(H5 + L5 + C5 - AVGH5.2 - AVGL5.2 - AVGC5.2) + ABS(H6 + L6 + C6 - AVGH5.2 - AVGL5.2 - AVGC5.2) + .00001) < (H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000/3 / (ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) + ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) + ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) + ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) + ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5) + .00001) AND (H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000/3 / (ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) + ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) + ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) + ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) + ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5) + .00001) < (H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) * 1000 / 3 / (ABS(H1 + L1 + C1 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H2 + L2 + C2 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H3 + L3 + C3 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H4 + L4 + C4 - AVGH5.1 - AVGL5.1 - AVGC5.1) + ABS(H5 + L5 + C5 - AVGH5.1 - AVGL5.1 - AVGC5.1) + .00001)



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