Downloading free financial data

It’s a bit grungy, but nowadays it’s much easier than it’s ever been. I mean getting financial data. Shockingly, you can get a lot for free. Milton Friedman, eat your heart out. Granted, the data’s delayed. The breadth of available data is as wide as the English Channel, including not only price data, but also fundamental data for specific stocks.

Here are two options which seem quite reasonable:

  1. It’s possible to import the data directly Into Excel, Edgeseeker has a rather useful and free plug-in, that also has some other features, which gives you a few typical analytical tools used in finance.
  2. If you want to go closer to the source, you can use YQL (which looks like a soul sister of Microsoft’s OData protocol-or not) programmatically. This returns information in either XML or JSON format, which you can then parse and use however you want. Jarloo has a good summary.

Yahoo finance has much more data breadth than google finance, and it has for a while, so you are probably best off sticking primarily with them for most “consumer-level” needs. They use tickers that look like Reuters RIC codes, but I’m not sure of the exact details on that. Both of these sources give lots of international data. They should be enough to get any budding model builder, like you, off the ground.

One Response to “Downloading free financial data”
  1. Mauricio says:

    I was searching for this but I couldn’t find anywhere.
    Thanks a lot,

    Nice blog, btw


What do you think? Leave a comment.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s