Spreadsheet: 207820-using-the-values-in-last-column-to-return-the-values-in-the-first-column-basic-materials
Sheet: Major Integrated Oil & Gas

Stock Quotes Provided by MSN Money
Click here to visit MSN Money |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BP
 |  |  | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market [NAME] | EPS | P/E Ratio | # [NAME] Out |  | COP
BP ADR Each Representing Six Ord Shs | Chart | News | 44.04 | 44.16 | 44.17 | 43.93 | 4059442 | -0.12 | -0.0027 | 48.34 | 36.25 | 140510503721 | 5.51 | 8 | 3190520000 |  | CVX
ConocoPhillips | Chart | News | 59.27 | 59.14 | 59.36 | 58.97 | 5309471 | 0.13 | 0.0022 | 78.29 | 50.62 | 71947557206 | 8.1 | 10.6 | 1213895000 |  | E
Chevron Corp | Chart | News | 115.24 | 114.74 | 115.24 | 114.06 | 8542855 | 0.5 | 0.0044 | 118.53 | 95.73 | 225545534259 | 12.19 | 9.4 | 1957181000 |  | EC
ENI ADR | Chart | News | 51.64 | 52.12 | 51.67 | 51.14 | 602552 | -0.48 | -0.0092 | 52.27 | 36.59 | 93834681411 | 5.62 | 9.5 | 1817093000 |  | ECA
Ecopetrol SA | Chart | News | 61.8 | 61.32 | 61.89 | 61.26 | 495948 | 0.48 | 0.0078 | 67.92 | 49.09 | 127050601432 | 4.13 |  | 2055835000 |  | EQM
[NAME] | Chart | News | 19.39 | 19.48 | 19.51 | 19.14 | 7854560 | -0.09 | -0.0046 | 24.29 | 17.28 | 14260314942 | -4.02 |  | 735446900 |  | GPR
EQT Midstream Partners LP | Chart | News | 33.37 | 32.9 | 34.02 | 32.9 | 55921 | 0.47 | 0.0143 | 34.96 | 22.58 | 1180870159 | 2.28 | 14.4 | 35387180 |  | OXY
Geopetro Resources Co | Chart | News | 0.08 | 0.09 | 0.1 | 0.08 | 30710 | -0.01 | -0.0889 | 0.27 | 0.06 | 3729204 | -0.1 |  | 45478100 |  | PTR
Occidental Petroleum Corp | Chart | News | 82.58 | 82.39 | 82.58 | 81.61 | 4784611 | 0.19 | 0.0023 | 106.68 | 72.43 | 66904987945 | 7.26 | 11.3 | 810183900 |  | PZE
Petrochina ADR Representing 100 Ord Shs | Chart | News | 144.29 | 142.65 | 144.36 | 143.17 | 77335 | 1.64 | 0.0115 | 153.35 | 116.35 | 264080988612 | 10.37 | 13.8 | 1830210000 |  | RDS-B
Petrobras Argentina ADR Representing 10 Ord Shs Class B | Chart | News | 5.05 | 4.99 | 5.09 | 4.95 | 71157 | 0.06 | 0.012 | 8.61 | 3.4 | 1019714724 | 0.53 | 9.5 | 201923700 |  | RRMS
RDS-B (Invalid symbol) | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? |  | SNP
Rose Rock Midstream LP | Chart | News | 32.09 | 32 | 32.19 | 32 | 8250 | 0.09 | 0.0028 | 34.58 | 20.22 | 538451590 | -0.71 |  | 16779420 |  | SSL
China Petroleum and Chemical ADR Repstng 100 H Ord Shs | Chart | News | 118.68 | 117.02 | 118.99 | 117.63 | 71210 | 1.66 | 0.0142 | 125.36 | 82.51 | 103038320437 | 10.04 | 11.7 | 868202900 |  | STO
Sasol Level II ADR repsg 1 Ord Shs | Chart | News | 41.85 | 41.77 | 41.87 | 41.57 | 160894 | 0.08 | 0.0019 | 54.42 | 39.72 | 27162716400 | 4.45 | 9.4 | 649049400 |  | TOT
Statoil ADR Rep 1 Ord Shs | Chart | News | 25.79 | 25.78 | 25.79 | 25.59 | 477513 | 0.01 | 0.0004 | 28.95 | 22 | 82235209049 | 4.6 | 5.6 | 3188647000 |  | XOM
Total ADR repsg one Ord Shs | Chart | News | 52.69 | 53.12 | 52.85 | 52.22 | 1746396 | -0.43 | -0.0081 | 57.06 | 41.75 | 124660268861 | 6.26 | 8.5 | 2365919000
Exxon Mobil Corp | Chart | News | 90.8 | 90.2 | 90.83 | 89.83 | 17196687 | 0.6 | 0.0067 | 93.67 | 77.13 | 413988358314 | 9.47 | 9.5 | 4559343000
Symbol Lookup |  | MSN Money Home |  |  |  | Microsoft Office Tools on the Web
Find stocks, mutual funds, options, indices, and currencies. |  | Discover MSN Money's tools, columns, and more! |  |  |  | Get the latest from Microsoft Office
Terms of Use. © 2013 Microsoft Corporation and/or its suppliers. All rights reserved.
DATA PROVIDERS
Copyright © 2013 Microsoft. All rights reserved.
Quotes are real-time for NASDAQ, NYSE and AMEX. See delay times for other exchanges.
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.
Japanese stock price data provided by Nomura Research Institute Ltd.; quotes delayed 20 minutes. Canadian fund data provided by CANNEX Financial Exchanges Ltd.
BP
COP
CVX
E
EC
ECA
EQM
GPR
OXY
PTR
PZE
RDS-B
RRMS
SNP
SSL
STO
TOT
XOM