Precious Metals Chart For Excel

[JoeSwindell]

I made a precious metal's chart for gold/silver/platinum/palladium where you can just change the price per ounce and get results for different weights.

You can download it here

http://vaparkway.com/other/goldvalues.xlsx (Excel 2007 + version)
http://vaparkway.com/other/goldvalues.xls (Excel 2003 Version)

If you like it please let me know! Or if there is anything wrong...I'm pretty sure I did most of it right but yeh...haha.

 

Amazon Forum Fav 👍

A Handbook of Civil War Bullets and Cartridges - Grab it through Amazon!

[mlayers]

Nice chart. I like it....Matt

 

[Real de Tayopa Tropical Tramp]

Excellent work my friend, thanks.

Don Jose de La Mancha

 

[arizonaames]

Sandman came up with this and it works well. You will have precious metal quotes all the time next to your date and time. Kitco is a precious metals brokerage:

http://kcast.kitco.com/

 

[detector de metales]

Nice spreadsheet!
Thanks!

J2

 

[rvdsr]

I though there was 20 dwts. to a ounce..doesn't this post say 24 on the chart.?

 

[stefen]

If its 16 OZ/LB

 

[Goodyguy]

I though there was 20 dwts. to a ounce..doesn't this post say 24 on the chart.?

Precious metals are usually bought and sold in Troy weights.

1 Troy ounce = 31.103 grams or 480 grains
1 Troy pound = 12 Troy ounces or 5,760 grains
There are 24 dwt to a Troy ounce dwt stands for pennyweight

Cornfuzin aint it
Here is a conversion chart for those in need: http://www.onlygold.com/tutorialpages/conversion_tables_FullScreenView.htm


GG~

 

[scrubber]

Thanks Joe and GG for the excellent tools.

scrubber

 

[simulationconsultant]

You'll find a spreadsheet that downloads historical prices for gold (and silver) at this link