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 |

Scanning watchlists in SF5 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
SunriseMan
Posted : Wednesday, June 9, 2010 9:26:34 AM
Registered User
Joined: 11/30/2009
Posts: 29
I posted this before, but an admin moved it to the "bugs" forum, which means I can't get an answer. Please don't move it again!

One of the most useful (to me) features of SF4 was the ability to load a layout that would easily screen a large watchlist of stocks (usually 1,000 to 2,000)  for certain conditions. Then, I could easily see which of the stocks were worthy of future investigation.

The idea here is that I have a number of different screens to look for different opportunities (e.g. Bullish MACD Divergence, Downward Bounce of Resistance, Upward Breakout, etc.). In SF4, it's easy to screen a long list of candidates to find the ones that meet any of those screens, by adding a column to a watchlist for each one. SF4 would automatically scan the whole watchlist, and any stocks that passed any of the screens would sort to the top.

I'm trying to figure out how to achieve the same functionality in SF5. All of these screens in aggregate can take an hour to run, so sitting there and spending an hour clicking on the various column sort buttons is not an attractive option. I know about filtering watchlists, but I can't see how to easily filter to find stocks that pass any of a set of conditions rather than all of a set of conditions.

The only idea I can come up with is to create a big combination condition that then references all of the other conditions. This is an unattractive solution, as it's difficult to maintain and error-prone as I add and remove screens from my collection.

Is there a recommended way to do this type of sort in SF5? Or is this not a use case anticipated by Worden?
jas0501
Posted : Wednesday, June 9, 2010 10:40:11 AM
Registered User
Joined: 12/31/2005
Posts: 2,499
The only idea I can come up with is to create a big combination condition that then references all of the other conditions. This is an unattractive solution, as it's difficult to maintain and error-prone as I add and remove screens from my collection.



see SF5 is not a SCANNING tool, just a sorting tool. for a realcode approach that may address your needs and is not that complicated to adjust. The column sort ordering is dynamic and the changing conditions is a simple drag and drop an setting the name to CONDx.
SunriseMan
Posted : Wednesday, June 9, 2010 1:58:16 PM
Registered User
Joined: 11/30/2009
Posts: 29

Thanks very much for the link to that post. That's an elegant way of representing the results of the very kludgy and error-prone combination I was trying to avoid, but still makes it difficult to keep track of and add/remove screens.

Has a trainer (or any other Worden employee) confirmed that SF5 deliberately has no way to do this kind of scanning? The banner at the top of the StockFinder homepage says "Rule-Based Scanning, Sorting & Charting... just got easier." I'm still hoping that's true, and that I'm just missing some technique that makes this straightforward.

Bruce_L
Posted : Thursday, June 10, 2010 10:52:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
SunriseMan,
StockFinder 5 is currently limited to a single Sort. The only way I can think of to use multiple WatchList Columns in a Sort would be to combine them algorithmically in an Indicator and then use that Indicator as the Sort.

For a left to right Sort, you could add 2 ^ (Column Number starting from the right - 1) to the Value of the Indicator if that Column's Condition is True. For a Number of Conditions True Indicator, you would just add 1 to the Value of the Indicator if that Column's Condition is True.

If you want the feature added, the best place for the question is in StockFinder 5.0 » Bugs / Suggestions forum and not in the Ask a Trainer - StockFinder forum.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
SunriseMan
Posted : Thursday, June 10, 2010 11:50:32 AM
Registered User
Joined: 11/30/2009
Posts: 29
Bruce, thanks for the reply. I was hoping that there was an elegant alternate way to achieve the goal, which is why I was asking a trainer. Unfortunately, it sounds like scanning of multiple conditions just wasn't anticipated.

My earlier thread on the topic was moved to the Bugs/Suggestions forum, so whoever monitors posts there should presumably already know about it.
Bruce_L
Posted : Thursday, June 10, 2010 11:55:28 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
SunriseMan,
Yes, having one topic there already should be enough. There's no need to have a second topic in the suggestions forum.

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