ODDLPRICE is a function in Excel that calculates the odd price of a security. The odd price is the price of the security that is higher than the average price of the security. To use ODDLPRICE in Excel, you first need to enter the average price of the security. Next, you need to enter the high price and the low price of the security. Finally, you need to enter the number of shares that you want to calculate the odd price for. ODDLPRICE will then calculate the odd price for the security and return the result.
ODDLPRICE is a function in Excel that calculates the price of a bond that pays an odd coupon. The syntax of the function is:
ODDLPRICE( settlement, maturity, cpn, redemption, frequency, basis )
settlement is the date of the bond's settlement maturity is the date of the bond's maturity cpn is the bond's coupon rate redemption is the bond's redemption value frequency is the bond's frequency of payments basis is the bond's basis point convention
ODDLPRICE is a function in Excel that calculates the price of a bond using the Odd Lot bond pricing method. To use the function, you first need to enter the following information into Excel: the par value of the bond, the number of days to maturity, the coupon rate, the yield, and the settlement date. Then, use the following formula: =ODDLPRICE(par value, maturity, coupon rate, yield, settlement date)
There are a few occasions when you should not use ODDLPRICE in Excel. One is when you are trying to calculate the average price of a product. In this case, you should use the AVERAGE function. Another time you should not use ODDLPRICE is when you are trying to calculate the price of a product based on the quantity that is sold. In this case, you should use the PRODUCT function.
In Excel, there are a few similar formulae to ODDLPRICE. The first is ODD, which calculates the odd numbers in a given range. The second is PRICE, which calculates the price of a given security. The third is PMT, which calculates the payment for a given loan or investment. Finally, the fourth is NPV, which calculates the net present value of a given series of cash flows.
