I have forgotten
my Password

Or login with:

  • Facebookhttp://facebook.com/
  • Googlehttps://www.google.com/accounts/o8/id
  • Yahoohttps://me.yahoo.com
COST (GBP)
this unit 2.81
sub units 5.88
+
0
FinanceBanking

bill Yield

viewed 1758 times and licensed 90 times
Calculate the yield for a treasury bill. Excel: TBILLYIELD
Controller: CodeCogs

Dependents

Info

Interface

C++
Excel

BillYield

 
doublebillYieldintsett
intmat
doubleprice )
This function calculates the yield for a treasury bill. It is equivalent to the Microsoft Excel function TBILLYIELD. The following equation is used to calculate the result:

Where: yield is the yield of the treasury bill, pr is the price per 100 (currency units) face value, and DSM is the number of days from settlement to maturity.

Example:

#include <iostream>
 
#include <codecogs/units/date/date.h>
#include <codecogs/units/date/dateymd.h>
#include <codecogs/finance/banking/billyield.h>
 
int main()
{
  int settDate=Units::Date::date(1999, 3, 31);
  int maturityDate=Units::Date::date(1999, 6, 1);
  double yield=Finance::Banking::billYield(settDate, maturityDate, 98.45);
  int y, m, d;
 
  Units::Date::dateYMD(settDate, y, m, d);
  printf("settlement=%i/%i/%i\n", y, m, d);
 
  Units::Date::dateYMD(maturityDate, y, m, d);
  printf("maturity=%i/%i/%i\n", y, m, d);
 
  printf("bill yield=%f\n", yield);
 
  return 1;
}
Output:
settlement=1999/3/31
maturity=1999/6/1
bill yield=0.091417

References:

Microsoft Excel help file

This is the date after issue when the treasury bill is traded to the buyer.

Julian date. This is the date when the treasury bill expires.

(expressed in the appropriate currency units).

Note

maturity dates more than 1 yeaer after the settlement date cause an error message to be issued.

Parameters

settThe settlement date, expressed as a serial Julian date.
matThe maturity date of the settlement, expressed as a serial
priceThe price per 100 face value of the treasury bill

Returns

The yield of the treasury bill.

Authors

James Warren (August 2005)
Source Code

Source code is available when you buy a Commercial licence.

Not a member, then Register with CodeCogs. Already a Member, then Login.