REALTIME NAVs of Closed End Precious Metal Funds - PUBLIC
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
If you find a problem, think of something good to add, or just want to say hi feel free to email me @ monetaadvisors@gmail.com#REF!
2
NAVS of certain precious Metal FundsThis spreadsheet self updates based on the bid side of the Monex spot gold & silver prices. This sheet incorporates asmuch real time updating as possible. Prices are real time as of each refresh Also note Closed End data screen scraped from NAV pages which change data positions on occasion causing a #REF which I fix when I notice itMonex DownRealTime DownForex Down
3
S&P 500/GOLD Ratio#REF!MAY 1932 4.5FEB 1933 4.5xDEC 1974 2.7xJan 1980 5.7xNOTE THIS SHEET ONLY FUNCTIONS FULLY WHEN MARKETS ARE OPEN PRICES WILL ONLY LOAD FROM 9:30am to 4pm
4
Today's Date:11/21/2016 16:58:46Dow/GOLD Ratio =#REF!GoldSilverCEFGTUPHYSPSLVSPPPUSD/CADPlatinum Palladium
5
Date of Last Manual Update of Holdings:9/24/2012Spot Gold/Silver Ratio = #REF!Open#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
6
XAU81.081.772.23%Delay (Minutes) = RTRTRTRTRT15RT
7
HUI184.412.311.27%PHYS UPDATED TO REFLECT LATEST OFFERING 9-24-2012Updated to reflect latest secondary as it stands 9/24
8
Central Fund of Canada (CEF)Central Gold Trust of Canada (GTU)Sprott Physical Gold Trust (PHYS)Sprott Physical Silver Trust (PSLV)Sprott Physical Platinum & Palladium Trust
9
Holdings%US$ PriceUS$ ValueHoldings%US$ ValueHoldings%US$ PriceUS$ ValueHoldings%Holdings%US$ PriceUS$ Value
10
11
Gold Oz#REF!#REF!#REF!#REF!Gold Oz698,496#REF!#REF!Gold Oz1,616,832#REF!#REF!#REF!Silver Oz49,287,863#REF!#REF!#REF!Platinum81,486#REF!#REF!#REF!
12
Palladium186098#REF!#REF!#REF!
13
Silver Oz#REF!#REF!#REF!#REF!Gold Cert Oz6,156#REF!#REF!
14
EstimatedEstimated#REF!
15
Cash Assets#REF!#REF!#REF!#REF!Cash $15,999,409.00#REF!$15,999,409Cash #REF!#REF!#REF!Cash#REF!#REF!#REF!
16
Cash#REF!#REF!
17
Subtotal#REF!#REF!#REF!#REF!#REF!
18
19
Shares254,432,713Shares19,299,000Shares195,368,753Shares127,367,197Shares28,000,000
20
Oz per share0.00828Au val#REF!total %#REF!
21
NAV per share#REF!#REF!NAV#REF!#REF!NAV#REF!Estimated#REF!Nav per Share#REF!Estimated#REF!Nav per Share#REF!
22
23
Price#REF!Price#REF!Price#REF!Price#REF!Price#REF!
24
25
Premium#REF!Premium#REF!PremiumPrem Au only no cash#REF!#REF!Premium#REF!Premium#REF!
26
27
Percent to NAV#REF!Percent to NAV#REF!Percent to NAV% Au only no cash#REF!#REF!Percent to NAV#REF!Percent to NAV#REF!
28
29
Monex will temporarily go down on occasion and the information will display N/A. It will come back when Kitco refreshes.instrument=/PLN4
30
Silver Bullion Trust (SBT.U)
31
Holdings%US$ ValueGOLD TRACKERSTICKERSPriceDaily Change ($)52 Week Low
32
JPMGLD115.580.43100.23
33
Silver Oz3,143,830#REF!#REF!HSBCSGOL117.860.37102.26
34
SprottPHYS9.940.028.624136941454.11487.61452.200
35
Silver Cert Oz0#REF!#REF!Ultra GoldUGL37.050.2629.0648.27
36
Ultra Short GoldGLL82.15-0.5664.91118.85
37
Cash CA$ 2,049,792.00#REF!#REF!GOLD& SILVER MINER ETFSTICKERSPriceDaily Change ($)52 Week Low52 Week HighDouble Short GoldDZZ6.24-0.044.89.08
38
SeniorsGDX21.480.4312.431.79
39
#REF!JuniorsGDXJ35.260.7416.8752.5SILVER TRACKERSTICKERSPriceDaily Change ($)52 Week Low52 Week High
40
ExplorersGLDX#N/A#N/A#N/A#N/AJPMSLV15.72-0.0113.0419.71
41
SilverSIL35.71.1214.9454.34HSBCSIVR16.230.0113.4320.3
42
SprottPSLV6.320.035.238.01
43
Shares5,467,228Ultra SilverAGQ35.2026.5557.26
44
Ultra Short SilverZSL36.4-0.0925.0866.29
45
46
47
NAV per Share#REF!
48
49
50
Price
51
52
53
Premium#REF!
54
55
Percent to NAV#REF!
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
Loading...
 
 
 
Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet7
Sheet8