Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/23/2007 Posts: 20
|
I got this PCF from a webinar I attended. when I enter it in as a condition I get the error-- formulia argument missing >=
AVGC20>=AVGC20.10AND
AVGC20.10>=AVGC20.20AND
XAVGC8>=AVG20AND
XAVGC8>=AVG20.10AND
L1<=AVGC20ANDL1<=XAVGC8OR
L<=AVGC20ANDL<=XAVGC8AND
C>XVGC8
2 Questions
1. this code above, as writen will it work, or does it need changes to work ?
2. when writing a condtion code like this in TC2000 does it ned to be one continuous string with no brakes or can it be written as I have above with brakes.
Thanks for your help
|
|
Registered User Joined: 10/18/2012 Posts: 40
|
It's your last line - should be c>xAvgc8
I would have spaces before and after every occurence of AND & OR, but that may be personal preference.
|
|
Registered User Joined: 10/23/2007 Posts: 20
|
Sorry that last line was a typo on my part it should of read C>XAVGC8
thanks for pointing that out
but still not working
tks
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
Third and fourth line AVGC20 are missing "C".
Thanks
|
|
Registered User Joined: 10/23/2007 Posts: 20
|
yup your right with the other typos but that doesent correct the formula error
thank for looking at it
anyone else see a reason this won't run
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
You need spaces to offset the ANDs.
AVGC20>=AVGC20.10 AND AVGC20.10>=AVGC20.20 AND XAVGC8>=AVGC20 AND XAVGC8>=AVGC20.10 AND L1<=AVGC20 AND L1<=XAVGC8 OR L<=AVGC20 AND L<=XAVGC8 AND C>XAVGC8
|
|
Registered User Joined: 10/23/2007 Posts: 20
|
Hi everyone
I figured out how to get this condtion to work Lost some of my hair over it but it works
This is how I set it up
AVGC20>=AVGC20.10 AND
AVGC20.10>=AVGC20.20 AND
XAVGC8>=AVGC20 AND
XAVGC8>=AVGC20.10 AND
(L1<=AVGC20 AND L1 <=XAVGC8) OR
(L<=AVGC20 AND L<=XAVGC8 AND C>XAVGC8)
I made it as it looks above fixed the typos and added the spaces between the ands and added the brackets last 2 lines
set it up as an easyscan with $$ vol 250000+ and your good to go
enjoy it
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am happy to read you were able to get the formula entered with syntax which works.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |