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">RECEIVED(settle, M, I, D, basis)</font></font>''..."
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">RECEIVED(settle, M, I, D, basis)</font></font>'''</font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'settle''''</font></font><font face="Arial, sans-serif"><font size="2"> is the security's settlement date, 'M' is the security's maturity date, 'I' is the amount invested in the security, 'D' is the security's discount rate 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 amount received at maturity for a fully invested security.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED shows the error value, when 'settle', 'M' or 'I' is not a valid date or 'I' or 'D' < 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">RECEIVED computes the error value when settle ≥ M</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED 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">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">DIM = number of days from issue to maturity.</font></font></font>
<br /><br />
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
RECEIVED
</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">RECEIVED(settle, M, I, D, 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">04-24-2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">07-24-2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">1550000</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">4.65%</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font>
<font color="#000000"><font face="Tahoma, sans-serif"><font size="1"><nowiki>=RECEIVED(B2,B3,B4,B5,B6) is 1568230.6817</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=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 04-24-2010
| class="sshl_f" | 1568230.6817
| class=" " |
| class=" sshl_f " |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 07-24-2010
| class=" sshl_f " |
| class=" SelectTD SelectTD" |
<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>
| class=" " |
|- class="odd"
| Row3
| class="sshl_f" | 1550000
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class="sshl_f" | 4.65%
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 2
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" sshl_f " |
| class=" " |
| class=" " |
| class=" " |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'settle''''</font></font><font face="Arial, sans-serif"><font size="2"> is the security's settlement date, 'M' is the security's maturity date, 'I' is the amount invested in the security, 'D' is the security's discount rate 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 amount received at maturity for a fully invested security.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED shows the error value, when 'settle', 'M' or 'I' is not a valid date or 'I' or 'D' < 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">RECEIVED computes the error value when settle ≥ M</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED 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">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">DIM = number of days from issue to maturity.</font></font></font>
<br /><br />
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
RECEIVED
</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">RECEIVED(settle, M, I, D, 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">04-24-2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">07-24-2010</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">1550000</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">4.65%</font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font>
<font color="#000000"><font face="Tahoma, sans-serif"><font size="1"><nowiki>=RECEIVED(B2,B3,B4,B5,B6) is 1568230.6817</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=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 04-24-2010
| class="sshl_f" | 1568230.6817
| class=" " |
| class=" sshl_f " |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 07-24-2010
| class=" sshl_f " |
| class=" SelectTD SelectTD" |
<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>
| class=" " |
|- class="odd"
| Row3
| class="sshl_f" | 1550000
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class="sshl_f" | 4.65%
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 2
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" sshl_f " |
| class=" " |
| class=" " |
| class=" " |
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----