| Author |
 Replies: 13 / Views: 2,117 |
|
|
Valued Member
United States
420 Posts |
Hello,
What would you recommend to keep track of my coins? Software? What software should I use? I'd like something reasonable yet powerful enough to get the job done.
Thanks,
Rich
|
|
|
|
Pillar of the Community
United States
2602 Posts |
Excel works well for me. You can readily put values in and multiply them if you have more than one of something.
|
|
Valued Member
 United States
420 Posts |
Hello,
If I use Excel what do I put in there, what fields? I wouldn't even know where to begin.
Thanks,
Rich
|
|
Pillar of the Community
United Kingdom
2217 Posts |
Hi and welcome in to the Forums!
|
|
Valued Member
United States
63 Posts |
 enjoy! |
|
Valued Member
United States
80 Posts |
For the Excel, I would have a sheet for each coin type you collect I would but some information at the top explaining your goal, what are the dates and mints you want. Then I would have fields for Date of coin, Mint of coin, price you paid, grade (even if it is your personal guess), whole sale value (if you have the blue book) or retail value (if you have the Red Book) and date of purchase. Maybe at the bottom have some fields for totals of price paid, etc. Hope this helps some. At least it will get you started. BTW |
|
Valued Member
United States
290 Posts |
Is there any excel spreadsheets that have been uploaded onto this site? I saw a 7070 uploaded somewhere here.
I am beginning a JFK set and was wondering if anyone had any blank forms.
thanks.
|
|
Valued Member
United States
420 Posts |
Hello,
I'm unaware of any blank forms, although I find it much easier now to create my own spreadsheets because I have more control over what I want to do and what content to add. I know it is tedious and a pain but trust me once you get used to it you might find you prefer it too.
Rich
|
|
Pillar of the Community
United States
1944 Posts |
I use a software called coinmanage (coinmanage.com). you can create as many folders as you want. you can enter coins as to date, MM, grade, quantity there is also a "coin" value attached. it fairly closely matches values I have seen online. there are annual updates for coin values, but you do NOT need to update, if it is only for the updated values. I suppose there could be some argument as to how accurate the values are in any case. I like it (for ny uses)
|
|
Pillar of the Community
United States
651 Posts |
Just google "free excel coin template" and you'll get a few hits of blank forms
|
|
Moderator
 United States
188322 Posts |
Quote:
...I find it much easier now to create my own spreadsheets because I have more control over what I want to do and what content to add. I agree. I have kept my information in a spreadsheet for many years now (I actually started with VisiCalc). To this day I still use a spreadsheet for tracking my budget and account information! Just sit down one afternoon with your Red Book, coin album, or whatever source you want to compile your list. You can start out simple if you like by just listing date and mint. The great thing about spreadsheets is that they can evolve over time. I know mine has!  |
|
Pillar of the Community
United States
1179 Posts |
I have a full spreadsheet with everything I've ever bought etc. New tab for each type of coin, dates, MM, how much I paid, mintage, you name it its on there.
I replied to your other thread Novilerro, shoot me an email and I'll send what I have.
|
|
Valued Member
United States
290 Posts |
Ceaton,
I don't have enough posts to email other members.
I wonder if 10 e-mails, this one is number 10, will put me over the top.
|
|
Pillar of the Community
United States
1179 Posts |
Looks like 10th is the charm, sorry, didnt realize it! Emailed you back, let me know if you need anything else :)
|
| |
Replies: 13 / Views: 2,117 |
|
Posted 09/25/2008 4:10 pm
