Goolge sheets live data

General
1

Hello,
Can someone help me with Google sheets.
I want to import live Gold usd price but it looks Google finance dosen’t provide commodities live data anymore.
Have anyone tried to get this data from any other sources?
Thanks

2 Likes
2

I dont think there is a direct way.
You can refer this and write a script

3

@Anikethan
i am using this but it has to be refreshed manually.
=ImportHTML(“Gold Dec 21 (GC=F) Stock Price, News, Quote & History - Yahoo Finance”,1)