Registered User
Joined: 3/8/2012
Posts: 12
|
Hi again- would you please show me how to write the formula for:
The closing prices of today and the previous 3 days are each less than (the average of the last 12 days times 0.97) AND
The closing prices of today and the last 3 days are increasing.
Thank you! And BTW, are there any instructions or a tutorial for writing this language other than what's in Help under Custom Formula Language?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
.97 * AVGC12 > C AND C > C1 AND C1 > C2 AND C2 > C3
The PCF Formula Descriptions topic contains a fairly comprehensive list of the syntax which is valid in the Personal Criteria Formula Language and the Handy PCF example formulas to help you learn the syntax of PCFs! topic has some basic example PCFs.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 3/8/2012
Posts: 12
|
Hi Bruce- You had shown me the first several pieces of this formula. I added a few more and they're not working. Can you straighten me out, please?
.97 * AVGC12 > C AND C > C1 AND C1 < C2 and C2 < C3 AND O < C AND AVGV20 > 100000 AND AVGC60 > 5 AND C > AVGC200
What I want is:
-
Today closed 3% below AVGC12
-
Today was an up day, and the last 3 days were down days
-
Average volume was greater than 100,000
-
Average closing price for the last 60 days was more than $5
-
Today's close was above the 200-day moving average
I think the first 2 bulleted points are working, but the last 3 are not, or not always. Thanks for your help!
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
.97 * AVGC12 > C and C > C1 and C1 < C2 and C2 < C3 and C3 < C4 and AVGV20 > 100000 and AVGC60 > 5 and C > AVGC200
"Today was an Up Day": does this mean price closed above the previous day's close or that price closed above the open (which means the stock could still have been down compared to the previous day's close)?
|