- Qintar
- Free sheets
- Local and world gold price: how big is the gap?
Local and world gold price: how big is the gap?
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.
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 ounce: The ounce price in US dollars.
- The dollar: The dollar rate you want to compare with.
- The local price: The local selling price of 1 g of 24K.
- The gap: The sheet works out the gap and its percentage.
- 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 gapA step-by-step guide with a worked example.
- Local versus world gold price calculatorThe 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.
More free sheets
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?