Changes

=PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)=

=PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)=

*where 'settlement' is the security's settlement date (a date when coupon or a bond is purchased),  

*where 'settlement' is security's settlement date (a date when coupon or a bond is purchased),  

*'maturity' is the security's maturity date (a date when coupon or a bond expires),  

*'maturity' is security's maturity date (a date when coupon or a bond expires),  

*'rate' is the security's annual coupon rate,  

*'rate' is security's annual coupon rate,  

*'yield' is the security's annual yield,

*'yield' is security's annual yield,

*'redemption' is security's redemption value per $100 face value,

*'redemption' is security's redemption value per $100 face value,

*'frequency' is the number of coupon payments per year, and  

*'frequency' is the number of coupon payments per year, and  

*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]

*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]