Manuals/calci/ODDFYIELD

ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)

• $s$ is the settlement.
• $m$ is the maturity.
• $iss$ is the issue date.
• $fc$ is the first coupon date.
• $r$ is the rate of interest.
• $pr$ is the security's price.
• $rdm$ is the security's redemption.
• $f$ is the frequency.
• $b$ is the basis.

Description

• This function gives the yield of a security that pays interest periodically but has an odd first period.
• $ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)$,$s$ is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
• $m$ is the security's maturity date. This date is after the settlement date specifying when the security matures.
• $iss$ is the date which is specifying when the security was issued.
• $fc$ is the date which is specifying when the security has its first interest payment. This date must be after the settlement date but before the maturity date.
• $r$ is a non-negative number specifying the interest rate for the coupons that the security pays.
• $pr$ is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
• $rdm$ is a number or currency specifying the security’s value at redemption per $100 of face value.
• $f$ is is a number specifying the number of coupons per year.
• The supported values are

 1 -annual payments
 2 -semiannual payments
 4 -quarterly.

• $b$ is an optional number specifying the day basis system to use.
• The following types are supported

Basis	Day count basis
0 or omitted	American 30/360 (default)
1	actual/actual
2	actual/360
3	actual/365
4	European 30/360

• To find the value of a $ODDFYIELD$ we are using the iterative technique.
• The value is changed through 100 iterations until the estimated price with the given value is near to the price.
• The date arguments must satisfy the following conditions:

   iss(issue)<s(settlement) <fc(first coupon) < m(maturity). 

• Also $s$, $m$,$iss$,$fc$ and $b$ are truncated in to integers.
• This function gives the result as error when

  1.The date arguments s,m and fc are not a valid date.
  2.r<0 or pr<=0
  3.b<0 or b>4