| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/26/2005
Posts: 5
|
The Friday report by Sir Geologist looks to be an interesting manner of selection so I thought that I would create the PCF's and try it out.
I created the A,B,C,D&E PCF's however there is a Syntax error and each formula requires "market days needed to calculate criteria"
I'm a newbie to all this, is there an easy way to add the market days needed so that the formulae can run?
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Post one of the PCFs giving you a Syntax error here so we can test it for you.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/26/2005
Posts: 5
|
This is PCF Buy 2
(Tab A +) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND (STOC30.4 > AVG(STOC30.4 ,5)) AND (TSV17 > AVG(TSV17,9))
|
|
Registered User
Joined: 1/26/2005
Posts: 5
|
When running a test, this comes up as Error in Formula Syntax..................Market days needed to calculate criteria 39
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Please review this post and video
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
TAB A etc is not part of the PCFs. Here are the ones to use.
Here is Tab A
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND
(STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 >
AVG(STOC2.1,2))
TAB B is Tab A + this:
AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND
(STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9))
so TAB B is:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND
(STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 >
AVG(STOC2.1,2)) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND
(STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9))
(note TAB A is bold)
- Craig
Here to Help!
|
|
Registered User
Joined: 1/26/2005
Posts: 5
|
Thanks Craig however when I copied & pasted this to my PCF
& did a test it still came up wrong....Result False
Market days needed to calculate criteria 39
I'm back to where I started from
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
False is OK.
It means it is false for the
test symbol.
Thanks
diceman
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
A Boolean PCF can either test TRUE or FALSE depending on the symbol.
FALSE is not an error message.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/26/2005
Posts: 5
|
Thanks Guys, I'll plod on from here and assume that all is OK
|
|
Registered User
Joined: 10/7/2004
Posts: 166
|
How do I get to the original "Daily Worden" report that Sir Geo posted back in 2007? I want to understand his logic used. I have found it a very good scanning system and want to better learn the logic in it.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The >>>>> Worden Report Searchable Archive Link <<<<<< should have all of the Daily Worden Reports.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |