Keeping track of your coins.

Two Excel spreadsheets: 1x for my collection 1x for spares for trading

 

Log in or Sign up to hide this ad.

My collection I have in a small Index card binder. I have it broken down by denomination and year. Rare or expensive coins that I know will take a while I have outlined in red. As far as anything else, not much cataloging. But is a good idea.

 

I would like to add it's best to start a catalog of your collection with the purchase of your first coin. It's easier to only do one at a time versus a large pile of coins. Trust me, I know from experience!

 

Excel is not adequate for me. I haven't YET exceeded the line number limit, but I can see it from here. An Access database is under development.

 

Nothing. Unlabeled boxes stuffed in corners. Every day is like Christmas.

 

I used to use excel to track, but then I got out coins for a while and the computer with that data base is long gone. I'll probably start working on a new spread sheet soon, now that I'm starting up again or look into an app.

 

You mean something like this?

 

How did you get into my house!!!

 

There are people in Hades with good intentions...

 

Right now anything!

Sent from my SM-G930R4 using Tapatalk

 

I use a Google Sheets spreadsheet (actually several). That way, I can access it from anywhere via my phone. This helps when you're browsing listings from another computer or your phone and need to check your holdings.

 

Here is a screen shot of mine. Data is kept in an external file and automatically loaded when I fill in the cells

 

my collection is relatively small when it comes to graded coins as the majority of my collection are dug coins i keep in a binder.However recently i created my own checklists for state and national park quarters for which i have had a recent interest in.I tried to use a free phone app for a while but it seems tricky to always have my phone in hand while looking at my coins.

 

I have an Access database I use to keep track of everything. Keeping it up to date and figuring out new things for it to do gives me something coin related to do when I am a little short on coin funds.

 

I use Excel, plenty of columns, and separate pages for different subjects. Works like a charm, and, I can import it to my phone for quick access when I'm traveling.

 

I have a spreadsheet using Google Sheets.

It's very complex at first glance and took a while when I first set up the formulas. But, it auto-calculates various data for me based on my basic data entry, such as troy oz per coin, aggregate troy oz, today's inflation adjusted value, break even sell pricing, how many Quadrums of each size I need, etc. I also auto calculate some "fun facts" such as the lowest minted year for each region, # of proofs, # of 1-year types, etc.

 

Post-it notes, categorized by color.

 

i use excel and keep copies on two different passport drives

 

My main copy is on a passport drive and it is only connected when using it. That way it is not connected all the time in case someone hacks in. I also have two separate copies on different passport drives, stored in two different locations. Being overly cautious costs little in this day of cheap storage.

 

Glad to see I'm not the only one!