Registered User Joined: 6/23/2007 Posts: 95
|
Trying to use the following to show me stocks where the current bar's Close is above the 200 bar simple ma and below the 5 bar simple ma
(C) > (AVGC200 )and (C) <(AVGC5)
Doesn't seem to work. Scan using condition today shows VNO and GOOG as meeting the criteria. Both are > than the 5 bar Ma. What am I doing wrong?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
VNO and GOOG are both very definitely below their 5-Period Simple Moving Average on a Daily chart in my copy of TC2000. Are you sure that your charted 5-Period Simple Moving Average is of price and not of something else (such as another moving average)?
If you hover the mouse over the name of Moving Average 5 on your chart, it should bring up a small box indicating which indicator on the chart is parent of your moving average. The only thing listed above the moving average in this box should be Price History. If more than one item is listed above the moving average or if the other item listed is not Price History, then your moving average is not based directly on price.
If the 5-Period Simple Moving Average is based on the 200-Period Simple Moving Average (and the 200 is based on Price History) instead of Price History, then your Condition Formula would need to be more like the following to match the charts:
C > AVGC200 AND C < AVG(AVGC200, 5)
On another note, you should be able to get rid of all of the parentheses in your Condition Formula.
C > AVGC200 AND C < AVGC5
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 6/23/2007 Posts: 95
|
Bruce, Thank you. I messed up and was using 4 day instead of Daily. Working fine now. Thank you again.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome. I am happy to read you were able to figure out the issue.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|