Accurate gold coin offer price scraping for the spreadsheet nerds

Discussion of the Gold portion of the Permanent Portfolio

Moderator: Global Moderator

User avatar
dualstow
Executive Member
Executive Member
Posts: 6953
Joined: Wed Oct 27, 2010 10:18 am
Location: Rand Paul's grass clippings
Contact:

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby dualstow » Wed Nov 29, 2017 11:01 am

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.
inflation is now 2.2%
User avatar
Kriegsspiel
Executive Member
Executive Member
Posts: 844
Joined: Sun Sep 16, 2012 5:28 pm

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby Kriegsspiel » Wed Nov 29, 2017 11:23 am

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.
User avatar
dualstow
Executive Member
Executive Member
Posts: 6953
Joined: Wed Oct 27, 2010 10:18 am
Location: Rand Paul's grass clippings
Contact:

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby dualstow » Wed Nov 29, 2017 11:25 am

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.
inflation is now 2.2%
flyingpylon
Executive Member
Executive Member
Posts: 325
Joined: Fri Jan 06, 2012 9:04 am

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby flyingpylon » Wed Nov 29, 2017 1:54 pm

Here's one that still works:

=Index(ImportHTML("https://www.moneymetals.com/precious-metals-charts/gold-price","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.
User avatar
dualstow
Executive Member
Executive Member
Posts: 6953
Joined: Wed Oct 27, 2010 10:18 am
Location: Rand Paul's grass clippings
Contact:

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby dualstow » Wed Nov 29, 2017 3:17 pm

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.
inflation is now 2.2%
User avatar
Cortopassi
Executive Member
Executive Member
Posts: 903
Joined: Mon Feb 24, 2014 2:28 pm
Location: Illinois

Re: Accurate gold coin offer price scraping for the spreadsheet nerds

Postby Cortopassi » Wed Dec 06, 2017 1:44 pm

flyingpylon wrote:Here's one that still works:

=Index(ImportHTML("https://www.moneymetals.com/precious-metals-charts/gold-price","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.

Return to “Gold”

Who is online

Users browsing this forum: No registered users and 2 guests