Spreadsheets For Coin Tracking

I just use an XL spreadsheet. I can modify it any way I choose and you can build macro's for sorting and computations. I have separate tabs for denominations and sets.

I have no problem and actually enjoy updating the prices in my spreadsheets. I am not obsessed with their value, but I like to have a ballpark, so I update the prices maybe once or twice a year.

I agree with the paranoia of having it update online. Even if your list is "secure" on your PC, the program is updating the prices of those coins. It could be easy for someone sniffing your traffic to "see" your list just by seeing what prices are updating! It might be safer if the program grabs all prices whether you have them or not, but still risky since a snooper would see your interest in coins. I admit that might be over-the-top paranoia!

I use a program called Pro-Coin. Its awesome and has a trial available. https://www.mwpsoftware.com

I assimilated BadThad's spreadsheet into mine a few weeks ago... The "comments" column is very informational!

I also started off using badthad's spreadsheet. Very nice and useful. I now I have multiple tabs and now its nothing like badthads :) I wont use pictures until I am finalized and happy with each coin in my set. One thing I do is add in the price I purchased the coin for. This helps me determine how much my set is worth or how much ive spent so far.

Small Change, try http://www.openoffice.org/index.html Free software and you can make your own spreadsheets up. GOod luck

jbak....is there a way on Pro-Coin to get the field to calculate how many of one coin and their aggregate value into one cell?

Currently, I've had to enter each coin (e.g. 1909 VDB) in separately rather than being able to say my inventory has X number of a coin and getting the software to calculate X times value of each coin = Z.

I too use Excel. Saw BadThads sheet but too late. I have been using my own for probably hundreds of years. Slight exageration. I really like Excel since I can transfer all info from one computer to another with out the necessity of entering a special program. I too don't like on line type programs since there are way to many hackers out there that could be accessing your info.
I now keep my spread sheets simple. I used to document purchase dates, purchase amounts, where purchased, any postage if through a postage necessity situation, present values, grades, etc. One spread sheet for each album, proof sets, uncirc sets, rolls of coins, in 2x2's, etc. I download this info on those little stick things for a USB port which someone so nicely put in the front of my comoputer. Eventually I said to myself, SELF, what are you doing? Who cares about all that stuff? I don't sell coins, so why the history.
I also print out each sheet. This becomes a book in itself.
So now I cut down to just an inventory based on denominations, dates, mints, grade and approximate value.
With over 100 Albums, Proof and Uncirc sets from back in the 50's, rolls and rolls of coins, boxes of 2x2's, I still end up with a book of information.
Getting old so might eventualy even drop the value column.