Registered User Joined: 10/7/2004 Posts: 794
|
I had this model to alert me when all components are true and when it does it it reads 6
( - 2) * ((C > AVGC50) + (C > AVGC200) + (AVGC50 > AVGC20
0) + (RSI3.2 < 30) + (AVGC10 - AVGC20 > 0) + (AVGC10 - AVGC20 >
AVG(AVGC10,30) - AVG(AVGC20,30))) - 6
I am trying to do the same with these variables but failing, could yo please help for Vs 7 and Vs18
(-2) * (XAvgC3> xavg(XAvgC3,2) + (O*2 + H + L +C*4)/8 >XAvgC3 and XAvgC3> Avg
+ (RSI3.2 <30)+ Stoc5.3.3) ))-6
Thanks
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am assuming the third term of the first formula is (AVGC50 > AVGC200).
Your second formula has the parentheses all messed up and seems to be missing some indicators, settings, and/or values in some of the conditions you want counted.
(-2) * ((XAVGC3> XAVG(XAVGC3,2)) + ((O * 2 + H + L + C * 4) / 8 > XAVGC3) + (XAVGC3 > AVGC10) + (RSI3.2 < 30) + (STOC5.3.3 < 30)) - 5
The above just fills in arbitrary values for these things. For example, it change XAVGC3 > AVG into XAVGC3 > AVGC10 instead and changes STOC5.3.3 into STOC5.3.3 < 30 instead. These probably aren't the correct things, they are just placeholders to show you the correct structure while still allowing the formula to calculate.
You shouldn't need to change anything in order for it to calculate in TC2000 v18 as well.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/7/2004 Posts: 794
|
Is it true that if i get +5 it means that all 5 components are true?
thank you
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It should because the base calculatiosn range from 0 through 10, but then we are subtracting 5 at the end so it runs from -5 through 5 instead.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/7/2004 Posts: 794
|
Thank you sorry for the mess I sent you What is the -2 in beginning of formula refer to?
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
When you put a Boolean (true or false) formula inside parentheses it returns -1 when true and 0 when false. So if you were to just add everything all together the base results would range from -5 to 0. Multiplying this by -2 changes the base results so they range from 0 to 10 instead.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|