Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Gold to silver ratio calculator

Gold to silver ratio calculator

How many grams of silver does a gram of gold buy today, and how does that ratio move?

The gold to silver ratio tells you how many grams of silver a gram of gold is worth. This sheet logs it day by day from local prices, together with the world ratio if you follow it. This calculator is the same as the "Gold to silver ratio: a daily log" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

Day1 g of 24K gold (EGP)1 g of 999 silver (EGP)Gold ounce (USD), optionalSilver ounce (USD), optionalLocal ratioWorld ratioDelete

Who this calculator is for

This is the online version of the "Gold to silver ratio: a daily log" sheet, made for individuals. A daily log of the local price of a gram of 24K gold and a gram of 999 silver, the gold to silver ratio, and the world ratio from the two ounce prices if you type them.

The question it answers: How many grams of silver does a gram of gold buy today, and how does that ratio move?

How to use it

  1. The prices: 1 g of 24K gold and 1 g of 999 silver, local prices.
  2. The world prices: The two ounce prices, if you want them.
  3. The ratio: The sheet works out both ratios.
  4. Follow up: One line for each day.
  5. Compare: Local against world.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

Day1 g of 24K gold (EGP)1 g of 999 silver (EGP)Local ratioWorld ratio
Example: day 17,032.3788.0879.880.0
Example: day 27,065.0089.1079.379.3
Example: day 37,040.0087.6080.40.0

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

The calculation

Terms used on this sheet

Gold to silver ratio
The price of gold divided by the price of silver, in the same unit: how many units of silver one unit of gold is worth.
Troy ounce
The unit for world gold and silver prices: 31.1034768 g.
999 silver
Silver of 999 parts per thousand, almost pure: the fineness local silver prices are quoted for.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: The gold to silver ratio: what it is and how to find it.

Frequently asked questions

What does a high ratio mean?

It means gold is expensive compared with silver on that day. The sheet only works out the ratio; it does not tell you what to buy.

Where do I get the prices?

The Qintar app shows local gold and silver prices, and the world ounce price.

Why the same kind of price, selling or buying?

So the comparison is fair: selling with selling, or buying with buying.

Why can the local and world ratios differ?

Each metal is priced locally in its own way, with its own buy-sell gap and premium. The difference between the two ratios shows that.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.

Related calculators

All calculators · All free sheets