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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » formula for 52 week low

formula for 52 week low Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
brainfreze1
Posted : Tuesday, December 26, 2006 10:10:31 AM
Registered User
Joined: 3/8/2006
Posts: 12
 is there a way to write a formula that u can find the high for the year that is double the 52 week low. or more simply 52 week low for the year times 100 percent
Back to top
Bruce_L
Posted : Tuesday, December 26, 2006 10:29:08 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 Please try the following:

H = MAXH252 AND H >= MINL252 * 2

You may wish to review the following:

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
Back to top
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.