google finance json stock quote stopped working [closed]

Question

So far I was using this URL to get stock quotes from google finance, and parsing the json data using PHP:

http://finance.google.com/finance/info?client=ig&q=nse:infy,nasdaq:aapl 

Today it stopped working However, I can still access this one:

http://finance.google.com/finance/?client=ig&q=nse:infy 

The problem is that this one is only returning quotes for a single stock, and not multiple ones like previous one used to do...

Anyone knows how to get stock quotes for multiple stocks using this URL? When I tried like this:

http://finance.google.com/finance/?client=ig&q=nse:infy,nse:ashokley 

it still returns some json stating that both stocks are active. But it won't include quotes etc... Any help is greatly appreciated.

Or if its not possible to get it from here, please point me to another place where I can get OHLCV data for similar stocks.

Updating on 04 Aug, 2018 Google realtime intraday backfill has also stopped working. The below URL will redirect to google search page for the symbol.

https://finance.google.com/finance/getprices?p=1d&f=d,o,h,l,c,v&q=NIFTY&x=NSE&i=60 

Answer 1

As Peter Said, Google Finance API was to shut down on October 2012. Google left the servers functioning without supporting or monitoring them. They will turn off the servers when a major bug or security hole is discovered as mentioned by Jeff Nelson here.

You can use Yahoo finance to get the prices for multiple stock symbols as follow :http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=snbaopl1

Google Ticker: https://finance.google.com/finance?q=NASDAQ:AAPL&output=json

Or you can use Google Realtime Intraday Backfill Data.

This is an overview about the above google api since it is a litile tricky. I will use the url you wrote in the comment: https://www.google.com/finance/getprices?q=.NSEI&x=NSE&i=600&p=1d&f=d,o,h,l,c,v

Here the parameter i(interval) = 600 seconds = 10 minutes.

One tricky bit with the first column(date) has the full and partial timestamp.(Please check the notes in image )

The first row has timestamp = 1504669800. The second row in the data set in image has an interval of 1. You can multiply this number by our interval size (600 s, in this example) and add it to the last Unix Timestamp. That gives you the date for the current row. (So our second row is 10 minutes after the first row. Easy.)

1504669800 + (1 * 600) = 1504670400 -> timestamp for second row 1504670400 + (2 * 600) = 1504671600 -> timestamp for Third row ... and so on. 

The last row (in the bottom) has the highest date and the latest tick.

It is easy to convert the unix time stamp to formatted date in any programming language, php example:

<?php $timestamp=1504669800; echo gmdate("Y-m-d\TH:i:s\Z", $timestamp); ?> 

Online Convertor Here

Hope this help.

Answer 2

It seems to be Google Finance API down today (September 6, 2017). You can use alphavantage as an alternative FREE API with JSON output for U.S. Stocks