Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Price move calculator for a gold shop's stock

Price move calculator for a gold shop's stock

If the 24K gram price rises or falls by a given amount, how much does the value of my gold change?

Every time the price moves, the value of the gold in the shop moves with it. This sheet works out that effect for a move you type, up or down. This calculator is the same as the "The price moved: how much did my stock gain or lose?" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

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

ItemKaratWeight (g)Pure gold (g)Value beforeValue after the moveDifferenceDelete

Result

Who this calculator is for

This is the online version of the "The price moved: how much did my stock gain or lose?" sheet, made for goldsmiths and shop owners. A sheet that works out the effect of a price move on a shop's stock: for each karat, the pure gold and its value before and after the move, and the difference. The move is a figure you type, up or down.

The question it answers: If the 24K gram price rises or falls by a given amount, how much does the value of my gold change?

How to use it

  1. The price: Today's buying price for one gram of 24K.
  2. The move: How many pounds up or down.
  3. The stock: Each item with its karat and weight.
  4. The calculation: The pure gold and the value before and after.
  5. The effect: The difference in pounds and as a percentage.

Worked example

Buying price, 1 g of 24K today (example): 7,009.37 · Move in the 24K gram price, EGP, minus if it falls (example): −100.00

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

ResultValue
Total pure gold (g)1,447.268
Value before10,154,587.98
Difference−144,871.62
Difference %−1.43%

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

Stock
All the gold the shop holds: jewelry on display, bars, and scrap waiting to be sold or refined.
Pure gold
Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure, and Qintar counts 24K as 0.999.
Buying price
The price at which a shop buys gold. The sheet values the stock at this price, as it is what the gold would fetch.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: How a gold price move hits a shop's stock: work it out.

Frequently asked questions

Is the move a forecast?

No. You type the figure to see its effect. Try several figures.

Why work in pure gold?

So that every karat is moved by the same amount: the 21K and 18K prices move in proportion to their purity.

Does it include the making charge?

No. The making charge does not move with the gold price, so the calculation covers the gold only.

Does the result change my profit?

Not by itself. It is the change in the value of the gold you hold on paper. It becomes real when you buy or sell at the new price.

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