Coin Inventory

I use OpenOffice/LibreOffice as well, but stick to the spreadsheets (Calc). Sorry.

I have an Excel spreadsheet with columns for the year, mm, variety, amt paid, coin worth, and where I bought it from. I also have a summary page adding it all up. I don't have the access to auto update the prices. When I want to update, I have to actually go on, and update the prices out of a book.

I also taught myself Filemaker pro. It gives me a database for the coins that I have, complete with pictures of all of my coins. Again, I don't have access to any auto update.

I have both sets set up so that to update prices, I would have to buy a new book, and manually update them. Right now, I have the prices entered from the 2007 Red Book. I figure that my current prices should be pretty accurate, seeing as I am using a 5 year old Red Book.

I liked my creating my own inventory sheets, because it gave me the categories that I wanted to see in my inventory, in the way I like to see them. I figure that the only perk that I am missing is the auto update of price. I can take a rainy weekend, and sit down and update them all, someday. By doing this, I can see what some of the changes, and any trends are, as opposed to having it auto updates, and just see numbers, but not how it changed.