Historical Gold and Silver Prices in Excel

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.

Start by

• 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.

Your price data is returned in one of 164 currencies.

These include historic gold and silver prices in USD, GBP, CAD, CNY, JPY and many more. Just pick the currency from the drop-down menu.

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).

You can now plot and analyze this data using all of Excel’s tools. You can calculate the historic volatility, MACD, RSI and many other technical indicators.

Excel Spreadsheet to Download Historic Gold & Silver Prices from Web