Using the Yield Add-in Functions
Excel provides five functions that let you make price calculations for securities such as bonds more easily: YIELD, YIELDDISC, ODDFYIELD, ODDLYIELD, and ODDLYIELD. (Excel's online help file supplies the actual formulas used for many of these...英国华人论坛