JSON Stock Queries

Sep 26, 2011

For some reason it wasn't easy to figure out where I could get back a concise JSON response for a stock quote. I wanted this for my Portfolio Rebalance spreadsheet, where I needed to query for a stock price and then insert it into the spreadsheet.

Well after digging around I figured out you can use Google finance to get back a JSON response to any stock ticker.

http://finance.google.com/finance/info?client=ig&q=MSFT

for example, will return:

{
      "id":"358464",
      "t":"MSFT",
      "e":"NASDAQ",
      "l":"25.06",
      "l_cur":"25.06",
      "s":"0",
      "ltt":"4:00PM EDT",
      "lt":"Sep 23, 4:00PM EDT",
      "c":"0.00",
      "cp":"0.00",
      "ccol":"chb"
   }