It is very common for unconstrained efficient portfolio frontiers to recommend sizeable short positions or unrealistically high exposures to individual stocks. Therefore, in practice it is quite often mandated that some constraints on minimum and maximum allocations are maintained. However, this makes building the frontier itself quite computationally and conceptually challenging. Today we are investigating a simple, flexible, and efficient procedure to construct optimal portfolios and frontiers with arbitrary allocation constraints in Excel and discuss the impact allocation constraints has on their shapes and feasible investment opportunities.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Finance!
Please consider supporting NEDL on Patreon: [ Ссылка ]
![](https://s2.save4k.ru/pic/NoWkHA84FuU/maxresdefault.jpg)