Kevin_in_GA
4,599 posts
msg #98287
- Ignore Kevin_in_GA |
12/29/2010 8:05:50 AM
Is there any way to implement a "rank" function for the output of a specific filter or indicator?
As an example, I want to see the relative rank of each stock in a symlist or watchlist against a set of specific indicators. Looking at RSI or TSI values over different evaluation periods, them assigning a rank for the position of each stock relative to others in the symlist for each indicator.
This function is present in Excel, so I would not think that coding this would be much of a challenge - it might look something like
rank(indicator, symlist())
In this format the results are not dependent on the actual results of the filter, but simply require calculating the indicator values for the specific stocks in the referenced symlist and spitting out the relative rank.
Thanks and Happy New Year!
Kevin
|
duke56468
683 posts
msg #98303
- Ignore duke56468 |
12/29/2010 4:24:01 PM
Kevin.... would this give us a way to simulate more closely the filters that EtfReplay and IBD use?
|
Kevin_in_GA
4,599 posts
msg #98304
- Ignore Kevin_in_GA |
12/29/2010 5:04:00 PM
Yup.
|
campbellb75
101 posts
msg #98306
- Ignore campbellb75 |
12/29/2010 10:04:01 PM
I second Kevin's request for a rank function. I currently use it in other investment applications and would love to see this get added to StockFetcher!
|
Kevin_in_GA
4,599 posts
msg #98360
- Ignore Kevin_in_GA |
1/1/2011 9:20:55 PM
Bumping this post, but also thinking the this could also be done as a percentile rank rather than a 1 -> N type ranking. People often look for stocks in the top quartile/decile/etc as strong candidates. This could either be a part of this function or a second function.
Thanks.
|
campbellb75
101 posts
msg #98405
- Ignore campbellb75 |
1/4/2011 6:57:16 PM
Tom B-
Any plans on including a rank function in a future upgrade for StockFetcher?
|
wkloss
231 posts
msg #98466
- Ignore wkloss |
1/6/2011 2:11:55 PM
Tom B.
I would like to see this implemented too.
Bill
|
Kevin_in_GA
4,599 posts
msg #98535
- Ignore Kevin_in_GA |
1/10/2011 10:03:12 PM
SF crew:
Any input on this? Sounds like there are a number of members that would like to see this function implemented.
Thanks.
|
marine2
963 posts
msg #98544
- Ignore marine2 |
1/11/2011 4:26:04 PM
Probably have to reach the SF crew by writing to them in their help section. I think awhile back SF mentioned that they respond better when you do that.
|
campbellb75
101 posts
msg #98577
- Ignore campbellb75 |
1/14/2011 4:18:35 PM
Still hoping to get a response from Tom B and the SF crew...
|