Deriscope ## The Excel Derivatives Periscope

##### Products

VaR_Spec

*VaR Spec* is a Type that represents a collection of specification parameters that define how the Value at Risk pertaining to the price of a given Tradable expressed in units of a specified reference Tradable and a certain time horizon is calculated.

Regardless of the exact definition, the Value at Risk depends on the probability distribution of the tradable's price as of the horizon date, which typically is the next business day.

The construction of the probability distribution is based on the assumption of what the random risk factors are and how they evolve.

This information is supplied through the input Key VaR Spec::Simulated Market

As explained in VaR Spec::Process Type, all stochastic process coefficients are assumed constant for the purpose of calculating the value of each risk factor at the end of each elementary time step.

This "constant coefficient" assumption can be mitigated by increasing the number in Key VaR Spec::Time Steps, but this is hardly needed for the usual one day VaR horizon.

The correlation between the various risk factors is given by a symmetric square matrix of dimensions *NxN*, where *N* is the total number of risk factors involved.

The simulation of the correlated risk factors is afforded by random numbers generated according to Random Generator and can be optionally set as antithetic.

The confidence interval associated with the calculated VaR is defined in Key VaR Spec::Confidence

Finally the degree of detail contained in the VaR output is controlled by the setting VaR Spec::Report Type