 Gold Customer
Joined: 9/26/2010
Posts: 10
|
I am working on a scan that identifies stocks in a general uptrend that have pulled back reently and hit or crossed the 50Moving Average one day ago. It the last part I am unsure a to how to code
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
So you want price to be hitting or crossing down through the 50 day average?
Use this formula:
C1 > AVGC50.1 and C <= AVGC50
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I have a slightly different interpretation of your request. I do not know which one would better work for your particular needs.
A Condition Formula for price having touched or crossed through the 50-period simple moving average yesterday can be written as:
(L1 <= AVGC50.1 AND C2 > AVGC50.2) OR (H2 >= AVGC50.1 AND C2 < AVGC50.2)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
If neither formula does what you want, please provide additional clarification as to your actual intent. This might allow us to refine the formulas further to get something closer to what you were actually asking.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|