Value at Risk, Histograms and risk management in Excel

In this post on value at risk we will start off with a data series for the USD-EUR Foreign currency exchange rate and see what a tool like Value at Risk can tell us about both the likely as well as the worst case movement for this exchange rate.


Portfolio VaR – Simple Moving Average Variance Covariance Approach using the Short Cut technique – PROOF!!

Portfolio VaR is a very important measure for assessing the market risk inherent in the entire portfolio of an entity. It is a measure whose calculation is often linked to heart burn because the risk manager envisions the very labor-intensive construction of the variance covariance matrix. In our courses on Value at Risk, Calculating Value [...]


Portfolio VaR

Value at Risk is a measure of the worst case loss that may occur over a specified holding period for a given probability. It is a measure used widely to assess the market risk inherent in a given investment or portfolio of investments. Portfolio VaR – EXCEL Example is a detailed calculation sheet that demonstrates [...]


Quant Training Videos: Value at Risk, Option Pricing, Monte Carlo Simulation and N(d1)

If you want to go ahead and build your own Value at Risk (VaR) model for equities, currencies, commodities and bond, check out the Calculating Value at Risk Course below. Within the calculating VaR course we walk through VCV (Variance CoVariance) and Historical Simulation, Portfolio Value at Risk and VaR for Fixed Income securities.


Finance Training Videos – The Online Quant Crash Course comes to town – Quantitative Training for the non-Quant.

If you have ever been in love with a spreadsheet or a pricing model; or hated your 18th run of Hull without understanding a word of it; or needed a spiffy answer to a question posed by our beloved Howard Corb, just so that you can make the right impression, the Online Quant Crash Course (for the non Quant?) is for you. Rather than limiting ourselves to PDF and excel files we decided to play with Finance Training Videos, the new home for online video based quantitative training.


Finance Training Course: Online Quant Crash Course: Video One

The Quant Crash Course is a 200 minute series of 4 videos that cover the basics of quant and computational finance. The course material and series has evolved over the last 8 years as part of the training practice run by Jawwad Farid in the areas of derivative pricing and risk management.


Online Quant Crash Course: Finance Training Courses: Pre-course announcement

The Quant Crash Course is a 200 minute series of 4 videos that cover the basics of quant and computational finance. The course material and series has evolved over the last 8 years as part of the training practice run by Jawwad Farid in the areas of derivative pricing and risk management.


Interest Rate Modelling Posts Index

INTEREST RATE MODELLING Interest Rate Modelling: Introduction Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Introduction Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Estimating Parameters & Calibrating the CIR Model Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Simulating the term structure of interest rates Interest Rate Models: Black, Derman and [...]


Interest Rate Models: Steps for building Black, Derman and Toy (BDT) model in Excel: How to utilize the results of a BDT interest rate model: Pricing Options

In this post we will consider how the Black-Derman-Toy (BDT) short rate binomial tree will be used to price options on bonds. Pricing Options The BDT model may also be used to price put or call options on bonds. For the purpose of calculating these prices it is important to generate the entire short interest [...]


Interest Rate Models: Steps for building Black, Derman and Toy (BDT) model in Excel: How to utilize the results of a BDT interest rate model: Pricing Bonds

In this post we will consider how the Black-Derman-Toy (BDT) short rate binomial tree will be used to price bonds. Pricing Bonds For example, we illustrate the use of the short rates to price a hypothetical 3-year fixed income bond at issue as follows: Using the observed YTM and the excel price formula the price [...]