keeping track of your coins

[Goldseeker]

Sorry, I am immune to hypnosis or whatever...........

[Splock]

I too use a spreadsheet (I'm missing a category field, thanks for the suggestion Mark). If you're going to use something like that then make sure you've got some off-site backup like Dropbox or Google drive. You can always store encrypted files there if you're worried about security.

With my file now on Dropbox I have permanent access to my full collection on my iPad, which is very useful when I'm at a dealer or attending coin fairs and don't want to duplicate or looking to upgrade on an existing item. Having the .pdf versions of all of the Krause catalogues on the iPad also helps when looking for new additions. Just wish McDonalds and Renniks would hurry up and join the 21st century.

[trout]

I too use a spreadsheet (I'm missing a category field, thanks for the suggestion Mark). If you're going to use something like that then make sure you've got some off-site backup like Dropbox or Google drive. You can always store encrypted files there if you're worried about security.

With my file now on Dropbox I have permanent access to my full collection on my iPad, which is very useful when I'm at a dealer or attending coin fairs and don't want to duplicate or looking to upgrade on an existing item. Having the .pdf versions of all of the Krause catalogues on the iPad also helps when looking for new additions. Just wish McDonalds and Renniks would hurry up and join the 21st century.

I have a couple of portable usb hard drives I shove may data bases and other doccuments on.
This seems to work OK :good:

[Triggersmob]

I have a couple of portable usb hard drives I shove may data bases and other doccuments on.
This seems to work OK Good

I also use Excel spreadsheet and back up on portable hard drive.

[trout]

I have a couple of portable usb hard drives I shove may data bases and other doccuments on.
This seems to work OK Good

I also use Excel spreadsheet and back up on portable hard drive.

I have only done 2 albums so far and that took me ages :dash1:
I will have to do 1 album a week and update the ones I have done as I go along.
I think I may have created a monster for myself here:swoon:

[stevo1962]

I've itemised all of my coins,notes ,gold nuggets etc on an Excel spreadsheet with the price
paid and any other relavent details and it keeps a running total of my total of what they owe
me

[Splock]

I have a couple of portable usb hard drives I shove may data bases and other doccuments on.
This seems to work OK :good:

An excellent idea. Only problem with this is that if your hard drive is in the same location as your computer, when you computer is stolen, so is the hard drive. We learnt this the hard way with a recent burglary at our place. Off site storage is well worth a look.

[Goldseeker]

Recording ones coin collection takes time.   But once done it looks good.   Hang in there.

[trout]

Recording ones coin collection takes time.   But once done it looks good.   Hang in there.

I haven't graded most of my coins so I have to grade each and every coin before I can add it to the database.
This is what takes the most time but it is an excellent opportunity to reacquaint myself with my collections.

This is why I started on the Decimal coins, Most of these are BU , proof or Silver Proofs and are simple to grade :good:

My predecimals grade from “what the hell is this piece of junk” to “Helllllloooo Baby”.

These will take the most effort but I intend to persevere and complete them all.

Then start on the Canadian and US stuff.

This may take a while I think:shock::mr47_05:

[WavyTwenty]

Like most others I also use Excel to keep a record of my coins.  It contains fields similar to Markn's picture above, but I account for multiples on the same line.  Having 5 Sydney 2007 MYO coins dont get a separate line item for each.

Like Mark I have a unique ID on each coin - I find this the most useful part of tracking them because I can find the exact coin that matches an entry.  Especially if the grades are similar....

I do have a total paid column - and a total [what they are worth today] column.  This offsets some of the pain of what I have spent already.

Wavy20

[Graham]

I also use Excel. However, I make extensive of Pivot tables to display and total coins, dates, values (purchase and current totals).

My foreign coin worksheet is 13,000 lines long.  The Pivot table sorts them by Country, date, denomination, quantity, cost and value.