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

Percentage change from Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
TBradley
Posted : Thursday, November 17, 2016 9:07:55 AM
Gold Customer Gold Customer

Joined: 1/22/2005
Posts: 73

I cannot think of   how to write two formula's, Help

% change from 52 week low

% change from 52 week high

Bruce_L
Posted : Thursday, November 17, 2016 9:34:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following for % change from 52 week low.

100 * (C / MINL252 - 1)

And the following for the % change from 52 week high.

100 * (C / MAXH252 - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
TBradley
Posted : Tuesday, November 22, 2016 11:34:23 AM
Gold Customer Gold Customer

Joined: 1/22/2005
Posts: 73

Thank you Bruce for your help.

Pamento
Posted : Friday, November 25, 2016 3:36:09 AM
Registered User
Joined: 1/10/2015
Posts: 1

Hi, this works. But the numbers was white. How can I add to this formula to get green number for up (positive) and red number (value) with - in front for down (negative)? Like you see the "% change" layout that is allready in TC2000. Thanks.

Bruce_L
Posted : Friday, November 25, 2016 8:28:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Right-click on the name of the WatchList Column at the top of the WatchList and select Edit (or Edit Columns).  There should be color options for Positive Color, Zero Color and Negative Color which can be adjusted.

How to edit positive, zero, and negative colors in a WatchList



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.