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	3,218	7
	Optimizing Portfolio is always stuck at Process 2 of 4	06 Dec 2018	yanki	3,579	1
	Optimizing Portfolio is always stuck at Process 2 of 4	06 Dec 2018	yanki	1,788	0
	How can data be added in an Excel file from a remote Excel file (hosted on the web)?	06 Oct 2018	Aysherrayan	3,521	1
	Can no longer download adjusted close data	20 May 2017	alb998	4,498	3
	Download Data spreadsheet does not download the S&P 500 index data (^GSPC)	19 May 2017	alb998	4,767	4
	No weights in optimized portfolio & error in benchmark return	22 Jun 2016	samint	4,740	1
	Results tab suggestion	01 Mar 2016	Jampa9	4,711	2
	Download Market Data crashes....	30 Dec 2015	Lalla150	8,849	12
	Indexes and Returns	04 Nov 2015	lush	5,271	3
	Further Clarification	27 Oct 2015	Michael172	5,106	2
	Name conflict error	20 Oct 2015	Michael172	5,481	3
	Assets other than stocks in portfolio	21 Sep 2015	dtawil	5,037	2
	Sortino Ratio - Downside Deviation versus Semi-Deviation	21 Jul 2015	A.Yu	6,034	3
	when running scenarios the sheet locks up and wont complete the 12100 total	06 Feb 2015	adam	5,475	3
	Run time error 9 - out of range	11 Oct 2014	manucub	5,712	4
	Same output by varying the Target returns	01 Sep 2014	sammmf	6,066	1
	"Runtime Error 13" and "Runtime error -2147483640" Excel 2011 Mac	13 Jun 2014	stejimenez	7,569	2
	Help Required from Administrator	15 May 2014	Rain	7,430	1
	Optimal portfolio with weight 0	04 Dec 2013	NYSE	8,226	3