Jump to content

I Made A Spreadsheet For Calculating Melt Values Of Finds


Recommended Posts

The other day I made a spreadsheet to calculate MELT value of all my finds, I pull most of the info from coininfo.com and then spot prices of precious metals from Money Metals Exchange. I pull over 35% nickels, 90% dimes, 90% quarters, 90% halves and because I found one, 80% Candian quarter prices, plus 9, 10, 14, and 18k gold. Under the PM spots there's a sterling silver per gram conversion and then there are some bullion prices (These I think are dealer bid prices, so lower than normal) and along with those, a sterling/ounce price. It is made with google sheets but I'm sure you can export it to excel format (or even LibreOffice Calc). The prices are not live, but they do update each time you open the file. Here is a link to check it out and copy it for yourself. Below everything you'll see 2 cells with the formula for "American Silver Eagle". I left that there to test pulling in other info from the website. If anyone wants an explanation on how to add different things just let me know. Later today I will try to explain here

Link to comment
Share on other sites


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...