Skip to content
LittleGiantWeb.

React + Firebase

GoldSilverStacker

I built a real-time precious metals portfolio tracker with live AUD spot prices, profit analytics, historical value charts, and sold items management for bullion investors.

Type
Web Application
Timeline
2024–Present
Stack
React, TypeScript, Firebase
Live site
goldsilverstacker.com

Everything quoted in USD

The problem with stacking bullion from Australia is that almost nothing quotes you in Australian dollars. The apps are built for a US market. You buy in AUD and you will sell in AUD, and the number on the screen is in a currency you never actually transact in.

The alternative is a spreadsheet, which means looking up four spot prices by hand every time you want to know where you stand. Mine was permanently out of date.

What I wanted was one screen. Total paid, what it is worth now, profit, and what moved today, split by metal. Most of my stack is Perth Mint coins and bars with some international pieces, and I wanted every purchase tracked on its own rather than averaged into a lump.

So I built GoldSilverStacker.

GoldSilverStacker homepage with live precious-metals pricing and portfolio dashboard
Dashboard with live AUD spot prices for gold, silver, platinum, and palladium

The Dashboard

When you log in, the first thing you see is the current spot price for gold, silver, platinum, and palladium, all in AUD. These update in real time. Below that is a full portfolio summary: total paid, total market value, estimated profit/loss, and daily change. It also shows breakdowns per metal, including average paid price, spot position, total premium paid over spot, and total weight in ounces and kilograms.

The idea is that you should be able to glance at the dashboard and immediately know how your stack is performing without doing any mental maths.

Your Stack

The main tracking view is a table of every item in your collection. Each entry includes the purchase date, year, name (e.g., “Perth Mint 2oz Mother and Baby Dingo”), quantity, total ounces, current profit if sold at market value, and profit percentage. Items are grouped by metal type, so you can see your silver stack separate from your gold.

You can search, sort by profit, and manage your stack from this view. Adding a new item is straightforward: enter the details, the purchase price, and it starts tracking against live spot immediately. The platform handles all the calculations automatically, including converting weight to ounces and tracking premiums paid over spot price at the time of purchase.

Stack view showing silver items with purchase dates, quantities, ounces, and profit percentages
Stack view with per-item profit tracking against live spot prices

Portfolio Value Charts

The graphs page shows your total portfolio value over time, plotted against what you originally paid. This makes it easy to see how your stack’s value has moved with the market. You can toggle between total market value and total paid to visualise your profit margin over any time period.

The chart also shows the live spot prices for all four metals at the top of the page, updated within the last minute. This is useful for timing purchases or just keeping an eye on where the market is sitting on any given day.

Portfolio value graph showing market value vs paid price over time
Historical portfolio value chart with live spot price indicators

Sold Items and Tax Tracking

When you sell items from your stack, they move to the Sold Items section. This tracks everything you need for record keeping: total paid on sold items, total sold price, profit/loss, postage charged, and tax. It also breaks down the totals by metal type with weight in ounces.

You can view invoices, download a full summary, and search through your sold history. This is particularly useful come tax time, because the platform keeps a clean record of every transaction with the numbers ready to hand to your accountant.

Sold items page showing financial year summary with profit, weight, and tax tracking
Sold items with financial year summary, profit tracking, and downloadable reports

Where it goes next

It runs as a real product now. Accounts, settings, dark mode, responsive down to a phone, and the architecture to handle more than just me. Whether it becomes a business depends on whether other Australian stackers have the problem I had. I suspect they do, because I went looking for this and it did not exist.

What it tracks

4
Metals Tracked
Live
Spot Prices
Per-Item
Profit Tracking
Historical
Value Charts
Sold Items
Management
SaaS
Ready

Four metals, priced in AUD, updated every minute. Each item carries its own profit against live spot rather than disappearing into a portfolio average, and it tracks the premium you paid over spot at the time, which is the number that decides whether a coin was a good buy. Sold items keep their own record with postage and tax, so the financial year summary is something you hand to an accountant rather than reconstruct from receipts in July.

Under the hood

React and TypeScript with Firestore behind it. The stack is not the interesting part. The spot price feed is: four metals, converted to AUD, refreshed every minute, with history kept so the charts have something to draw.

Everything else is arithmetic sitting on top of that. Profit against live spot, premium over spot at time of purchase, weight conversions, financial year totals. It is simple maths that has to be right, because people make actual decisions on the number it shows them.

Got something you want built?

Tell me what it is and I’ll tell you what it takes.

Get in touch