Spot prices in Google Sheets. Updated functions for you.

Update (Dec 2024): Kitco and APMEX have changed how they serve data, and I can't get the numbers into the spreadsheet anymore. If any software engineers want to see if they can figure out how to get the spot prices into google sheets, that would be the only route I can see working at this point. Sorry for the bad news.

Update (Aug 2024): Updated Kitco links as they had been changed at the source. Functions are all working as of this post. Prices should load when you open or reload the sheet. If the prices aren't updating then the sites kitco.com and apmex.com are likely updated, or not loading. Try again later.

Major: (Jan 2024) I decided to try and update these functions to pull both APMEX and KITCO numbers into Google Sheets and the old IMPORTHTML function was no longer cutting the mustard. Now using IMPORTXML instead, I've got everything set up on a Google Sheet Doc that you can view here: https://docs.google.com/spreadsheets/d/18kYQmiDFBsF3h0CxhhP5gLU6pLhxao7xTvEVmiNJq90/edit?usp=sharing

The new functions are very specific and you can highlight a cell in the doc above to see them individually. Here are 2 examples of the new function for Silver:

Kitco:

=IMPORTXML("https://www.kitco.com/price/precious-metals/","/html/body/div[1]/main/div[1]/div[2]/div[2]/div/ul/li[2]/div/span[2]")

APMEX:

=IMPORTXML("https://widgets.apmex.com/widget/spotprice/", "/html/body/div/div/table/tbody/tr[3]/td[2]")

Cheers!

Mini FAQ:

**Q: Does this work in Excel?**A: I have no idea. Google Sheets is free.

**Q: Can you do this for other spot price providers like KitCo or SDBullion?**A: Maybe, it depends. Send me a DM.

Updated: Grammar/Formatting

Note: I do this for free, but I do like gifts of SILVER, hint, hint. ;)