Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif">'''<font size="2">DISC(settle, M, P, R, basis)</font>'''</font></f..."
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif">'''<font size="2">DISC(settle, M, P, R, basis)</font>'''</font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'P' is the security's price, 'R' is the security's redemption value, 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 calculates the discount rate for a security.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DISC calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">'P' and 'R' must be grater than or equal to zero. </font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis value should between 0 and 4.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DISC is calculated as follows: </font></font></font>
<font color="#000000"></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">where:</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2"></font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B = number of days in a year, depending on the year basis.</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">DSM = number of days between settlement and maturity.</font></font></font>
<br /><br />
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
DISC
</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">DISC(settle, M, P, R, 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">June 9, 2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">November 19, 2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">97.975</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">1</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DISC(B2,B3,B4,B5,B6) is 0.0456</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=" " |
| Column1
| class=" " |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | June 9, 2010
| class=" sshl_f " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | November 19, 2010
|
|
|
|- class="odd"
| Row3
| class="sshl_f" | 97.975
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 100
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 1
|
|
|
|- class="even"
| Row6
| class="sshl_f" | 0.045563
|
|
| class="SelectTD SelectTD" |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="9SpaceContent" class="zcontent" align="left"><div>[[Image:16.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/16.JPG]]</div></div>
----
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'P' is the security's price, 'R' is the security's redemption value, 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 calculates the discount rate for a security.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DISC calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">'P' and 'R' must be grater than or equal to zero. </font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis value should between 0 and 4.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DISC is calculated as follows: </font></font></font>
<font color="#000000"></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">where:</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2"></font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B = number of days in a year, depending on the year basis.</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">DSM = number of days between settlement and maturity.</font></font></font>
<br /><br />
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
DISC
</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">DISC(settle, M, P, R, 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">June 9, 2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">November 19, 2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">97.975</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">1</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DISC(B2,B3,B4,B5,B6) is 0.0456</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=" " |
| Column1
| class=" " |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | June 9, 2010
| class=" sshl_f " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | November 19, 2010
|
|
|
|- class="odd"
| Row3
| class="sshl_f" | 97.975
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 100
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 1
|
|
|
|- class="even"
| Row6
| class="sshl_f" | 0.045563
|
|
| class="SelectTD SelectTD" |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="9SpaceContent" class="zcontent" align="left"><div>[[Image:16.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/16.JPG]]</div></div>
----