Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Tools You Should Be Using
>
Reply to Thread
Message:
<p>[QUOTE="geekpryde, post: 1975562, member: 36248"]<b>Part 3: NGC Collection Manager</b></p><p><b><br /></b></p><p>I know not everyone wants to geek-out on spreadsheets, or database software for you collection, but personally I can't even image collecting coins without some sort of inventory software. I use and highly recommend NGC's FREE Collection Manager, <a href="https://coins.www.collectors-society.com/WCM/CoinCollectionManager.aspx" target="_blank" class="externalLink ProxyLink" data-proxy-href="https://coins.www.collectors-society.com/WCM/CoinCollectionManager.aspx" rel="nofollow">found here</a>. Register for a free account or sign in to your existing account. It looks like this:</p><p><br /></p><p>[ATTACH=full]351228[/ATTACH]</p><p><br /></p><p><br /></p><p> <a href="http://www.ngccoin.com/news/viewarticle.aspx?IDArticle=1686" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.ngccoin.com/news/viewarticle.aspx?IDArticle=1686" rel="nofollow">See here for intro</a>.</p><p><br /></p><p>It is just about as good as you could want for free software, and it may be all you'll ever need.</p><p><br /></p><p>Let me show you the process of adding a coin:</p><p><br /></p><p>[ATTACH=full]351235[/ATTACH]</p><p><br /></p><p>You specify "owned", and then the TPG or Raw, and then the CERT#, and if it is a PCGS or raw coin, you will have to add the details such as grade, type, etc. If it is NGC coin, it will pull in the appropriate basic details.</p><p><br /></p><p>You should specify some additional information, such as when you bought it, from whom you bought it, and the price and any fees such as CAC fees, shipping fees, buyer fees, etc.</p><p><br /></p><p>[ATTACH=full]351237[/ATTACH]</p><p><br /></p><p>Click <b>SAVE AND EDIT, </b>and you will see the basic info you just added and a whole lot more. I recommend you add notes about the variety, CAC approval, purchase notes, set a <i>custom</i> Value if there is a premium beyond retail, such toning premium. I also strongly recommend you upload an Obverse and Reverse image as you buy coins, so it is manageable and so you have a visual record of what you own.</p><p><br /></p><p>[ATTACH=full]351238[/ATTACH]</p><p><br /></p><p>When you are done adding everything you want to specify about the coin, you click Save & Return, and you are back at the overall view of your collection. From here, you have some powerful filtering options to drill down into a particular part of you collection, or to find an exact coin. Some columns can be a fuzzy search, some can have a NOT operator, and some have drop-down selections.</p><p><br /></p><p>For example, lets say you only want TPG coins, under the column called "<b>grader</b>", click the Key looking icon, and you will see a few options. Click on "Doesn't Contain", and type the word "raw".</p><p><br /></p><p>[ATTACH=full]351241[/ATTACH]</p><p><br /></p><p>You just filtered out all the RAW coins.</p><p><br /></p><p>Now you can string these together, so if you wanted a coin from 1930, that was either NGC or PCGS, you can easily do that. Or If you wanted to see only coins that were "Washington Quarters" that you SOLD, see this example:</p><p><br /></p><p>[ATTACH=full]351243[/ATTACH]</p><p><br /></p><p>Once you have taken the time to add or update all the coins in your collection with the maximum amount of info you know about each coin, you can easily make inventory reports, sales reports, storage reports, etc. To make a report for export to PDF or Excel or other, click on "My Collection" > "Reports"</p><p><br /></p><p>[ATTACH=full]351246[/ATTACH]</p><p><br /></p><p>From there, I usually like to use the Inventory Report, with the "Owned" filter to exclude coins I've sold. Click "<b>run report</b>". From there you can view it, or also export it to Excel or save to PDF and some other choices show here:</p><p><br /></p><p>[ATTACH=full]351247[/ATTACH]</p><p><br /></p><p><a href="https://imageshack.com/i/id82BgxZj" target="_blank" class="externalLink ProxyLink" data-proxy-href="https://imageshack.com/i/id82BgxZj" rel="nofollow"><img src="http://imagizer.imageshack.us/v2/xq90/661/82BgxZ.jpg" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></a></p><p><br /></p><p><br /></p><p>You can also easily add coins to the NGC Registry, or even better yet, a Custom Registry like my CAC Type Set. If you are still in the Collection Manage, click the "Control Panel" button and scroll down:</p><p><br /></p><p>[ATTACH=full]351244[/ATTACH]</p><p><br /></p><p>Click the "Custom Sets" TAB. Add a New Custom Set or simply modify an existing one with any new coins you may have added to the Collection Manager recently. As long as you have maintained you collection with NGC free software, this is extremely easy to roll out a bunch of Registry sets.</p><p><br /></p><p>[ATTACH=full]351245[/ATTACH]</p><p><br /></p><p>I think you are starting to see how powerful and helpful this software could be to bring order to your collection, know what you have, and be able to quickly produce inventory reports for your insurance company like Hugh Wood, or to keep safe backed up off-site in case of fire or other loss.</p><p><br /></p><p>For me, I like to know when and where I bought something, or how much, and when I sold it, did I lose money or make money after fees? There is other software you can use for this, and maybe you even like that product better than NGC, but for me, the Collection Manager is suitable for newbies and advanced collectors alike and that is why I wanted to share it with you today.</p><p><br /></p><p>Remember, have fun with your coins![/QUOTE]</p><p><br /></p>
[QUOTE="geekpryde, post: 1975562, member: 36248"][B]Part 3: NGC Collection Manager [/B] I know not everyone wants to geek-out on spreadsheets, or database software for you collection, but personally I can't even image collecting coins without some sort of inventory software. I use and highly recommend NGC's FREE Collection Manager, [URL='https://coins.www.collectors-society.com/WCM/CoinCollectionManager.aspx']found here[/URL]. Register for a free account or sign in to your existing account. It looks like this: [ATTACH=full]351228[/ATTACH] [URL='http://www.ngccoin.com/news/viewarticle.aspx?IDArticle=1686']See here for intro[/URL]. It is just about as good as you could want for free software, and it may be all you'll ever need. Let me show you the process of adding a coin: [ATTACH=full]351235[/ATTACH] You specify "owned", and then the TPG or Raw, and then the CERT#, and if it is a PCGS or raw coin, you will have to add the details such as grade, type, etc. If it is NGC coin, it will pull in the appropriate basic details. You should specify some additional information, such as when you bought it, from whom you bought it, and the price and any fees such as CAC fees, shipping fees, buyer fees, etc. [ATTACH=full]351237[/ATTACH] Click [B]SAVE AND EDIT, [/B]and you will see the basic info you just added and a whole lot more. I recommend you add notes about the variety, CAC approval, purchase notes, set a [I]custom[/I] Value if there is a premium beyond retail, such toning premium. I also strongly recommend you upload an Obverse and Reverse image as you buy coins, so it is manageable and so you have a visual record of what you own. [ATTACH=full]351238[/ATTACH] When you are done adding everything you want to specify about the coin, you click Save & Return, and you are back at the overall view of your collection. From here, you have some powerful filtering options to drill down into a particular part of you collection, or to find an exact coin. Some columns can be a fuzzy search, some can have a NOT operator, and some have drop-down selections. For example, lets say you only want TPG coins, under the column called "[B]grader[/B]", click the Key looking icon, and you will see a few options. Click on "Doesn't Contain", and type the word "raw". [ATTACH=full]351241[/ATTACH] You just filtered out all the RAW coins. Now you can string these together, so if you wanted a coin from 1930, that was either NGC or PCGS, you can easily do that. Or If you wanted to see only coins that were "Washington Quarters" that you SOLD, see this example: [ATTACH=full]351243[/ATTACH] Once you have taken the time to add or update all the coins in your collection with the maximum amount of info you know about each coin, you can easily make inventory reports, sales reports, storage reports, etc. To make a report for export to PDF or Excel or other, click on "My Collection" > "Reports" [ATTACH=full]351246[/ATTACH] From there, I usually like to use the Inventory Report, with the "Owned" filter to exclude coins I've sold. Click "[B]run report[/B]". From there you can view it, or also export it to Excel or save to PDF and some other choices show here: [ATTACH=full]351247[/ATTACH] [URL='https://imageshack.com/i/id82BgxZj'][IMG]http://imagizer.imageshack.us/v2/xq90/661/82BgxZ.jpg[/IMG][/URL] You can also easily add coins to the NGC Registry, or even better yet, a Custom Registry like my CAC Type Set. If you are still in the Collection Manage, click the "Control Panel" button and scroll down: [ATTACH=full]351244[/ATTACH] Click the "Custom Sets" TAB. Add a New Custom Set or simply modify an existing one with any new coins you may have added to the Collection Manager recently. As long as you have maintained you collection with NGC free software, this is extremely easy to roll out a bunch of Registry sets. [ATTACH=full]351245[/ATTACH] I think you are starting to see how powerful and helpful this software could be to bring order to your collection, know what you have, and be able to quickly produce inventory reports for your insurance company like Hugh Wood, or to keep safe backed up off-site in case of fire or other loss. For me, I like to know when and where I bought something, or how much, and when I sold it, did I lose money or make money after fees? There is other software you can use for this, and maybe you even like that product better than NGC, but for me, the Collection Manager is suitable for newbies and advanced collectors alike and that is why I wanted to share it with you today. Remember, have fun with your coins![/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
>
Tools You Should Be Using
>
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...
