Google sheets

Can anyone provide me with working formula which gonna return me current stock price of Aurora Cannabis (CA05156X1087) into Google sheets? tried googlefinance and finki API but none is working

=(GOOGLEFINANCE(β€œTSE:ACB”, β€œprice”))

You’ll need to format the cell as dollars

Thank you very much

1 Like