3

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?

guagay_wk
  • 26,337
  • 54
  • 186
  • 295
  • =GOOGLEFINANCE("TYO","changepct")/100 seems to work – Leo May 01 '15 at 04:58
  • 1
    Unfortunately, TYO is listed in the US exchange, not Tokyo. – guagay_wk May 01 '15 at 05:45
  • https://support.google.com/docs/answer/3093281?hl=en-US says "GOOGLEFINANCE is only available in English and does not support most international exchanges" – Leo May 01 '15 at 05:50
  • Actually, it support most international exchanges so far except Tokyo so far from my experience. I was hoping I made some mistake. – guagay_wk May 01 '15 at 05:51
  • 1
    it's a shame, actually. I've heard that old google spreadsheets could support tokyo stocks – Leo May 01 '15 at 05:58

3 Answers3

8

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'

pnuts
  • 58,317
  • 11
  • 87
  • 139
0

My solution: Scrape the price from Google Finance website.

=IMPORTXML("https://www.google.com/finance/quote/1969:TYO","//div[@class='YMlKec fxKbKc']")

This will give you "¥1,570.00". If you want to convert it to a number use the below:

=VALUE(REGEXREPLACE(IMPORTXML("https://www.google.com/finance/quote/1969:TYO","//div[@class='YMlKec fxKbKc']"), "[¥]", ""))
Chris
  • 1
-1

A simple solution is to use the German stock exchanges and convert the euro rates to dollars or yen with googlefinance. So for example: DIP for KDDI

Ralf Borni
  • 1
  • 1
    Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Feb 12 '22 at 00:26