"For years I have said that people who use Excel® or C to do advanced financial analysis are wasting their time. For any kind of numerical computation, I can’t see using anything other than MATLAB."
Professor Manfred Gilli, University of Geneva
When Harry Markowitz developed a mean-variance framework for modern portfolio optimization more than 50 years ago, simplicity was a key part of its appeal. However, the adoption of more sophisticated risk measures—for example, value at risk—and constraints, including restrictions on the maximum number of different assets in a portfolio and minimum holding size, has made it all but impossible to optimize portfolios with classical techniques.
Using MATLAB®, Parallel Computing Toolbox™, and MATLAB Distributed Computing Server™, researchers at the University of Geneva have developed a multipurpose, data-driven optimization heuristic that addresses the challenges of more sophisticated risk measures and practical portfolio constraints.
"Financial analysts have been talking about downside risk for years, but few have attempted to use it for portfolio selection because the resultant optimization problem is difficult to solve," says Professor Manfred Gilli of the Department of Econometrics at the University of Geneva. "Using heuristic methods and MathWorks tools, we have developed a system that any analyst can use to arrive at optimal solutions very quickly."
Gilli and his colleagues sought to develop an automated system for portfolio selection using heuristics to solve complex optimization problems. Heuristic algorithms use trial-and-error methods to find solutions for mathematically complex problems. Although economists are familiar with implementing heuristic techniques, such as threshold accepting, finding a set of parameters to make algorithms work effectively is challenging.
“A financial analyst without sufficient experience with heuristic methods can waste lots of time trying to determine parameters such as the threshold sequence without a powerful analytics tool,” says Gilli, who wanted to automatically determine effective parameters for the algorithms based on the specified constraints and financial data.
As a teaching professor, Gilli also needed tools that would help students understand the concepts used in his research.
Gilli and his colleagues used MATLAB, Parallel Computing Toolbox, and MATLAB Distributed Computing Server to develop and implement a threshold accepting algorithm that rapidly solves complex portfolio optimization problems involving advanced risk functions and constraints.
The group started by implementing a threshold accepting heuristic in MATLAB.
As they developed the algorithm to implement this heuristic, they relied on MATLAB graphs and plots to visualize intermediate results and understand how the algorithm was working with various data sets.
Gilli then used MATLAB to develop an application that automatically determines an effective threshold sequence based on the constraints specified and the data analyzed for a particular problem before running the optimization algorithm.
The application runs dozens of times with different starting points to find the global minimum of an optimization problem with many local minima.
A single execution of the application using this real-world data required from three to seven minutes to complete. Needing dozens of results to arrive at a solution, Gilli used MathWorks distributed computing tools to create distributed applications that execute on a computing cluster. Using the MathWorks job manager as a scheduler, Gilli executed 32 independent tasks on 32 processors in the same time required to execute the algorithm once on a single processor.
To benchmark and validate the approach, the group solved the classical Markowitz model with the heuristic. Gilli then used Optimization Toolbox™ and Financial Toolbox™ to solve the Markowitz model with a classical approach, and compared the results with the heuristic solution.
Gilli’s students use MATLAB, Optimization Toolbox, Statistics Toolbox™, and Financial Toolbox to implement classical portfolio techniques and more advanced heuristic methods. He is now using the algorithm to determine the most appropriate risk measures for various market conditions.
To develop and implement a general-purpose, data-driven heuristic for portfolio optimization
Use MATLAB® and Parallel Computing Toolbox™ to develop algorithms, visualize results, and rapidly compute solutions