- Qintar
- Calculators
- Gold to silver ratio calculator
Gold to silver ratio calculator
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.
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
- 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.
Worked example
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| 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 |
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
- 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.
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
- Silver calculator: piece price and the value of your holdingsIs this silver piece fairly priced? How much pure silver do I own, and what is it worth?
- Silver piece pricing calculator for shopsWhat should I sell this silver piece for?
- Silver stock count calculator for a shopHow many silver pieces and grams do I have in each category, and what are they worth?
- Monthly silver savings plan calculatorIf I put an amount into silver every month, how much pure silver do I build up, and what is my average cost?
- Monthly gold savings plan calculatorIf I put a fixed amount into gold every month, how many grams do I build up, and what is my average cost?