Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
5/3/2013 1:49:27 PM EDT
Anyone have a recommendation for an Excel spreadsheet to track PM?  I found this one that has an auto price update through Kitco.  Any other suggestions?  TIA.

Gold & Silver Spreadsheet
5/3/2013 10:35:00 PM EDT
[#1]
I am using that one to keep an inventory. It covers the major bullion sizes but doesnt have things like 5oz, 2oz, 1/2oz etc.
5/4/2013 4:03:28 AM EDT
[#2]
Thanks for the reply.  I started using it last night for some silver my FIL gave us.  I was able to easily add rows to account for some items he has like WWII 35% silver nickels and some non-silver stuff he had in the pile like bi-centennial coins.  I went to this site: Silver Coin Weight Conversions and got the values I needed for the weights so I could update the cells.  

I like the built in calculator and the auto update feature that tracks the spot price for silver/gold and refreshes the values every 10 minutes.  I think it will work well for my needs, and being free is a plus.

ETA:  I also found this spreadsheet FWIW:  Grasp the Wealth