Auto-updating Gold and Silver Spreadsheet for Coin &
Bullion Holders v3.09
This autoupdating spreadsheet updates prices live from http://www.kitco.com/,
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.
Update March 29, 2016: Temporary fix
account for change in KITCO data presentation (will need to find a more reliable way to get gold, silver data)
Update January 4, 2017: Made some more changes to fix broken update for gold, silver
Update April 7, 2018: Simplified
and drastically sped up the web query process for silver, gold and
$USD/$CAD conversion. Also changed the data feeds to https://www.xe.com
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.
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
the latest GoldSilver spreadsheet here.
Go back to my gold and
silver page here.