Spreadsheet: 207828d1358570761-using-the-values-in-last-column-to-return-the-values-in-the-first-column-basic-materials-1
Sheet: Copper-Gold

Stock Quotes Provided by MSN Money
Click here to visit MSN Money
 |  |  | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market [NAME] | EPS | P/E Ratio | # [NAME] Out
Augusta Resource Corp | Chart | News | 2.38 | 2.5 | 2.5 | 2.34 | 131743 | -0.12 | -0.048 | 3.65 | 1.48 | 342926362 | -0.04 |  | 144086700
Freeport-McMoRan Copper & Gold Inc | Chart | News | 33.64 | 34.08 | 34.43 | 33.57 | 16632330 | -0.44 | -0.0129 | 48.96 | 30.54 | 31935083853 | 3.08 | 11.1 | 949318800
Lihua International Inc | Chart | News | 4.41 | 4.48 | 4.55 | 4.41 | 65376 | -0.07 | -0.0156 | 6.89 | 3.35 | 132674316 | 1.83 | 2.4 | 30084880
Southern Copper Corp | Chart | News | 41.26 | 40.7 | 41.28 | 40.75 | 1869919 | 0.56 | 0.0138 | 40.82 | 27.72 | 34887412211 | 2.28 | 17.8 | 845550500
Sterlite Industries (India) Ltd | Chart | News | 8.55 | 8.58 | 8.55 | 8.4 | 376370 | -0.03 | -0.0035 | 10.84 | 6.42 | 7184581405 | 0.89 | 9.7 | 840301900
Barrick Gold Corp | Chart | News | 34.04 | 34.08 | 34.21 | 33.95 | 5363831 | -0.04 | -0.0012 | 50.39 | 31 | 34077717237 | 3.34 | 10.2 | 1001108000
AgniCo Eagle Mines Ltd | Chart | News | 50.57 | 50.59 | 50.8 | 50.35 | 1102625 | -0.02 | -0.0004 | 57.35 | 31.42 | 8707445967 | -2.19 |  | 172186000
Allied Nevada Gold Corp | Chart | News | 25.39 | 26.8 | 26.4 | 25.34 | 2426568 | -1.41 | -0.0526 | 41.02 | 23.69 | 2278348998 | 0.55 | 49.1 | 89734110
AngloGold Ashanti ADR Reptg 1 Ord Shs | Chart | News | 29.13 | 29.14 | 29.44 | 28.99 | 844181 | -0.01 | -0.0003 | 47.17 | 28.61 | 11166198668 | 3.33 | 8.8 | 383323000
AuRico Gold Inc | Chart | News | 7.96 | 8.17 | 8.05 | 7.82 | 12001151 | -0.21 | -0.0257 | 10.35 | 5.25 | 2247203531 | 0.41 | 30.3 | 282312000
Yamana Gold Inc | Chart | News | 17.34 | 17.28 | 17.47 | 17.15 | 4314518 | 0.06 | 0.0035 | 20.59 | 12.68 | 13039945417 | 0.48 | 35.7 | 752015300
Aurizon Mines Ltd | Chart | News | 4.67 | 4.7 | 4.72 | 4.64 | 1025479 | -0.03 | -0.0064 | 5.77 | 3.19 | 768508289 | 0.27 | 17.2 | 164562800
Banro Corp | Chart | News | 2.84 | 2.96 | 2.97 | 2.81 | 140524 | -0.12 | -0.0405 | 6.05 | 2.55 | 573344863 | -0.07 |  | 201882000
Brigus [NAME] | Chart | News | 0.95 | 0.96 | 0.97 | 0.95 | 288362 | -0.01 | -0.0102 | 1.24 | 0.69 | 219838277 | 0.08 | 11.9 | 231360000
Compania De Minas Buenaventura SAA | Chart | News | 35.2 | 35.1 | 35.39 | 35.06 | 749187 | 0.1 | 0.0028 | 43.9 | 30.86 | 9702338130 | 3.04 | 11.6 | 275634600
Claude Resources Inc | Chart | News | 0.61 | 0.6 | 0.63 | 0.59 | 371280 | 0.01 | 0.0167 | 1.53 | 0.5 | 105984818 | 0.02 | 35.7 | 173745600
DRDGOLD ADR Representing 10 Ord Shs | Chart | News | 7.94 | 8.01 | 7.99 | 7.8 | 28072 | -0.07 | -0.0087 | 8.38 | 5.35 | 305994739 | 0.93 | 11.9 | 38538380
Entree Gold Inc | Chart | News | 0.51 | 0.48 | 0.52 | 0.47 | 107170 | 0.03 | 0.0667 | 1.41 | 0.4 | 65714481 | -0.12 |  | 128877200
[NAME] | Chart | News | 12.83 | 12.81 | 12.91 | 12.68 | 1533775 | 0.02 | 0.0016 | 16.2 | 9.78 | 9159610225 | 0.44 | 29 | 713921300
Franco-Nevada Corp | Chart | News | 55.4 | 56.4 | 56.59 | 55.35 | 185555 | -1 | -0.0177 | 61.6 | 37.51 | 8118792664 | 0.13 | 419.8 | 146548600
Great Basin Gold Ltd | Chart | News | 0 |  | 0 | 0 | 0 |  | 0 | 1.31 | 0.08 | 48066850 | -0.17 |  | 552436500
Gold Fields ADR Representing 1 Ord Shs | Chart | News | 12.34 | 12.13 | 12.36 | 12.1 | 2216073 | 0.21 | 0.0173 | 16.97 | 11.09 | 9004564747 | 1.2 | 10.1 | 729705400
Goldcorp Inc | Chart | News | 37.2 | 37.24 | 37.54 | 37.08 | 3385664 | -0.04 | -0.0011 | 50.74 | 31.54 | 30186595339 | 1.83 | 20.3 | 811467600
Randgold Resources ADR Reptg 1 Ord Shs | Chart | News | 92.27 | 92.87 | 93.28 | 91.91 | 361516 | -0.6 | -0.0065 | 127.27 | 72.91 | 8495367793 | 4.67 | 19.9 | 92070750
Gold Resource Corp | Chart | News | 14.39 | 14.65 | 14.76 | 14.2 | 519570 | -0.26 | -0.0177 | 28.36 | 12.13 | 758056152 | 1.11 | 13.2 | 52679370
Gold Reserve Inc | Chart | News | 2.9 | 2.77 | 2.91 | 2.77 | 84710 | 0.13 | 0.0469 | 4.66 | 2.53 | 209413270 | -0.35 |  | 72211470
Golden Star Resources Ltd | Chart | News | 1.77 | 1.78 | 1.79 | 1.74 | 989315 | -0.01 | -0.0056 | 2.25 | 0.9 | 458458315 | -0.05 |  | 259016000
Gold Standard Ventures Corp | Chart | News | 1.18 | 1.14 | 1.19 | 1.15 | 127908 | 0.04 | 0.0351 | 3.05 | 0.97 | 98907725 | -0.08 |  | 83820110
Central GoldTrust | Chart | News | 64.1 | 64.26 | 64.55 | 63.93 | 13017 | -0.16 | -0.0025 | 69.1 | 56.77 | 1237065871 | 4.4 | 14.5 | 19299000
Harmony Gold Mining ADR Representing 1 Ord Shs | Chart | News | 7.64 | 7.55 | 7.7 | 7.54 | 1297379 | 0.09 | 0.0119 | 13.4 | 7.46 | 3325368770 | 0.77 | 12.3 | 435257700
IAMGOLD Corp | Chart | News | 11 | 10.84 | 11.04 | 10.86 | 2134282 | 0.16 | 0.0148 | 17.74 | 9.2 | 4141907000 | 1.01 | 10.7 | 376537000
Jaguar Mining Inc | Chart | News | 0.75 | 0.68 | 0.76 | 0.68 | 2194318 | 0.07 | 0.1111 | 7.35 | 0.58 | 63307238 | -0.81 |  | 84409650 |  | AZC
Kimber Resources Inc | Chart | News | 0.38 | 0.38 | 0.39 | 0.38 | 56078 | 0 | -0.0052 | 1.32 | 0.32 | 31443339 | -0.04 |  | 82745630 |  | FCX
Kinross Gold Corp | Chart | News | 9.53 | 9.49 | 9.57 | 9.44 | 5558835 | 0.04 | 0.0042 | 11.95 | 7.11 | 10865209876 | -2.02 |  | 1140106000 |  | LIWA
Kingold Jewelry Inc | Chart | News | 1.31 | 1.35 | 1.35 | 1.3 | 89656 | -0.04 | -0.0296 | 2.93 | 0.97 | 80592690 | 0.52 | 2.6 | 61521140 |  | SCCO
Keegan Resources Inc | Chart | News | 4 | 3.88 | 4 | 3.85 | 75368 | 0.12 | 0.0309 | 5.45 | 2.35 | 340137360 | -0.24 |  | 85034340 |  | SLT
Comstock Mining Inc | Chart | News | 1.91 | 1.9 | 1.91 | 1.85 | 137439 | 0.01 | 0.0053 | 3.42 | 1.59 | 91311502 | -0.89 |  | 47807070 |  | ABX
Lake Shore Gold Corp | Chart | News | 0.89 | 0.91 | 0.91 | 0.88 | 188975 | -0.02 | -0.022 | 2.08 | 0.64 | 369932321 | -0.05 |  | 415654300 |  | AEM
Midway Gold Corp | Chart | News | 1.33 | 1.33 | 1.37 | 1.32 | 409731 | 0 | 0 | 2.14 | 1.07 | 170840235 | -0.15 |  | 128451300 |  | ANV
Minco Gold Corp | Chart | News | 0.45 | 0.47 | 0.47 | 0.45 | 44932 | -0.02 | -0.0404 | 0.98 | 0.34 | 22721249 | -0.1 |  | 50379710 |  | AU
Newmont Mining Corp | Chart | News | 44.89 | 44.44 | 45.22 | 44.46 | 6740276 | 0.45 | 0.0101 | 64.43 | 42.95 | 22065055229 | 0.19 | 111.6 | 491536100 |  | AUQ
NovaGold Resources Inc | Chart | News | 4.7 | 4.7 | 4.77 | 4.65 | 1364934 | 0 | 0 | 10.81 | 3.61 | 1463735981 | -0.34 | 34.6 | 311433200 |  | AUY
New Gold Inc | Chart | News | 10.93 | 10.83 | 11.01 | 10.82 | 1838650 | 0.1 | 0.0092 | 12.84 | 7.13 | 5202711842 | 0.21 | 51.5 | 476002900 |  | AZK
Nevsun Resources Ltd | Chart | News | 4.68 | 4.5 | 4.68 | 4.47 | 304669 | 0.18 | 0.04 | 6.83 | 2.68 | 931239470 | 0.84 | 5.4 | 198982800 |  | [NAME]
Primero Mining Corp | Chart | News | 6.42 | 6.56 | 6.57 | 6.39 | 256622 | -0.14 | -0.0213 | 7.98 | 2.28 | 622198288 | 0.95 | 6.9 | 96915620 |  | BRD
Rubicon Minerals Corp | Chart | News | 2.52 | 2.54 | 2.53 | 2.5 | 301441 | -0.02 | -0.0079 | 4.49 | 2.34 | 724767115 | -0.1 |  | 287606000 |  | BVN
Royal Gold Inc | Chart | News | 79.84 | 79.85 | 80.49 | 79.33 | 603635 | -0.01 | -0.0001 | 100.84 | 57 | 5139006753 | 1.61 | 49.3 | 64366320 |  | CGR
[NAME] | Chart | News | 3.35 | 3.35 | 3.39 | 3.32 | 99859 | 0 | 0 | 12.91 | 2.71 | 132546431 | -0.69 |  | 39566100 |  | DRD
Seabridge Gold Inc | Chart | News | 17.19 | 17.53 | 17.75 | 17.12 | 424902 | -0.34 | -0.0194 | 25.65 | 12.2 | 783114197 | -0.35 |  | 45556380 |  | EGI
Sandstorm Gold Ltd | Chart | News | 13.11 | 13.11 | 13.25 | 12.9 | 236924 | 0 | 0 | 15.43 | 6.16 | 1127589628 | 0.23 | 55.8 | 86009890 |  | EGO
Timmins Gold Corp | Chart | News | 3.01 | 3.06 | 3.06 | 2.99 | 54352 | -0.05 | -0.0163 | 3.47 | 1.45 | 433241339 | 0.25 | 12.4 | 143934000 |  | FNV
International Tower Hill Mines Ltd | Chart | News | 2.39 | 2.4 | 2.45 | 2.33 | 133259 | -0.01 | -0.0042 | 5.62 | 1.91 | 234384060 | -0.24 |  | 98068640 |  | GBG
Timberline Resources Corp | Chart | News | 0.22 | 0.22 | 0.24 | 0.22 | 79389 | 0 | -0.0098 | 0.63 | 0.19 | 12397880 | -0.08 |  | 55645780 |  | GFI
Tanzanian Royalty Exploration Corp | Chart | News | 3.83 | 3.85 | 3.88 | 3.71 | 446140 | -0.02 | -0.0052 | 5.34 | 2.7 | 385609371 | -0.14 |  | 100681300 |  | GG
Vista Gold Corp | Chart | News | 2.46 | 2.49 | 2.51 | 2.43 | 562797 | -0.03 | -0.012 | 4.09 | 2.21 | 200646213 | -0.46 |  | 81563500 |  | GOLD
Solitario Exploration & Royalty Corp | Chart | News | 1.7 | 1.68 | 1.75 | 1.67 | 19179 | 0.02 | 0.0119 | 1.92 | 0.97 | 58615934 | -0.11 |  | 34479960 |  | GORO
Exeter Resource Corp | Chart | News | 1.39 | 1.35 | 1.39 | 1.34 | 135055 | 0.04 | 0.0296 | 4.2 | 1.09 | 122886771 | -0.31 |  | 88407750 |  | GRZ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSS
Symbol Lookup |  | MSN Money Home |  |  |  | Microsoft Office Tools on the Web |  |  |  |  |  |  |  |  |  |  | GSV
Find stocks, mutual funds, options, indices, and currencies. |  | Discover MSN Money's tools, columns, and more! |  |  |  | Get the latest from Microsoft Office |  |  |  |  |  |  |  |  |  |  | GTU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HMY
Terms of Use. © 2013 Microsoft Corporation and/or its suppliers. All rights reserved. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IAG
DATA PROVIDERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KBX
Copyright © 2013 Microsoft. All rights reserved. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KGJI
Quotes are real-time for NASDAQ, NYSE and AMEX. See delay times for other exchanges. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KGN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LODE
Fundamental company data and historical chart data provided by Thomson Reuters (click for restrictions). Real-time quotes provided by BATS Exchange. Real-time index quotes and delayed quotes supplied by Interactive Data Real-Time Services. Fund summary, fund performance and dividend data provided by Morningstar Inc. Analyst recommendations provided by Zacks Investment Research. StockScouter data provided by Verus Analytics. IPO data provided by Hoover's Inc. Index membership data provided by SIX Telekurs. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LSG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MDW
Japanese stock price data provided by Nomura Research Institute Ltd.; quotes delayed 20 minutes. Canadian fund data provided by CANNEX Financial Exchanges Ltd. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MGH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEM
AZC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NG
FCX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NGD
LIWA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSU
SCCO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PPP
SLT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RBY
ABX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RGLD
AEM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RIC
ANV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
AU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAND
AUQ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TGD
AUY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THM
AZK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TLR
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRX
BRD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VGZ
BVN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XPL
CGR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XRA
DRD
EGI
EGO
FNV
GBG
GFI
GG
GOLD
GORO
GRZ
GSS
GSV
GTU
HMY
IAG
JAG
KBX
[NAME]
KGJI
KGN
LODE
LSG
MDW
MGH
NEM
NG
NGD
NSU
PPP
RBY
RGLD
RIC
SA
SAND
TGD
THM
TLR
TRX
VGZ
XPL
XRA