Spreadsheet: 107067d1304247306-need-help-with-correlation-matrix-bhp-billiton
Sheet: Sheet 1 - Table 1

Price History
BHP Billiton Limited (BHP)
Date | Open | High | Low | Close | Monthly Return | Average | [NAME]
2003-01-31 00:00:00 |  |  |  | 8.92 | 0.02545793269551196 | 0.01666850322658598 | 0.005502253163305985
2003-02-28 00:00:00 |  |  |  | 9.15 | 0.01410766751067923
2003-03-31 00:00:00 |  |  |  | 9.28 | -0.02620237239402407
2003-04-30 00:00:00 |  |  |  | 9.04 | -0.04989697114462304
2003-05-30 00:00:00 |  |  |  | 8.6 | -0.00116346726329807
2003-06-30 00:00:00 |  |  |  | 8.59 | 0.1317836496803622
2003-07-31 00:00:00 |  |  |  | 9.8 | 0.1091289165119209
2003-08-29 00:00:00 |  |  |  | 10.93 | -0.03443802391033168
2003-09-30 00:00:00 |  |  |  | 10.56 | 0.1042235058707512
2003-10-31 00:00:00 |  |  |  | 11.72 | -0.0391524560971817
2003-11-28 00:00:00 |  |  |  | 11.27 | 0.07847161544149531
2003-12-31 00:00:00 |  |  |  | 12.19 | -0.07669856533160954
2004-01-30 00:00:00 |  |  |  | 11.29 | 0.08242455234649475
2004-02-27 00:00:00 |  |  |  | 12.26 | 0
2004-03-31 00:00:00 |  |  |  | 12.26 | -0.06660699936678598
2004-04-30 00:00:00 |  |  |  | 11.47 | 0.05264373348542188
2004-05-31 00:00:00 |  |  |  | 12.09 | 0.03574710428127553
2004-06-30 00:00:00 |  |  |  | 12.53 | 0.05057476016638424
2004-07-30 00:00:00 |  |  |  | 13.18 | -0.003800840759656226
2004-08-31 00:00:00 |  |  |  | 13.13 | 0.0895468753053732
2004-09-30 00:00:00 |  |  |  | 14.36 | -0.03616133098673064
2004-10-29 00:00:00 |  |  |  | 13.85 | 0.109323770710407
2004-11-30 00:00:00 |  |  |  | 15.45 | -0.007145207404644255
2004-12-31 00:00:00 |  |  |  | 15.34 | 0.05885912529183623
2005-01-31 00:00:00 |  |  |  | 16.27 | 0.1624574647938619
2005-02-28 00:00:00 |  |  |  | 19.14 | -0.06865705685347152
2005-03-31 00:00:00 |  |  |  | 17.87 | -0.1080377267329683
2005-04-29 00:00:00 |  |  |  | 16.04 | 0.03912479449223222
2005-05-31 00:00:00 |  |  |  | 16.68 | 0.08446016378025899
2005-06-30 00:00:00 |  |  |  | 18.15 | 0.06453852113757116
2005-07-29 00:00:00 |  |  |  | 19.36 | 0.05526267867504952
2005-08-31 00:00:00 |  |  |  | 20.46 | 0.08387024808876872
2005-09-30 00:00:00 |  |  |  | 22.25 | -0.06979576193554198
2005-10-31 00:00:00 |  |  |  | 20.75 | 0.05256958801196915
2005-11-30 00:00:00 |  |  |  | 21.87 | 0.03944931070828294
2005-12-30 00:00:00 |  |  |  | 22.75 | 0.1258093465306123
2006-01-31 00:00:00 |  |  |  | 25.8 | -0.06195787454407953
2006-02-28 00:00:00 |  |  |  | 24.25 | 0.1437878927917116
2006-03-31 00:00:00 |  |  |  | 28 | 0.04538300584781775
2006-04-28 00:00:00 |  |  |  | 29.3 | -0.03720227375762372
2006-05-31 00:00:00 |  |  |  | 28.23 | 0.02691058772107608
2006-06-30 00:00:00 |  |  |  | 29 | -0.04333952866776585
2006-07-31 00:00:00 |  |  |  | 27.77 | -0.002523888125415342
2006-08-31 00:00:00 |  |  |  | 27.7 | -0.07766887281731315
2006-09-29 00:00:00 |  |  |  | 25.63 | 0.06239029259928179
2006-10-31 00:00:00 |  |  |  | 27.28 | -0.03925003909647912
2006-11-30 00:00:00 |  |  |  | 26.23 | -0.03609939814530776
2006-12-29 00:00:00 |  |  |  | 25.3 | 0.02882942160689378
2007-01-31 00:00:00 |  |  |  | 26.04 | 0.04100630933047188
2007-02-28 00:00:00 |  |  |  | 27.13 | 0.09688384962500621
2007-03-30 00:00:00 |  |  |  | 29.89 | -0.01279478734099846
2007-04-30 00:00:00 |  |  |  | 29.51 | 0.06621028460212147
2007-05-31 00:00:00 |  |  |  | 31.53 | 0.1052653636524259
2007-06-29 00:00:00 |  |  |  | 35.03 | 0.05471307543482894
2007-07-31 00:00:00 |  |  |  | 37 | 0.03766024469618619
2007-08-31 00:00:00 |  |  |  | 38.42 | 0.1480339965764076
2007-09-28 00:00:00 |  |  |  | 44.55 | 0.03420079608578469
2007-10-31 00:00:00 |  |  |  | 46.1 | -0.07007805878823853
2007-11-30 00:00:00 |  |  |  | 42.98 | -0.06836154784617227
2007-12-31 00:00:00 |  |  |  | 40.14 | -0.08010499162609623
2008-01-31 00:00:00 |  |  |  | 37.05 | 0.06605558843232373
2008-02-29 00:00:00 |  |  |  | 39.58 | -0.1000967561640782
2008-03-31 00:00:00 |  |  |  | 35.81 | 0.1658504305683572
2008-04-30 00:00:00 |  |  |  | 42.27 | 0.02868332351593982
2008-05-30 00:00:00 |  |  |  | 43.5 | 0.00458716400690614
2008-06-30 00:00:00 |  |  |  | 43.7 | -0.0957450569583844
2008-07-31 00:00:00 |  |  |  | 39.71 | 0.04167783568810862
2008-08-29 00:00:00 |  |  |  | 41.4 | -0.2892936763461225
2008-09-30 00:00:00 |  |  |  | 31 | -0.1021399009577842
2008-10-31 00:00:00 |  |  |  | 27.99 | 0.1021399009577841
2008-11-28 00:00:00 |  |  |  | 31 | -0.01822967149166116
2008-12-31 00:00:00 |  |  |  | 30.44 | 0.001969150619880896
2009-01-30 00:00:00 |  |  |  | 30.5 | -0.0563101719630552
2009-02-27 00:00:00 |  |  |  | 28.83 | 0.1015029286398415
2009-03-31 00:00:00 |  |  |  | 31.91 | 0.04173664974023322
2009-04-30 00:00:00 |  |  |  | 33.27 | 0.04093019425707437
2009-05-29 00:00:00 |  |  |  | 34.66 | 0.001729605504689574
2009-06-30 00:00:00 |  |  |  | 34.72 | 0.08631509009130846
2009-07-31 00:00:00 |  |  |  | 37.85 | -0.02813313470857262
2009-08-31 00:00:00 |  |  |  | 36.8 | 0.02495768880133374
2009-09-30 00:00:00 |  |  |  | 37.73 | -0.007448824012990401
2009-10-30 00:00:00 |  |  |  | 37.45 | 0.09785579000375849
2009-11-30 00:00:00 |  |  |  | 41.3 | 0.04312442663375462
2009-12-31 00:00:00 |  |  |  | 43.12 | -0.09022111029685359
2010-01-29 00:00:00 |  |  |  | 39.4 | 0.04224230519830075
2010-02-26 00:00:00 |  |  |  | 41.1 | 0.05881964474811224
2010-03-31 00:00:00 |  |  |  | 43.59 | -0.06737192656342962
2010-04-30 00:00:00 |  |  |  | 40.75 | -0.06357375150367113
2010-05-31 00:00:00 |  |  |  | 38.24 | -0.01554913393729801
2010-06-30 00:00:00 |  |  |  | 37.65 | 0.06354200884783223
2010-07-30 00:00:00 |  |  |  | 40.12 | -0.07960661135163893
2010-08-31 00:00:00 |  |  |  | 37.05 | 0.0489829352543663
2010-09-30 00:00:00 |  |  |  | 38.91 | 0.07451175301632469
2010-10-29 00:00:00 |  |  |  | 41.92 | 0.01937220987821478
2010-11-30 00:00:00 |  |  |  | 42.74