# A gold trade journal: realized gains versus paper gains

> How to record gold trades: cost with the fee and VAT, realized gain or loss when you sell, and open trades at today's buying price, with an example.

Source: https://qintar.app/en/articles/gold-trades-journal.html
Language: English
قنطار (Qintar)، qintar.app

---

How much did I gain or lose on each gold trade I closed? And what are the ones I still hold worth?

A gain on gold comes in two kinds: realized, meaning you sold and were paid, and on paper, meaning you still hold the gold and the price has moved. Mixing them up gives a false impression.

The real cost is not just the price per gram: there is the fee per gram and its VAT. And when you sell, there may be a deduction. The sheet counts all of them.

An open trade is valued at today's buying price, because that is the price you would be paid if you sold. Value it at the selling price and it looks better than it is.

The journal does not tell you what to do, but it shows the result of your past decisions in numbers.

## Two prices in every Egyptian quote

Egyptian gold shops quote a selling price, which you pay when you buy, and a lower buying price, which you get when you sell. On a bar you also pay a fee per gram, with 14% VAT on the fee only.

So every trade starts slightly behind. The journal makes that visible: a trade bought recently can show a small paper loss even if the price has not moved, and only a rise above your cost turns it into a gain.

## The example in plain words

A 10 g bar was bought at EGP 6,650 a gram with a EGP 90 fee: a cost of EGP 67,526.00. It was sold at EGP 7,009.37 a gram for a realized gain of EGP 2,567.70, or 3.8%.

A 5 g bar bought at EGP 6,890 with a EGP 100 fee cost EGP 35,020.00. At a buying price of EGP 7,009.37 it shows a paper gain of EGP 26.85. A 20 g bar bought at EGP 7,150 cost EGP 145,052.00 and shows a paper loss of EGP 4,864.60.

Overall: EGP 2,567.70 realized, a paper loss of EGP 4,837.75 on the open trades, and an overall loss of EGP 2,270.05 on a cost of EGP 247,598.00. The realized gain is real money; the paper loss is only a figure until the bars are sold.

## The calculation

- Cost = grams × (price per gram you paid + fee per gram × (1 + VAT)).
- Realized = grams × sale price × (1 − deduction) − cost (closed trades).
- On paper = grams × today's buying price − cost (open trades).

## Example A worked example

VAT on the fee (example 14%): 14% · Today's buying price, same karat (example): 7,009.37

| Trade | Grams | Cost | Realized gain / loss | Paper gain / loss | % | Status |
| --- | --- | --- | --- | --- | --- | --- |
| Example: 10 g bar | 10.000 | 67,526.00 | 2,567.70 | 0.00 | 3.8% | Closed |
| Example: 5 g bar | 5.000 | 35,020.00 | 0.00 | 26.85 | 0.1% | Open |
| Example: 20 g bar | 20.000 | 145,052.00 | 0.00 | −4,864.60 | −3.4% | Open |

| Result | Value |
| --- | --- |
| Realized (closed trades) | 2,567.70 |
| On paper (open trades) | −4,837.75 |
| Total | −2,270.05 |
| Total cost | 247,598.00 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

## Terms used on this sheet

- **Realized:** A gain or loss on a trade you have closed: you sold and were paid.
- **On paper:** A gain or loss on gold you still hold, at today's buying price. It changes every day until you sell.
- **Bar fee:** The fee per gram a shop charges on a gold bar, with 14% VAT on the fee only.
- **Deduction:** A percentage some shops take off when they buy back gold.

## Step by step with the sheet

1. **The purchase:** The grams, the price per gram you paid and the fee per gram.
2. **The sale:** The price per gram you sold at, and the deduction, if you sold.
3. **Today's price:** Today's buying price, to value what you still hold.
4. **The result:** Realized and paper results for each trade.
5. **The totals:** Total realized, total on paper and total cost.

**The sheet is free:** [Gold trade journal: gain or loss?](https://qintar.app/en/sheets/gold-trade-journal.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/gold-trade-journal.html) with today's prices.

## Frequently asked questions

**Does the sheet tell me when to sell?**

No. It only works out the result of what you have done, and it does not predict prices.

**Why value open trades at the buying price?**

Because that is the price you would be paid if you sold today, so it is the most honest figure for what an open trade is worth.

**What if my trades are in different karats?**

The sheet has one valuation price. Split the trades over two copies, one per karat.

**Why does a trade bought today already show a small loss?**

You bought at the selling price and paid a fee and its VAT, while the trade is valued at the lower buying price. The price has to rise by that gap before the paper result turns positive.

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)
