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

Can't solve PCF formula problem Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
esf35ml
Posted : Wednesday, May 10, 2006 9:16:12 AM
Registered User
Joined: 3/12/2005
Posts: 6
Please help me straighten this out.

C > C1
C2 > C3
V > V1
V1 > V2
V2 > V3
20% * C <= 100 * C / MAXH250
>= $5
V >= 250000

The first part seems easy enough, but I am looking for price and volume changes over a few days and then a price within 20% of the 52 week high. I also want the price over $5 and volume to be over 250,000 shares. I keep getting a syntax error and I cannot change enough formulas to get it right.

Your help would be appreciated.

Thanks
Bruce_L
Posted : Wednesday, May 10, 2006 9:22:27 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
There were several minor issues, but I suspect the biggest problem was that the various conditions need to be strung together using AND. Please try the following:

C > C1 AND C2 > C3 AND V > V1 AND V1 > V2 AND V2 > V3 AND C >= .8 * MAXH250 AND C >= 5 AND V >= 2500

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
esf35ml
Posted : Wednesday, May 10, 2006 9:32:15 AM
Registered User
Joined: 3/12/2005
Posts: 6
Hi Bruce,

I did as you said and I still cannot get it to calculate. It gives me an error saying it needs 251 days to calculate and it will take longer. I am not sure what is happening here, so I leave it to you to test it out for me. I have read all of the PCF documents and tried many formulae, but this simple one is giving me a fit.

Here is exactly what I pasted in after your suggestion to add teh "and":

C > C1 AND C2 > C3 AND V > V1 AND V1 > V2 AND V2 > V3 AND C >= .8 * MAXH250 AND C >= 5 AND V >= 250000

Thanks for your help again,

Ellen
Bruce_L
Posted : Wednesday, May 10, 2006 9:38:08 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The message is not an error message, it is just informing you that the Personal Criteria Formula will require 251 days of data to calculate. Volume in TeleChart is in blocks of 100, so you may wish to revert to the formula I provided (unless you are actually looking for volume of 25 million shares or more).

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
esf35ml
Posted : Wednesday, May 10, 2006 9:39:52 AM
Registered User
Joined: 3/12/2005
Posts: 6
Okay, then why doesn't it calculate?

Ellen
Bruce_L
Posted : Wednesday, May 10, 2006 9:46:13 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It does calculate on my system when I select Databank | Personal Criteria Formulas | Update All Criteria. Since the test indicates the formula requires 251 days of data, you may wish to make sure Include criteria which require more than 250 days of history (slower) is checked (although it calculates fine on my system even when it isn't).

Have you reviewed the topics I referenced earlier? Do you receive any error messages during the update process itself?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Doug_H
Posted : Wednesday, May 10, 2006 9:54:49 AM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Ellen: I suspect that the "error message" you're getting is actually a FALSE result. This is not an error. Every boolean formula like this must return a TRUE or FALSE for every stock. Boolean formulas do not calculate values, but instead, they return either TRUE or FALSE. It just so happens that formula is false for the ticker you are testing the formula on. You'd know if you got an error, because it would say "Error in Formula Syntax".

- Doug
Teaching Online!
esf35ml
Posted : Wednesday, May 10, 2006 10:02:02 AM
Registered User
Joined: 3/12/2005
Posts: 6
Everything is fine now since I checked the box. No more formula problems...hopefully never again.

Ellen
Doug_H
Posted : Wednesday, May 10, 2006 10:04:04 AM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Glad to hear that you've gotten it figured out!

- Doug
Teaching Online!
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.