New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Sorting Chartlists (not charts) in a predetermined order?
Dear friends, do you have any idea how to sort the order of appearance of Chartlists (not charts within a Chartlist)? 001 etc does not seem to work. Thanks for your advice, Robert
0
Comments
However, you can determine list order by name because the chart list names appear in alphabetical order.
Here's a screen shot of my lists for the Energy sector:
The numbers on the left determine the order the lists appear in. Probably more complicated than necessary, but it shows that names matter.
If I needed another Energy list, I could name it 10 10 06 ... Other Energy and it would appear after 10 10 05 ... Coal.
If I wanted to change the order of the list, I might have to change the names of multiple lists to get it right.
If you add a list and it doesn't appear where you think it should, click away from the list page and come back. When the list page is refreshed, the lists should be in alpha order.
Example: My chartlist for this scan needs to be called AB Not as good as AA . If I name the scan used AB Not as good as AA, when I run the scan I can save the results to a new list and the chartlist name will be setup, automatically as AB Not as good as AA (plus the date run).
Naming conventions (how you name things) is a very important thing when dealing with chartlists. The more lists you create the more obviously important it becomes.
For instance, you can use the first grouping to order by sector
10 Energy
15 Materials
20 Industrials
etc.
Then a second grouping to order by industry
10 10 Energy - Integrated O&G
10 20 Energy - Exploration and Production
Then you could use a third grouping to order the list by, say, dividend, or by SCTR rank or whatever.
10 10 10 Energy - Integrated by yield
10 10 11 Energy - Integrated by SCTR
And so on.
I would think this method would allow you to replicate your spreadsheet pretty handily. You can space out the numbers (e.g. 10, 15, 20.. ) so you can add new groups between the old groups ( e.g. 10, 12, 15, 17, 20, etc.) if your spreadsheet changes.
For new lists, maybe it would help to have an index card taped to the monitor to remind you what each group and sub-group represents.