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