Excel Portfolio Optimization Template

Excel Help Forum for Excel Portfolio Optimization Template

Excel Help Topics		Date	Author	Views	Replies
	Working with text	21 Sep 2021	Andrew Perkins	2,072	5
	Optimizing Portfolio is always stuck at Process 2 of 4	06 Dec 2018	yanki	2,564	1
	Optimizing Portfolio is always stuck at Process 2 of 4	06 Dec 2018	yanki	1,409	0
	How can data be added in an Excel file from a remote Excel file (hosted on the web)?	06 Oct 2018	Aysherrayan	2,528	1
	Can no longer download adjusted close data	20 May 2017	alb998	3,417	3
	Download Data spreadsheet does not download the S&P 500 index data (^GSPC)	19 May 2017	alb998	3,712	4
	No weights in optimized portfolio & error in benchmark return	22 Jun 2016	samint	3,752	1
	Results tab suggestion	01 Mar 2016	Jampa9	3,716	2
	Download Market Data crashes....	30 Dec 2015	Lalla150	6,871	12
	Indexes and Returns	04 Nov 2015	lush	4,247	3
	Further Clarification	27 Oct 2015	Michael172	4,031	2
	Name conflict error	20 Oct 2015	Michael172	4,374	3
	Assets other than stocks in portfolio	21 Sep 2015	dtawil	3,915	2
	Sortino Ratio - Downside Deviation versus Semi-Deviation	21 Jul 2015	A.Yu	5,009	3
	when running scenarios the sheet locks up and wont complete the 12100 total	06 Feb 2015	adam	4,429	3
	Run time error 9 - out of range	11 Oct 2014	manucub	4,695	4
	Same output by varying the Target returns	01 Sep 2014	sammmf	5,030	1
	"Runtime Error 13" and "Runtime error -2147483640" Excel 2011 Mac	13 Jun 2014	stejimenez	6,498	2
	Help Required from Administrator	15 May 2014	Rain	6,387	1
	Optimal portfolio with weight 0	04 Dec 2013	NYSE	7,165	3