Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel.

Includes articles relating to calculating the Value at Risk (VaR) of various financial instruments and portfolios in Excel through Deriscope

Valuing a Portfolio of Multi-Currency FX Options and Producing its Value at Risk in Excel using Deriscope

cover
The topic here is not about simple option pricing but rather about dealing with the complexity introduced by the simultaneous existence of several different currencies in the context of calculating the Price and Value at Risk of a portfolio of European FX options.If you are not familiar with the basics of European option pricing in Excel using Deri...
Continue reading
  767 Hits
  0 Comments
767 Hits
0 Comments

How to compute the VaR: Step-by-Step Excel Guide

cover
The purpose of this article is to show you step-by-step how you can calculate the Value at Risk (VaR) of any portfolio by generating all simulation samples in the spreadsheet. This is great for understanding what's going on but it becomes too complex and slow when the number of samples generated by the simulation exceeds 100.If you don't ...
Continue reading
  5961 Hits
  0 Comments
5961 Hits
0 Comments