Get historical prices for gold and silver with this free web-connected spreadsheet. You can get prices in many different currencies.
Gold and silver have been on a roll-coaster over the last few years. These two precious metals form a significant part of many portfolios, and clever investors need to keep tabs on historic prices.
That’s where this spreadsheet comes into play – it gives you quick access to historic price data across many different currencies.
This spreadsheet is really easy to use.
- choosing whether you want historic prices for either gold or silver,
- then select the currency you want prices in,
- then enter a start date and end date,
- and finish by clicking on the “Get Data” button.
The spreadsheet then connects to a web-service that provides historic prices for gold and silver, and downloads daily closing prices between the two dates. This process is fully automated and takes place behind-the-scenes with some clever VBA.
The data is placed in the “Data” sheet.
A complete list of currencies (together with their ISO 4217 currency code) is given on the right-hand side of the Parameters sheet (don’t delete this list – it’s used to populate the currency drop-down menu).