Registered User
Joined: 12/30/2004
Posts: 14
|
I'm trying to write a scan to determine which symbols have experienced a crossover of today's close over yesterday's 4 day average of the following: (( H + L + C ) / 3 )
Below is what I've written but it gives me no results. Something must be wrong because I highly doubt that there were NO stocks that met this criteria
in english:
today's 4 day average close > the avg of the last 4 days values for (not including today's value): ( H + L + C ) / 3
AND
yesterday's 4 day average close <= yesterday's avg of the last 4 days values for (not including yesterday's value): ( H + L + C ) / 3
in TC-2007 language
(AVGC5 > ( ( H1 + L1 + C1 ) / 3 , ( H2 + L2 + C2 ) / 3, ( H3 + L3 + C3 ) / 3, ( H4 + L4 + C4 ) / 3 ) / 4 )
AND
( AVGC4.1 <= ( ( H2 + L2 + C2 ) / 3, ( H3 + L3 + C3 ) / 3, ( H4 + L4 + C4 ) / 3, ( H5 + L5 + C5 ) / 3 ) / 4 )
Thanks,
Ben
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following instead:
C > (AVGH4.1 + AVGL4.1 + AVGC4.1) / 3 AND C1 <= (AVGH4.2 + AVGL4.2 + AVGC4.2) / 3
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 12/30/2004
Posts: 14
|
Hi Bruce,
You are absolutely correct in your simplification of my equations. Thanks!
I still need to use: AVGC4 > ... rather than C > .... however
because I am testing the average close over the last 4 days
(note my original eqn should read AVGC4 and NOT AVGC5)
Thanks again
Ben
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|