Registered User
Joined: 12/5/2004
Posts: 9
|
I've written the following pcf for MACD 12.26.9 crossing over today with 1,000,000 avg volume for 90 days and average price over $15 for 90 days. I'm getting a syntax error saying "Market days needed to caluculate criterion:176.
XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND (XAVGC12.1 - XAVGC26.1 < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND AVGV90 >= 10000 AND AVGC90 >= 15
I don't understand my error or whether or not the formula is correct for what I'm trying to do.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The response mentioned (Market days needed to calculate criterion:176) is not a error message. It is informational and means that symbols with less than 176 market days of data will not calculate. That said, your formula appears to have an extra parenthesis that is causing a Syntax Error. please try the following instead:
XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND AVGV90 >= 10000 AND AVGC90 >= 15
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Understanding MACD
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|