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.
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"
}