# Gold to silver ratio: a daily log | Free sheet

> Free Excel and PDF gold to silver ratio log: the daily local price of 1 g of 24K gold and 1 g of 999 silver, the local ratio and the world ratio.

Source: https://qintar.app/en/sheets/gold-silver-ratio-log.html
Language: English
قنطار (Qintar)، qintar.app

---

# 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 KB](https://qintar.app/en/sheets/gold-silver-ratio-log.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-silver-ratio-log.xlsx)

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](https://qintar.app/en/tools/gold-silver-ratio-log.html).

![Preview of the first page of the "Gold to silver ratio: a daily log" sheet, with the table and the worked example](https://qintar.app/en/sheets/gold-silver-ratio-log.png)

## 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

| 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 it](https://qintar.app/en/articles/gold-silver-ratio.html)A step-by-step guide with a worked example.
- [Gold to silver ratio calculator](https://qintar.app/en/tools/gold-silver-ratio-log.html)The 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html)If I split my buying over several prices, what will my average cost be?
- [Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.html)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?](https://qintar.app/en/sheets/workshop-production-tracker.html)How many days did each order spend in each stage, and is it late against what was agreed?

[All free sheets](https://qintar.app/en/sheets/)
