Why Maximum-Sharpe Portfolios Can Produce Extreme Weights

Summary

The document raises a portfolio-optimization problem: an Excel Solver calculation intended to maximize the Sharpe ratio produces very large long and short weights. The author asks what constraints might be appropriate, why unconstrained extreme positions may be undesirable, and whether such allocations can be feasible. It identifies a practical modeling choice around limiting portfolio exposures rather than accepting the mathematical optimizer's output without review.

The post provides no proposed constraint, optimization setup, asset universe, or answer. It therefore does not establish whether the large weights arise from leverage, short selling, input estimates, or solver settings, nor does it give evidence about resulting performance. The question points to the need to define investment constraints in light of the intended portfolio and to examine how assumptions affect an optimized allocation, but the document itself leaves these issues unresolved.

Key ideas

• The post describes extreme long and short weights from a Sharpe-ratio maximization in a spreadsheet solver.
• It asks what portfolio constraints would be suitable and why they matter.
• The document does not specify the assets, inputs, or optimization setup behind the result.
• It gives no recommendation or evidence establishing which constraints to use.
• The feasibility of the calculated positions depends on assumptions the post does not provide.

Tags

# Portfolio Weight Constraints


# Portfolio Weight Constraints












Hi,

So I was asked to calculate the maximum sharpe ratio using solver in excel but it gave me really big numbers for the portfolio weights. So I was wondering what is a good constraint to add and why is it bad or if it is even feasible to have portfolio weights so heavily in a long or short position?

Cheers.

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.