Home > Forum Home > Excel Portfolio Optimization Template > Optimal portfolio with weight 0 Share

Optimal portfolio with weight 0

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

Forum TopicPost Reply Login

Optimal Portfolio With Weight 0

Rate this:
(3.7/5 from 3 votes)
Confused 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 on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
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:
  1. Optimize 2 portfolios: 1 for short positions and 1 for long with the same capital amount.
  2. 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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Optimal portfolio with weight 0 in the