Best way to track a gold and silver portfolio: app vs spreadsheet
By Justin · Published · Updated
Originally published March 2026. Updated and reviewed July 2026.
If you own physical gold and silver, you need a way to see what your stack is worth. The real question is how you track it.
Most stackers start in a spreadsheet. Excel, Google Sheets, sometimes a notebook. It is free, it is familiar, and for a small stack it works fine.
This guide is not here to tell you spreadsheets are bad. They are not. It is here to show you where a spreadsheet earns its keep, where it quietly starts costing you time, and how serious stackers actually track their holdings in 2026. By the end you will know which approach fits your stack.
New to tracking metals? Start with the basics: how to track a gold and silver portfolio.
Bottom line
If you own fewer than about five products, a spreadsheet is perfectly fine. You control every cell and you owe nothing.
Once you are maintaining dozens of holdings, junk silver, multiple purchase lots, or Goldbacks, a dedicated tracker usually saves enough time to justify itself. It updates spot prices automatically, tracks cost basis for every holding and calculates unrealized gain or loss for you, and charts your portfolio without any formula work. Power users often keep a spreadsheet alongside for custom modeling and export their data whenever they need it.
Quick comparison
| What you are doing | Spreadsheet | Dedicated app (MyOunces) |
|---|---|---|
| Live spot pricing | Manual lookup or fragile API formula | Automatic, refreshes every 5 minutes |
| Cost basis and profit and loss | Custom formulas on every row | Automatic per lot |
| Setup time | Build the structure, formulas, and formatting | Pick your products, enter amounts |
| Junk silver | Research and build weight formulas yourself | Built in with circulated weights |
| Portfolio breakdown charts | Build and maintain manually | Built in |
| Portfolio value over time | Manual snapshots, if you remember | Automatic once transactions are logged |
| Multi-currency | Exchange-rate formulas on every value | One toggle, 9 currencies |
| Data privacy | Local file is private. Google Sheets lives on Google servers | Local device only, no account |
| Backup | Standard file save | JSON and CSV export |
| Cost | Free, or an Excel license | $79 once |
Why almost every stacker starts with a spreadsheet
There is a good reason spreadsheets have been the default for decades. For some jobs they are still the right tool.
You want total control. If you need a column, a calculation, or a view that no app offers, a spreadsheet gives it to you. Custom formulas, conditional formatting, pivot tables. If you can think it, you can build it.
You are tracking a small, simple stack. If you own five products and you just want a rough number, a spot-price column and a sum does the job. You do not need an app for that.
You already live in Excel. If you build reliable formulas for a living, the learning curve is zero and the flexibility is real.
You want to model scenarios. What does my stack look like if gold hits 5,500. What if I add 100 oz of silver. Spreadsheets are excellent for that kind of what-if math.
If that describes you, stay where you are. The rest of this guide is for stackers whose spreadsheet has started to fight back.
Where spreadsheets start costing you time
For most stackers, the spreadsheet does not fail loudly. It fails quietly, and the failures cost you accuracy.
Manual price updates. This is the big one. Spot moves constantly. Unless you have wired up a live data feed, and kept it working, your sheet shows whatever price you last typed in. Most stackers update by hand, which means the portfolio value is wrong nearly every time they open the file.
Junk silver is a headache. Constitutional silver has different content by denomination, country, and era. A 1964 Kennedy half contains roughly 0.3575 troy oz of silver at circulated weight. A worn British coin uses .925 purity at a different weight again. Building accurate formulas across every denomination is tedious, and most people either oversimplify with theoretical weights or skip junk silver entirely. If you are unfamiliar with circulated weights or the 0.715 formula, the complete constitutional silver guide walks through it. If you just want the number, the junk silver calculator does it for you.
Formula fragility. One shifted cell reference. One deleted row. One paste that overwrites a formula with a hard number. These errors are silent, and in a sheet with dozens of holdings you may not catch them for weeks.
No profit and loss per lot. If you bought 10 oz of silver at 25 and another 10 oz at 32, your average cost matters for real returns. Tracking cost basis per lot in a spreadsheet is doable, but it adds work to every purchase you log.
Multi-currency is painful. Want to see the stack in EUR or GBP. Now you need exchange-rate data and a conversion layer on every value. Switching currencies means rebuilding, not toggling.
Charts take real effort. A donut of allocation by metal. A ranked list of your top holdings. An Au to Ag ratio strip. All possible in a spreadsheet, all something you have to build and maintain by hand.
What spreadsheets were never built for
Some of this is not a matter of effort. A spreadsheet is simply the wrong shape for it.
A live total, always current. A spreadsheet is only accurate the moment you last typed a spot price into it. Open it a week later and the number is stale, sometimes by hundreds of dollars. MyOunces calculates melt value against current spot every time you open it, across every metal you own. No refresh, no typing.
Your portfolio value over time. A spreadsheet tells you what your stack is worth today, and only if you kept it updated. It has no memory of last month unless you saved a snapshot, and most people never do. MyOunces builds a historical value chart from your transactions, dated back to your first purchase, with your cost basis overlaid. You see how the stack has actually grown over months and years, not just where it sits today.
Knowing when to rebalance. The gold to silver ratio is one of the oldest signals stackers watch, but acting on it means math you would rather not maintain in a sheet. The GSR rebalancing calculator shows the current ratio against 110 years of history. Set a target, say you want to rebalance when the ratio hits 80, and it tells you exactly how many ounces to move to get there.
Holdings grouped for taxes and estate planning. Come tax time or when you are documenting a stack for heirs, you want holdings grouped by where they sit or how you got them. A spreadsheet makes you build that by hand. Tag holdings as IRA, safe, or inherited, and MyOunces breaks out weight, cost basis, and gain and loss per tag automatically.
These live in the Intelligence Hub, which is part of Pro. And if you also collect Goldbacks or Silverbacks, those are tracked too, with official mintage data behind the rarity tiers.
Privacy is the part most trackers get wrong
This deserves its own section, because it is where MyOunces is genuinely different.
Most trackers talk about privacy. Fewer are built around it. MyOunces stores everything in your browser's local storage. No account, no cloud, no server-side copy of your holdings. The data never leaves your device, which means there is no database of stacker holdings to breach or subpoena, because it does not exist.
That is worth comparing directly against the two common alternatives.
| Feature | Spreadsheet | Cloud-based tracker | MyOunces |
|---|---|---|---|
| Requires an account | No | Yes | No |
| Data stored locally | Yes | No | Yes |
| Live pricing | Manual | Yes | Yes |
| Works offline | Yes | Varies | Yes |
| Goldback tracking | No | Rarely | Yes |
| One-time purchase | Yes | Usually no | Yes |
A local Excel file gives you the privacy but none of the automation. A cloud-based tracker gives you the automation but puts your holdings on someone else's server behind a login. MyOunces is the row where both columns say yes.
If privacy is part of why you own metal in the first place, why your portfolio should not live on someone else's server makes the fuller case for local-first tracking over a cloud account.
Spreadsheet users are still welcome
None of this means you have to abandon Excel.
Many Pro users still export their holdings to Excel for taxes, estate planning, or custom analysis. That is the point. The app becomes your source of truth for what you own and what it is worth, and the spreadsheet becomes a tool for the custom modeling an app will never cover.
If you have spent years building an Excel or Google Sheets file, you do not have to start over. MyOunces Pro imports existing holdings from CSV, and exports them again whenever you want.
MyOunces supports CSV export, so your data opens cleanly in Excel or Google Sheets whenever you want it. You are not locked in, and you are not choosing one tool forever. You are letting each one do what it is good at.
Who should use what
| If you | Use |
|---|---|
| Own around 5 products | Spreadsheet |
| Want fully custom calculations or modeling | Spreadsheet |
| Track precious metals inside a larger portfolio sheet | Spreadsheet |
| Want live pricing with no manual updates | MyOunces |
| Track junk silver | MyOunces |
| Own 50 or more products | MyOunces |
| Track Goldbacks or Silverbacks | MyOunces |
| Care about keeping holdings off the cloud | MyOunces |
| Want portfolio history and charts | MyOunces |
| Need clean exports for estate planning | MyOunces |
Still weighing whether an app is worth it at all? Our comparison of the best gold and silver portfolio trackers puts MyOunces next to the other options, so you can see where it fits before you commit.
Common spreadsheet mistakes when tracking gold and silver
These are the errors that actually happen, not hypotheticals.
Using theoretical silver weights instead of circulated weights. A 1964 Washington quarter theoretically holds about 0.18084 troy oz of silver, but circulated coins are worn. The industry standard is roughly 0.1788 oz, based on 0.715 oz per 1 dollar of face value. Theoretical weights overstate your silver by more than a percent, and across a large junk position that adds up.
Forgetting to update spot. The sheet says 45,000, but that was last Tuesday, and gold has moved 80 an ounce since. The most common and most costly spreadsheet error there is.
Breaking formulas during edits. A new row in the middle of a range, a paste from another sheet, a formula quietly replaced with a hard value. Silent, and they accumulate.
Tracking a single average cost instead of per lot. If you bought the same product at different prices, one blended number hides your real returns.
Mixing troy ounces with regular ounces. Precious metals use troy ounces at 31.1 grams, not the 28.35 gram avoirdupois ounce. One wrong conversion throws everything off by about 10 percent.
FAQ
Is Excel good for tracking gold and silver? Yes, for a small stack or for someone comfortable building and maintaining formulas. It gets harder to keep accurate as holdings grow, especially with junk silver and multiple currencies.
What is the easiest way to track a bullion portfolio? A dedicated tracker with live spot prices and a product database. You select your products, enter quantity and cost, and the app calculates the rest.
Can Excel or Google Sheets pull live spot prices automatically? Only if you build and maintain an API connection, which takes technical work and breaks often. Most stackers end up updating prices by hand.
How often are prices updated? In MyOunces, spot prices refresh every 5 minutes from a professional metals data feed, so the melt value you see is current.
Does MyOunces work offline? Yes. After the first load it works without a connection. The only thing that needs the network is refreshing live spot prices.
Can I track platinum and palladium? Yes. MyOunces tracks gold, silver, platinum, palladium, and copper, including coins, bars, and rounds.
Can I track Goldbacks or Silverbacks in a spreadsheet? You can log them, but you would have to research denominations, fractional gold content, and variants yourself. MyOunces tracks them natively with official mintage data.
How do I calculate junk silver content? For US 90 percent coins, the standard is about 0.715 troy oz of silver per 1 dollar of face value. MyOunces applies circulated weights automatically, so you enter face value or piece count and it computes the silver.
How do I calculate melt value? Melt value is the fine metal weight multiplied by the current spot price, summed across your holdings. A tracker does this live. In a spreadsheet you maintain the weights and the spot column yourself.
Can I track inherited or gifted metals? Yes. Each holding records how you acquired it, whether purchased, gifted, inherited, or traded, which keeps cost basis and estate records clean.
Can I import an existing spreadsheet into MyOunces? Yes. Pro supports bulk CSV import using a template you download in the app.
Can I export my data later? Yes. MyOunces supports CSV export, plus full JSON backup, so you can move your data into a spreadsheet or keep an off-device copy anytime.
Can I back up my data? Yes. A full JSON export saves everything in one file, and you restore it by uploading the same file. Auto-backup keeps a recent copy for you as well.
Does MyOunces replace a spreadsheet? For most stackers, yes. It handles live pricing, cost basis, profit and loss, junk silver, and charts automatically. For custom modeling, some users keep a spreadsheet alongside it.
What is the safest way to store my holdings data? A local file or a local-storage app keeps your data off the cloud. MyOunces stores everything in your browser and never sends holdings to a server.
Do I need an account to use MyOunces? No. There is no account and no login. You open it and start tracking.
Will my data sync across devices? Each device stores its own data locally, which keeps the privacy model intact. A Pro license activates on up to 5 devices, and you move data between them with export and import.
How many products can I track? The free tier covers 7 products. Pro is unlimited, across a catalog of 272 standard products plus Goldbacks and Silverbacks.
How much does MyOunces cost? $79 USD, one time. No subscription or recurring fees.
The verdict
Spreadsheets work. They have tracked metals for decades and they will keep working for anyone who wants full control and does not mind the upkeep.
But for most physical stackers, a dedicated tracker saves time, removes silent errors, and shows you more about your stack. The biggest upgrade is automatic spot pricing. The second is junk silver done right. Together they remove the two most common sources of error in spreadsheet tracking.
The best tracker is the one you will actually keep up to date. For some people that is a spreadsheet. For many stackers it is a purpose-built tracker that removes most of the maintenance.
If you have been meaning to clean up your spreadsheet for months and still have not, that is probably your sign.
Justin LeBlang is the creator of MyOunces and has been stacking physical precious metals for more than eight years. He built MyOunces to give stackers a way to track their holdings without creating an account or storing their data in the cloud.
Track your stack privately. Live prices, cost basis, junk silver, and portfolio history. No account, no cloud, no formulas. Launch MyOunces.