Calculating Value at Risk – Calculation reference


2 mins read

VaR Formula Reference

This formula reference includes the following formula, sections and terms related to Calculating Value at Risk. Also see calculating value at risk.

Outstanding term to maturity

(assumes Actual/ 365 day count convention)

Outstanding term to maturity


(e.g. interpolation of rates between tenors t and t+1)

Calculating Value at Risk – Calculation reference


T= outstanding term = t+k years, where t≤t+k≤t+1 and 0≤k≤ 1

Tt=rounded down value of the outstanding term = t years

Tt+1= t+1 years

Rt=Rate observed at time t years

Rt+1=Rate observed at time t+1 years

Rt+k=Interpolated Rate for time t+k

EXCEL’s Price formula

Excel's Price formula


t = number of days from settlement to next coupon date.

E = number of days in coupon period in which the settlement date falls.

N = number of coupons payable between settlement date and redemption date.

A = number of days from beginning of coupon period to settlement date.

Continuous return of daily prices

Return of Daily Prices

Where st is the price at time t and

Rt is the continuous rate of return of the daily prices and is calculated as the natural logarithm of successive prices.

SMA volatility (σ)

SMA volatility

Where Rt is the rate of return at time t and E(R) is the mean of the return distribution, i.e.

SMA volatility 1

‘n’ represents the number of return observations used in the calculations.

EWMA volatility (σ)

EWMA volatility

Where Rt is the rate of return at time t and

λ is the decay factor where(0< λ <1). The industry standard of λ is 0.94.

Weights and Scaling of weights under the EWMA approach

As per the EWMA VaR formula the weight for the data (return) point at time t is:

EWMA volatility 1

Where λ is the decay factor where(0< λ <1). The industry standard of λ is 0.94.

The sum to infinity of the all the weights is 1. However it is not possible to have infinite data so if the sum of weights is not close to one, certain adjustments are needed. One option is to increase the number of observations used in the data. The second option is to scale the weights by dividing each weight by the following factor:

EWMA volatility 2

Where n is the number of return observations.

Determining daily SMA and EWMA VaR

σ × z-value of standard normal cumulative distribution corresponding with a specified confidence level

Determining the index value for Historical VaR

Index Value = number of return observations × (1-confidence level%)

Scaling daily VaR

J-day VaR= √J × (daily VaR)