Spreadsheet: 107071d1304247342-need-help-with-correlation-matrix-woodside-petroleum
Sheet: Sheet 1 - Table 1

Price History
Woodside Petroleum Limited (WPL)
Date | Close | Monthly return | Average | [NAME]
2003-01-31 00:00:00 | 11.57 | -0.07257998647194694 | 0.01370279672029393 | 0.00598639932422076
2003-02-28 00:00:00 | 10.76 | 0.004636076917478651
2003-03-31 00:00:00 | 10.81 | 0.0496267816418883
2003-04-30 00:00:00 | 11.36 | 0
2003-05-30 00:00:00 | 11.36 | 0.07787350942599111
2003-06-30 00:00:00 | 12.28 | 0.07072860635536479
2003-07-31 00:00:00 | 13.18 | 0.004542021434500986
2003-08-29 00:00:00 | 13.24 | 0.003769322216291696
2003-09-30 00:00:00 | 13.29 | -0.01287408920921101
2003-10-31 00:00:00 | 13.12 | 0.03813546219249843
2003-11-28 00:00:00 | 13.63 | 0.07421277747792819
2003-12-31 00:00:00 | 14.68 | -0.01440848254297693
2004-01-30 00:00:00 | 14.47 | 0.04195473213636508
2004-02-27 00:00:00 | 15.09 | 0.0313137130661494
2004-03-31 00:00:00 | 15.57 | 0.05193534898424575
2004-04-30 00:00:00 | 16.4 | -0.01722059775167041
2004-05-31 00:00:00 | 16.12 | 0.02511617475445062
2004-06-30 00:00:00 | 16.53 | 0.07626621531893045
2004-07-30 00:00:00 | 17.84 | 0.002798770368764509
2004-08-31 00:00:00 | 17.89 | 0.07793359250452034
2004-09-30 00:00:00 | 19.34 | -0.001552393584725307
2004-10-29 00:00:00 | 19.31 | 0.06854395319980539
2004-11-30 00:00:00 | 20.68 | -0.03694091541552498
2004-12-31 00:00:00 | 19.93 | 0.02722266594660361
2005-01-31 00:00:00 | 20.48 | 0.05324451451881228
2005-02-28 00:00:00 | 21.6 | 0.1095185258064899
2005-03-31 00:00:00 | 24.1 | -0.03375847992495442
2005-04-29 00:00:00 | 23.3 | 0.05185107871111034
2005-05-31 00:00:00 | 24.54 | 0.1673361588505475
2005-06-30 00:00:00 | 29.01 | 0.03355678352884277
2005-07-29 00:00:00 | 30 | 0.0852598439508234
2005-08-31 00:00:00 | 32.67 | 0.0886934631726146
2005-09-30 00:00:00 | 35.7 | -0.1302554518577188
2005-10-31 00:00:00 | 31.34 | 0.1006910473595851
2005-11-30 00:00:00 | 34.66 | 0.114379159661834
2005-12-30 00:00:00 | 38.86 | 0.1431351542546653
2006-01-31 00:00:00 | 44.84 | -0.1104781578111885
2006-02-28 00:00:00 | 40.15 | 0.116259806115862
2006-03-31 00:00:00 | 45.1 | 0.02863270674445157
2006-04-28 00:00:00 | 46.41 | -0.0617699661175661
2006-05-31 00:00:00 | 43.63 | 0
2006-06-30 00:00:00 | 43.63 | -0.02788932792128484
2006-07-31 00:00:00 | 42.43 | -0.01233119727725338
2006-08-31 00:00:00 | 41.91 | -0.07401620461917573
2006-09-29 00:00:00 | 38.92 | -0.04412480490893794
2006-10-31 00:00:00 | 37.24 | 0.0002684924167021634
2006-11-30 00:00:00 | 37.25 | 0.0165072970881349
2006-12-29 00:00:00 | 37.87 | -0.02216083213572482
2007-01-31 00:00:00 | 37.04 | -0.002432762383767715
2007-02-28 00:00:00 | 36.95 | 0.05809017026809878
2007-03-30 00:00:00 | 39.16 | -0.001789137857445999
2007-04-30 00:00:00 | 39.09 | 0.08692610005272562
2007-05-31 00:00:00 | 42.64 | 0.06205831381828338
2007-06-29 00:00:00 | 45.37 | -0.05528021143940323
2007-07-31 00:00:00 | 42.93 | 0.04531224763377328
2007-08-31 00:00:00 | 44.92 | 0.1027301670692034
2007-09-28 00:00:00 | 49.78 | 0.0353268111234217
2007-10-31 00:00:00 | 51.57 | -0.06986585277329621
2007-11-30 00:00:00 | 48.09 | 0.03834857006654237
2007-12-31 00:00:00 | 49.97 | -0.08343381553797698
2008-01-31 00:00:00 | 45.97 | 0.2067824608690628
2008-02-29 00:00:00 | 56.53 | -0.0448619266019822
2008-03-31 00:00:00 | 54.05 | 0.02539181079643048
2008-04-30 00:00:00 | 55.44 | 0.1507435215056439
2008-05-30 00:00:00 | 64.46 | 0.0377518193958889
2008-06-30 00:00:00 | 66.94 | -0.2269227180354181
2008-07-31 00:00:00 | 53.35 | 0.1587724638314441
2008-08-29 00:00:00 | 62.53 | -0.2120902003373875
2008-09-30 00:00:00 | 50.58 | -0.1971401835991569
2008-10-31 00:00:00 | 41.53 | -0.1498657885026456
2008-11-28 00:00:00 | 35.75 | 0.01801850550267821
2008-12-31 00:00:00 | 36.4 | -0.03665258504757109
2009-01-30 00:00:00 | 35.09 | 0.01161650688624623
2009-02-27 00:00:00 | 35.5 | 0.06224716559199343
2009-03-31 00:00:00 | 37.78 | 0.007383999794639893
2009-04-30 00:00:00 | 38.06 | 0.1218036686401866
2009-05-29 00:00:00 | 42.99 | -0.003261885464401383
2009-06-30 00:00:00 | 42.85 | 0.05604279111601666
2009-07-31 00:00:00 | 45.32 | 0.06966931225800611
2009-08-31 00:00:00 | 48.59 | 0.06204003309657188
2009-09-30 00:00:00 | 51.7 | -0.0889474860164963
2009-10-30 00:00:00 | 47.3 | 0.02195592640141619
2009-11-30 00:00:00 | 48.35 | -0.02407232930779355
2009-12-31 00:00:00 | 47.2 | -0.1088978380586775
2010-01-29 00:00:00 | 42.33 | 0.02427190331444249
2010-02-26 00:00:00 | 43.37 | 0.07824971760495882
2010-03-31 00:00:00 | 46.9 | -0.03250557040493141
2010-04-30 00:00:00 | 45.4 | -0.05547545661703784
2010-05-31 00:00:00 | 42.95 | -0.02618382867359694
2010-06-30 00:00:00 | 41.84 | -0.005752652489449922
2010-07-30 00:00:00 | 41.6 | 0.006469412763834283
2010-08-31 00:00:00 | 41.87 | 0.0468890553759777
2010-09-30 00:00:00 | 43.88 | -0.008697697312391155
2010-10-29 00:00:00 | 43.5 | -0.03628250518142315
2010-11-30 00:00:00 | 41.95