writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − + −
Manuals/calci/MDURATION (view source)
Revision as of 23:03, 18 January 2014
, 23:03, 18 January 2014no edit summary
*MDURATION() or modified duration calculates the percentage derivative of price with respect to yield.
*MDURATION() or modified duration calculates the percentage derivative of price with respect to yield.
*Formula:
*Formula- <math>MDURATION = \frac{DURATION}{1 + \frac{Yield}{Frequency}}</math>
<math>MDURATION = \frac{DURATION}{1 + \frac{Yield}{Frequency}}</math>
*<math>SettlementDate</math> and <math>MaturityDate</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*<math>SettlementDate</math> and <math>MaturityDate</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.