Optimal portfolio with weight 0

Excel Help for Optimal Portfolio With Weight 0 in Excel Portfolio Optimization Template

Optimal Portfolio With Weight 0

Rate this: (3.6/5 from 5 votes)

	Hi!! I'm looking for a way, starting from a null capital, to buy and short sale some titles so that the optimized portfolio's weight results 0... I'd like to manage to indicate which stocks to buy and which to borrow! I cannot understand how to do it... Thank you in advance for your help!
	Posted by NYSE on 04 Dec 2013

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Delta zero Rate this: (4/5 from 3 votes) Bonjour, J'utilise un autre optimiseur qui permet le delta 0. La contraite min doit passer à -100%. Apres la contrainte somme de tous les poids des lignes qui est egale à 100%, je la fixe à 0 et refait tourner pour avoir les pods en long short. J'ai essayé ici, mais il faut modifier le vba. Donc cet optimiseur ne peut fonctionner qu'en long. Cordialement.
	Leloup
	Posted by First on 21 Oct 2020

	Equal weight long and short positions Rate this: (3.5/5 from 2 votes) Here the portfolio would have and equal weight of long and short postions so that the capital (ignoring borrowing costs) would be essentially zero. The system does not currently provide for this situation. Two workarounds are possible: Optimize 2 portfolios: 1 for short positions and 1 for long with the same capital amount. Optimize the portfolio as long/short mixed and then adjust weightings for positions by the ratio of long and short so that their totals equate. This would be the preferred method in order to capture the correlation offsets of the long and short positions.
	Excel Business Forums Administrator
	Posted by Excel Helper on 04 Dec 2013

	Long and Short Rate this: (3.3/5 from 3 votes) If you set the weighting constraints as positive then each investment can have up to that amount in either long or short. This way a mixed long/short portfolio can be found with weights up to the maximum weight either long or short.
	Excel Business Forums Administrator
	Posted by Excel Helper on 21 Oct 2020

Displaying page 1 of 1