I have searched everywhere but didn't find a way for this.
It's for =Googlefinance("ticker"), Is china's SSE index available as a ticker for google finance, to be used in google sheets?
How to get China Stock Market Index (SSE) in Google Sheets using GOOGLEFINANCE?
Viewed 5921
2 Answers
did you try:
=GOOGLEFINANCE("SSE", "price")
=GOOGLEFINANCE("SSE", "all", TODAY()-7, TODAY(), "daily")
=GOOGLEFINANCE("SSE", "price", TODAY()-7, TODAY(), "daily")
or perhaps:
=GOOGLEFINANCE("LON:SSE", "price")
=GOOGLEFINANCE("LON:SSE", "all", TODAY()-7, TODAY(), "daily")
UPDATE:
=REGEXEXTRACT(QUERY(IMPORTXML("https://finance.yahoo.com/quote/000001.SS/", "//*"),
"where Col1 contains '000001.SS - SSE' limit 1 offset 2", 0), "\d+,\d+\.\d+")*1
or other source:
=IMPORTXML("https://www.bloomberg.com/quote/SHCOMP:IND/",
"//span[@class = 'priceText__1853e8a5']")*1
GOOGLEFINANCE is only available in English and does not support most international exchanges.
Related