Manuals/calci/PRICEMAT - Revision history

Devika: /* Related Videos */

2018-11-16T21:03:18Z

Devika at 22:30, 22 August 2018

2018-08-22T22:30:38Z

Devika at 22:46, 30 July 2018

2018-07-30T22:46:04Z

Jayaram at 11:08, 14 March 2017

2017-03-14T11:08:28Z

Swapna at 20:10, 18 April 2015

2015-04-18T20:10:25Z

Swapna at 22:19, 13 December 2013

2013-12-13T22:19:08Z

Swapna at 22:11, 9 December 2013

2013-12-09T22:11:43Z

Swapna at 21:57, 9 December 2013

2013-12-09T21:57:59Z

Show changes

MassBot1: Created page with "
'''PRICEMAT(settle, M, I, R, yield, basis)
2013-10-25T02:42:33Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">PRICEMAT(settle, M, I, R, yield, basis)</fon..."

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

<font color="#000000">'''<font face="Arial, sans-serif"><font size="2">PRICEMAT(settle, M, I, R, yield, 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 security's issue date, 'R' is the security's interest rate, 'yield' is the security's annual yield, and 'basos' is the type of day count basis to use.</font></font></font>

<br />

</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 that pays interest.</font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left">

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">PRICEMAT shows the error value, when 'settle', 'M', 'I', or 'I' 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">PRICEMAT counts the error value when settle ≥ M. </font></font></font>

<br /><br />

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

PRICEMAT

</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">PRICEMAT(settle, M, I, R, yield, 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">03-20-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">12-12-2007</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">6%</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">6%</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>=PRICEMAT(B2,B3,B4,B5,B6,B7) is 99.9844</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" | 03-20-2008
| class="sshl_f" | 99.984362
| class=" " |
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | 05-18-2008
| class=" sshl_f " |
|
|
|- class="odd"
| Row3
| class="sshl_f" | 12-12-2007
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 6%
|
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 6%
|
| class="SelectTD SelectTD" |
|
|- class="even"
| Row6
| class="sshl_f" | 0
|
|
|
|}

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

@@ Line 73: / Line 73: @@
 ==Related Videos==
-{{#ev:youtube|jom5A3vNfMk|280|center|PRICEMAT}}
+{{#ev:youtube|v=m_ahBi3n0Dk|280|center|PRICEMAT}}
 == See Also ==

@@ Line 7: / Line 7: @@
 *<math>YieldPercent</math> is security's annual yield,
 *<math>Basis</math> is the type of day count basis to use.
+**PRICEMAT(), returns the price per $100 face value of a security that pays interest at maturity.
 == Description ==

@@ Line 1: / Line 1: @@
-=PRICEMAT(settlement, maturity, issue, rate, yield, basis)=
+<div style="font-size:30px">'''PRICEMAT (SettlementDate,MaturityDate,IssueDate,Rate,YieldPercent,Basis)'''</div><br/>
-*where <math>settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),
+*where <math>SettlementDate</math> is the security's settlement date (a date when coupon or a bond is purchased),
-*<math>maturity</math> is security's maturity date (a date when coupon or a bond expires),
+*<math>MaturityDate</math> is security's maturity date (a date when coupon or a bond expires),
-*<math>issue</math> is security's issue date (a date when coupon or a bond is issued),
+*<math>IssueDate</math> is security's issue date (a date when coupon or a bond is issued),
-*<math>rate</math> is security's interest rate,
+*<math>Rate</math> is security's interest rate,
-*<math>yield</math> is security's annual yield,
+*<math>YieldPercent</math> is security's annual yield,
-*<math>basis</math> is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
-PRICEMAT() calculates the price per &#36;100 face value of security, that pays interest at maturity.
+PRICEMAT(), returns the price per $100 face value of a security that pays interest at maturity.
 == Description ==
+PRICEMAT (SettlementDate,MaturityDate,IssueDate,Rate,YieldPercent,Basis)
 *The function returns the price per &#36;100 face value of security, that pays interest at maturity.
-*<math>settlement</math>, <math>maturity</math> and <math>issue</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>SettlementDate</math>, <math>MaturityDate</math> and <math>IssueDate</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-*If <math>settlement</math> date ≥ <math>maturity</math> date, Calci displays #N/A error message.
+*If <math>SettlementDate</math>  ≥ <math>MaturityDate</math> , Calci displays #N/A error message.
-*<math>rate</math> and <math>yield</math> values must be greater than or equal to zero, else Calci displays #N/A error message.
+*<math>Rate</math> and <math>YieldPercent</math> values must be greater than or equal to zero, else Calci displays #N/A error message.
-*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 36: / Line 35: @@
 |}
-*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 == Examples ==
-PRICEMAT(settlement, maturity, issue, rate, yield, basis) function with inputs in order is calculated as follows:
+PRICEMAT (SettlementDate,MaturityDate,IssueDate,Rate,YieldPercent,Basis) function with inputs in order is calculated as follows:
 <div id="2SpaceContent" class="zcontent" align="left">

← Older revision		Revision as of 11:08, 14 March 2017
Line 86:		Line 86:
	*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]		*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]
	*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]		*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 20:10, 18 April 2015
Line 72:		Line 72:

	=PRICEMAT(A1,A2,A3,A4,A5,A6) : Calculates the Price Value with the inputs in the range A1 to A6. Returns ''84.24817365442365''.		=PRICEMAT(A1,A2,A3,A4,A5,A6) : Calculates the Price Value with the inputs in the range A1 to A6. Returns ''84.24817365442365''.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|jom5A3vNfMk\|280\|center\|PRICEMAT}}

	== See Also ==		== See Also ==

@@ Line 8: / Line 8: @@
 *'basis' is the type of day count basis to use.
-PRICEMAT() calculates the price per &#36;100 face value of security that pays interest at maturity.
+PRICEMAT() calculates the price per &#36;100 face value of security, that pays interest at maturity.
 == Description ==
@@ Line 14: / Line 14: @@
 PRICEMAT(settlement, maturity, issue, rate, yield, basis)
-*The function returns the price per &#36;100 face value of security that pays interest at maturity.
+*The function returns the price per &#36;100 face value of security, that pays interest at maturity.
-*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*Settlement, maturity and issue dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
 *If settlement date ≥ maturity date, Calci displays #N/A error message.
 *'rate' and 'yield' values must be greater than or equal to zero, else Calci displays #N/A error message.
@@ Line 54: / Line 54: @@
 |- class="even"
-| class="sshl_f" | 5%
+| class="sshl_f" | 1/2/2008
 | class="sshl_f" |
 |- class="odd"
-| class="sshl_f" | 8%
+| class="sshl_f" | 5%
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" | $100
+| class="sshl_f" | 8%
 | class="sshl_f" |
@@ Line 69: / Line 69: @@
 | class="sshl_f" |
 |}
-  =PRICEMAT(A1,A2,A3,A4,A5,A6) : Calculates the Price Value with the inputs in the range A1 to A7. Returns ''81.36538958112115''.
+  =PRICEMAT(A1,A2,A3,A4,A5,A6) : Calculates the Price Value with the inputs in the range A1 to A6. Returns ''84.24817365442365''.
 == See Also ==