- Qintar
- Free sheets
- Gold to silver ratio: a daily log
Gold to silver ratio: a daily log
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.
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.

How to use it
- The prices: 1 g of 24K gold and 1 g of 999 silver, local prices.
- The world prices: The two ounce prices, if you want them.
- The ratio: The sheet works out both ratios.
- Follow up: One line for each day.
- Compare: Local against world.
Example The calculation with numbers
| Day | 1 g of 24K gold (EGP) | 1 g of 999 silver (EGP) | Local ratio | World ratio |
|---|---|---|---|---|
| Example: day 1 | 7,032.37 | 88.08 | 79.8 | 80.0 |
| Example: day 2 | 7,065.00 | 89.10 | 79.3 | 79.3 |
| Example: day 3 | 7,040.00 | 87.60 | 80.4 | 0.0 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Local ratio = price of 1 g of 24K gold ÷ price of 1 g of 999 silver.
- World ratio = price of an ounce of gold ÷ price of an ounce of silver (if you type them).
- The ratio tells you how many grams of silver a gram of gold is worth. It does not say what will happen.
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
- The gold to silver ratio: what it is and how to find itA step-by-step guide with a worked example.
- Gold to silver ratio calculatorThe same sheet online, with today's prices.
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
- Buying gold at several price levelsIf I split my buying over several prices, what will my average cost be?
- Comparing suppliers: which making charge is cheaper?For an order of a given weight, which supplier has the lowest real making charge after the discount?
- Order production tracker: which stage ran late?How many days did each order spend in each stage, and is it late against what was agreed?