http://www.apmex.com/ no longer lists gold prices on their main page....You should be able to just change it out for http://www.apmex.com/category/10000/gold and It should start working again. If not here is what i've been using: =ImportXml("http://www.apmex.com/category/10000/gold","...

is there any way that I can import the previous closing price rather than importing prices from WSJ, so that I can estimate real-time prices by adding the % change of TLT? =IFERROR(Importxml("http://wsj.com/mdc/public/page/2_3020-treasury-"&TEXT(TODAY()-1,"YYYYMMDD")&&qu...

Sure. By the way, it does seem to be updating in a timely manner after all. I think I got this from fnord and one other bright spark. If it looks like I'm dumbing it down, that's just in case brand new readers come across this. I know most of this will be obvious to you. =vlookup(date(2040,11,15),w...

Here try this: =ImportXml("http://wsj.com/mdc/public/page/2_3020-treasury.html","//tr[td=' 2/15/2042 ']/td[ 3 ]") Just change 2/15/2042 to the maturity date of the Bond you wish to lookup.  If you want to pull other data from the tables at http://wsj.com/mdc/public/page/2_3020-tr...

I remember TripleB talking about this a year ago.  I hope he didn't sell.

http://gyroscopicinvesting.com/forum/va ... ster-ammo/

Anyone heard from him lately?  I always enjoyed reading his posts.