Code: Select all
=importhtml("http://www.coloradogold.com/htsell.php","table",1)
Nah, that's not working either. I should just type in the value manually once in a while.
Moderator: Global Moderator
Code: Select all
=importhtml("http://www.coloradogold.com/htsell.php","table",1)
I just go to kitco and type in the gold spot price. No big deal.dualstow wrote: Nah, that's not working either. I should just type in the value manually once in a while.
Thanks. Apmex just seemed to go away again and this does work.flyingpylon wrote:Here's one that still works:
=Index(ImportHTML("https://www.moneymetals.com/precious-me ... ,"table",1),2,2)
It's getting more difficult to find sites still using tables, that deliver the same page content to both browsers and Google Sheets, and don't use javascript to populate the price value, etc.
Code: Select all
=importhtml("http://www.coloradogold.com/htsell.php","table",1)
Code: Select all
=importhtml("http://www.ajpm.com/gold-bullion.html","table",0)
Mark Leavy wrote: ↑Thu Feb 04, 2021 11:07 am These two are both working for me right now.
...
Darn, they're not working for me. Thanks, anyway.
Mark Leavy wrote: ↑Thu Feb 04, 2021 11:07 am These two are both working for me right now.Code: Select all
=importhtml("http://www.coloradogold.com/htsell.php","table",1)
Code: Select all
=importhtml("http://www.ajpm.com/gold-bullion.html","table",0)