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 Der...
The question whether Excel can be trusted for pricing and risk managing derivative transactions seems to be a never ending one. If you are curious about my own opinion on this matter, you may jump to the end of this article. In the sequel, I will confront this issue through the real-world case of pricing and managing a book of FX options. In my las...
In my previous post about USD Interest Rate Swaps in Excel, I explained how to calculate the price and risk of a single USD interest rate swap using actual market data from Bloomberg as of 22 May 2019. In the current post, I will make use of the same market data to calculate the prices and DV01s (both flat and bucket) of two different swap collecti...
In an earlier post with the title Trading Blotter and Book Risk Management of USD Interest Rate Swaps in Excel: Example of a Book with 10,000 Trades, I explained how to calculate the price and risk of a fictitious portfolio of up to 10,000 vanilla fixed-to-floating USD interest rate swaps that all involved the 3-month USD LIBOR index. Apart from th...
Everybody these days seems to ask the same question: On D-Day when LIBOR will cease to exist and pricing will rely solely on risk-free reference rates like SOFR or SONIA and the Spread Adjustments published by Bloomberg, what will the impact on portfolio pricing be? The mechanics of pricing a single USD interest rate swap with and without the ISDA-...
