$5 · one-time · instant download
Silver Stacking Spreadsheet
The calculator values a coin in seconds. The Silver Stacking Spreadsheet keeps the whole record — every coin and bar, what you paid, and your running melt value and profit/loss — auto-calculated from the spot price you enter. One file, one price, yours to keep.
- Stack Tracker — melt value, cost basis & P/L on every item, one row per coin
- Melt Reference — 21 pre-loaded coin & bullion specs (silver, gold, platinum, palladium)
- Stack totals — total melt value, total cost, total profit/loss at a glance
- Setup instructions — enter spot once, everything updates
- Excel · Google Sheets · Numbers — standard .xlsx, no app required
Secure checkout via Gumroad. Not sure yet? Grab the free printable melt-value cheat sheet first.
Why keep a stack spreadsheet?
Once you own more than a handful of coins, "what's my stack worth?" stops being a calculator question and becomes a record-keeping one. The melt value of each item moves every minute with spot, and your profit depends on what you paid — often across many purchases, at many prices.
- Know your real number. Total melt value vs. total cost, updated the moment you change spot.
- Track cost basis per coin. Your buy price on every item — the figure you need for profit/loss and taxes.
- Sort and audit. See your stack by metal, by type, by date, or by biggest gain.
- Stop guessing at a dealer. Walk in knowing your melt value and break-even before you sell.
What's inside
| Tab | What it does |
|---|---|
| Stack Tracker | One row per item: metal, type, quantity, fine oz/unit, melt value, what you paid, and profit/loss — all formula-driven from a single spot-price cell, with running stack totals. |
| Melt Reference | 21 pre-loaded coin and bullion specs with their published fine-metal content (US 90% & 40% silver, silver dollars, Silver Eagles, sterling, junk silver, gold by karat, platinum & palladium), so you never look a spec up again. |
| Instructions | A short setup sheet: enter spot, add your coins, read your totals. Works the same in Excel, Google Sheets and Numbers. |
Free calculator vs. the spreadsheet
| Task | Free calculator | $5 spreadsheet |
|---|---|---|
| Melt value of one coin, right now | Yes | Yes |
| Live spot pulled automatically | Yes | You enter spot once |
| Record your whole stack, item by item | Browser-only, cleared easily | Saved file |
| Cost basis & profit/loss per coin | Limited | Full P/L |
| Sort, filter, print, back up | No | Yes |
| Works offline / archive for tax time | No | Yes |
Most stackers use both: the free calculator for a quick answer, the spreadsheet for the permanent record.
Who it's for
- Silver stackers with more coins than a calculator can conveniently handle.
- Junk-silver and coin collectors who want cost basis per piece.
- Anyone preparing to sell who wants to know their break-even and melt value before talking to a dealer.
- Gold, platinum & palladium holders — the same tracker covers all four metals.
Not for you if you only ever price a single coin occasionally — the free melt value calculator is enough for that.
Frequently asked questions
What is the Silver Stacking Spreadsheet?
A $5 one-time spreadsheet download from SaltCrate that tracks your whole precious-metals stack: the melt value, the price you paid, and your running profit or loss on every coin and bar. It includes a Stack Tracker, a Melt Reference with 21 pre-loaded coin specs, and setup instructions, and it works in Excel, Google Sheets and Apple Numbers.
How does it calculate melt value and profit/loss?
You enter the current spot price once. The spreadsheet holds the fine-metal content of each coin spec, so melt value = spot price × fine-metal content × quantity. Cost basis comes from the price you paid, and profit/loss = melt value − cost basis, updated automatically for the whole stack.
Does it work in Google Sheets, Excel and Numbers?
Yes — it is a standard .xlsx file that opens in Microsoft Excel, Google Sheets and Apple Numbers. No subscription and no app required.
Which coins and metals are pre-loaded?
21 pre-loaded specs covering US 90% and 40% silver coins, silver dollars, Silver Eagles and rounds, sterling silver, junk silver, gold by karat and bar, plus platinum and palladium — each with its published fine-metal content ready for the melt-value formula.
Is this different from the free calculator?
The free calculator values one item at a time. The spreadsheet is the permanent record: every item you own, what you paid, and your total melt value and profit/loss, all in one file you can save, sort and print. Try the free calculator first if you want a feel for it.
Is the spot price automatic?
No — you enter the current spot price in one cell and the whole file updates. For a live single-item melt value, use the free calculator, which pulls spot automatically.
Track your stack's melt value & P/L
21 pre-loaded coin specs, automatic profit/loss, and one place for your whole stack — for the price of a fast-food coffee.