Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Help with Moving Average PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thebirdoc
Posted : Friday, March 15, 2013 5:17:40 PM
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?

Bruce_L
Posted : Friday, March 15, 2013 5:35:28 PM


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
thebirdoc
Posted : Friday, March 15, 2013 5:47:30 PM
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.

Bruce_L
Posted : Friday, March 15, 2013 7:10:45 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.