Up
 


Using the VaR
Simulator


Software Environment

 

Download 

 

Hoadley VaR Simulator

Overview

The Hoadley VaR Simulator provides a simple form filling and point-and-click method of simulating Value at Risk (VaR) and Conditional Value at Risk (CVaR) using any of the three simulation methods supported by the Finance Add-in for Excel:

bullet

Monte Carlo Simulation

bullet

Copula Simulation

bullet

Filtered Historical Simulation (FHS).


 
Using the VaR Simulator

Using the simulator consists of assembling parameters and market data onto a number of simple sheets and then calculating VaR and CVaR by clicking the button on the main control panel (shown below) for the type of simulation required.

Hoadley VaR Simulator

Three types of input data are required:

bullet

Position data. Positions can be linear (eg shares; cashflow-mapped bonds) or options.

bullet

VaR parameters (confidence interval, VaR risk horizon etc)

bullet

Asset Details depending on the simulation type.  For example, correlations and volatilities for Monte Carlo simulation and for some copulas; Student T degrees of freedom for copula simulation. Historical price data for historical simulation.

The Finance Add-in for Excel includes tools to estimate all inputs required, such as volatilities and correlations, copula calibration parameters, GARCH parameters (for FHS), option "Greeks" etc.

The VaR Simulator application uses the VaR, copula and other components from the Finance Add-in for Excel.  More information.

 

Software Environment

See Finance Add-in for Excel system requirements.
 

Download the Hoadley VaR Simulator

The Hoadley VaR Simulator is free to download to users who have purchased the Hoadley Finance Add-in for Excel and are still within their one year free download period.

Register and download