Difference between revisions of "Manuals/calci/TBILLYIELD"
Jump to navigation
Jump to search
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =TBILLYIELD( | + | <div style="font-size:30px">'''TBILLYIELD (Settlement,Maturity,Price)'''</div><br/> |
| − | |||
where, | where, | ||
| − | *<math> | + | *<math>Settlement</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased) |
| − | *<math> | + | *<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() | ||
== Description == | == Description == | ||
| − | TBILLYIELD( | + | TBILLYIELD (Settlement,Maturity,Price) |
| − | *<math> | + | *<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> | + | *If <math>Settlement</math> >= <math>Maturity</math>, Calci displays #N/A error message. |
| − | *<math> | + | *<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> <=0, Calci displays #N/A error message. | *If <math>Price</math> <=0, Calci displays #N/A error message. | ||
*Formula: | *Formula: | ||
| Line 50: | Line 48: | ||
=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(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. | =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 59: | 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.
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.
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:
. Else, Calci displays #N/A error message.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
See Also
References