writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − + − + − + − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − *This function computes the price per $100 face value of a security having an odd last coupon period.+ − *ODDLPRICE shows the error value when+ − 1.Settle, M, I, or FC is not a valid date+ − 2.R or Yield< 0.+ − 3.Basis must between 0 and 4.+ − 4.M > settle > LI+ − + − ==Example==+ − + − Lets see an example+ − + − ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)+ − '''B'''+ − + − <font color="#000000"><font face="Arial, sans-serif"><font size="2">01-08-2008</font></font></font>+ + + + + + + + + + + + + + + − <font color="#000000"><font face="Arial, sans-serif"><font size="2">05-18-2008</font></font></font>+ + + + − <font color="#000000"><font face="Arial, sans-serif"><font size="2">11-15-2007</font></font></font>+ + + + + − <font color="#000000"><font face="Arial, sans-serif"><font size="2">4.35%</font></font></font>+ − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">5.25%</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">$100</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">0</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ3ca8cc865116b625-nowiki-00000002-QINU</font></font></font> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | class=" " | Column1 − | class=" " | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 01-08-2008 − | class="sshl_f" | 99.6691 − | class="SelectTD sshl_t ChangeBGColor" | − | class=" sshl_t" | − |- class="even" − | class=" " | Row2 − | class=" " | 05-18-2008 − | class=" sshl_f " | − | class=" sshl_f" | − | class=" sshl_f" | − |- class="odd" − | Row3 − | class=" " | 11-15-2007 − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | 4.35% − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | 5.25% − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class="sshl_f" | Row6 − | class=" " | $100 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row7 − | class=" " | 2 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | class="sshl_f" | Row8 − | class="sshl_f " | 0 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row9 − | class=" sshl_f " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class="sshl_f" | Row10 − | class="SelectTd " | − | class=" " | − | class=" " | − | class=" " | − |}
no edit summary
<div style="font-size:30px">'''ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)'''</div><br/>
<div style="font-size:30px">'''ODDLPRICE(st,m,lt,r,yld,rdm,f,b)'''</div><br/>
*<math> st </math> is the settlement date.
*<math>Settle</math> is the security's settlement date
*<math> m </math> is the maturity date.
*<math>M</math> is the security's maturity date
*<math> lt </math> is the last interest date.
*<math>LI</math> is the security's last coupon date
*<math> r </math> is the rate of interest.
*<math>R</math> is the security's interest rate
*<math> yld </math> is the yield for annum.
*<math>Yield</math> is the security's annual yield
*<math> rdm </math> is the security's redemption value.
*<math>Redem</math> is the security's redemption value
*<math> f </math> is the frequency.
*<math>F</math> is the number of coupon payments per year
*<math> b </math> is the basis.
*<math>Basis</math> is the type of day count basis to use.
==Description==
==Description==
*This function gives the price of a security that pays interest periodically, but has an odd last coupon period.
*The peroid can be shorter or longer compared with the other periods.
*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.
*<math>m</math> is the security's maturity date. This date is after the settlement date specifying when the security matures.
*<math>lt</math> is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
*<math> r </math> is a non-negative number specifying the interest rate for the coupons that the security pays.
*<math>yld</math> is the security's yield for an annum which is a nonnegative number.
*<math>rdm</math> is a number or currency specifying the security’s value at redemption per $100 of face value.
*<math>f</math> is is a number specifying the number of coupons per year.
*The supported values are
1 -annual payments
2 -semiannual payments
4 -quarterly.
*<math>b</math> is an optional number specifying the day basis system to use.
{| class="wikitable"
|-
! Basis
! Day count basis
|-
| 0 or omitted || American 30/360 (default)
|-
| 1 || actual/actual
|-
| 2 || actual/360
|-
| 3 || actual/365
|-
| 4 || European 30/360
|}
*The date arguments must satisfy the following conditions:
s(settlement) <lt(last interest) < m(maturity).
*Also s, m, lt,and b are truncated in to integers.
*This function will give the result as error when
1.The date arguments s,m and lt are not a valid date.
2.r<0 or yld<0.
3.b<0 or b>4.
==Examples==
{| class="wikitable"
|-
! !! A !! B
|-
! 1
| 7/18/2006 || 12-Oct-2013
|-
! 2
| 9/8/2007 || 14-Mar-14
|-
!3
| 4/20/2005 || 05-May-2012
|-
! 4
| 3.75% || 4.85%
|-
! 5
| 5.25% || 6.45%
|-
! 6
| 110 || 150
|-
! 7
| 2 || 1
|-
! 8
| 0 || 0
|}
#=ODDLPRICE(A1,A2,A3,A4,A5,A6,A7,A8) = 107.560579
#=ODDLPRICE(A1,A2,A3,A4,A5,A6,4,2) = 107.5383470
#=ODDLPRICE(B1,B2,B3,B4,B5,B6,B7,B8) = 147.83213209
#=ODDLPRICE(B1,B2,B3,B4,B5,B6,2,3) = 147.82713239
==See Also==
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/ODDFPRICE | ODDFPRICE ]]
*[[Manuals/calci/ODDFYIELD | ODDFYIELD ]]
*[[Manuals/calci/ODDLYIELD | ODDLYIELD ]]
==References==