writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − + − + − + + + + Line 13:
Line 16: − + − + − + − + − + − + − + + − + Line 41:
Line 45: − s(settlement) <lt(last interest) < m(maturity). + − + − + − + − +
no edit summary
<div style="font-size:30px">'''ODDLPRICE(st,m,lt,r,yld,rdm,f,b)'''</div><br/>
<div style="font-size:23px">'''ODDLPRICE (SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,Redemption,Frequency,Basis)
*<math> st </math> is the settlement date.
'''</div><br/>
*<math> m </math> is the maturity date.
*<math> lt </math> is the last interest date.
*<math> SettlementDate </math> is the settlement date.
*<math> r </math> is the rate of interest.
*<math> MaturityDate </math> is the maturity date.
*<math> yld </math> is the yield for annum.
*<math> LastInterestDate </math> is the last interest date.
*<math> rdm </math> is the security's redemption value.
*<math> Rate </math> is the rate of interest.
*<math> f </math> is the frequency.
*<math> Yield </math> is the yield for annum.
*<math> b </math> is the basis.
*<math> Redemption </math> is the security's redemption value.
*<math> Frequency </math> is the frequency.
*<math> Basis </math> is the basis.
**ODDLPRICE(), returns the price per $100 face value of a security with an odd last period.
==Description==
==Description==
*The peroid can be shorter or longer compared with the other periods.
*The peroid can be shorter or longer compared with the other periods.
*This function is inverse of the ODDLYIELD.
*This function is inverse of the ODDLYIELD.
*In <math>ODDLPRICE(st,m,lt,r,yld,rdm,f,b)</math>, <math>st</math> is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
*In <math>ODDLPRICE (SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,Redemption,Frequency,Basis)
*<math>m</math> is the security's maturity date. This date is after the settlement date specifying when the security matures.
</math>, <math>SettlementDate</math> is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
*<math>lt</math> is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
*<math>MaturityDate</math> is the security's maturity date. This date is after the settlement date specifying when the security matures.
*<math> r </math> is a non-negative number specifying the interest rate for the coupons that the security pays.
*<math>LastInterestDate</math> is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
*<math>yld</math> is the security's yield for an annum which is a nonnegative number.
*<math> Rate </math> is a non-negative number specifying the interest rate for the coupons that the security pays.
*<math>rdm</math> is a number or currency specifying the security’s value at redemption per $100 of face value.
*<math>Yield</math> is the security's yield for an annum which is a nonnegative number.
*<math>f</math> is is a number specifying the number of coupons per year.
*<math>Redemption</math> is a number or currency specifying the security’s value at redemption per $100 of face value.
*<math>Frequency</math> is is a number specifying the number of coupons per year.
*The supported values are
*The supported values are
1 -annual payments
1 -annual payments
2 -semiannual payments
2 -semiannual payments
4 -quarterly.
4 -quarterly.
*<math>b</math> is an optional number specifying the day basis system to use.
*<math>Basis</math> is an optional number specifying the day basis system to use.
{| class="wikitable"
{| class="wikitable"
|-
|-
|}
|}
*The date arguments must satisfy the following conditions:
*The date arguments must satisfy the following conditions:
SettlementDate < LastInterestDate < MaturityDate.
*Also s, m, lt,and b are truncated in to integers.
*Also SettlementDate, MaturityDate, LastInterestDate,and Basis are truncated in to integers.
*This function will give the result as error when
*This function will give the result as error when
1.The date arguments s,m and lt are not a valid date.
1.The date arguments SettlementDate, MaturityDate and LastInterestDate are not a valid date.
2.r<0 or yld<0.
2.Rate<0 or Yield<0.
3.b<0 or b>4.
3.Basis<0 or Basis>4.
==Examples==
==Examples==