Changes

5,351 bytes added , 02:41, 25 October 2013

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif">'''<font size="2">ODDLPRICE(settle, M, LI, R,yield, redem, F, ..."

<div id="6SpaceContent" class="zcontent" align="left">

<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">'''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>

</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

</div></div>
----
<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>

<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"><nowiki>=ODDLPRICE(B2,B3,B4,B5,B6,B7,B8,B9) is 99.6691</nowiki></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=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/ODDLPRICE (view source)

Revision as of 02:41, 25 October 2013

Navigation menu

Search