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