Slick, web-based tool for comparing lots of stock histories
February 9, 2010 9:07 AM   Subscribe

Good online tool for comparing the historical results of stocks?

So I have a list of twenty stock symbols, and I want to be able to compare their historical performance for various date ranges, and slice and dice the data all different ways. Tools like Yahoo Finance aren't slick and shiny enough for me ... what are the really intuitive, Web 2.0 ways to cross-examine tons of stock performance data?
posted by jbickers to Computers & Internet (7 answers total) 6 users marked this as a favorite
I'd download the historical stock quotes into Excel and run pivot tables on them. I'm not aware of a web-based tool that does that.
posted by dfriedman at 9:09 AM on February 9, 2010

You're not going to find much in the way of slick analysis tools unless you have a Bloomberg, Mark-It, etc subscription. People pay lots of money for that kind of thing.

Download the historical price data for your 20 symbols in CSV or XLS format, then play in Excel.
posted by jckll at 9:11 AM on February 9, 2010

Don't forget about dividends!

(Everyone always forgets about dividends when comparing stocks.)
posted by smackfu at 9:17 AM on February 9, 2010 [1 favorite]

BTW, I have done this type of thing before in Excel. I have a number of out of date Excel data dumps that I've created pivot tables for (stock price data is several years old at this point).

MeMail me with your email address if you want me to send you some of these data dumps in order to give you an idea of what you'd be looking at.

Please note I won't be able to respond to this until later this evening (NYC time).
posted by dfriedman at 9:17 AM on February 9, 2010

Where you guys download this data from? EOD data? Anywhere else?
posted by delmoi at 10:21 AM on February 9, 2010

Delmoi: I've downloaded historical data from yahoo finance and google finance.

The data available may not be as granular as that available from EOD data.
posted by dfriedman at 10:54 AM on February 9, 2010

I don't know if it is slick enough for you, but I rather like Google finance's interface. It's pretty easy to overlay several different stock charts and to drag around the time period you want to look at. 20 stocks might be a bit much for it.

My job is spent analyzing a lot of stock data, and for that I always use excel (I just use Google finance for fun). Even with Excel you are going to run into problems with having 20 lines on a chart and have it still be meaningful. If you are good at using dynamic ranges/pivot tables/ pivot charts thought you could probably rig up something pretty nice looking, but it might take a bit of thought and effort.

I haven't used them personally, but depending on what you are looking for these sites might be helpful:
posted by vegetableagony at 12:24 PM on February 9, 2010 [1 favorite]

« Older Video editing for noobs   |   Help a yoga novice find the perfect yoga DVD. Newer »
This thread is closed to new comments.