Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. The price moved: how much did my stock gain or lose?

The price moved: how much did my stock gain or lose?

Free sheet for goldsmiths and shop owners · 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.

Download PDF137 KBDownload Excel60 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 "The price moved: how much did my stock gain or lose?" sheet, with the table and the worked example

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.

Example The calculation with numbers

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

ItemKaratWeight (g)Pure gold (g)Value beforeDifference
Example: 21K on display211,286.7001,125.8637,899,486.32−112,698.95
Example: 18K on display18162.000121.500852,490.95−12,162.16
Example: bars2495.00094.905665,890.15−9,500.00
Example: 21K scrap21120.000105.000736,720.57−10,510.51
ResultValue
Total pure gold (g)1,447.268
Value before10,154,587.98
Difference−144,871.62
Difference %−1.43%

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

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.

Read more

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. 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