logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
tigershark  
#1 Posted : Thursday, November 29, 2012 9:13:45 PM(UTC)
tigershark

Rank: Newbie

Groups: Registered, Registered Users
Joined: 8/8/2009(UTC)
Posts: 1

Does anyone know if there is a way of sorting stock lists by exchange? For instance, I may only want the S&P 500 stocks that are NYSE listed, and disregard the Nasdaq listed stocks. I can't figure this out without checking (or unchecking) the individual box next to each stock in the stock lists. Thoughts that I was unable to implement: 1. Check if a stock in on multiple lists. For instance, only output stock if on both S&P 500 list and NYSE list. 2. Create Explorer based on name of symbol. Only output stock if symbol contains ".n", which designates the stock a NYSE stock in the MetaStock stock lists.
John S  
#2 Posted : Friday, November 30, 2012 9:54:20 AM(UTC)
John S

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/9/2012(UTC)
Posts: 169

There are several other way you could do this. For example you could use Excel. From The Explorer, copy the NYSE instruments to Excel. Then do the same for the SP500. Then do your Excel magic. I don't know the exact steps in Excel off the top of my head, but I know it could be done pretty easily.

If you are using MetaStock 12, you could create a custom list using the Custom List Manager. You'd have to invest a bit of time up-front, but once done you should be set.


hk88888  
#3 Posted : Wednesday, April 3, 2013 6:01:17 AM(UTC)
hk88888

Rank: Member

Groups: Registered, Registered Users
Joined: 6/25/2012(UTC)
Posts: 12

I had this problem too.. but just by coincidence, I managed to find a way to to do this!

Follow the normal procedure to run an exploration - when you click on 'Add securities', add all of your securities to the list... then just click on the 'Composite' column header.. and this should sort all the securities by exchange (or rather the symbol suffix).
John S  
#4 Posted : Wednesday, April 3, 2013 9:39:36 AM(UTC)
John S

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/9/2012(UTC)
Posts: 169

Nice suggestion. This would work for local data folders in versions 11.0 and older, but not in 12.0.

Thanks
Users browsing this topic
Guest (Hidden)
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.