Asset Allocation by Maximizing the Omega Ratio of a Portfolio

This Excel spreadsheet finds the investment weights that maximize the Omega Ratio of a portfolio.  Under realistic conditions, this requires non-convex global optimizers – Excel’s optimizers are not robust enough. So consider the simplified problem in this spreadsheet as a learning exercise.