Numbers no longer tracks silver and gold spot prices?
For some reason, numbers is no longer tracking silver and gold spot prices.
I should be able to use =CURRENCY(“XAG”,”USD”) to get silver spot price to appear. However, it’s giving me a number that is roughly $2.00 below that amount. A similar problem is appear for XAU, which is the symbol for gold spot price. I’ve looked at other options, like =STOCK(“SI=F”) but that’s basically useless because that’s silver futures and not spot price.
Is numbers broke? It seems like it’s a source error.