What's new

Gregory's Spreadsheet JG_XLS_8.4 (CCS swap)

Thread starter #1
There is a correction in the spreadsheet: JG_XLS_8.4 (CCS swap)

Example at time 0.025


The square root term on the last term should be eliminated and thus the correct formula is


I seen Gregory's spreadsheet on his website and it is the case.

David Harper CFA FRM

David Harper CFA FRM
Staff member
Okay thank you I will check it out, that actually makes sense! Although why isn't the initial B31 squared, shouldn't it be?:


Can i ask, did you see this in an updated XLS version, or did he explicitly identify in an errata? Thanks!