JSON Stock Queries

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.


for example, will return:

      "ltt":"4:00PM EDT",
      "lt":"Sep 23, 4:00PM EDT",