How do you keep track of your coins???

I use Excel. It's easiest for me. Actually I use Excel to keep track of almost everything. It's pretty much carry-over from my workplace.

 

Log in or Sign up to hide this ad.

I only have about 70-80 2x2 cardboard-held coins, the rest being wheats and nickels in rolls. I have a nice wooden box for display purposes, but right now they all easily fit in my one, small cardboard 2x2 holder box. I've never thought to organize it other than by denom. and date within the box they're in, but then again, I'm only working on Can. and U.S. type sets and collecting random ancients, so I don't have so many that I've lost track as of yet.

 

I keep track of what I have in a FileMaker Pro database I created. My coins are spread out between a safe, some binders, and a couple of desk drawers.

 

Coinmanage Software. Its getting better, I think I have taxed the limits of the program though. Couple that with a few sets of Danscos' and Walla. Complete control.

 

Can anyone tell me about how to set up excel to manage my coins?

 

well...
i just buy like 20 folders and label them each folder for 1 country

 

I use excel and Heritage's "My Heritage/Collection". It's on their website:

http://coins.heritageauctions.com/

Best part of the Heritage is that it is FREE and it also lists the current wholesale/retail prices for your coins so you have an instant snapshot of what your collection is worth compared to what you paid for a given coin. You also can download (into excel) and print what you inputed into this "My Collection". Did I say that this is FREE?

Here's what's you get for a single entry:

Your Item #: Coin Description. Coin No., Auction Prices, Realized Numismedia Wholesale, Ask, Purchase Price, Wantlist, Demand, Add'l Data

/21646172, (1) 1909 1C INDIAN RD MS64 PCGS, Population: 1046/961, 2237, $150.00, $200.00, 53 (want list)

Like anything else, you have to enter your coins, but isn't that the fun part of the hobby to sort, resort, and sort again what YOU have?

 

Excel Spreadsheet-I don't have the means to take pictures of all the coins I have, but I know where all the 1000's I have are.

 

who keeps track?! I am a collector, not a keeper-tracker....lol, actually I use excel for sets I am still working on and I use a sheet of paper in my wallet with a list of the things I'm currently looking for, and then the completed sets are in binders or folders of one sort or another. It is a mess, but such is life.

 

I think there are some of us that are only in this for the sort, catagorize, evaluate, catalog, document, etc. My wife noticed one time that she can tell how stressed I am based on how much time I spend with my coins. The more stressed I am, the more 'coining' I do. The more relaxed I am, the more woodworking I do. I think it might be some mental thing - it gets my brain working in a linear way, processing things, evaluating things, etc. It helps me think through things.

Back on topic - I like binders because I can look at a large group of coins at the same time, I can lay out the pages on the table and look at them. I can look at both sides.

This thread got me ciourious so I went and counted last night. I have a box with probably 40 lbs of world coins in it. I have no idea how many are in there. I counted all of my binders and came out with about 4,125 coins.

 

So on your excell spreadsheet is that listed under the column of raw coins, or snackfood?:goofer:

 

Ihave liberty coin and currency ,coinmanage and currency and coin andcurrencycollector if you need a sample they all have free downloads they really have made a differance redhorse

 

I have a ring binder for most of my coins.

I've taken pics of many of my more valuble ones....mainly just to show off on the internet though

I don't have a list of them anywhere though.

 

I was looking at that software a while ago, and sent them feedback asking a specific question and never got a response. Perhaps you could answer it.

Is there any way to track PAST value in that program, so you can see how a coin has trended over time and maybe do some nice graphs? I know there are ways to do current value, but knowing about now without knowing about then isn't terribly useful.

Thanks,

Fish

 

Fish, the program does have a financial summary. It will calculate fllowing:

total coins
your cost
total market value
average cost per coin
average market value per coin
dollar profit
percent of profit or loss

The program will do the financial summary for all coins in the data base or by denomination. Hope this helps.

 

That is a tuff one to answer because you have to be familiar with Excel a little and if you are then it doesn't really have to be explained. You may want to just experiment with that program or hit a book store for one of those Excel for idiot type books. I found one for beginners and just experimented and now I use it for everything.

 

I actually have a column called DUMB STORAGE PLACES.

 

Great as long as there is no emergency where you need cash fast. It may be difficult to sell $100 coins fast and if done you may loose a lot. But with 1500 $2 coins you could always just take to a bank for an emergency or sell to freinds, neighbors and/or relatives for a slight loss or no loss at all. Many people would take a $2 coin but not easy to find someone in an emergency to hand you a $100 for a coin.
Hope I don't ever have to try it though.

 

Ihave 3 different software packages but Iwent to trovesoftware.com and they have a demo down load and a lot of information i like some of the features yhats why Ihave the different software they all have different features for different applications thanks just carl for the heads up. redhorse