6

Since last weekend, I encounter problems retrieving data from exchanges such as SGX and SHA.

=GOOGLEFINANCE(SGX:ES3,changepct)
=GOOGLEFINANCE(SHA:000001,changepct)

The error message is;

When evaluating GOOGLEFINANCE, Google Spreadsheets is not authorized to access data for exchange: 'SHA'

Anyone encountered the same problem and found a solution?

4
3

The Help file includes:

GOOGLEFINANCE is only available in English and does not support most international exchanges.

Google Docs Help Forum (Juln 16/12/15):

Due to issues beyond our control, the following exchanges are no longer supported in Google Sheets: TYO, INDEXTYO, BKK, INDEXBKK, SHA, INDEXCSI, SGX, & KLSE.

For a solution, maybe scrape a web page.

Not the answer you're looking for? Browse other questions tagged or ask your own question.