Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Gold to silver ratio: a daily log

Gold to silver ratio: a daily log

Free sheet for individuals · 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.

Download PDF127 KBDownload Excel60 KB

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. Or try it online without downloading.

Preview of the first page of the "Gold to silver ratio: a daily log" sheet, with the table and the worked example

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.

Example The calculation with numbers

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

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

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.

Read more

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. Check tax matters with your accountant.

Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.

More free sheets

All free sheets