# Local and world gold price: how big is the gap?

> Free Excel and PDF sheet comparing the Egyptian gold price with the world price: 24K per gram in EGP from the ounce and dollar, the gap and implied dollar.

Source: https://qintar.app/en/sheets/local-premium-tracker.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for individuals · By what percentage is the gold price in Egypt above the world price?

The gold price in Egypt is built from the world price and the dollar, but it is not always equal to it. This sheet works out the gap and its percentage day by day, and the dollar rate implied by the local gold price.

[Download PDF133 KB](https://qintar.app/en/sheets/local-premium-tracker.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/local-premium-tracker.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/local-premium-tracker.html).

![Preview of the first page of the "Local and world gold price: how big is the gap?" sheet, with the table and the worked example](https://qintar.app/en/sheets/local-premium-tracker.png)

## How to use it

1. **The ounce:** The ounce price in US dollars.
2. **The dollar:** The dollar rate you want to compare with.
3. **The local price:** The local selling price of 1 g of 24K.
4. **The gap:** The sheet works out the gap and its percentage.
5. **Implied dollar:** The dollar rate that makes the two prices equal.

## Example The calculation with numbers

| Day | Ounce (USD) | Dollar rate (EGP) | Local price, 1 g of 24K | World price per gram in EGP | Gap (EGP) | Gap % | Implied dollar |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Example: day 1 | 4,590.00 | 47.60 | 7,032.37 | 7,017.40 | 14.97 | 0.21% | 47.70 |
| Example: day 2 | 4,610.00 | 47.60 | 7,065.00 | 7,047.98 | 17.02 | 0.24% | 47.71 |
| Example: day 3 | 4,575.00 | 47.65 | 7,040.00 | 7,001.81 | 38.19 | 0.55% | 47.91 |

| Result | Value |
| --- | --- |
| Average gap % | 0.33% |

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

## The calculation

- World price of 1 g of 24K in EGP = ounce ÷ 31.1034768 × 0.999 × dollar rate.
- Gap = local price − world price, and its percentage = gap ÷ world price.
- Implied dollar = local price ÷ (ounce ÷ 31.1034768 × 0.999).

## Terms used on this sheet

- **Troy ounce:** The unit for world gold prices: 31.1034768 g.
- **Premium:** A positive gap between the local price and the world price (علاوة). A negative gap is a discount.
- **Goldsmiths' dollar:** The dollar rate implied by local gold prices, as gold traders talk about it (دولار الصاغة). It can differ from the official rate.

## Read more

- [Local and world gold prices: working out the gap](https://qintar.app/en/articles/local-vs-global-gold-price.html)A step-by-step guide with a worked example.
- [Local versus world gold price calculator](https://qintar.app/en/tools/local-premium-tracker.html)The same sheet online, with today's prices.

## Frequently asked questions

**Which dollar rate do I type?**

You choose: the official rate, or the one the app shows. The sheet calculates with the figure you type, and that changes the result.

**Why multiply by 0.999?**

In Qintar's calculations 24K is 99.9% pure, so a gram of 24K holds 0.999 g of pure gold.

**What is the implied dollar?**

It is the dollar rate at which the world price would come out exactly equal to the local price. It is close to the idea of the "goldsmiths' dollar".

**Why divide by 31.1034768?**

World gold prices are quoted per troy ounce, and one troy ounce is 31.1034768 g. Dividing gives the price of a gram of pure gold in dollars.

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

- [Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.html)What does each order cost, how much has the customer paid, and what is still due?
- [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html)Did the piece go back to the customer at the same weight? And what does the repair cost?
- [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html)How many pieces and grams do I have in each category and karat, and what are they worth?

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