Home > Forum Home > Excel Portfolio Optimization Template > Optimal portfolio with weight 0 > Equal weight long and short positions Share

Equal weight long and short positions

Excel Help for Equal Weight Long And Short Positions in Excel Portfolio Optimization Template


Forum TopicLogin

Equal Weight Long And Short Positions

Rate this:
(3.5/5 from 2 votes)
Oops 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
 
View Full Post

Find relevant Excel templates and add-ins for Equal weight long and short positions in the