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