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