I have covered in quite exhausting detail the mathematical description of an Overnight Index Swap (OIS) in my earlier post about Pricing and Understanding OIS using Excel. Since then, OIS have increased in significance due to the cessation of Libor that affected primarily the USD and GBP currencies to the effect that today hardly anyone still trade...
Overnight Index Swaps (OIS) may be priced in Excel using the free and open source derivatives analytics QuantLib library through the Deriscope Excel interface. Table Of Contents Overnight Index Swap (OIS) Description Mathematical Calculation of the OIS Present ValueCreating a 5-year OIS object in Excel in less than 18 seconds Gett...
I have discussed the generic concepts of Carry and Roll-Down in relation to the expected cash flows of any financial instrument in my post titled Carry and Roll-Down of USD Interest Rate Swaps in Excel with Bloomberg Comparison. The emphasis there was placed on their absolute (dollar) definition and a USD Libor interest rate swap was used as exampl...
