Silver DCA Blog

How to Track Your Silver Stack Without a Spreadsheet

Written by Dade · Published November 13, 2026 · Updated November 13, 2026

You do not need a spreadsheet to keep track of a silver stack. You need one honest record for each purchase, kept in the same way every time, and a running total that you update as you buy. The record itself is small. The date of the purchase, the number of troy ounces, and the total amount you paid, with shipping and any fees inside that total. With those three facts kept for every buy, your total ounces, your total spent and your average cost per ounce are always one short calculation away, and the portfolio tracker on this site will do that calculation for you.

A spreadsheet earns its keep when a portfolio holds many kinds of assets across many accounts. A personal silver stack is simpler than that. It is a list of purchases of one metal, and the danger is not a lack of software. The danger is a record that leaves out shipping, mixes up the two kinds of ounces, or never gets updated after a sale. A small record kept with care beats a large file that nobody wants to open.

What to record for each purchase

That is the whole record. Spot on the day, a note on why you bought, and where the silver is stored can all ride along if you find them useful, but they are extras. The five items above are the ones your average is built from, and a record that holds them for every purchase will never leave you guessing at what your stack cost.

Worked example

Say a buyer makes three purchases across a year, and keeps the record above for each one. The prices are round figures for teaching, not live quotes, and every total already holds its shipping inside it.

That final average is the number the whole record exists to produce. It tells this buyer that the stack cost $38.20 for each of its 20 troy ounces, $764.00 in total. From there, a value check takes one more step. If spot were $40.00 per troy ounce on a given day, a teaching figure and not a quote, the metal in the stack would be worth 20 × $40.00 = $800.00 at spot, which is $800.00 − $764.00 = $36.00 above what was paid, or $40.00 − $38.20 = $1.80 per troy ounce. A real sale would bring its own costs and a dealer price below spot, so treat that gap as a guide to where you stand, not as money in hand.

Run your own numbers

Open the free Silver DCA Calculator on the homepage and open the portfolio tracker. The form asks for exactly the record this post describes: the date of the purchase, the weight in troy ounces, and the all in cost of that order as one total. Add the three buys from the example, $152.00 for 4 troy ounces, $252.00 for 6 troy ounces and $360.00 for 10 troy ounces, and the tracker shows the same result the record built by hand: 20 troy ounces, $764.00 spent and a $38.20 average, with your profit and loss worked out at the live spot price. For your own stack, add one entry for each past purchase, using the total from the receipt, and from then on add each new buy on the day you make it. The record stays in your own browser and is stored on your own device; nothing is uploaded, and no account is needed.

Mistakes to avoid

Variations to try

Want your own average worked out? The free Silver DCA Calculator on the homepage blends your purchases into one average cost per ounce and tracks your profit and loss at the live spot price, your portfolio stays in your own browser, nothing is uploaded.

Open the calculator

This post is general information about how dollar cost averaging maths works. It is not financial advice and does not recommend any purchase. Silver prices move both ways, do your own research before buying.