How to Track a Gold and Silver Portfolio (2026 Guide)
By Justin · Published · Updated
Originally published April 2026. Updated and reviewed July 2026.
Owning precious metals is only half the job. If you do not know what you own, what you paid, and what it is worth today, you are making decisions with incomplete information.
Most stackers can check spot and do rough math. That tells you today's price. It does not tell you how your own position is performing, which metal you are overweight, or whether the ounce you bought last month is up or down against the one you bought three years ago. That gap, between knowing spot and actually tracking a portfolio, is where most stackers lose clarity. This guide covers what to track, how to track it, and how to keep it current.
Bottom line
A portfolio tracker should record three things: what you own, what you paid, and what it is worth today. Everything else builds from those three: allocation, gain and loss, performance over time, and estate records. You can keep them in a spreadsheet or in dedicated software. What matters is that all three are captured and stay current.
| Data point | Priority |
|---|---|
| What you own | Essential |
| What you paid, cost basis | Essential |
| Current live value | Essential |
| Allocation by metal | Nice to have |
| Portfolio history | Nice to have |
| Acquisition and estate tags | Nice to have |
Why tracking actually matters
A stack of any meaningful size is real money, and small differences in cost basis turn into large differences in real gain or loss.
Say you bought an ounce of gold a few years ago, when it traded at a fraction of today's price, and another ounce recently near the current level. A spot check treats those two ounces identically. Your actual financial picture does not. One is a large gain. The other is close to flat.
The same is true for silver. If you have accumulated junk silver over several years at different prices, your blended cost basis is what tells you whether you are actually up or down. Tracking gives you that picture. Without it, you watch the market move without knowing how your specific position is doing.
What to track
Most stackers underestimate how much is worth capturing. These are the pieces that actually matter.
| Track | Why it matters |
|---|---|
| Cost basis, price paid including premium | Your real gain and loss |
| Purchase date | Performance over time |
| Product and metal | Melt value and allocation |
| Quantity or weight | Current value |
| Acquisition type | Cost basis, taxes, estate |
| Tags and storage location | Organization and estate records |
Two of these deserve a note.
Cost basis means the total you paid, premium included, not the spot price on the day. It is the number you compare against melt value to know your real return.
Acquisition type matters because not everything was bought at market. A gifted or inherited ounce carries a different cost basis than one you purchased, which changes your gain and loss. Recording whether each piece was purchased, gifted, inherited, or traded keeps that math honest.
What not to bother tracking
Not everything needs to be in your system.
Numismatic premium above melt is real value, but it is hard to track accurately. It moves with collector demand and condition. For most stackers, melt value is the right baseline and numismatic premium is upside. The exception is active graded-coin collecting, where grade and serial fields handle it separately.
Daily price swings are noise for a long-term stacker. A good tracker surfaces the 24-hour change on its own. You do not need to watch it.
Storage location is useful for estate planning, but it does not affect melt value. A notes or tag field covers it if you want it recorded.
The three common approaches
Spreadsheet
The starting point for most stackers. Free, flexible, works on any device.
The problems show up over time: manual spot updates, no built-in silver content formulas, and a tendency to break in quiet ways. A wrong reference, a shifted formula, a stale price nobody noticed. A spreadsheet works well for a small, simple stack. It becomes a maintenance burden as the stack grows. For the full breakdown, see app vs spreadsheet.
Dealer portfolio tools
Dealers like APMEX and JM Bullion offer tracking built into your account. These work well if nearly all of your buying happens at a single dealer, because purchases populate on their own.
They fall short once your stack comes from more than one place. They only track what you bought there. Your holdings sit on the dealer's server next to your payment details. And anything from a coin show, a second dealer, a gift, or an inheritance never appears.
Dedicated portfolio tracker
The purpose-built option. A good tracker includes a product database, applies live spot automatically, and calculates melt value and gain and loss per holding with no manual work.
MyOunces is built for physical stackers. Add each purchase with its date, product, quantity, and cost, and it handles the rest. It covers 272 built-in products across gold, silver, platinum, palladium, and copper, plus dedicated tracking for constitutional silver, Goldbacks, and Silverbacks. Tag any holding by acquisition type so cost basis stays accurate.
For deeper analysis, the Intelligence Hub adds portfolio value over time, per-tag breakdowns, and a gold to silver ratio calculator. Full JSON backup and CSV import and export mean your data moves in and out freely. Everything stays in your browser. No account, no server, no login.
The difference from a dealer tool is independence. MyOunces tracks everything regardless of where you bought it: coin shows, multiple dealers, inherited pieces, gifts, trades. For a side-by-side of dedicated trackers, see best gold and silver portfolio trackers.
Setting up: what order to do it in
Starting from scratch with an existing stack? Work in this order.
- Start with your largest holdings by value, not quantity. Get the biggest positions entered first, so your portfolio total is useful immediately, even before you have finished entering everything.
- Pull whatever purchase records you have. Old receipts, dealer emails, bank statements. For pieces with no record, use your best estimate. An approximate cost basis beats none.
- Enter quantity and metal before exact product details. If you are not sure whether a bar is PAMP Suisse or Valcambi, enter a generic gold bar and refine later. Weight and metal drive melt value. Product specifics are secondary.
- Review your allocation once everything is in. Most stackers find their real percentages do not match what they assumed. It is common to think of yourself as mostly silver and learn you are 60 percent gold by value.
How to handle junk silver
Constitutional silver is the most common source of tracking confusion, so it earns its own section. If you want the full background, see the complete constitutional silver guide.
The standard for 90 percent US silver coins is 0.715 troy oz of silver per 1 dollar of face value. From there:
| Coin | Silver content |
|---|---|
| Roosevelt or Mercury dime | 0.0715 oz |
| Washington or Standing Liberty quarter | 0.17875 oz |
| Walking Liberty, Franklin, or 1964 Kennedy half | 0.3575 oz |
| Morgan or Peace dollar | 0.7650 oz |
For most junk silver holders, face value entry is the way to go. It is the unit dealers use, it converts cleanly to troy ounces, and it saves you counting coins in a bag. Any decent tracker converts face value automatically, and the junk silver calculator does it if you just want a number.
For 40 percent Kennedy halves from 1965 to 1970, 35 percent War Nickels, and Canadian 80 percent silver, different factors apply. A good tracker handles all of them so you do not have to memorize the numbers.
How often to update
For a physical stacker, a light cadence is enough.
After every purchase, log it while it is fresh, with the price you actually paid.
After every sale or trade, record it the same day. A missed sale leaves a phantom holding that overstates your total.
Once a month, export a backup. Local-first trackers keep your data on your device, which means the backup is your responsibility. A JSON export takes a few seconds.
Once a quarter, review allocation. Check that your metal split still matches your intent.
Once a year, do a fuller audit. Reconcile your records against receipts and a physical count.
FAQ
What information do I need to track a precious metals portfolio? At minimum: what you own, what you paid, and current melt value from live spot prices. Acquisition type keeps cost basis accurate, and allocation by metal shows how your holdings are distributed.
How do I calculate the value of my gold and silver portfolio? Multiply the troy ounce weight of each holding by the current spot price for that metal, then sum across holdings. One American Gold Eagle holds one troy oz of gold. For junk silver, use 0.715 troy oz per 1 dollar of face value for 90 percent US coins. A tracker does this automatically.
What is cost basis and why does it matter? Cost basis is the total you paid for a holding, premium included. It is what you subtract from melt value to find your real gain or loss. Without it, you only see today's price, not whether you are up or down.
How do I track junk silver? Enter it by face value and let the tracker apply the 0.715 oz per dollar formula for 90 percent US coins. Different factors apply to 40 percent halves, War Nickels, and Canadian silver, and a dedicated tracker handles them for you.
How do I handle gifted or inherited metals? Record them with the acquisition type set to gifted or inherited. Their cost basis is different from purchased metal, and tagging them keeps your gain and loss and your estate records accurate.
Can I track platinum, palladium, and copper too? Yes. A full tracker covers all the common metals, not just gold and silver. MyOunces tracks gold, silver, platinum, palladium, and copper.
Do I need a separate tracker for Goldbacks and Silverbacks? Most trackers do not support them, because they need per-note tracking across states, denominations, and variants. MyOunces includes dedicated collector systems for both, with grade, serial, and variant fields.
How do I see my allocation by metal? A tracker calculates it from your holdings and shows the split as a chart or percentage. This is where most stackers find their real mix differs from what they assumed.
How do I back up a local-first tracker? Export a full JSON file and store it somewhere safe. You restore by importing the same file. Because the data lives on your device, keeping a recent backup is on you.
How often should I update my portfolio? After each purchase and each sale, with a monthly backup and a quarterly allocation check. You are not day-trading, so a light cadence keeps it accurate without becoming a chore.
How private is a precious metals portfolio tracker? It depends entirely on where the data is stored. A cloud-based tracker keeps a full inventory of your stack on a server. A local-first tracker like MyOunces stores everything in your browser, with no account and nothing on a server to breach. More on that in why your portfolio should not live on someone else's server.
Does a tracker replace a spreadsheet? For most stackers, yes, though some keep a spreadsheet for custom modeling. The full comparison is in app vs spreadsheet.
How many products can a tracker handle? MyOunces includes a catalog of 272 standard products plus Goldbacks and Silverbacks, and lets you add custom entries for anything not listed.
The verdict
The best tracker is not the one with the most features. It is the one you will keep current. A spreadsheet you actually maintain beats software you abandon, and dedicated software earns its place by making that upkeep close to automatic.
Whichever you choose, capture the three basics from day one: what you own, what you paid, and what it is worth. Everything useful about tracking grows from there.
Justin LeBlang is the creator of MyOunces. He has been stacking physical precious metals for more than eight years and is active in r/Silverbugs, r/Gold, and r/Goldbacks. He built MyOunces after growing tired of every portfolio tracker requiring him to trust someone else with his holdings data.
Track your gold, silver, platinum, palladium, copper, Goldbacks, and Silverbacks with live spot prices and full cost basis. No account required. Launch MyOunces.