| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/14/2016
Posts: 24
|
Prior to the latest update in TC2000 vs 17 the formula producing this error plotted nicely. If I could be alowed a guess; it seems the formula is 2 characters too long to be processed. The formula ends in "-1)" The formula is 224 characters long.
It's the first time I've recieved this error.
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you let me know the name of the layout and/or chart containing the indicator I could take a look at it to try and see if I can figure out why it is generating the error and how the fomula could be corrected.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/14/2016
Posts: 24
|
This PCF creates a bolean expression, true when both moving averages are rising, false when both are falling. One is a 16 period SMA of the high+low+close/3 the other is a 9 period SMA of the high+low/2. The error flags the position 2 characters from the end the '-1'.
ABS((AVGH16+AVGL16+AVGC16)/3 > (AVGH16.1+AVGL16.1+AVGC16.1)/3 AND ((AVGH9+AVGL9)/2) >= ((AVGH9.1+AVGL9.1)/2))+(ABS((AVGH16+AVGL16+AVGC16)/3 < (AVGH16.1+AVGL16.1+AVGC16.1)/3 AND ((AVGH9+AVGL9)/2) <= ((AVGH9.1+AVGL9.1)/2))*-1)
Thanks!
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
That formula calculates a value, not a True/False result. The error is caused by no spaces around the * at the end.
Try this version...
ABS((AVGH16+AVGL16+AVGC16)/3 > (AVGH16.1+AVGL16.1+AVGC16.1)/3 AND ((AVGH9+AVGL9)/2) >= ((AVGH9.1+AVGL9.1)/2))+(ABS((AVGH16+AVGL16+AVGC16)/3 < (AVGH16.1+AVGL16.1+AVGC16.1)/3 AND ((AVGH9+AVGL9)/2) <= ((AVGH9.1+AVGL9.1)/2)) * -1)
|
|
Registered User
Joined: 9/14/2016
Posts: 24
|
Well, thank you very much.
Cheers.
|
|
|
Guest-1 |