Hey guys, I am essentially wondering how to calculate R Squared for a portfolio in excel. Obviously actually doing that isn't hard, but what I can't seem to figure out is the variables. In terms of the portfolio and calculating everything, what am I making my x's and y's? I assume once I have those I just follow through as though you would calculate R squared with normal data points. For the benchmark I would be using the S&P (I realize I could use ETFs to model it, but its for a competition and you can't use them) Any help would be great. Thanks!
Submitted November 16, 2016 at 10:05PM by TradingZebra17 http://ift.tt/2gjiJYG
No comments:
Post a Comment