| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/20/2010
Posts: 16
|
I picked up the pcf for 30 bar CCI from your reply to another member:
(H + L + C - AVGH30 - AVGL30 - AVGC30) * 6000 / 3 / (ABS(H + L + C - AVGH30 - AVGL30 - AVGC30) + ABS(H1 + L1 + C1 - AVGH30 - AVGL30 - AVGC30) + ABS(H2 + L2 + C2 - AVGH30 - AVGL30 - AVGC30) + ABS(H3 + L3 + C3 - AVGH30 - AVGL30 - AVGC30) + ABS(H4 + L4 + C4 - AVGH30 - AVGL30 - AVGC30) + ABS(H5 + L5 + C5 - AVGH30 - AVGL30 - AVGC30) + ABS(H6 + L6 + C6 - AVGH30 - AVGL30 - AVGC3
It gives Syntax Error.
What is missing?
Thanks
|
|
Registered User
Joined: 2/1/2013
Posts: 1
|
Try two parenthesis "))" on the end.
|
|
Registered User
Joined: 9/20/2010
Posts: 16
|
From my previous post: the syntax error was from two missing paranthesis at the end. So here is the updated that does not give syntax error: (H + L + C - AVGH30 - AVGL30 - AVGC30) * 6000 / 3 / (ABS(H + L + C - AVGH30 - AVGL30 - AVGC30) + ABS(H1 + L1 + C1 - AVGH30 - AVGL30 - AVGC30) + ABS(H2 + L2 + C2 - AVGH30 - AVGL30 - AVGC30) + ABS(H3 + L3 + C3 - AVGH30 - AVGL30 - AVGC30) + ABS(H4 + L4 + C4 - AVGH30 - AVGL30 - AVGC30) + ABS(H5 + L5 + C5 - AVGH30 - AVGL30 - AVGC30) + ABS(H6 + L6 + C6 - AVGH30 - AVGL30 - AVGC3))
However when I plot above on 12.4, it gives different results than the built in CCI indicator. I need the correct pcf for CCI30 to use it in other pcfs that i want.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You appear to actually be missing most of the formula. The first part seems correct, there just isn't enough formula there to calculate the desired value and the missing portions cause errors:
(H + L + C - AVGH30 - AVGL30 - AVGC30) * 6000 / 3 / (ABS(H + L + C - AVGH30 - AVGL30 - AVGC30) + ABS(H1 + L1 + C1 - AVGH30 - AVGL30 - AVGC30) + ABS(H2 + L2 + C2 - AVGH30 - AVGL30 - AVGC30) + ABS(H3 + L3 + C3 - AVGH30 - AVGL30 - AVGC30) + ABS(H4 + L4 + C4 - AVGH30 - AVGL30 - AVGC30) + ABS(H5 + L5 + C5 - AVGH30 - AVGL30 - AVGC30) + ABS(H6 + L6 + C6 - AVGH30 - AVGL30 - AVGC30) + ABS(H7 + L7 + C7 - AVGH30 - AVGL30 - AVGC30) + ABS(H8 + L8 + C8 - AVGH30 - AVGL30 - AVGC30) + ABS(H9 + L9 + C9 - AVGH30 - AVGL30 - AVGC30) + ABS(H10 + L10 + C10 - AVGH30 - AVGL30 - AVGC30) + ABS(H11 + L11 + C11 - AVGH30 - AVGL30 - AVGC30) + ABS(H12 + L12 + C12 - AVGH30 - AVGL30 - AVGC30) + ABS(H13 + L13 + C13 - AVGH30 - AVGL30 - AVGC30) + ABS(H14 + L14 + C14 - AVGH30 - AVGL30 - AVGC30) + ABS(H15 + L15 + C15 - AVGH30 - AVGL30 - AVGC30) + ABS(H16 + L16 + C16 - AVGH30 - AVGL30 - AVGC30) + ABS(H17 + L17 + C17 - AVGH30 - AVGL30 - AVGC30) + ABS(H18 + L18 + C18 - AVGH30 - AVGL30 - AVGC30) + ABS(H19 + L19 + C19 - AVGH30 - AVGL30 - AVGC30) + ABS(H20 + L20 + C20 - AVGH30 - AVGL30 - AVGC30) + ABS(H21 + L21 + C21 - AVGH30 - AVGL30 - AVGC30) + ABS(H22 + L22 + C22 - AVGH30 - AVGL30 - AVGC30) + ABS(H23 + L23 + C23 - AVGH30 - AVGL30 - AVGC30) + ABS(H24 + L24 + C24 - AVGH30 - AVGL30 - AVGC30) + ABS(H25 + L25 + C25 - AVGH30 - AVGL30 - AVGC30) + ABS(H26 + L26 + C26 - AVGH30 - AVGL30 - AVGC30) + ABS(H27 + L27 + C27 - AVGH30 - AVGL30 - AVGC30) + ABS(H28 + L28 + C28 - AVGH30 - AVGL30 - AVGC30) + ABS(H29 + L29 + C29 - AVGH30 - AVGL30 - AVGC30) + .000001)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/20/2010
Posts: 16
|
Thanks Bruce.
User error on my part. I did not know to open up a given entry from the main list of topics to get the full details. So I just copied part ot the formula that shows when i looked at the main list.
Thanks again.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |