Keeping Track of What You Got

I've searched through the threads here, but how do you keep track of what you all have.
Up to now, I've been buying sets, but am now buying raw lots. Is there a "easy" way to keep track of what you have? I purchased "Pro-Baseball" from mwp software, but it is not the most user friendly thing on the planet and editing is hard. Excel, without a database attached, seems like too much work. Have any of you reached a happy medium?
Up to now, I've been buying sets, but am now buying raw lots. Is there a "easy" way to keep track of what you have? I purchased "Pro-Baseball" from mwp software, but it is not the most user friendly thing on the planet and editing is hard. Excel, without a database attached, seems like too much work. Have any of you reached a happy medium?
0
Comments
TGF Collection
TGF Sports
My ebay listings
<< <i>Microsoft Excel is an easy and free (if you have it) way to keep track of what you have. >>
AMEN!
This is a work that's always in progress. Tweak something here or there but otherwise, really simple and took no time putting together.
The 1st two rows of prices are from Beckett. You can sign up for a month and copy/paste all the checklists you need for only $5.
The others are from SMR.
I add notes to the right; such as extras, previous prices on certain cards, etc.
Autosum the number of cards I don't have and color code for ones that I do (yellow is fine, red badly needs upgrade, grey is pending, and orange is could use an upgrade but not needed)
If you want to get all fancy, you can hyperlink with a picture uploaded in photobucket or even ebay auctions.
Color coded tabs to represent baseball or football..
I promise you, I'm the ultimate lazy procrastinator and I don't consider it work; just being somewhat responsible of my collection.
1. insurance
2. They give me spreadsheet copy of all my cards
3. Some actually sell at nice prices
4. Good way to show them off with others
5. Sometimes people like to pick up the cards in person - so i introduce them to my friends card shop
6. Cheaper than a safety deposit box, but almost as accessible
The only cards i don't keep at the card shop are inexpensive cards that aren't for sale (like my psa/dna cards), but most things have a price.
I print off PSA pop reports for each year I collect. I then write the grade, cert. number, and price I paid off to the side. If the card is raw I just mark "R" and the price, leaving room to change it if the card gets graded. This way I can keep a running tally of my investment for each year. Then I also enter all of my graded stuff on VCP, with the same information. This serves 2 purposes - to have a dollar amount of my graded card investments as well as a second place to record cert. numbers in the event something ever happens to my stuff.
It takes time to do it both ways but when I'm finished I think it will serve me well in the long run.
Ron
Buying Vintage, all sports.
Buying Woody Hayes, Les Horvath, Vic Janowicz, and Jesse Owens autographed items
ebay i.d. clydecoolidge - Lots of vintage stars and HOFers, raw, condition fully disclosed.