Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

how to get a numeric value from PCF instead of 'true' Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
georgekern
Posted : Thursday, April 24, 2008 11:56:29 AM
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
Bruce_L
Posted : Thursday, April 24, 2008 12:01:09 PM


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
georgekern
Posted : Thursday, April 24, 2008 12:48:00 PM
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
Craig_S
Posted : Thursday, April 24, 2008 1:24:49 PM


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