Registered User Joined: 11/8/2004 Posts: 89
|
Hello Bruce, et al,
Is there any way to have a blank column wherein one may place a number so that one can then sort the watchlist based on the numbers entered?
If this is not possible would you kindly request the ability to enter more than simply 'My Notes' which I prefer to keep in a bottom window of my charting layouts.
It is obviously not possible to rename the stocks with a number preceeding them as the charts would disappear lol. So any help would be appreciated.
Perhaps there's a pcf that you might suggest that will allow an interger of at least 2 digits to be input ? Thanks for everything,
/* Phil */
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Your last paragraph suggests the only way to do this of which I am aware.
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
|