| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 9
|
I wanted RS sort...and I got it, thank you. But, being a greedy human, now I'd like to VERBATIM replicate the IBD newspaper sort of industry groups.
Here's what I need:
1. Rank sort by 6 month price change
-- we have that already in a system sort, formula is: 100*(C-C126)/C126
2. Rank of rank sort by 6 month price change ONE WEEK AGO.
3. Rank of rank sort by 6 month price change THREE MONTHS AGO
My feeble mind cannot figure out the math/forumla to keep all those 3 sorts in the same realtive scale, so as to be meaningful.
It does no good to know that something went up 20% over the last week, and 80% over the last 3 months.
I want to know the RANK ORDER or what changed price by how much this week....and I want to know what that same rank order looked like ONE WEEK AGO... and 3 MONTHS ago...so I can see what is moving up or down in relative 6 month price change rank over that time
I can get that at IBD, and I'm convinced I can make it happen at TC.
Any ideas?
Thanks in advance!
TDM
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
I can get the columns going across by making my own PDF's staggerd by the time frames I indicate...
in other words, 1 week look back is:
100*(C5-C131)/C131
etc...for 21 days (a month) and 63 days (3 months)....
HOWEVER, that's no good. I'd like each time frame in some sort of RELATIVE RANK percentile, like a formula, but I need to have each time frame visible simultaneously in columns, so I can see the relative progress of each symbol in the list.
For example, using the pcf's I indicate above...I show that MG851 is up by 80.58% over the last 6 months. Shifting that by 5 days back, 21 days back, and 63 days back, I get 48%, 42% and 51%, evidently, but that does me no good.
I need to convert each time frame into a RELATIVE RANK PERCENTILE of some type.
????? TDM 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Have you tried changing the Column Display to use Display Market Rank instead of Display Value?
Right-click on the Watchlist Column header and select Edit Column.
Select Display Market Rank.
Select OK.
You may wish to review the following:
Customize the Information Displayed in the WatchList
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
By Jove...I think Bruce_L has done it!
I DID say that I have a FEEBLE mind, right?
Anyone who could not toggle the "Market Rank" button on his column MUST have a feeble mind...and I do!
EXCELLENT day on the Worden.com Discussion thread.
Much obliged -- ur a good man, Bruce! Thanks!!
TDM 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |