Registered User
Joined: 10/7/2004
Posts: 7
|
Please see the attached jpg file. How can I produce this multiple day colored sort in TC2007?
Thanks, Tom Powell
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Check out this video:
Customize the Information Displayed in the WatchList
- Craig
Here to Help!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
dctommy,
Please try the following:
Create ten Price Percent Change Personal Criteria Formulas:
%3:
100 * (C / C3 - 1)
%10:
100 * (C / C10 - 1)
%21:
100 * (C / C21 - 1)
%31:
100 * (C / C31 - 1)
%42:
100 * (C / C42 - 1)
%52:
100 * (C / C52 - 1)
%63:
100 * (C / C63 - 1)
%84:
100 * (C / C84 - 1)
%116:
100 * (C / C116 - 1)
%126:
100 * (C / C126 - 1)
Then use each of the PCFs as the contents of one of your Watchlist Columns. Both Foreground Colors should be Black. The top Background Color should be Green and the bottom Background Color should be Red. Round values to whole numbers, Show plus and minus signs and Display Value should all be selected.
You may wish to review the following:
Customize the Information Displayed in the WatchList
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
|