Page 1 of 1
Is the APMEX gold link broken?
Posted: Tue Jun 04, 2013 11:44 am
by dualstow
I mean this one, which is useful in gDocs:
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",7),2,2)
Everything fails once in a while, but it's been several days now.
Re: Is the APMEX gold link broken?
Posted: Tue Jun 04, 2013 11:49 am
by Bean
dualstow wrote:
I mean this one, which is useful in gDocs:
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",7),2,2)
Everything fails once in a while, but it's been several days now.
It looks like they changed their web layout, I use the same formula and it is broken for me also.
melveyr posted the formula awhile ago in this thread.
http://gyroscopicinvesting.com/forum/ht ... 171#p46171
shines Melveyr batlight into the forum sky....
Re: Is the APMEX gold link broken?
Posted: Tue Jun 04, 2013 12:27 pm
by Khisanth
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",1),2,2)
Re: Is the APMEX gold link broken?
Posted: Tue Jun 04, 2013 12:41 pm
by dualstow
Khisanth wrote:
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",1),2,2)
So just change the 7 to a 1?
Yay! It works!
Many thanks.
Re: Is the APMEX gold link broken?
Posted: Tue Jun 04, 2013 12:46 pm
by Bean
Awesome
For Silver if you track that also:
=Index(ImportHTML("
http://apmex.com/","table",1),3,2)
Re: Is the APMEX gold link broken?
Posted: Wed Jun 12, 2013 9:04 am
by dualstow
You know what's strange? I have the same code
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",1),2,2)
In two different google spreadsheets and it gives different prices. Currently, my old sheet says 1374/oz and the new one says 1381.
