| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 8/22/2005
Posts: 21
|
Hi,
when I scan for (C'06/06/12')/C'06/05/12') >= 1.04 in tc2000 I don't get correct results.
ie. OSIR shows up in the scan results even though it was a loser on 06/06/12.
how do I correct this so it shows stocks up 4% on 06/06/21?
thanks
|
|
Gold Customer
Joined: 8/22/2005
Posts: 21
|
any follow up on this Bruce? thanks
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
The formula you posted is missing a parenthesis.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula is missing an opening parenthesis, but I don't think it is the issue. Referencing those dates is bringing up values which are off by 1 day. I am still researching the issue to see if we can figure out what it is causing it. It seems to only happen on 11/27/2013 or earlier (so Thanksgiving probably has something to do with it).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 8/22/2005
Posts: 21
|
what is an opening parenthesis?
thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following is an opening parenthesis:
(
It should be in the Condition Formula between the / and C.
(C'06/06/12')/(C'06/05/12') >= 1.04
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 8/22/2005
Posts: 21
|
thanks Bruce.. that worked!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |