...

This example is a portfolio of three stocks: GOOG, YHOO, and MSFT. Process is: 1. I calculated for each stock the historical series of daily periodic returns (bottom left, below). 2. For each historical day (e.g., Friday 7/18), I calculate the portfolio gain/loss as if I held the current portfolio on that day. This is the essence of the idea: run historical returns through the current portfolio allocation. 3. This produces an historical series (right column, green) of simulated portfolio returns. Now I can treat as with the single-asset; e.g., if I want 95% VaR, then I need = PERCENTILE(range, 5%)

<< Back to article