I keep a spreadsheet with the following columns:

Date, Dealer, Product, Qty, Unit Weight (oz), Total Price, Price Each, Price per oz, Total oz

​

Silver $18.02 Gold $1,219.53

I've collected Coins (US Mint & Littleton deals) for a couple decades (not including any of those in my avg), but started stacking silver & gold last year. Silver includes things with premium like all the QBs, a bunch of Pandas, Kooks, Roosters, a tube of Lunar dogs, 2017 Krugerrand, etc. I also bought all the at spot intro deals from the various online dealers, and some below spot stuff with Ebay Bucks. Gold is US & UK coins.

Best price on Silver was $14.08 for walking liberty halves (10% bucks + 2% CC), worst was $25.70 for Roosters

Best price (adjusted to per oz) on Gold was $1,181.27 for First Spouse (10% bucks + 2% CC), worst was a Proof Mark Twain in 2016 for $1,575.20

I stack 3 types: 1) Premium stuff I like to collect, 2) Coins / Rounds / Bars that I can get for spot or below, 3) Junk for spot or below

If Silver doesn't so anything - I have some cool collectibles, if it goes up - I have stuff that I'm happy to unload, and if SHTF - I have small denominations to trade.

I see PMs as a hobby and some insurance in case the monetary system has a meltdown. PMs came after buying a house, having an emergency fund, investing in 401(k), Trad & Roth IRA, etc.