Registered User Joined: 9/4/2014 Posts: 4
|
Hello,
I am trying to setup a condition that checks to make sure that the 4 week MA is GT the 10 week MA and that is greater than the 30 wk MA. My current syntax is C>AVGC20>AVGC50>AVGC150. In the test field it is coming up without an error, but the test is being done on MSFT, and the outputs appear to be True, while the stock prices should calculate true, and the scan results in nothing, but I know that, for example LUV, should be true for that. Any tutorial information on using averages would be appreciated.
Thank you,
Dan
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You need to make the comparisons individually instead of serially. So your Condition Formula needs to be as follows.
C > AVGC20 AND AVGC20 > AVGC50 AND AVGC50 > AVGC150
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|