Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Local versus world gold price calculator

Local versus world gold price calculator

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. This calculator is the same as the "Local and world gold price: how big is the gap?" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

DayOunce (USD)Dollar rate (EGP)Local price, 1 g of 24KWorld price per gram in EGPGap (EGP)Gap %Implied dollarDelete

Result

Who this calculator is for

This is the online version of the "Local and world gold price: how big is the gap?" sheet, made for individuals. A sheet that turns the price of an ounce in US dollars, at the dollar rate you type, into the price of a gram of 24K in Egyptian pounds, compares it with the local price, and shows the gap, its percentage and the dollar rate implied by the local gold price.

The question it answers: By what percentage is the gold price in Egypt above the world price?

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.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Average gap %0.33%

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

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Local and world gold prices: working out the gap.

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.

Related calculators

All calculators · All free sheets