Platinum Customer
Joined: 10/7/2004 Posts: 38
|
Is it possible to Re-Order a Watchlist on a User-Defined basis? i.e. If I have a Watchlist of 50 stocks, is there a way to place the stocks I'm most interested in at the top of the list. I would be ordering them based on critieria not available in TC2000.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There is no built in way to sort a WatchList in an arbitrary user defined order.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 2/28/2012 Posts: 24
|
I don't understand why it's not a feature in the developpement pipeline. I love your solution, but without this I'm frustrated because it's all the time chaos on my watchlist.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is possible to sort your WatchList using any WatchList Column you can create so your WatchList don't need to be entire chaos. There just isn't a practical way to assign arbitrary values to symbols to use as a WatchList Column or force a particular user defined order when the WatchList is "unsorted".
Sorting based on a user defined arbitrary order has been suggested, but it is only one of many suggestions. I do not know when or if any particular suggestion might be implemented.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 2/28/2012 Posts: 24
|
Without arbitary order, when the day star it's the chaos for me in your solution.
I can't classified my index per favorite order and groupe them how I want tool.
It's really painful. I think it's simply a must.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There is a theoretical workaround. I don't consider it practical and would personally see it as more painful than not being able to set an arbitrary sort order, but you might disagree, so I will present it.
The basic idea is that you can sort by the results of formulas. This means all you need to do is create a formula which has the values returned for symbols of interest in the same order as your arbitrary sort order.
Obviously, not just any old formula is going to normally meet these requirements. Constructing a formula which will meet the requirements can usually be done, but it is a tedious manual process to do so.
I will demonstrate the technique by creating a formula which will take the Dow Jones 15 Utility Stocks and sort them in an arbitrary order:
AEP, AES, CNP, D, DUK, ED, EIX, EXC, FE, NEE, NI, PCG, PEG, SO & WMB
The sort order chosen isn't meant to be useful or an example of what somebody might actually want to do, it is just a demonstration that it is normally possible to create whatever sort order you want if you think the work of doing so is worth the results.
I am going to create an Indicator Formula to sort the list in alphabetical order of symbols if the symbols were reversed, so:
WMB, EXC, D, ED, NEE, FE, PCG, PEG, NI, DUK, SO, AEP, CNP, AES & EIX
With the Indicator Formula being:
ABS(V'10/23/2013' = 5011600) - 2 * (V'10/23/2013' = 17272900) - 3 * (V'10/23/2013' = 1940700) - 4 * (V'10/23/2013' = 3040900) - 5 * (V'10/23/2013' = 1737400) - 6 * (V'10/23/2013' = 5432200) - 7 * (V'10/23/2013' = 3487500) - 8 * (V'10/23/2013' = 3151900) - 9 * (V'10/23/2013' = 2412900) - 10 * (V'10/23/2013' = 4412500) - 11 * (V'10/23/2013' = 4988000) - 12 * (V'10/23/2013' = 6079100) - 13 * (V'10/23/2013' = 3514400) - 14 * (V'10/23/2013' = 4324600) - 15 * (V'10/23/2013' = 1210300)
Note that I chose the volume for these symbols on October 23, 2013 as each symbol is the WatchList had a different volume on that date. That said, you would just need to choose one thing that is unique about the symbol within the WatchList to use in the formula construction.
While I did not do so (the formula was constructed entirely by hand), a spreadsheet could be useful in constructing such a formula in a way that you could resort the WatchList within the spreadsheet and then have the spreadsheet automically create a formula based on the desired order.
While it shouldn't be an issue in TC2000 version 7, the data used would eventually cycle out of TC2000 version 12.3 because only the most recent 500 bars of data are available in any given time frame. This would force you to periodically choose new unique identifiers for each symbol you wished to include in your sort.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 2/28/2012 Posts: 24
|
Hi Bruce,
Thanks for the try, I really appreciate, but It's not respond to my need. I just hope you will add a true solution for that. I don't understand and can't imagine how all your client smanage their watchlist without that.
JMD
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I knew it was a longshot that the workaround would meet your needs when I posted it. I posted it anyway because it is theoretically possible to do create an arbitrary sort order in TC2000 even if I don't see it as practical to do so.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/25/2005 Posts: 2
|
It would be useful if there was a way to paste symbols into a watch list and have the order they were pasted in preserved in TC2000. This works in Stockfinder. Maybe a feature to turn off sorting.
|