How to Download and Check Gold or Silver Price Data as CSV

The gold and silver charts on GoldSilver Tracker can now be downloaded as CSV files. This is useful when you want to inspect the observations behind a line, compare coverage across markets, or check a premium calculation in a spreadsheet.

The file is deliberately simple. It contains the observations returned for the period selected on the chart. It does not fill missing market dates, smooth the series, or turn a connected line into invented daily prices.

Downloading the file

1. Open the gold chart or silver chart.
2. Select a period from one week to three years.
3. Wait for the chart to finish loading, then choose Download CSV.

The selected period is included in the filename. Changing the visible exchange toggles does not remove columns from the download: the file keeps every available tracked market so the same export can be audited later.

What the columns mean

All price columns use the same USD-per-troy-ounce unit. This makes arithmetic comparison possible, but it does not make the underlying instruments identical. Trading hours, contract terms, delivery rules and source timestamps can still differ.

Why some cells are blank

A blank cell means that the export did not contain a valid observation for that market on that date. Common causes include weekends, exchange holidays, an unavailable source record, a missing matching exchange rate, or a collection failure. A blank is not zero, and it is not evidence that the market price was unchanged.

Spreadsheet software may draw a line across blanks depending on its chart settings. That visual choice does not create an observation. Count non-empty cells when you compare coverage, and do not replace blanks with zero before calculating an average.

Reproducing the premium

For a row containing both a benchmark and a market value, the displayed premium can be checked with:

(market_usd_per_oz - benchmark_usd_per_oz) / benchmark_usd_per_oz * 100

For example, if the benchmark is in cell B2 and the SGE value is in C2, a spreadsheet formula is =(C2-B2)/B2*100. Leave the result blank when either input is blank. Small differences from the stored percentage can occur if a spreadsheet displays fewer decimal places than the underlying values.

Three checks worth doing before analysis

• Coverage: count valid observations for each market instead of assuming that a three-year selection contains three complete years for every line.
• Dates: compare only rows where the values needed for your question are present. A matched-date comparison is usually clearer than comparing two series with different start dates.
• Source definition: read the chart legend and the methodology page. The benchmark is an aggregated USD spot reference, while SGE, MCX and the LBMA-related field come from different source arrangements.

The data status page shows recent observation counts and timestamps. Use it together with the CSV when deciding whether a period is sufficiently covered for your purpose. The export is a record of available observations, not investment advice or a complete licensed market database.