Can anyone please share some tips and probably Excel spreadsheet to do some calculations:
For example that 0.5g gold coin with store price of $60:
$1341 (spot price) / 31.103 (grams in an ounce) / 2 (as only half a gram) = $27.97 worth of Gold, so that markup/premium is HUGE (more than 100% over spot).
I want the input type of the Excel is:
The Gold price can be pulled from this website: www.apmex.com/spotprices/gold-price
(if this can be automated with auto refresh then it is great).
I want the output type of the Excel is:
RED if it is more than 100% of the worth of gold/store price.
GREEN if it is more than 50% of the worth of gold/store price.
31.103 grams to a troy ounce.
32.15 troy ounces to a kilo.
Spot x .75 for 18k
Spot x .916 for 22k
is this possible with Excel Spreadsheet ?
like in: http://www.silverstackers.com/calculators/index.php