Build a Better Process

# Optimization Definition and Quiz

Portfolio optimization is an iterative process of reviewing inputs and constraints such as turnover, industry bounds and risk exposures to achieve the desired portfolio weights.
1. Define - Define optimization in Finance.
2. Context - Use optimization in a sentence.
3. Quiz - Test yourself.
Updated: February 18, 2021
In my experience, it can take a dozen iterations through an optimization to find a satisfactory solution. Learn more below.

/ factorpad.com / fin / glossary / optimization.html

## Understanding Mathematical Optimization for Financial Applications

Intermediate

Mathematical optimization is the selection of a best result of a function among a variety of alternative results. The optimal solution is selected by altering values within a range to find the desired maximum or minimum of a function. These ranges are often called constraints or bounds in the optimization function. Optimization is used in computer science, operational research and in financial applications.

Synonyms: portfolio optimization, MVO optimization, optimisation

For context, an application in the financial realm requiring optimization is the process of portfolio optimization. Here the outcome is the selection of portfolio weights to assets based on the maximization of a ratio of return over risk, like the Sharpe Ratio for example. This type of optimization is often called MVO for Mean/Variance Optimization which is a key component of Modern Portfoio Theory.

In that equation, the numerator 'Mean' stands for the forecast return based on weights times forecast return. The denominator 'Variance' stands for the forecast variance for the ending portfolio. This optimization incorprates two measure of risk: variance and covariance. The calculation takes into consideration the benefits of risk-lowering diversification by utilizing an asset-by-asset or factor-based covariance matrix.

Portfolio optimization is often an iterative process of reviewing inputs and setting constraints such as turnover, industry bounds and risk explsures to achieve the desired portfolio weights. A rebalance frequency refers to how often a financial optimization is performed.

Optimization is typically performed using specialized risk analysis software and third-party risk models. Alternatively, for simple cases optimization in Excel can be performed using the Solver Add-In provided with a subscription to Excel.

### In a Sentence

Kim:  At my job I do SEO. Search Engine Optimization. What do you do again?
Guy:  I do MVO. It's portfolio optimization. I've heard SEO is more difficult.

### Video

Many terms have 4-5 minute videos showing a derivation and explanation. If this term had one, it would appear here.

Videos can also be accessed from our YouTube Channel.

### Video Script

If this term had a video, the script would be here.

### Quiz

Optimization in Excel can be done, but it requires the Data Analysis ToolPak. | True or False?

False. It requires the Solver Add-In.

The word 'optimal' is often too strong because the result relies on many thousands of estimates. | True or False?

True. Many seasoned portfolio managers iterate through various optimization scenarios before finalizing a trade list.

Still unclear on the topic of Optimization? Check out our financial modeling series called Quant 101.

### Related Terms

Our trained humans found other terms in the category portfolio management you may find helpful.

## What's Next?

There's a lot to explore on our YouTube Channel. Get reminders of new content via Twitter @factorpad.

• For all Glossary terms, click Outline.
• To review the term Optimal Portfolio, hit Back.
• Democratizing investment coding knowledge isn't free, click Tip.
• For a discussion and video on creating a Pitch Book, click Next.

/ factorpad.com / fin / glossary / optimization.html

optimization in finance
portfolio optimization
MVO optimization
optimal portfolio
portfolio theory
efficient frontier
what is optimization
optimal stock investing
portfolio risk aversion
optimization definition
mathematical optimization
what is optimisation
Excel Solver optimization
modern portfolio theory
portfolio optimisation
Sharpe Ratio maximization
portfolio constraints

A newly-updated free resource. Connect and refer a friend today.