| Author |
 Replies: 22 / Views: 3,337 |
Page 2 of 2
|
|
|
|
New Member
Bulgaria
27 Posts |
In a small notebook and a large Excel spreadsheet that I've been too lazy to update it since the 2nd of December.  |
|
Moderator
 United States
189502 Posts |
Quote:
Perhaps Excel will be the best solution for me, but unfortunately I do not know how to use it. How is your table designed ? I have a separate worksheet for each album. Some columns vary, but most US sheets have Year, Mint, Variety, Value, Purchase Date, Paid, Grade, and Notes. The "world coin" sheets add columns for Country and KM#. Not all cells have information though. |
|
Pillar of the Community
United States
4085 Posts |
Excel
I keep track of date/mint mark, denomination/series, grade, current value, acquisition price, notes
If the coins are in an album, I group them by that. I also have sections for single coins and proof/mint sets.
|
|
Moderator
United States
189502 Posts |
Quote:
I also have sections for single coins and proof/mint sets. Yes, I have a worksheet just for all the OGP items in my collection. It has grown a lot the last ten years.  |
|
Moderator
United States
97685 Posts |
Excel spread sheet. 2 different file one for mint /uncirculated coins and one for coins taken out of circulation and placed in albums or folders.
all listed by date/mint mark, # of coins minted, purchase date, Purchase price, bought from who, grade, then current value
All collums with prices are then totaled up for a grand total.
|
|
Valued Member
United States
282 Posts |
I have used the coin elite software for years. Easy to use and you can make your own formats to add anything you want. I would highly recommend it.
|
|
Pillar of the Community
Australia
9449 Posts |
I store images of all my coins in the CCF gallery and that is a tool I can refer to from anywhere. It's also handy to refer other people to when looking for trades. The images are also stored on my computer and backed up on second remote storage device. Also keep information on every coin on an Excel spreadsheet.
Steve :)
|
|
Pillar of the Community
United States
747 Posts |
I catalog my coins on numista, which I find very easy to use. You can download an excel spreadsheet anytime you'd like. You can enter private info about each coin when you catalog it.
I would love to get around to photographing my collection some day.
|
|
Pillar of the Community
United States
619 Posts |
Quote:
Perhaps Excel will be the best solution for me, but unfortunately I do not know how to use it. How is your table designed ? There are lots of Excel tutorials online (ie - Youtube). Very simple to learn. I like this spreadsheet a lot not only to keep inventory of coins but for financial tracking too. |
|
Pillar of the Community
Canada
999 Posts |
|
|
Pillar of the Community
Canada
1505 Posts |
I use excel with a few different tables to keep things organized. 1. Master ledger. Inventory of all coins (work in progress), listed by country, date, grade, variety, issues, cert, price paid, value, date purchased/sold/sale price, inventory number. I wish I would have been more detailed on where I purchased. It is just ebay, bank, other. Best thing I did was list some bulk lots as one item (eg. Box of pennies of 5000 coins). No time to catalog and number each coin. 2. Collection list. Basically a table that shows me highest grade of each coin I am collecting and associated tables for each monarch to summarize each type set by denomination. This is pulled from master ledger. 3. The scary table. Pulls data on cost, value, sold and profit from master ledger. It's surprising how quick it adds up. I might not want to show this to my significant other... Overall it is kind of neat to see how far I have come, looking at some of the winners/losers and it has inspired me to sell duplicates to reduce investment and free up space for stuff. Next stage is to photograph permanent collection and label with inv number. Hopefully when it comes time to sell/pass it on, it will be an easier process as all cataloging and photos are done. The hardest part I find in selling off excess coins is taking time to photograph and price, once that part is done, listing becomes a lot easier. Edited by purelywasted
02/21/2021 12:41 pm
|
|
Pillar of the Community
United States
1373 Posts |
Unfortunately, I just recently paying better attention to my collection. I should have begun years and years ago.
Right now I'm just using paper. I have used Excel in the past but now any of that info is in two or three computers that crashed/died and are now stacked in my garage unusable. I actually did back up some stuff on floppy disks (yes, from the golden ages) but my new computers can't read them.
I am basically just keeping tabs on the prices I've paid for my coins. I've told my kids that when I pass I hope they can get at least half of my costs back.
|
|
Moderator
United States
189502 Posts |
|
|
Pillar of the Community
United States
1373 Posts |
Thank-you jbuck! If I knew those things were so inexpensive I would have bought one years ago.
|
|
Moderator
United States
189502 Posts |
No problem.  I have had a USB floppy for years. Now I have a USB DVD because the new laptop is too thin for a built-in. |
|
Page 2 of 2
|
Replies: 22 / Views: 3,337 |
Page 2 of 2
|
First Page
Posted 02/16/2021 11:57 am
