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 |

OK...gotta start over here, but we're making progress Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
TrilionDolarMan
Posted : Wednesday, May 23, 2007 12:19:32 PM
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
TrilionDolarMan
Posted : Wednesday, May 23, 2007 12:26:41 PM
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
Bruce_L
Posted : Wednesday, May 23, 2007 12:52:16 PM


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
TrilionDolarMan
Posted : Wednesday, May 23, 2007 1:43:48 PM
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
Bruce_L
Posted : Wednesday, May 23, 2007 2:05:51 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

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