Difference between revisions of "Manuals/calci/TBILLYIELD"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
=TBILLYIELD(SettlementDate, MaturityDate, Price)=
+
<div style="font-size:30px">'''TBILLYIELD (Settlement,Maturity,Price)'''</div><br/>
−
 
 
 
where,  
 
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>Price</math> is the Treasury Bill's price per $100 face value.
 
*<math>Price</math> is the Treasury Bill's price per $100 face value.
−
 
+
**TBILLYIELD() returns the yield for a Treasury bill.
−
TBILLYIELD() calculates the yield for a Treasury Bill.
 
  
 
== Description ==
 
== Description ==
−
TBILLYIELD(SettlementDate, MaturityDate, Price)
+
TBILLYIELD (Settlement,Maturity,Price)
  
−
*<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>Settlement</math> &gt;= <math>Maturity</math>, Calci displays #N/A error message.
−
*<math>MaturityDate</math> should not be more than one year than that of <math>SettlementDate</math>. Else, Calci displays #N/A error message.
+
*<math>Maturity</math> should not be more than one year than that of <math>SettlementDate</math>. Else, Calci displays #N/A error message.
 
*If <math>Price</math> &lt;=0, Calci displays #N/A error message.
 
*If <math>Price</math> &lt;=0, Calci displays #N/A error message.
 
*Formula:  
 
*Formula:  
Line 28: Line 26:
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class="sshl_f" |  
+
| class="sshl_f" | 06/25/2014
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
  
 
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" |  
+
| class="sshl_f" | 10/25/2014
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
  
 
|- class="even"
 
|- class="even"
−
| class="sshl_f" |  
+
| class="sshl_f" | 97.5
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
Line 48: Line 46:
 
|}
 
|}
  
−
<font color ="Red">Need to add examples after next release</font>
+
=TBILLYIELD(A1,A2,A3) : Calculates the yield for treasury bill with the input values from the cells A1 to A3. <br />Returns '''0.07566204287515763''' as a result.
 +
=TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) : Calculates the yield for treasury bill <br />with the values mentioned as arguments. Returns '''0.09624107600678411''' as a result.
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|v=0CCcKeuXy60|280|center|TBILLYIELD}}
  
 
== See Also ==
 
== See Also ==
Line 58: Line 61:
  
 
*[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 ]]

Latest revision as of 15:13, 16 November 2018

TBILLYIELD (Settlement,Maturity,Price)


where,

  • is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
  • is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
  • is the Treasury Bill's price per $100 face value.
    • TBILLYIELD() returns the yield for a Treasury bill.

Description

TBILLYIELD (Settlement,Maturity,Price)

  • and should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
  • If >= , Calci displays #N/A error message.
  • should not be more than one year than that of . Else, Calci displays #N/A error message.
  • If <=0, Calci displays #N/A error message.
  • Formula:

If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLYIELD is calculated as -

Examples

Consider the following example that shows the use of TBILLYIELD function:

06/25/2014
10/25/2014
97.5 
=TBILLYIELD(A1,A2,A3) : Calculates the yield for treasury bill with the input values from the cells A1 to A3. 
Returns 0.07566204287515763 as a result.
=TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) : Calculates the yield for treasury bill 
with the values mentioned as arguments. Returns 0.09624107600678411 as a result.

Related Videos

TBILLYIELD

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TBILLYIELD&oldid=211356"