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

Notification

Icon
Error

Options
Go to last post Go to first unread
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.

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,530

Thanks: 45 times
Was thanked: 121 time(s) in 117 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.
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

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,530

Thanks: 45 times
Was thanked: 121 time(s) in 117 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.
Users browsing this topic
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.