| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 794
|
Is this correct XAvgC3>Avg(XAvgC3,2)> XAvgC3.1>Avg(XAvgC3,2.1)
I want new results vs yesterday
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You need to make all of the comparisons individually.
XAVGC3 > AVG(XAVGC3, 2) AND AVG(XAVGC3, 2) > XAVGC3.1 AND XAVGC3.1 > AVG(XAVGC3.1, 2)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
Is this correct XAvgC3>Avg(XAvgC3,2)> XAvgC3.1>Avg(XAvgC3,2.1)
I want new results vs yesterday or previous bar
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
XAVGC3 > AVG(XAVGC3, 2) returns true or false.
XAVGC3.1 > AVG(XAVGC3.1, 2) returns true or false.
You can't check to see if one is greater than the other.
If you are going to compare things, they have to return numeric values.
I don't know what numeric values you are trying to compare.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
Thank you
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
The program states
XAVGC3 > AVG(XAVGC3, 2) AND AVG(XAVGC3, 2) > XAVGC3.1 AND XAVGC3.1 > AVG(XAVGC3.1, 2)
has syntax errors
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
I found it everything good!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I am happy to read you were able to figure it out on your own.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |