I have forgotten
my Password

Or login with:

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

bill Price

Calculate the price per 100 units face value of a treasury bill. Excel: TBILLPRICE
Controller: CodeCogs

Dependents

Info

Interface

C++
Excel

BillPrice

 
doublebillPriceintsett
intmat
doublerate )
Return the price per 100 (currency units) face value of a treasury bill. This function is equivalent to the Microsoft Excel function TBILLPRICE.

The following equation is used:

Where: price is the price per 100 face value of the treasury, rate is the discount rate of the treasury bill, DSM is the number of days from settlement to maturity.

References:

Microsoft Excel help file

Example 1

#include <stdio.h>
#include <codecogs/units/date/date.h>
#include <codecogs/finance/banking/billprice.h>
 
int main(int argc, char *argv[])
{
  int settDate=Units::Date::date(1999, 3, 31);
  int maturityDate=Units::Date::date(1999, 6, 1);
  double result=Finance::Banking::billPrice(settDate, maturityDate, 0.09);
  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("treasury bill price=%f\n\n", result);
 
  settDate=Units::Date::date(2005, 8, 9);
  maturityDate=Units::Date::date(2005, 12, 30);
  result=Finance::Banking::billPrice(settDate, maturityDate, 0.11);
  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("treasury bill price=%f\n", result);
  return 0;
}
Output:
settlement=1999/3/31
maturity=1999/6/1
treasury bill price=98.45
 
settlement=2005/8/9
maturity=2005/12/30
treasury bill price=95.661111

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.

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
rateThe discount rate of the treasury bill.

Returns

The previous coupon date of the security.

Authors

James Warren (August 2005)
Source Code

Source code is available when you agree to a GP Licence or buy a Commercial Licence.

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