Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 2/20/2005 Posts: 54
|
Hi,
I have a PCF for 'volume surge up today': 100 * V / AVGV100 AND C > O AND C > C1
I have it on a tab, and it returns 'true' if applicable. How can I change the PCF so that it returns and sorts by a numeric value instead of 'true'?
thanks,
George Kern
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Your Personal Criteria Formula has a value based portion and two Boolean portions. I'm really not sure what value you want returned when. If you want 100 * V / AVGV100 returned when C > O AND C > C1 (and zero if not True), you may wish to try the following:
100 * V / AVGV100 * ABS(C > O) * ABS(C > C1)
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 2/20/2005 Posts: 54
|
I want to sort a watch list by volume surge today. The formula 100 * V / AVGV100 returns a numeric value, but it mixes red and green volume days. I want to separate the formula: one for price up volume and another one for price down volume. But the formula I came up with does not return numeric values anymore, just 'true'. I want to get the same numeric results as in the basic formula.
George Kern
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
How do you want the number to show?
You can try this: It will give the volume as a positive number if the stock closed up, negative if it closed down:
((100*V/AVGV100)*ABS(C>=C1)) + ((100*V/AVGV100)*(C<C1))
- Craig Here to Help!
|
|
Guest-1 |