qlLegDuration shows wrong number while qlLegBPS is correct

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

qlLegDuration shows wrong number while qlLegBPS is correct

imachabeli
In the same spreadsheet for the same vanilla ATM 5Y usd swap I'm computing duration and BPS,NPV
While bps shows 485(correct value for ATM 5Y)
=qlLegBPS(FixedLeg,TermStructure,IncludeSettlementDateFlows,SettlementDate)

NPV is close to 0 , also ok

duration produced by formula is 2.6 does not make sense to me

=qlLegDuration(FixedLeg,FixedLegRate,FixedLegDayCounter,"Simple","Semiannual","Modified",IncludeSettlementDateFlows,SettlementDate,SettlementDate)


Does this formula really calculates duration?