The TCG Autopsy Collection Tracker
(Spreadsheet + Online App)
I’ve been in the Pokémon market for 30 years and trading seriously for 20. I wrote The TCG Autopsy: The Complete Guide to Pokémon TCG Investing, a #1 best seller, and my channel has passed 5 million views across YouTube and Facebook.
Everything I teach comes down to discipline: know what you paid, know what it’s worth, and know when to sell. This tracker puts that discipline into one spreadsheet.
What you get
📥 The spreadsheet: instant download, works in Excel and Google Sheets.
📱 The online app: your tracker at app.thetcgautopsy.com, on your phone, tablet or computer, saved to your own private account. Your access code arrives by email within 24 hours of purchase.
What you enter
What you bought, your buy prices, when you bought it, and the last 5 eBay sold prices. Pick Short-Term, Long-Term or Speculative, the language, and for graded cards, the grading company.
What it does for you, automatically
Average entry: averages your buys into your real cost per item.
Market price: averages your last 5 eBay sold listings into one real market price. Sold prices only, never asking prices.
Portfolio value: calculates what every position is worth right now.
Profit and loss: shows your gain or loss in dollars and percent on every item, every category and your entire collection.
Rule of 4 sell prices: your +25%, +50% and +75% sell prices fill in automatically.
Sell alerts: a sell price lights up when the market hits it.
Sales tracking: after you sell, that sell price marks itself SOLD so you always know your next move.
Holdings update themselves: log a sale and your counts adjust on their own.
Profit after fees: every sale shows your profit after eBay fees and shipping, with your % gain or loss.
Realized vs. unrealized profit: see what you’ve locked in and what’s still on the table.
Days held: counts up from your purchase date.
12-month warning: flags a short-term flip that has quietly become a 12-month hold.
Stale-price warning: flags prices that are more than 30 days old.
Portfolio split: your Short-Term, Long-Term and Speculative percentages next to the 60 / 30 / 10 target.
One home page: your unrealized profit, realized profit, total profit and portfolio value, all in one place.
Every part of your collection, organized
Raw singles, graded cards, Pokémon Center ETBs, ETBs, booster boxes, booster bundles and misc sealed each get their own tab, plus a Sold tab for every sale you make. All of it feeds one home page.
Built to be easy
Plain-English labels. Large, easy-to-read text. You fill in the white cells and the tracker handles the rest. It works in Excel and Google Sheets.
Stop guessing. Start tracking.
I’ve been in the Pokémon market for 30 years and trading seriously for 20. I have a degree in business and finance, a career in professional finance behind me, and I retired early from Pokémon investing. I wrote The TCG Autopsy: The Complete Guide to Pokémon TCG Investing, a #1 best seller, and my channel has passed 5 million views across YouTube and Facebook.
Everything I teach comes down to discipline: know what you paid, know what it’s worth, and know when to sell. This tracker puts that discipline into one spreadsheet.
What you enter
What you bought, what you paid, when you bought it, and the last 5 eBay sold prices. Pick Short-Term, Long-Term or Speculative, the language, and for graded cards, the grading company.
What it does for you, automatically
Market price: averages your last 5 eBay sold listings into one real market price. Sold prices only, never asking prices.
Portfolio value: calculates what every position is worth right now.
Profit and loss: shows your gain or loss in dollars and percent on every item, every category and your entire collection.
Rule of 4 sell prices: your +25%, +50% and +75% sell prices fill in the moment you enter what you paid.
Sell alerts: a sell price lights up purple when the market hits it.
Sales tracking: after you sell, that sell price marks itself SOLD so you always know your next move.
Holdings update themselves: log a sale and your counts adjust on their own. No editing rows, no deleting anything.
Profit after fees: pick the item from a dropdown and your cost fills in. Profit comes out after eBay fees and shipping, with your % gain or loss.
Realized vs. unrealized profit: see what you’ve locked in from sales and what’s still on the table.
Days held: counts up from your purchase date.
12-month warning: turns red when a short-term flip has quietly become a 12-month hold.
Stale-price warning: turns red when your prices are over 30 days old.
Portfolio split: calculates your Short-Term, Long-Term and Speculative percentages next to the 60 / 30 / 10 target.
One home page: your unrealized profit, realized profit, total profit and portfolio value, all in one place, updated from every tab.
Every part of your collection, organized
Raw singles, graded cards, Pokémon Center ETBs, ETBs, booster boxes, booster bundles and misc sealed each get their own tab, plus a Sold tab for every sale you make. All of it feeds one home page.
Built to be easy
Plain-English labels. Large, easy-to-read text. You fill in the white cells and the tracker handles the rest. It works in Excel and Google Sheets.
Stop guessing. Start tracking.