google-sheetsstocksgoogle-finance

Getting Tokyo stock price data to appear on Google spreadsheet

I have no problem retrieving price data of US stocks. For example, to retrieve Apple price data, this formula =GOOGLEFINANCE("AAPL","changepct")/100 works fine. When I tried to retrieve Tokyo stocks price data, this formula GOOGLEFINANCE("TYO:1969","changepct")/100 cannot work. Both formulas look similar. I cannot figure out why. Is it because Tokyo stocks are not supported by Google Finance?

Solution

  • Is it because Tokyo stocks are not supported by Google Finance?

    Yes.

    Try and the error message presently includes:

    When evaluating GOOGLEFINANCE, Google Spreadsheets is not authorised to access data for exchange: 'TYO'