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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » 52 week high - low % change sort

52 week high - low % change sort Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
SummitTC2K
Posted : Friday, December 26, 2008 2:20:55 PM
Registered User
Joined: 1/4/2005
Posts: 15
 I'm trying to sort watchlists by it's 52 week max high to it's 52 week min low by it's net % + or - change relative to today's observation.  Starting with the SGN( ) format given as SGN (C - C1) example,  I came up with SGN((MAXC250 - MINC250)) / (MAXC250) * 100, but that is not giving me what I'm looking for.  Your help would be appreciated.

Thanks
Chuck
Back to top
StockGuy
Posted : Tuesday, December 30, 2008 10:47:34 PM

Administration

Joined: 9/30/2004
Posts: 9,187
 Why are you using SGN exactly?

(MAXC250 / MINC250)* 100

...will return the difference in the 52 wk high vs the 52 week low as a percentage. 

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.