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

Notification

Icon
Error
How to extract list of stocks from a Favorites folder?
Options
Go to last post Go to first unread
Previous Topic Next Topic
lurker192  
#1 Posted : Sunday, October 2, 2016 3:31:25 AM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

I've set up a folder in Favorites with a large number of stocks.  Is there an easy way

to extract that list so that I can paste it into Word or Excel please?  Thanks in advance.
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
MS Support  
#2 Posted : Tuesday, October 11, 2016 3:56:33 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
Hi, Sorry for the delay on this. There is not a direct way to do this, but what you can do is run a basic exploration that has no filter (i.e. just create a new Exploration with "C" in the column A formula box. You can then copy/paste the results of the exploration (which will include the ticker symbol) into Excel which should allow you to grab just the ticker symbol column.
Back to top
lurker192  
#3 Posted : Wednesday, October 12, 2016 3:02:00 AM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

Thanks for that MS Support! I'd remembered a way to do it using 'Reports' and print to file, but using 'Results' and 'Save List to Clipboard' is much simpler.  Hopefully a future version of MS will enable copying a list of group members out to Excel easier than it currently is.

Edited by user Wednesday, October 12, 2016 3:04:52 AM(UTC)  | Reason: Not specified
Back to top
MS Support  
#4 Posted : Wednesday, October 12, 2016 4:40:47 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
Save List is definitely an option as well (I think it is either space or tab delimited, was designed for our old QuoteCenter datafeed). You can also right-click and copy on the results (Or Ctrl-C to copy) as well. This does get the additional column into excel, but those can be stripped out leaving just the symbol column.
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET