OctoStudy Business
Print Сite this

Correlation Matrix for Stocks Over Five Years

Ten stocks that have been chosen for the analysis are AAPL, SBUX, MSFT, FB, AMZN, TSLA, SHSAX, GGHCX, FHEAX, and ABT. The correlation matrix for all the stocks over the past five years can be seen in Table 1. It shows how closely returns on stocks correlate with each other. There are three correlations that are higher than 0.6 (SHSAX – AMZN, GGHCX– SHSAX, and SHSAX– ABT). This means that for all three pairs, if one asset increases in value, another one increases, too. There are also correlations that are lower than 0.1 (SBUX – FB, and TSLA – FHEAX). Low correlations indicate that two stocks are perfectly decoupled. The lower the correlations between stocks, the more diversified the portfolio. Thus, high correlation coefficients may indicate that the portfolio is poorly diversified.

AAPLSBUXMSFTFBTSLAAMZNSHSAXGGHCXFHEAXABT
AAPL1,00000,13850,46090,40470,21070,39360,40380,41630,29520,3902
SBUX0,13851,00000,27000,0095-0,13750,20960,26880,23520,21550,3126
MSFT0,46090,27001,00000,37660,12650,52150,30360,31800,19360,4507
FB0,40470,00950,37661,00000,13360,49950,28790,27740,30290,1693
TSLA0,2107-0,13750,12650,13361,00000,12350,21640,18210,00220,2158
AMZN0,39360,20960,52150,49950,12351,00000,61300,56100,37270,4578
SHSAX0,40380,26880,30360,28790,21640,61301,00000,97370,59570,6604
GGHCX0,41630,23520,31800,27740,18210,56100,97371,00000,56990,6320
FHEAX0,29520,21550,19360,30290,00220,37270,59570,56991,00000,3728
ABT0,39020,31260,45070,16930,21580,45780,66040,63200,37281,0000

Table 1. Correlation Matrix for the Stocks Over the Past Five Years

Cite this paper
Select style

Reference

OctoStudy. (2023, February 7). Correlation Matrix for Stocks Over Five Years. Retrieved from https://octostudy.com/correlation-matrix-for-stocks-over-five-years/

Reference

OctoStudy. (2023, February 7). Correlation Matrix for Stocks Over Five Years. https://octostudy.com/correlation-matrix-for-stocks-over-five-years/

Work Cited

"Correlation Matrix for Stocks Over Five Years." OctoStudy, 7 Feb. 2023, octostudy.com/correlation-matrix-for-stocks-over-five-years/.

1. OctoStudy. "Correlation Matrix for Stocks Over Five Years." February 7, 2023. https://octostudy.com/correlation-matrix-for-stocks-over-five-years/.


Bibliography


OctoStudy. "Correlation Matrix for Stocks Over Five Years." February 7, 2023. https://octostudy.com/correlation-matrix-for-stocks-over-five-years/.

References

OctoStudy. 2023. "Correlation Matrix for Stocks Over Five Years." February 7, 2023. https://octostudy.com/correlation-matrix-for-stocks-over-five-years/.

References

OctoStudy. (2023) 'Correlation Matrix for Stocks Over Five Years'. 7 February.

This paper was written and submitted to our database by a student to assist your with your own studies. You are free to use it to write your own assignment, however you must reference it properly.

If you are the original creator of this paper and no longer wish to have it published on OctoStudy, request the removal.