import index XAO price into google sheet

Question

I'm trying to load the asx all ords (INDEXASX: XAO) price into a Google sheet cell. Most stocks return a result like BHP below, but cannot get an index like XAO to work.

=googlefinance("asx:bhp", "price") This works for BHP.

=googlefinance("INDEXASX: XAO", "price") This doesn't work for XAO.

score 0 · Accepted Answer · answered Dec 17 '18 at 19:13

0

=googlefinance("indexasx:XAO")

works for me.

answered Dec 17 '18 at 19:13

pnuts

58,317
11
87
139

import index XAO price into google sheet

1 Answers1