Use The FALSE function categorized as a Logical function and primarily used for compatibility with other spreadsheet programs. The function returns the Boolean value FALSE. What is the Boolean value? The Boolean data type is rooted from the idea of binary logic i.e. the numeric system uses only two digits – 0 or 1. In […]

## ODDFYIELD function in Excel

Use The ODDFYIELD function calculates the yield of a security that has an irregular (short or long) first period. Syntax ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) The ODDFYIELD function has the following arguments: settlement – Required. The security’s settlement date, which comes after the issuance date. maturity – Required. The expiry date […]

## ODDFPRICE function in Excel

Use The ODDFPRICE function calculates the price of a bond having an irregular first period. Syntax ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) The ODDFPRICE function has the following arguments: settlement – Required. After the issuance date, it is the date on which the bond is traded to the buyer. maturity – Required. […]

## ODDLPRICE function in Excel

Use The ODDLPRICE function calculates the price per $100 face of a security having an irregular/odd (short or long) last coupon period. Syntax ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) The ODDLPRICE function has the following arguments: settlement – Required. The security’s settlement date. maturity – Required. The expiry date of the security. last_interest […]

## ODDLYIELD function in Excel

Use The ODDLYIELD function calculates the yield of a security that has an odd (irregular) last period. Syntax ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) The ODDLYIELD function has the following arguments: settlement – Required. The date on which the security is traded to a buyer. maturity – Required. The maturity date of the […]

## PRICE function in Excel

Use If you purchased a security that pays periodic interest, you can calculate the price per $100 face value of that security by using the PRICE function in Excel. Syntax PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) The PRICE function has the following arguments: settlement – Required. The security’s settlement date, it comes after the issuance […]

## PRICEDISC function in Excel

Use The PRICEDISC function calculates the price per $100 face value of a discounted security. Syntax PRICEDISC(settlement, maturity, discount, redemption, [basis]) The PRICEDISC function has the following arguments: settlement – Required. The settlement date of the discounted security. The date comes after the issuance date when the security is traded to a buyer. maturity – […]