Realcent.org

Base Metal & Precious Metals Forum

Skip to content

INVENTORY TRACKING FOR SILVER COIN

This forum is for discussing hunting and collecting US and Canadian circulation Silver Bullion Coins, other types of minted bullion, and other types of precious and base metal investments other than Bullion Pennies and Nickels.

Please Note: These articles are to inform your thinking, not lead it. Only you can decide the best place for your money, and any decision you make will put your money at risk. Information or data included here may have already been overtaken by events – and must be verified elsewhere – should you choose to act on it.
Post a reply

INVENTORY TRACKING FOR SILVER COIN

Postby mtldealer » Fri Jan 20, 2012 4:23 pm

what is the best way to track silver coin culled from circulation? I sort thru thousands of dollars a week and I am using paper and pencil to keep track of my finds... any suggestions?
User avatar
mtldealer
Penny Collector Member
 
Posts: 462
Joined: Mon Oct 31, 2011 3:58 pm
Location: West Coast
Top

Re: INVENTORY TRACKING FOR SILVER COIN

Postby Chief » Fri Jan 20, 2012 4:27 pm

I use excel with week of the year #, dates, total coin searched, halves searched, dimes searched, 90% Halves, 40% halves, 90% dimes, then use the ASW of the three to calculate troy oz per week and troy oz per $1k searched. Then totals at the bottom.
ASW that I use...
90% Halves: 0.36169
40% Halves: 0.1479
90% Dimes: 0.07234
Hope this helps! :)
User avatar
Chief
1000+ Penny Miser Member
 
Posts: 1656
Joined: Thu Mar 31, 2011 11:38 pm
Location: Nebraska
Top

Re: INVENTORY TRACKING FOR SILVER COIN

Postby rexmerdinus » Fri Jan 20, 2012 4:32 pm

http://goldsilverstocks.info/GOLDSILVERSPREADSHEET.html

Pretty easy to modify if you have any knowledge of Excel. For other ideas, see te old thread here:
viewtopic.php?f=9&t=8760
My beer and homebrewing blog: http://alemongery.blogspot.com
My wine and winemaking blog: http://connoisseurscorner.blogspot.com
rexmerdinus
Penny Collector Member
 
Posts: 486
Joined: Tue Apr 20, 2010 3:00 pm
Top
Post a reply

Return to Silver Bullion, Gold, & other Bullion Metals

Who is online

Users browsing this forum: No registered users and 72 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group