Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » PCF query

PCF query Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
chartist123
Posted : Thursday, December 22, 2005 2:02:42 AM
Registered User
Joined: 11/29/2005
Posts: 12
 Hello,
I have created the following formula:
AVGV50 >= 1000 AND 10 < C <= 20 AND H >= MAXH40
When I test this for the stock symbol PYX, the values returned were
4687.22 >= 1000.00 AND 10.00 < 15.44 <= 20.00 AND 15.49 >= 15.49
yet the test result was FALSE.
Could you please why this is happening ?
Also I get the message that the market days needed to create the criterion was 51. How was the 51 days arrived at ?
Thanks.
Back to top
Craig_S
Posted : Thursday, December 22, 2005 6:54:56 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 FALSE only means the formula was not TRUE for the ticker you tested on... in your case, the formula has a problem. You cannot string the logic. This formula should work:

AVGV50>=1000 AND C>10 AND C<=20 AND H=MAXH40

I removed the > from the H>=MAXH40. The high today cannot be greater than the MAXH40 because the high today is part of the MAXH40. At best, they can only be equal.
- Craig
Here to Help!
Back to top
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.