- Qintar
- Calculators
- Gold trade journal: realized and on paper
Gold trade journal: realized and on paper
If you buy and sell gold over time, it is hard to know from memory how much you really made. This sheet records every trade and keeps the realized result apart from the result on paper. This calculator is the same as the "Gold trade journal: gain or loss?" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Gold trade journal: gain or loss?" sheet, made for individuals. A journal for every trade: the grams, the price you paid, the fee per gram and its VAT, the price you sold at and any deduction, the realized gain or loss, and the value of open trades at today's buying price.
The question it answers: How much did I gain or lose on each gold trade I closed? And what are the ones I still hold worth?
How to use it
- The purchase: The grams, the price per gram you paid and the fee per gram.
- The sale: The price per gram you sold at, and the deduction, if you sold.
- Today's price: Today's buying price, to value what you still hold.
- The result: Realized and paper results for each trade.
- The totals: Total realized, total on paper and total cost.
Worked example
VAT on the fee (example 14%): 14% · Today's buying price, same karat (example): 7,009.37
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Realized (closed trades) | 2,567.70 |
| On paper (open trades) | −4,837.75 |
| Total | −2,270.05 |
| Total cost | 247,598.00 |
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
- 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).
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.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold trade journal: realized gains versus paper gains.
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.
Related calculators
- Entry cost compared: bar, gold pound or jewelryFor which option must the price rise the least before I get my money back?
- Local versus world gold price calculatorBy what percentage is the gold price in Egypt above the world price?
- Gold bar price comparison: price per gram and premiumBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?
- What if it had been gold? Comparison calculatorThe amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?
- Buying at price levels: your average costIf I split my buying over several prices, what will my average cost be?