| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
Registered User
Joined: 3/12/2005
Posts: 6
|
Okay, then why doesn't it calculate?
Ellen
|
|
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
|
|
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!
|
|
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
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Glad to hear that you've gotten it figured out!
- Doug
Teaching Online!
|
|
|
Guest-1 |