| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 12
|
The following PCF returns false results. Can please explain why?
AVGC50.60 > AVGC50.50 AND AVGC50.50 > AVGC50.40 AND AVGC50.40 > AVGC50.30 AND AVGC50.30 > AVGC50.20 AND AVGC50.20 > AVGC50.10 AVGC50.10 > AVGC50.5 AND C > 10.0
Thanks
E. Etgar
P.S. when I remove the last criterion "C>10.0" the results are as expected.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Your test symbol must have a price lower than $10. What symbol are you testing against?
The Test button tests the condition against one symbol so can see what the formula is returning. False just means that the test symbol does not pass the condition.
|
|
Registered User
Joined: 10/7/2004
Posts: 12
|
I did test one stock that the PCF returned, and the result was False whereas the same stock in the list returned from the PCF has a TRUE value.
|
|
Registered User
Joined: 10/7/2004
Posts: 12
|
As an example one specific stock that's included in the list the PCF returned with a true value is TUP (Tupperware). The list is daily and the PCF criteria were updated after the last download.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
TUP returns True for this PCF when I test it. Also returns True when I sort a list using that PCF.
|
|
Registered User
Joined: 10/7/2004
Posts: 12
|
Then something is wrong with my TC2000 software because according with the PCF TUP sould not be on the list in the first place. And I want to remind you that I posed a question for the same problem in October 2009, and never got a response. The fact remains that there is a problem, and I will appreciate very much If we can make a serious attempt to solve it this time.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
I see what you mean now, didn't look at the Test results closely enough. We'll look into the problem.
|
|
Registered User
Joined: 10/7/2004
Posts: 12
|
I waiting with great interest for the results of your research. Thank you
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
etgar,
Your Personal Criteria Formula does not use proper syntax and the C > 10 portion is not being evaluated. It is missing the AND between the last two Moving Average comparisons.
AVGC50.60 > AVGC50.50 AND AVGC50.50 > AVGC50.40 AND AVGC50.40 > AVGC50.30 AND AVGC50.30 > AVGC50.20 AND AVGC50.20 > AVGC50.10 AND AVGC50.10 > AVGC50.5 AND C > 10
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 12
|
Thanks Bruce. Sorry for the miss.
Etgar
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
etgar,
You're welcome. Our pleasure. It is an easy thing to miss.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
How did I miss that???!!!!
|
|
|
Guest-1 |