Is the APMEX gold link broken?

[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.

[Bean]

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....

[Khisanth]

Code: Select all

=Index(ImportHTML("http://apmex.com/","table",1),2,2)

[dualstow]

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.

[Bean]

Awesome

For Silver if you track that also:

=Index(ImportHTML("http://apmex.com/","table",1),3,2)

[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.