- Qintar
- Free sheets
- Comparing gold bar prices between sellers
Comparing gold bar prices between sellers
You can find the same 10 g bar at several prices. This sheet puts the offers side by side: the price per gram, how far it is above today's price, and the gap if you sold it back to the same seller.
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.

How to use it
- The reference price: Today's selling price for one gram of 24K.
- The offers: The seller, the weight and the total price.
- Buy-back: If the seller publishes a buy-back price.
- Compare: The price per gram and the premium.
- The gap: The gap between the selling and the buy-back price.
Example The calculation with numbers
Selling price, 1 g of 24K today (example): 7,032.37
| Seller / shop | Weight (g) | Total price quoted | Price per gram | Above today's gram price | Premium % | Gap between selling and buy-back, per gram |
|---|---|---|---|---|---|---|
| Example: Offer A | 10.000 | 72,400.00 | 7,240.00 | 207.63 | 3.0% | 230.63 |
| Example: Offer B | 10.000 | 73,100.00 | 7,310.00 | 277.63 | 3.9% | 290.00 |
| Example: Offer C | 10.000 | 71,950.00 | 7,195.00 | 162.63 | 2.3% |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Price per gram = total price ÷ weight.
- Premium = price per gram − today's 24K selling price per gram (and as a percentage).
- Gap = price per gram − the published buy-back price: what you would lose if you sold straight back.
Terms used on this sheet
- Premium
- How far the price per gram of a bar is above the day's 24K gram price. It mostly reflects the bar fee and its VAT.
- Buy-back price
- The price per gram at which a seller says it will buy its own bars back.
- Bar fee
- The fee per gram on a gold bar. In the usual figures (3 November 2026) it is EGP 90 a gram on a 10 g bar, and higher on smaller bars.
Read more
- Comparing gold bar offers: which one is really cheaperA step-by-step guide with a worked example.
- Gold bar price comparison: price per gram and premiumThe same sheet online, with today's prices.
Frequently asked questions
Does the sheet compare quality or the hallmark?
No. It compares the figures only. Check the hallmark, the invoice and the seller's reputation yourself.
Why is there a premium at all?
The total price includes the bar fee and its VAT, and sometimes other charges. A premium over the gram price is normal; what matters is comparing it.
What if the seller doesn't publish a buy-back price?
Leave the cell empty. The sheet then compares the price per gram and the premium only.
Is a lower price per gram always the better deal?
Not on its own. An offer with no published buy-back price may cost more to sell later. The sheet shows both figures so you can weigh them.
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
- Gold savings goal: how much to put aside each monthI 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 itHow many grams of gold does the family own, who holds them, and what are they worth?
- What if it had been gold? Comparing in figuresThe amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?