fotchstecker
304 posts
msg #155309
- Ignore fotchstecker
modified |
1/14/2021 12:22:00 PM
Hello! This is a rotation filter I've shared to the forums before.
1. Is there a way to display in a column a count of the days in a row that a given top-ten ticker has appeared among the top ten rankings? The "top 10" are the top ten spots as ranked by the filter.
2. Is there a way to display "number of times in the last 30 days" the ticker has appeared somewhere in the top 10? Some tickers hop in and out of the top-10. Good information.
I wish there were some built-in components for this kind of thing. Does anyone have any ideas? Thank you.
|
Cheese
1,374 posts
msg #155311
- Ignore Cheese |
1/14/2021 1:49:23 PM
fotch,
I don't know the answer.
But you might be able to get some ideas from davesaint86's RANK approach here
https://www.stockfetcher.com/forums/Filter-Exchange/PORTFOLIO-SELECTION-AND-MANAGEMENT-USING-RISK-REWARD-RATIOS/91296/520
Good luck.
|
Cheese
1,374 posts
msg #155312
- Ignore Cheese |
1/14/2021 2:14:58 PM
and thank you, fotch for sharing !
|
fotchstecker
304 posts
msg #155314
- Ignore fotchstecker |
1/14/2021 2:36:46 PM
Thanks, Cheese. You're like the "information desk" of StockFetcher! Appreciated!
I don't think those ranking methods will work because they require the set statement to reference a ticker. Or maybe they do work and I just don't know how to make them work.
Maybe excel is the answer...
|
Cheese
1,374 posts
msg #155315
- Ignore Cheese
modified |
1/14/2021 2:52:35 PM
fotch,
I actually like davesaint86's RANK filter enough and I am also crazy enough
to do heavy editing of dave's filter and mitigate the severe limitations of
nine symbols hardcoded in the filter.
It's painstaking and fraught with coding bugs. But if I have, say 11 instead of 9 favorites
compared to dave's 9 favorites, then the time investment may be worthwhile.
In your case, say, after you've edited dave's filter to your liking,
then step 1 would be to run your filter, and step 2 is to plug some of your picks
into your edited dave's approach. In the very earlier years, some of the sF traders
used multi-step approach end-of-day to plan their trading the next day,
Happy trading.
|