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

> Free Excel and PDF sheet showing how a gold price move changes a shop's stock value: pure gold per karat, value before and after, and the difference.

Source: https://qintar.app/en/sheets/shop-price-move-impact.html
Language: English
قنطار (Qintar)، qintar.app

---

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 KB](https://qintar.app/en/sheets/shop-price-move-impact.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-price-move-impact.xlsx)

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](https://qintar.app/en/tools/shop-price-move-impact.html).

![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](https://qintar.app/en/sheets/shop-price-move-impact.png)

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

| Item | Karat | Weight (g) | Pure gold (g) | Value before | Difference |
| --- | --- | --- | --- | --- | --- |
| Example: 21K on display | 21 | 1,286.700 | 1,125.863 | 7,899,486.32 | −112,698.95 |
| Example: 18K on display | 18 | 162.000 | 121.500 | 852,490.95 | −12,162.16 |
| Example: bars | 24 | 95.000 | 94.905 | 665,890.15 | −9,500.00 |
| Example: 21K scrap | 21 | 120.000 | 105.000 | 736,720.57 | −10,510.51 |

| Result | Value |
| --- | --- |
| Total pure gold (g) | 1,447.268 |
| Value before | 10,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

- Pure gold = weight × karat purity.
- Value = pure gold ÷ 0.999 × the 24K gram price (before and after the move).
- Difference = pure gold ÷ 0.999 × the move. At the buying price, without the making charge.

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

- [How a gold price move hits a shop's stock: work it out](https://qintar.app/en/articles/gold-price-move-stock.html)A step-by-step guide with a worked example.
- [Price move calculator for a gold shop's stock](https://qintar.app/en/tools/shop-price-move-impact.html)The same sheet online, with today's prices.

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

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html)I want to reach a set number of grams in a set time. How much should I save each month?
- [Family gold register: every piece and who owns it](https://qintar.app/en/sheets/family-gold-register.html)How many grams of gold does the family own, who holds them, and what are they worth?
- [Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.html)Bars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?

[All free sheets](https://qintar.app/en/sheets/)
