Efficient portfolio frontiers with allocation constraints (Excel)

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!

[sevdaaliyeva]

Hi. Amazing video and explanation. Bu t I could not understand the alpha, beta, gamma, and delta part. Can you recommend a source where I can learn it? Thanks in advance.

[tshegophale]

Yet another stellar job, welldone. One could also add Tracking error or level of diversification (or any other, really) as additional constraints particularly when you have a large number of assets in your portfolio, just need to check how many constraints can solver handle. With that said however, more restrictions results in non-optimal results, so always need to be reasonable on that front. Luckily Python has a few more solver types that can handle advanced/complex constraints.

[dhairyapatel]

Hi, can you please create a video on creating the frontier with short selling constraints in python. I saw the general frontier video in python, thanks a lot for that, however as you said taking short positions may not be possible and excel solver won’t help in realistic cases

[bentansley]

Sorry if this a stupid question, but does this work for asset classes broadly, as I note the absence of a correlation matrix.