ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Spot Prices & Source Setup
2
Edit B4 and B5 manually, or replace them with a live-feed formula from a licensed/approved source.
3
4
MetalSpot Price / Troy OzUnitNotes
5
Gold$4,541.80USD/oztManual value used by Gold tab and Summary.
6
Silver$73.03USD/oztManual value used by Silver tabs and Summary.
7
Last Updated5/4/2026Change this when you update prices.
8
Constitutional silver assumption$1.40 face = 1.000 troy oz silverUsed in 90% Silver tab formulas.
9
Sterling assumption.925 fine silverUsed in .925 Silver tab formulas.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100