Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Post the formula you are using and we can adjust it.
- Craig Here to Help!
|
|
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
|
|
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))
|
|
Registered User Joined: 11/19/2004 Posts: 130
|
Bruce: Once again your formula works well.
Thanks WinWon
|
|
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
|
|
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
|
|
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
|
|
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!
|
|
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
|
|
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
|
|
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
|
|
Guest-1 |