Search code examples
google-sheetsgoogle-sheets-apigoogle-financegoogle-finance-api

How to get Taiwan Stock Exchange Index in google spreadsheet

How to get Taiwan Stock Exchange Index in google spreadsheet? This index do exist in google finance under https://www.google.com/finance?q=TPE%3ATAIEX

I tried the following formula, but all of them are failed.

=GoogleFinance("TPE:TAIEX"; "price")
=GoogleFinance("TPE.TAIEX"; "price")
=GoogleFinance("TAIEX.TW"; "price")
=GoogleFinance("TAIEX:TPE"; "price")
=GoogleFinance("TAIEX.TPE"; "price")
=GoogleFinance("TPE%3ATAIEX"; "price")
Solution 
  • =GoogleFinance("TWII"; "price")