Auto-updating Gold and Silver Spreadsheet for Coin & Bullion Holders v3.10

This autoupdating spreadsheet updates metals prices live including conversion rates for the Canadian Dollar, thus generating results in $US and $CDN.  Click on the following thumbnails to see screenshots of the Silver and Gold sheets. Also included are simple calculator s for obtaining the value of an arbitrary number of grams or Troy ounces of Silver or Gold. 
V3.08 Update January 4, 2017: Made some more changes to fix broken update for  gold, silver
V3.09 Update April 7, 2018: Simplified and drastically sped up the web query process for silver, gold and $USD/$CAD conversion.
V3.10 Update August 28, 2018: Fixed broken links.

SilverScreenshot GoldScreenshot          

Just enter the quantities of the coins or bullion you have and the spreadsheet will keep track of the value of your portfolio. If you enable the autoupdate feature and have an internet connection, then your spreadsheets will update with live prices for Silver and Gold as well as for the Canadian and U.S. Dollar exchange rate from Kitco. You can easily modify the spreadsheet to suit your own needs. I have made some fictitious quantity entries to help give you an idea of what the spreadsheet does.

Download the latest GoldSilver spreadsheet here.

Go back to my gold and silver page here.