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
