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”
   }