Geek asks and answers

How to get Taiwan stock exchange index in google spreadsheet

How to get Taiwan stock exchange index in google spreadsheet? This index exists in google finance under https://www.google.com/finance?q=TPE%3ATAIEX

I tried the following formula, but they all 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")
+3
source share
2 answers
=GoogleFinance("TWII"; "price")
+2
source

I can offer you 2 works:

:
Google script . http://www.bloomberg.com/quote/TWSE:IND. , , script URL- .
, , , "," ".". .

function twn(){
var feed = UrlFetchApp.fetch("http://www.bloomberg.com/quote/TWSE:IND");  // URL of your favorite site
  var taux = feed.getContentText().match(/meta itemprop\="price" content\="[0-9,\.]*"/); // looking for a regexp in the retrieved page
  taux = taux[0].slice(31,taux[0].length-1); // cleaning around what you retrieved
  taux = taux.replace(",",""); // french trick
  taux = taux.replace(".",","); // french trick
  Logger.log("taux: "+taux); // a little log to check Is I'm not doing anything bad
  return(taux); // result displayed in your spreadsheet when you call function twn()
}

:

:
=mid(REGEXEXTRACT(concatenate(Importdata("http://www.bloomberg.com/quote/TWSE:IND"));"itemprop=""price"" content=""[0-9,\.]*");27;10)

+1

More articles:


All Articles