Hi guys, I'm looking for a good way to catalog my coins on the computer, and I figured I better get started soon before I forget how much I bought them for! Here's the dilemma though: I like already made coin software because of the nice interface and ease of use, but I also like Excel because of it's flexibility and capability to do what I want (mostly). Right now I'm using this program called Numismatist's Notebook, and it does its job well, but there's something missing. I want to to be able to have a column of what I paid for each coin and how much I sold it for, with formulas that calculated the total money spent/earned. My question is, if I move to Excel for those features, will I lose some of the functions of the other program, most importantly the ability to upload pictures, and categories for different denominations? Thanks for your input guys, I'll post some pictures of what I'm using below. If some of you want to show some pictures of how you manage your collection, that would be greatly appreciated as well! (You don't have to show your actual coins - just the format)
I am not familiar with your software. I would imagine you can export to CSV and then import into excel. whether or not it saves all the formulas would be a guess on my part. CSV typically puts all your data into Comma Separated Values at which point you can then import and then format, create new formulas and label.. I use excel for tracking all my purchases. I am also adding coins that are in my collections that were handed down to me, mostly pictures. Its nice because I can create hyperlinks in the spreadsheet to the specific coin image in another folder. I also use the PCGS registry spreadsheet for certified coins which I am just now starting to load. Since I buy mostly from eBay, I copy info from my "won" page and paste it into excel and add other information and worksheets as needed. Excel offers a tremendous amount of flexibility and is relatively intuitive to repetitive formulas and functions. It allows me to have hyperlinks to the individual sellers. The only draw back comes from the fact eBay only stores completed listing for 60 days - so the hyper link to the actual listing only works for 2 months. Here is a section from my PCGS certified worksheet. Amongst the specific seller info. Accounting wise, I track what the item closed at, Quantity, shipping cost, total cost, and net gain from total cost to PCGS value. Hopefully this will give you some ideas and is helpful.
The nice thing about Excel is you can design it anyway you want. Add colums for new categories move things around etc, and it is possible to insert pictures into the Excel worksheet either as a permanently displayed picture or as links that can be opened and closed as desired.
You would not care to share with us those 1943 P, D, & S coins you have, would you? MS66RD's are a bit on the unusual side.
ya think? did you really take the time to nit pick? the beauty of copy and paste at its best.... MS68 would be worth posting
