Precious Metals Average Cost Calculator
Reconcile up to 24 entered gold and silver purchases into separate troy-ounce quantities, weighted metal prices and all-in average costs. Import or copy an exact purchase CSV and optionally revalue both holdings using prices you enter.
Enter the purchase ledger
Keep all monetary values in one currency. Dates are optional, but enter all dates or none.
Gold and silver cost reconciliation
Precious Metals Average Cost 2.0.0.
Separate metal summaries
Gold and silver ounces and averages are never added together.
On smaller screens, scroll each table horizontally; the page itself remains contained.
| Metal | Rows | Quantity | Metal spend | Entered costs | Cash outlay | Weighted metal price | All-in average | Entered current price | Entered-current value | Current value share |
|---|
Purchase-by-purchase audit
Each row shows its own arithmetic and cumulative result for that metal only.
| Row | Date | Metal | Quantity | Price / oz | Entered cost | Metal spend | Cash outlay | Row all-in / oz | Cumulative metal quantity | Cumulative metal outlay | Cumulative metal all-in / oz |
|---|
Entered-current-price sensitivity
Both entered current prices are multiplied by the same five fixed factors.
The 75%, 90%, 100%, 110% and 125% rows are arithmetic scenarios, not gold or silver price forecasts.
| Price factor | Gold price | Silver price | Portfolio value | Difference from outlay | Difference % | Status |
|---|
How the Precious Metals Average Cost Calculator works
Row cash outlay = metal spend + entered acquisition cost
Metal-only weighted price = metal spend for that metal ÷ troy ounces for that metal
All-in average cost = cash outlay for that metal ÷ troy ounces for that metal
Entered-current value = quantity × entered current price
Gold and silver remain separate because their ounce quantities and unit prices are not interchangeable. Only same-currency cash outlay and entered-current value are combined at portfolio level.
Worked example from the audited fixture
Two entered gold rows total 0.3 fine troy oz, USD 770 of metal spend and USD 15 of costs, producing USD 2,616.67/oz all-in. Two silver rows total 30 troy oz, USD 920 of metal spend and USD 25 of costs, producing USD 31.50/oz all-in.
Total cash outlay is USD 1,730. At entered current prices of USD 2,650 gold and USD 31 silver, portfolio value is USD 1,725 and the difference from outlay is −USD 5, or −0.2890%. Those are entered-price calculations, not executable sale proceeds.
Use and limitations
- Enter fine troy ounces for gold and troy ounces for silver; do not enter coin count, grams or gross package weight.
- Enter premiums, commissions, shipping or other acquisition costs once. Do not duplicate a cost already included in unit price.
- The currency field is a label only. Convert mixed-currency records before entry.
- Dates are optional ledger evidence. Same-day rows are allowed, but dated rows cannot move backwards.
- No live quote, historical return, authenticity check, selling spread, storage, insurance, tax lot or disposal method is supplied.
- Mechanical scenarios do not forecast returns or recommend gold, silver or any allocation.
Frequently asked questions
- For each metal, the calculator totals entered quantity times price plus entered acquisition costs, then divides that metal’s total cash outlay by its troy-ounce quantity.
- Gold and silver ounces have different unit prices and are not interchangeable. Only same-currency cash amounts and entered-current values are combined.
- Enter the acquisition costs you want reflected in all-in average cost. Leave a row cost at zero if its entered price already includes every intended cost.
- It accepts five columns with the exact header date, metal, troy_ounces, price_per_troy_ounce, extra_cost. Metal must be XAU or XAG, with up to 24 rows.
- They multiply both current prices you entered by 75%, 90%, 100%, 110% and 125% and revalue the same quantities. They are mechanical cases, not forecasts.
- No. Tax lots, currency rules, fee treatment, disposals and basis methods vary by jurisdiction. This tool only reconciles entered acquisition arithmetic.
- No. Convert fine-metal content to troy ounces first. Do not use coin count, gross item weight or avoirdupois ounces.
- No. It excludes any unentered dealer spread, selling fee, tax, storage, execution or product-specific term and is not a realizable quote.
Sources and methodology
- LBMA — The Price — documents gold and silver price quotation per troy ounce.
- The Royal Mint — Bullion premiums — explains why physical-product prices can include costs above underlying metal value.
- CFTC — Precious Metals Consumer Advisory — highlights markups, fees and the difference between quoted metal prices and transaction economics.
Precious Metals Average Cost 2.0.0 runs deterministic entered-data arithmetic in the browser and retrieves no account, dealer or market data.
Continue metals planning
Compare Top Forex Brokers
Purchase-ledger arithmetic does not establish a broker product, execution quality or suitability. Verify the current entity, account, instrument, ownership structure, costs and jurisdictional terms independently.
Risk and affiliate disclosure: precious metals, forex and CFD products can lose value, and leveraged products can produce substantial losses. These are affiliate links, so ForexMT4Indicators.com may receive compensation if you register or trade through them, at no additional cost to you. Availability and terms vary by jurisdiction and entity.