Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Local and world gold price: how big is the gap?

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

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 KBDownload Excel61 KB

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.

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

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

DayOunce (USD)Dollar rate (EGP)Local price, 1 g of 24KWorld price per gram in EGPGap (EGP)Gap %Implied dollar
Example: day 14,590.0047.607,032.377,017.4014.970.21%47.70
Example: day 24,610.0047.607,065.007,047.9817.020.24%47.71
Example: day 34,575.0047.657,040.007,001.8138.190.55%47.91
ResultValue
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

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

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

All free sheets