 |
Peter Gum
2010-12-11 13:33:14
|
|
Is it possible to create a watchlist that is a composite of other watchlists?
I have a dyanmic watchlist from which my strategy picks randomly when funds become available. However:
- for various reasons, including avoiding the appearance of a conflict of interest, there are stocks from time to time that I should not hold.
One way to do that might be to put those in a watchlist that is linked somehow to the dynamic list in 'exclude' manner (filter).
I would rather not simply remove 'flagged' stocks from the database.
- similarly, though less interesting, there are cases of stocks that do not pass the dynamic tests yet I would like to include them in the pool.
One approach might be to place those stocks in a watchlist whose entries could be 'filtered' into the dynamic lst.
- one can imagine other creative reasons for combining watchlists.
Obviously this is not a 'problem' but rather something that could become more useful in a live trading situation (though simulation results would also be affected), so I offer the scenario for your consideration unless of course there is already a workable way to achieve the same result.
-Pete
|
|
|
 |
QuantShare
2010-12-11 16:54:25
0
|
|
Best Answer
In the symbol filter of a watchlist, you can reference another watchlist symbols by selecting "Internal List" condition type.
|
|
|
|
|
Peter Gum
2010-12-12 11:29:24
0
|
|
Thanks. But i have questions:
- I tried 'custom symbols' to add symbols. It apparently does an intersection if the box is not checked. If checked, the display of symbols does not include the custom symbols, which one would like to see to confirm that the symbols have been added. What I am looking for is the union of these two sets.
- I tried the internal list. It apparently does an intersection: the only symbols showing appear in both lists separately. What I want to keep are the symbols that are *not* in the intersection (union of the two sets and then exclude the intersection; i.e., none of the second set appear in the result).
-Pete
|
|
|
|
|
Peter Gum
2010-12-12 11:38:21
0
|
|
On the second point above, I did indeed get it working. A simple oversight on my part: just set the filter mark to "X" rather than a check mark. That filters 'out' rather than 'in'. QS already has the capability I was looking for. -Pete
|
|
|
|
|
Peter Gum
2010-12-12 12:09:23
0
|
|
On the first point: the difficulty seems to be that my formula steps are run after the symbols are added and then not selected by those criteria. I would like those criteria to not apply. How would I add symbols afer formula execution, or as the last step of the formula?
-Pete
|
|
|
|
|
QuantShare
2010-12-13 04:03:47
0
|
|
We will add this capability in the next version.
|
|
|
|
|
Peter Gum
2010-12-13 07:22:36
0
|
|
Excellent! Icing in the cake. One essential feature of my strategy is a daily regeneration of the watchlist, letting symbols 'naturally' drop out and others appear. QS already has the best I have seen mechanisms for performing and refining this process. The above capabilities add rather nice flexibility in how a watchlist can be assembled out of pieces. Thanks. Looks good to me.
|
|
|
|
|
QuantShare
2011-01-05 05:25:22
0
|
|
We have created an "AND" operator in the Symbols Filter control
|
|
|
|
|
Peter Gum
2011-01-05 07:06:15
0
|
|
Looks promising, but I need a bit more help: I don't quite understand how to use it? I can add the line to the table, but to what does it apply? I can't move/insert that line above the current last line, for example, to make it apply to an existing line. -Pete
|
|
|
|
|
QuantShare
2011-01-05 09:17:17
0
|
|
The "And" line instructs the application to add the symbols that meet the above criteria to the symbols that meet the below criteria
Example:
Name: A*
Market: NYSE
AND
Market: NASDAQ
This will return NYSE stocks whose symbol starts with "A" plus NASDAQ Stocks.
You can use it to create a composite watchlist (Union)
Watchlist 1
AND
Watchlist 2
|
|
|
|
|
Peter Gum
2011-01-05 16:43:37
0
|
|
Thanks. But let me ask some follow up questions: In the above, "Name:A*" does not apply to "Market:NASDAQ"? Also, if there is an "X" in front of Watchlist 2, the symbols it contains will be excluded from the whole list? That is, I don't understand the interplay between checkmarks, "X" and AND. -Pete
|
|
|
|
|
QuantShare
2011-01-06 05:35:53
0
|
|
"Name:A*" does not apply to "Market:NASDAQ".
If there is an "X" in front of Watchlist 2 then the above filter will return:
Symbols in watchlist 1 + All symbols except symbols in Watchlist 2.
When an "AND" is found, the filter is separated in two different filters (one with the conditions that are above "AND" and another with the conditions that are below "AND"). The final result is the union of the symbols returned by each filter.
|
|
|
|
|
Peter Gum
2011-01-06 07:19:19
0
|
|
Thanks. I need to experiment with this. There's a lot of capability in there to work with . . .
-Pete
|
|
|
|
|
0
