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

need help with condition error Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
pacifichawkeye
Posted : Sunday, November 29, 2015 1:35:09 PM
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

 

BillÇochrane
Posted : Sunday, November 29, 2015 6:13:50 PM
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.

pacifichawkeye
Posted : Tuesday, December 1, 2015 1:09:56 AM
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

diceman
Posted : Tuesday, December 1, 2015 7:33:04 AM
Registered User
Joined: 1/28/2005
Posts: 6,049

Third and fourth line AVGC20 are missing "C".

 

 

 

Thanks

 

pacifichawkeye
Posted : Thursday, December 3, 2015 12:52:05 AM
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

 

 

StockGuy
Posted : Thursday, December 3, 2015 8:42:51 AM

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

pacifichawkeye
Posted : Friday, December 4, 2015 1:15:44 AM
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

 

 
Bruce_L
Posted : Friday, December 4, 2015 9:16:07 AM


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
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.