OmarKnows

Share this post
JSON Stock Queries
www.omarknows.com

JSON Stock Queries

Omar Shahine
Sep 26, 2011
Share this post
JSON Stock Queries
www.omarknows.com

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

Share this post
JSON Stock Queries
www.omarknows.com
Previous
Next
Comments
TopNewCommunity

No posts

Ready for more?

© 2023 Omar Shahine
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing