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
- The date. The date tells you the order of your buys, and the order matters when you sell a part of the stack or look back at what spot was doing when you bought. It also turns a pile of receipts into a history you can read at a glance.
- What you bought, in a few words. Coin, round or bar, the mint or maker if you know it, and the size of each piece. This line is for you, not for the maths. Years from now it is the line that tells you which piece in the box is which purchase.
- The ounces, in troy ounces. Silver is weighed and priced in troy ounces, and every record in your list needs to use the same unit. If a piece is marked in grams, convert it before you write it down, and write down the troy ounce figure.
- The total you paid, all in. The full amount that left your account for that order, the pieces, the shipping and any fees together as one number. This is the figure your average has to be built from, because it is the true cost of getting that silver into your hands.
- The price per ounce for that buy. Take it from the two figures above it: the total you paid, divided by the ounces. Writing it down at the time saves you from working it out again later, and it makes each buy simple to compare with the buys around it.
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.
- Buy one: 4 troy ounces for a total of $152.00. The price per ounce for this buy is $152.00 ÷ 4 = $38.00 per troy ounce. The running record now reads: 4 troy ounces held, $152.00 spent, average cost $152.00 ÷ 4 = $38.00 per troy ounce.
- Buy two: 6 troy ounces for a total of $252.00. The price per ounce for this buy is $252.00 ÷ 6 = $42.00 per troy ounce. Add it to the record: ounces 4 + 6 = 10 troy ounces, spent $152.00 + $252.00 = $404.00, and the new average is $404.00 ÷ 10 = $40.40 per troy ounce. Notice that the average sits between the two buy prices, closer to the second one, because the second buy added more ounces.
- Buy three: 10 troy ounces for a total of $360.00. The price per ounce for this buy is $360.00 ÷ 10 = $36.00 per troy ounce. Add it to the record: ounces 10 + 10 = 20 troy ounces, spent $404.00 + $360.00 = $764.00, and the new average is $764.00 ÷ 20 = $38.20 per troy ounce. The large buy at the lower price pulled the average down from $40.40 to $38.20, even though it never changed what the first two buys cost.
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
- 1. Recording the price of the pieces and leaving out the shipping. A total that skips shipping understates what the silver cost, and the error grows with every small order, where shipping is a larger share of the spend. Record the amount that left your account, all of it, every time.
- 2. Writing the ounces down in regular ounces. A troy ounce is heavier than a regular ounce, and a record that mixes the two will give you an ounce count that is wrong and an average built on that wrong count. Convert everything to troy ounces at the moment you write it down.
- 3. Keeping the record in your head. Memory rounds prices, drops a buy, and turns two purchases into one. A stack built across years deserves better than a guess, and the record takes under a minute to add to on the day of a purchase.
- 4. Leaving a sale out of the record. When you sell a part of the stack, remove those ounces and remove their share of the cost at your average at the time, so the average of what remains stays true. A record that only grows will in time describe a stack you no longer hold.
Variations to try
- Keep a paper notebook instead. The record matters, not the tool, and a notebook that lives with the stack works well for many buyers. Write the same five items for each purchase and work the running totals out with a pocket calculator when you want them. Paper has one real strength: it can be read alongside the physical silver it describes.
- Add a once a year review. Once a year, count the physical stack, compare the count with your record, and check that the totals still agree. The review catches a lost entry or a sale you forgot to write down while the gap is still small enough to sort out.
- Keep the receipts with the record. A receipt, paper or in your email, holds the proof behind each line: the date, the pieces and the total. Keeping the two together makes the record simple to check, and it gives you a paper trail for your own insurance records if you ever choose to list the stack on a policy.
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
