## MS Solver for Excel

To install a solver in MS Excel follow the instructions in the video.

## Correlation matrix

<iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/w5Do76xC7Eg” frameborder=”0″ allow=”accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture” allowfullscreen></iframe>

## Net present value

In this video we show how to calculate the net present value (NPV) of a financial investment in MS Excel. The cashflows for more than one period must be given…

## Markowitz portfolio selection

In this tutorial we show how to solve the Markowitz portfolio selection problem in Excel by help of Solver. The expected returns for each asset and covariance matrix are given. The…

## Dynamic histogram

Consider you want to draw in Excel an histogram which is automatically updating when the input data is changing:

## Calculating covariance matrix

To calculate covariance matrix using Excel:

## Simulation of stock prices

Modeling the volatility of an asset (e.g., index, bond, stock, commodities) allows to simulate the value of that asset. Based on the simulated value range derived or composite financial products…