Manuals/calci/TBILLPRICE - Revision history

Devika: /* Related Videos */

2018-11-16T21:16:02Z

Devika at 22:25, 22 August 2018

2018-08-22T22:25:14Z

Devika at 22:00, 27 July 2018

2018-07-27T22:00:33Z

Jayaram at 11:04, 14 March 2017

2017-03-14T11:04:24Z

Swapna at 19:00, 19 July 2015

2015-07-19T19:00:17Z

Swapna at 22:32, 28 February 2014

2014-02-28T22:32:41Z

Swapna at 22:04, 28 February 2014

2014-02-28T22:04:47Z

Swapna at 22:03, 28 February 2014

2014-02-28T22:03:34Z

MassBot1: Created page with "
'''TBILLPRICE'''(SettlementDate, MaturityDate, Discount) where, '''SettlementDate '''- represents the Treasur..."

2013-10-25T02:45:55Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TBILLPRICE'''(SettlementDate, MaturityDate, Discount) where, '''SettlementDate '''- represents the Treasur..."

New page

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

'''TBILLPRICE'''(SettlementDate, MaturityDate, Discount)

where,

'''SettlementDate '''- represents the Treasury bill's settlement date.

'''MaturityDate''' - represents the Treasury bill's maturity date.

'''Discount '''- represents the Treasury bill's discount rate

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

It returns the price per $100 face value for a Treasury bill.

'''Formula''' :-

TBILLEPRICE = 100 X (1-(Discount x N)/360)

where,

N - Number of days between settlement an maturity date.

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

If SettlementDate > MaturityDate, TBILLPRICE returns the #ERROR.

If Discount <= 0, it returns the #ERROR.

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

TBILLPRICE

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

Lets see an example in (Column1, Row1)

<nowiki>=TBILLPRICE(DATE(2008,1,1),DATE(2008,2,20),"5.85%")</nowiki>

TBILLPRICE returns 99.1875.

Consider an another example

<nowiki>=TBILLPRICE(DATE(DATE(2007/4/1),DATE(2008,5,1),"-4%")</nowiki>

It returns #ERROR(discount=-4%).

</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
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 99.1875
|
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f SelectTD ChangeBGColor SelectTD" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
|
|
|
|- class="odd"
| Row3
| class="sshl_f " |
|
|
|
|- class="even"
| Row4
| class="sshl_f " |
|
|
|
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
|
|}

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

@@ Line 51: / Line 51: @@
 ==Related Videos==
-{{#ev:youtube|ps1rCDdSPZs|280|center|TBILLPRICE}}
+{{#ev:youtube|v=OdEI6TMOz78|280|center|TBILLPRICE}}
 == See Also ==

@@ Line 4: / Line 4: @@
 *<math>Maturity</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
 *<math>Discount</math> is the Treasury Bill's discount rate.
+**TBILLPRICE(), returns the price per $100 face value for a Treasury bill.
 == Description ==

@@ Line 1: / Line 1: @@
-=TBILLPRICE(SettlementDate, MaturityDate, Discount)=
+<div style="font-size:30px">'''TBILLPRICE (Settlement,Maturity,Discount)'''</div><br/>
 where,
-*<math>SettlementDate</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
+*<math>Settlement</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
-*<math>MaturityDate</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
+*<math>Maturity</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
 *<math>Discount</math> is the Treasury Bill's discount rate.
-TBILLPRICE() calculates the price per $100 face value for a Treasury Bill.
+TBILLPRICE(), returns the price per $100 face value for a Treasury bill.
 == Description ==
-TBILLPRICE(SettlementDate, MaturityDate, Discount)
+TBILLPRICE (Settlement,Maturity,Discount)
-*<math>SettlementDate</math> and <math>MaturityDate</math> should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>Settlement</math> and <math>Maturity</math> 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>SettlementDate</math> &gt;= <math>MaturityDate</math>, Calci displays #N/A error message.
+*If <math>SettlementDate</math> &gt;= <math>Maturity</math>, Calci displays #N/A error message.
-*<math>MaturityDate</math> should not be greater than one year from <math>SettlementDate</math>. Else, Calci displays #N/A error message.
+*<math>Maturity</math> should not be greater than one year from <math>Settlement</math>. Else, Calci displays #N/A error message.
 *If <math>Discount</math> &lt;=0, Calci displays #N/A error message.
 *Formula:

← Older revision		Revision as of 11:04, 14 March 2017
Line 63:		Line 63:

	*[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill]		*[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 50: / Line 50: @@
   =TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3. <br />Displays '''94.75125''' as a result.
   =TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with <br />the mentioned values. Displays '''93.925''' as a result.
 == See Also ==

@@ Line 18: / Line 18: @@
 If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLPRICE is calculated as -
-<math>TBILLPRICE = 100 * (1 - \frac{(Discount * N))}{360}) </math>
+<math>TBILLPRICE = 100 * (1 - \frac{(Discount * N)}{360}) </math>
 == Examples ==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=TBILLEQ(SettlementDate, MaturityDate, Discount)=
-'''TBILLPRICE'''(SettlementDate, MaturityDate, Discount)
+where,
-where,
+TBILLEQ() calculates the price per $100 face value for a Treasury Bill.
-'''SettlementDate '''- represents the Treasury bill's settlement date.
+== Description ==
-'''MaturityDate''' - represents the Treasury bill's maturity date.
+*<math>SettlementDate</math> and <math>MaturityDate</math> should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-'''Discount '''- represents the Treasury bill's discount rate
+<math>TBILLPRICE = 100 * (1 - \frac{(Discount * N))}{360}) </math>
-</div>
+== Examples ==
-It returns the price per $100 face value for a Treasury bill.
+Consider the following example that shows the use of TBILLPRICE function:
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
+| class=" " |
-| Column2
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" | 11/20/2010
-| class="sshl_f" | 99.1875
+| class=" " |
+| class=" " |
-−
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" | 5.85%
-| class="sshl_f    SelectTD ChangeBGColor SelectTD" |
+| class=" " |
-<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
+| class=" " |
-−
 |- class="odd"
-| Row3
+| class="sshl_f" |
-| class="sshl_f        " |
+| class=" " |
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3. <br />Displays '''94.75125''' as a result.
-----
+ =TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with <br />the mentioned values. Displays '''93.925''' as a result.