I have been in the process of organizing the collection my father gave me moving them from coin books and tubes to 2x2s. I am also interested making an electonic catalog of them. I am thinking i would like to barcode them with a ptouch as well. Does anyone know of some software solutions? I could use excel but would like something more specific for the task.
If they are US coins and you have Mac, I recommend a program called US Coins. It’s in the Apple store. It was $19.95 when I bought it. And they provide regular updates and program improvements.
If you have an iPad, I would recommend Mystuff 2 Pro, about $10, it was a while ago I got it. It is not specifically for coins, but it is a collector software and is very flexible. I used it for a few years, though I have to say as my collection grew, and I wanted to add more complex stats, Excel worked the best. Again, I had to set it up for my own liking, but it was worth it.
Exact Change by Wild Man Software has everything you mentioned. You can create inserts for your 2X2s which will have barcodes. You can do a lot with the free download, but a whole lot more with the full version. Fun to play with. I used it for a long time. You can also get DVD copies of Standard World Coin Catalogs very cheap. $5-$8 each http://exactchange.info/
I just went through a big search on what kind of database or spreadsheet I wanted to use. Having a MacBook narrowed the choices, and being a primarily world coin collector as well. I fiddled around with some spreadsheets like Excel, Numbers, Google sheets, Open Office...but preferred a more database-like approach. My top contenders: Re-Collector http://www.collectingcatalog.com/ Flexible, user friendly. Has a demo so you can try it out. Started by a map collector and not coin specific. Tap Forms https://www.tapforms.com/ All of what I said about Re-Collector, but I liked it better. Has a nice way to make labels (or 2x2 inserts as the case may be). Very well supported. A consumer level database and you can use it in a spreadsheet view without too much trouble. Exact Change http://www.exactchange.info/Series_page.htm which is what I probably would have gotten if not entranced by using a program for more than just coins. Has integration with Krause (if you have e-copies) and is super collector oriented. Pretty sure Tap Forms can generate bar codes. But, Tap Forms is Mac only. Has an app too. I went with Tap Forms and now use it for a few different things and have other thoughts in mind...like home inventory, books, etc. I even set it up to follow by dates some auctions (with links, interesting lots, reminders). Good luck!
I would like to have a file of my collection like in excel or infopath , that connects to a source that can track prices, and have some algorithm to track trends and possibly have an algorithm compute information on what coins would be “hot” to buy. Perhaps a file that can communicate with a data analysis tool like Matlab. Ok, this takes the fun out of hobby - sorry - thank you drive through
If you are proficient with excel, you can't beat a customized spreadsheet. That's what I've been using for 20 years, and it serves me quite well.
Best software around. Still works when the power goes out. Won't lose the data to scammers, crashes or viruses. It's been tried and true for millennia...... Best thing about it? It doubles as a "pad".