Page 1 of 1
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Nov 29, 2017 11:01 am
by dualstow
Damn, the colorado gold link isn't working for me anymore.
Code: Select all
=importhtml("http://www.coloradogold.com/htsell.php","table",1)
Going to try apmex again.
Nah, that's not working either. I should just type in the value manually once in a while.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Nov 29, 2017 11:23 am
by Kriegsspiel
dualstow wrote:
Nah, that's not working either. I should just type in the value manually once in a while.
I just go to kitco and type in the gold spot price. No big deal.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Nov 29, 2017 11:25 am
by dualstow
Yeah, Kitco is where I usually peek outside of spreadsheets.
I just type 'k' into the chrome browser and chrome rolls its eyes and takes me there.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Nov 29, 2017 1:54 pm
by flyingpylon
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.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Nov 29, 2017 3:17 pm
by dualstow
It does indeed work, thanks! I keep all these different lines of code in the comment section of the gold price sell of my spreadsheet. That way I can try alternates when one fails.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Wed Dec 06, 2017 1:44 pm
by Cortopassi
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.
Thanks. Apmex just seemed to go away again and this does work.
Otherwise, the other options I've considered:
1) Hey, not supposed to be looking at the PP every minute anyway. Just enter the price manually for gold.
2) Use GLD and a multiplier. I do this already as a backup. Gets you pretty close.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Thu Feb 04, 2021 10:03 am
by dualstow
None of the codes on these two pages are working for me today. Maybe it's a Google Sheets problem.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Thu Feb 04, 2021 11:07 am
by Mark Leavy
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)
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Thu Feb 04, 2021 2:32 pm
by dualstow
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.
Re: Accurate gold coin offer price scraping for the spreadsheet nerds
Posted: Fri Feb 05, 2021 2:51 am
by pors
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)
Awesome thanks! The result takes up quite a few cells, but at least it works
