use two stocks that you have invested in your porfolio. Visit yahoo finance and download the last...

Question

use two stocks that you have invested in your porfolio. Visit yahoo finance and download the last five years of monthly closing prices. Then calculate monthly returns over this period. Use excel to find out the correlation coefficient of these two firms monthly stocks returns.Answer this question:1 Was this a good pair to have put together for your portfolio ? why? or why not?Upload your spreadsheet

Prateek · Accepted Answer

102534
	Date	CENX	Monthly Return
(CENX)	BBBY	Monthly Return
(BBBY)
	4/1/17	13.6		38.75
	5/1/17	14.4	6%	34.41	-11%
	6/1/17	15.6	8%	30.4	-12%
	7/1/17	16.8	8%	29.9	-2%
	8/1/17	19.5	16%	27.59	-8%
	9/1/17	16.6	-15%	23.469999	-15%
	10/1/17	14.0	-16%	19.9	-15%
	11/1/17	13.3	-5%	22.389999	13%
	12/1/17	19.6	48%	21.99	-2%
	1/1/18	22.3	13%	23.08	5%
	2/1/18	19.0	-14%	21.440001	-7%
	3/1/18	16.5	-13%	20.99	-2%
	4/1/18	17.5	6%	17.459999	-17%
	5/1/18	17.7	1%	18.16	4%
	6/1/18	15.8	-11%	19.93	10%
	7/1/18	12.8	-19%	18.73	-6%
	8/1/18	12.6	-1%	17.940001	-4%
	9/1/18	12.0	-5%	15	-16%
	10/1/18	7.9	-34%	13.74	-8%
	11/1/18	9.0	13%	12.88	-6%
	12/1/18	7.3	-19%	11.32	-12%
	1/1/19	9.2	26%	15.09	33%
	2/1/19	8.6	-6%	16.73	11%
	3/1/19	8.9	3%	16.99	2%
	4/1/19	8.4	-5%	16.709999	-2%
	5/1/19	5.6	-34%	12.69	-24%
	6/1/19	6.9	24%	11.62	-8%
	7/1/19	7.2	4%	9.71	-16%
	8/1/19	5.5	-23%	9.67	-0%
	9/1/19	6.6	21%	10.64	10%
	10/1/19	5.8	-12%	13.7	29%
	11/1/19	7.

use two stocks that you have invested in your porfolio. Visit yahoo finance and download the last five years of monthly closing prices. Then calculate monthly returns over this period. Use excel to...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment