Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Re-Order a Watchlist Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
pdunn
Posted : Monday, October 7, 2013 1:53:31 PM
Platinum Customer 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.

Bruce_L
Posted : Monday, October 7, 2013 1:57:07 PM


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
jmidemers
Posted : Wednesday, October 23, 2013 11:32:14 AM
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.

Bruce_L
Posted : Wednesday, October 23, 2013 11:42:22 AM


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
jmidemers
Posted : Wednesday, October 23, 2013 4:56:36 PM
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.

 

Bruce_L
Posted : Thursday, October 24, 2013 11:44:17 AM


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
jmidemers
Posted : Friday, October 25, 2013 9:58:38 PM
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

Bruce_L
Posted : Monday, October 28, 2013 11:16:13 AM


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
quimlane
Posted : Sunday, March 23, 2014 9:41:12 PM
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.

Bruce_L
Posted : Monday, March 24, 2014 7:06:06 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Thank you for your suggestion.



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