Error still there...

Excel Help for Error Still There... in Excel Portfolio Optimization Template

Error Still There...

Rate this: (3/5 from 1 vote)

	Yes, I still get the same error.   I am running Excel 2013 in compatilibity Mode, I am also using Windows 10,  not sure these facts make a difference or not.   I have two more additional questions regarding the program: 1. The total Return Comparision chart is very jagged when using a daily return data set, is this because the chart is plotted using monthly-calculated points? If so, is there a way to make it more smooth? 2. Output data is in the same time period as the input data set, as in, Avg Period Return for a daily data set is for one day, so to get an annual return, I will have to multiply it by 255?. What about the ratios and probabilities.  I assume the sharpe ratio stays the same, but what about "Probability of achieving ##% targert return", is this the probability in any given one-day for a daily data-set? thanks, let me know if there is a document that I should be reading to answer these questions regarding funactionality. Michael
	Posted by Michael172 on 20 Oct 2015

View Full Post