Delta and Historical VaR

Delta and Historical VaR

Expert articles on a wide range of topics​

By Phil Walsh

 

 

This spreadsheet enables verification of historical and delta VaR results, for a single transaction under the following assumptions: the transaction is two-sided, i.e. one floating side and one fixed side;  – the transaction is for one settlement period; the transaction uses one market price to value the floating side of the transaction; the same discount factor is used to discount both the floating and the fixed sides of the transaction; all available historical returns are used within the VaR calculation; the historic volatility, for the delta VaR calculation, is calculated as a simple average or EWMA.


 


 
 

error: Content is protected.

Download PDF version

This field is for validation purposes and should be left unchanged.