| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> | + | <div style="font-size:30px">'''ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)'''</div><br/> |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif">'''<font size="2">ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)</font>'''</font></font>
| + | *settle is the security's settlement date |
| | + | *M is the security's maturity date |
| | + | *LI is the security's last coupon date |
| | + | *R is the security's interest rate |
| | + | *yield is the security's annual yield |
| | + | *redem is the security's redemption value |
| | + | *F is the number of coupon payments per year |
| | + | *basis is the type of day count basis to use. |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'settle''''</font><font size="2"> is the security's settlement date, 'M is the security's maturity date, 'LI' is the security's last coupon date, 'R' is the security's interest rate, 'yield' is the security's annual yield, 'redem' is the security's redemption value, 'F' is the number of coupon payments per year, and 'basis' is the type of day count basis to use.</font></font></font>
| + | *This function computes the price per $100 face value of a security having an odd last coupon period. |
| | + | *ODDLPRICE shows the error value when |
| | + | *'settle', 'M', 'I', or 'FC' is not a valid date or 'R' or 'Yield' < 0. |
| | + | *Basis must between 0 and 4. |
| | + | *M > settle > LI |
| | | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the price per $100 face value of a security having an odd last coupon period.</font></font></font>
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">ODDLPRICE shows the error value, when 'settle', 'M', 'I', or 'FC' is not a valid date or 'R' or 'Yield' < 0.</font></font></font>
| |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis must between 0 and 4. </font></font></font>
| |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">M > settle > LI</font></font></font>
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| | | | |
| | ODDLPRICE | | ODDLPRICE |
| | | | |
| − | </div></div>
| + | Lets see an example |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
| |
| − | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)</font></font></font>
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>
| + | 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">01-08-2008</font></font></font> |
| Line 51: |
Line 40: |
| | <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">0</font></font></font> |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=ODDLPRICE(B2,B3,B4,B5,B6,B7,B8,B9) is 99.6691</nowiki></font></font></font> | + | <font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ3ca8cc865116b625-nowiki-00000002-QINU</font></font></font> |
| | | | |
| | </div> | | </div> |