Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
How do you guys organize your collections digitally?
>
Reply to Thread
Message:
<p>[QUOTE="Phil Ham, post: 1912190, member: 5787"]I use a spreadsheet with numerous tabs. The first tab has the entire collection organized by country, denomination, year, and mint mark. This tab includes numerous columns to record information on each coined acquired. The next series of tabs list the coin books that I have on each denomination and whether the hole is filled or not. I have also created tabs on proof sets, commemoratives, special issues, tokens, currency, and trading cards. Another tab summarizes the number and value of coins by country from the first tab. Another tab allows me to enter the information from coinflation, which is subsequntly linked to the market value of individual coins on the first tab. It takes the coinflation intrinsic value of the coin and adds a market valve to the formula. For instance, a 2014 bullion ASE might be $19.69 from coinflation plus $5 for its collector value. Another tab provides the currency rates from various countries versus $USD. It automatically updates foreign coin values, at least the ones without collector's value. I recently created a tab to list all the 20th century circulation coins and whether I have each one or not. One item on my bucket list is to have at least one of each 20th century circulation coins. I'm 93.06% of the way there. I also created a tab to summarize my coin purchases from each year and determine my current ROI. I've been collecting for quite some time and my ROI is 3.1276%. I do not consider it too bad for a hobby, as most hobbies cost you money.[/QUOTE]</p><p><br /></p>
[QUOTE="Phil Ham, post: 1912190, member: 5787"]I use a spreadsheet with numerous tabs. The first tab has the entire collection organized by country, denomination, year, and mint mark. This tab includes numerous columns to record information on each coined acquired. The next series of tabs list the coin books that I have on each denomination and whether the hole is filled or not. I have also created tabs on proof sets, commemoratives, special issues, tokens, currency, and trading cards. Another tab summarizes the number and value of coins by country from the first tab. Another tab allows me to enter the information from coinflation, which is subsequntly linked to the market value of individual coins on the first tab. It takes the coinflation intrinsic value of the coin and adds a market valve to the formula. For instance, a 2014 bullion ASE might be $19.69 from coinflation plus $5 for its collector value. Another tab provides the currency rates from various countries versus $USD. It automatically updates foreign coin values, at least the ones without collector's value. I recently created a tab to list all the 20th century circulation coins and whether I have each one or not. One item on my bucket list is to have at least one of each 20th century circulation coins. I'm 93.06% of the way there. I also created a tab to summarize my coin purchases from each year and determine my current ROI. I've been collecting for quite some time and my ROI is 3.1276%. I do not consider it too bad for a hobby, as most hobbies cost you money.[/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 guys organize your collections digitally?
>
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...