Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
How do you track the value of your collection?
>
Reply to Thread
Message:
<p>[QUOTE="juris klavins, post: 3374395, member: 76693"]95% of my 'collection is just silver bullion of various types - 90% 'constitutional' halves, quarter and dimes, .999 silver bars and rounds, sterling silver items bought well below melt, etc. - I do have about 100 unremarkable silver dollars and a few tubes of older Barber coins in AG-VG condition and dateless Standing Liberty quarters and the usual accumulations of 40% Kennedy halves and 35% war nickels, byproducts of buying mixed lots on eBay -</p><p>I keep track of them on individual Google Sheets (free spreadsheets) pages - My headings are: date, seller, spot price, cost, total grams of coins, total troy oz. of silver, cost per troy oz., % premium above spot, quantity, description and cumulative troy ounces of silver - the formulas for calculated columns save input time - I print out pages as they become full or at year end, whichever comes first.</p><p>The rest of my humble collection, miscellaneous world coins, Indian head cents, 1921 Mercs and 1932 quarters plus Secret Santa presents and lord M's & Noah Finney's recent lucky ha'penny are stored in flips inside a couple of fancy old wooden cigar boxes - the cigar box stuff maintains its value unchanged, but the bulk silver bullion value can be estimated by simple arithmetic (total troy ounces x silver spot price) - sample sheet pdf below[/QUOTE]</p><p><br /></p>
[QUOTE="juris klavins, post: 3374395, member: 76693"]95% of my 'collection is just silver bullion of various types - 90% 'constitutional' halves, quarter and dimes, .999 silver bars and rounds, sterling silver items bought well below melt, etc. - I do have about 100 unremarkable silver dollars and a few tubes of older Barber coins in AG-VG condition and dateless Standing Liberty quarters and the usual accumulations of 40% Kennedy halves and 35% war nickels, byproducts of buying mixed lots on eBay - I keep track of them on individual Google Sheets (free spreadsheets) pages - My headings are: date, seller, spot price, cost, total grams of coins, total troy oz. of silver, cost per troy oz., % premium above spot, quantity, description and cumulative troy ounces of silver - the formulas for calculated columns save input time - I print out pages as they become full or at year end, whichever comes first. The rest of my humble collection, miscellaneous world coins, Indian head cents, 1921 Mercs and 1932 quarters plus Secret Santa presents and lord M's & Noah Finney's recent lucky ha'penny are stored in flips inside a couple of fancy old wooden cigar boxes - the cigar box stuff maintains its value unchanged, but the bulk silver bullion value can be estimated by simple arithmetic (total troy ounces x silver spot price) - sample sheet pdf below[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
How do you track the value of your collection?
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...