Spreadsheet: 107069d1304247324-need-help-with-correlation-matrix-telstra
Sheet: Sheet 1 - Table 1

Price History
Telstra Corporation Limited (TLS)
Date | Open | High | Low | Close | Monthly Return | Average | [NAME]
2003-01-31 00:00:00 |  |  |  | 4.49 | -0.1155583406342724 | -0.004985832110728819 | 0.003211264798032674
2003-02-28 00:00:00 |  |  |  | 4 | 0.01734863833461307
2003-03-31 00:00:00 |  |  |  | 4.07 | 0.03381964823978638
2003-04-30 00:00:00 |  |  |  | 4.21 | 0.06883450582029695
2003-05-30 00:00:00 |  |  |  | 4.51 | -0.02469261259037141
2003-06-30 00:00:00 |  |  |  | 4.4 | 0.06169356900533975
2003-07-31 00:00:00 |  |  |  | 4.68 | 0.07013182377408242
2003-08-29 00:00:00 |  |  |  | 5.02 | -0.05739279799665253
2003-09-30 00:00:00 |  |  |  | 4.74 | 0
2003-10-31 00:00:00 |  |  |  | 4.74 | 0.03930185234761346
2003-11-28 00:00:00 |  |  |  | 4.93 | -0.02256505999208968
2003-12-31 00:00:00 |  |  |  | 4.82 | 0.02053460244170774
2004-01-30 00:00:00 |  |  |  | 4.92 | -0.02886798400085213
2004-02-27 00:00:00 |  |  |  | 4.78 | -0.05151353445010801
2004-03-31 00:00:00 |  |  |  | 4.54 | 0.05151353445010796
2004-04-30 00:00:00 |  |  |  | 4.78 | -0.01900796404517663
2004-05-31 00:00:00 |  |  |  | 4.69 | 0.06998740165345989
2004-06-30 00:00:00 |  |  |  | 5.03 | -0.02008099605704924
2004-07-30 00:00:00 |  |  |  | 4.93 | -0.02672307014075351
2004-08-31 00:00:00 |  |  |  | 4.8 | -0.03174869831458019
2004-09-30 00:00:00 |  |  |  | 4.65 | 0.004291852081540863
2004-10-29 00:00:00 |  |  |  | 4.67 | 0.05417991637379278
2004-11-30 00:00:00 |  |  |  | 4.93 | -0.004065046248169445
2004-12-31 00:00:00 |  |  |  | 4.91 | 0.006091389393401913
2005-01-31 00:00:00 |  |  |  | 4.94 | 0.06276569554978731
2005-02-28 00:00:00 |  |  |  | 5.26 | -0.03285319618718711
2005-03-31 00:00:00 |  |  |  | 5.09 | -0.05036310983389099
2005-04-29 00:00:00 |  |  |  | 4.84 | 0.03651521297509747
2005-05-31 00:00:00 |  |  |  | 5.02 | 0.007936549595736342
2005-06-30 00:00:00 |  |  |  | 5.06 | 0.001974334303717829
2005-07-29 00:00:00 |  |  |  | 5.07 | -0.0800427076735365
2005-08-31 00:00:00 |  |  |  | 4.68 | -0.1396551104750516
2005-09-30 00:00:00 |  |  |  | 4.07 | 0.03381964823978638
2005-10-31 00:00:00 |  |  |  | 4.21 | -0.08938949939459714
2005-11-30 00:00:00 |  |  |  | 3.85 | 0.02056627758147702
2005-12-30 00:00:00 |  |  |  | 3.93 | 0.01264239341517653
2006-01-31 00:00:00 |  |  |  | 3.98 | -0.03320867099665346
2006-02-28 00:00:00 |  |  |  | 3.85 | -0.0289875368732523
2006-03-31 00:00:00 |  |  |  | 3.74 | 0.05209511188340187
2006-04-28 00:00:00 |  |  |  | 3.94 | -0.06014884669049868
2006-05-31 00:00:00 |  |  |  | 3.71 | -0.008119124438504129
2006-06-30 00:00:00 |  |  |  | 3.68 | 0.0373376704376441
2006-07-31 00:00:00 |  |  |  | 3.82 | -0.05931657715641939
2006-08-31 00:00:00 |  |  |  | 3.6 | 0.03009803115727935
2006-09-29 00:00:00 |  |  |  | 3.71 | 0.06521214864704536
2006-10-31 00:00:00 |  |  |  | 3.96 | -0.04916902380646981
2006-11-30 00:00:00 |  |  |  | 3.77 | 0.09603333278268758
2006-12-29 00:00:00 |  |  |  | 4.15 | 0.02145493500125947
2007-01-31 00:00:00 |  |  |  | 4.24 | 0.004705891037412493
2007-02-28 00:00:00 |  |  |  | 4.26 | 0.08974628785627548
2007-03-30 00:00:00 |  |  |  | 4.66 | 0.002143623543251369
2007-04-30 00:00:00 |  |  |  | 4.67 | 0.03987936623159654
2007-05-31 00:00:00 |  |  |  | 4.86 | -0.05715841383994875
2007-06-29 00:00:00 |  |  |  | 4.59 | 0.002176279422595448
2007-07-31 00:00:00 |  |  |  | 4.6 | -0.05129329438755046
2007-08-31 00:00:00 |  |  |  | 4.37 | -0.002290951746555824
2007-09-28 00:00:00 |  |  |  | 4.36 | 0.07082605256861221
2007-10-31 00:00:00 |  |  |  | 4.68 | -0.002139038248749418
2007-11-30 00:00:00 |  |  |  | 4.67 | 0.004273510777382085
2007-12-31 00:00:00 |  |  |  | 4.69 | -0.07755823434587461
2008-01-31 00:00:00 |  |  |  | 4.34 | 0.115219588982185
2008-02-29 00:00:00 |  |  |  | 4.87 | -0.1014893961702829
2008-03-31 00:00:00 |  |  |  | 4.4 | 0.03571808260207903
2008-04-30 00:00:00 |  |  |  | 4.56 | 0.0408219945202552
2008-05-30 00:00:00 |  |  |  | 4.75 | -0.1135813488026834
2008-06-30 00:00:00 |  |  |  | 4.24 | 0.05951412753240772
2008-07-31 00:00:00 |  |  |  | 4.5 | -0.03390155167568146
2008-08-29 00:00:00 |  |  |  | 4.35 | -0.03986459856392782
2008-09-30 00:00:00 |  |  |  | 4.18 | -0.01445808317522978
2008-10-31 00:00:00 |  |  |  | 4.12 | -0.01467018974779385
2008-11-28 00:00:00 |  |  |  | 4.06 | -0.05831817042108652
2008-12-31 00:00:00 |  |  |  | 3.83 | -0.0104987840982197
2009-01-30 00:00:00 |  |  |  | 3.79 | -0.06541841560701056
2009-02-27 00:00:00 |  |  |  | 3.55 | -0.1006766663453999
2009-03-31 00:00:00 |  |  |  | 3.21 | 0.03670136685042796
2009-04-30 00:00:00 |  |  |  | 3.33 | -0.06834957780120976
2009-05-29 00:00:00 |  |  |  | 3.11 | 0.08620719520121611
2009-06-30 00:00:00 |  |  |  | 3.39 | 0.04046794955284642
2009-07-31 00:00:00 |  |  |  | 3.53 | -0.07957067556658914
2009-08-31 00:00:00 |  |  |  | 3.26 | 0.003062789530545731
2009-09-30 00:00:00 |  |  |  | 3.27 | 0.01517479801923513
2009-10-30 00:00:00 |  |  |  | 3.32 | 0.02674750836702836
2009-11-30 00:00:00 |  |  |  | 3.41 | 0.00584796988242312
2009-12-31 00:00:00 |  |  |  | 3.43 | -0.02658945418923961
2010-01-29 00:00:00 |  |  |  | 3.34 | -0.1174088541740007
2010-02-26 00:00:00 |  |  |  | 2.97 | 0.006711434587986778
2010-03-31 00:00:00 |  |  |  | 2.99 | 0.06160780938949037
2010-04-30 00:00:00 |  |  |  | 3.18 | -0.07847161544149532
2010-05-31 00:00:00 |  |  |  | 2.94 | 0.1002454149910559
2010-06-30 00:00:00 |  |  |  | 3.25 | -0.009273636785329102
2010-07-30 00:00:00 |  |  |  | 3.22 | -0.157780447877837
2010-08-31 00:00:00 |  |  |  | 2.75 | -0.04842659390547441
2010-09-30 00:00:00 |  |  |  | 2.62 | 0.01890415463915265
2010-10-29 00:00:00 |  |  |  | 2.67 | 0.05110601093349636
2010-11-30 00:00:00 |  |  |  | 2.81