Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel.
If you choose a category from the list on the left and click on the appearing envelope icon, you will be notified by email when a new article is posted in that category.

The articles here deal with Overnight Index Swaps.

Sonia OIS Relative Carry and Roll-Down in Excel. Has Bloomberg got it Wrong?

cover
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...
Continue reading
  2601 Hits
  0 Comments
2601 Hits
0 Comments

Overnight Index Swap (OIS): Observation Lags, Lookbacks, Rate Cutoffs and step-by-step Prising in Excel

cover
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 trades...
Continue reading
  4256 Hits
  0 Comments
4256 Hits
0 Comments

Overnight Index Swap (OIS): Pricing and Understanding using Excel

cover
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 Getti...
Continue reading
  38089 Hits
  0 Comments
38089 Hits
0 Comments