This content has been marked as final. Show 1 reply
I know this has something to do with constraints. For instance, Cell C8 must = 100%. Cells E8:AH8 will change, depending on the weights of the stocks (this is contingent on risk; defined assumptions and parameters of the distribution curves). Likewise, Cells E6:AH6 must change, depending on the potential future returns of the stocks (this is also contingent on the risk). It seems like, if I define an assumption, it wipes out any formula that I have in the cell. So, I'm not sure how to 'link' the E6:AH6 range and the E8:AH8 range. Does anyone here have any ideas on this?