Previous Topic

Next Topic

oBondUS_EYield( ) - United States Government Bond Equivalent Yield Function

Component

Resolution - Bond Pricing

 

 

Function Definition

oBondUS_EYield(PriceMethod, PriceOrYield, SettlementDate, DatedDate, FirstCpnDate, MaturityDate, FaceValue, CouponRate, HolidaySchedule, OutputFlag)

Calculates equivalent yield(s) using United States Government bond pricing conventions. Returns a number of equivalent yields.

 

 

Bond Types

United States Government bonds (T-Bonds).

 

 

Function Parameters

 

Parameters

Description

 

Parameter Type

 

Restrictions

.

Price Method

 

Indicates whether the PriceOrYield argument contains the clean price or the yield.

 

Enumerated Constant

1 - Clean Price
2 - Yield

PriceOrYield

The clean price or the yield for the bond.

 

Double

 

PriceOrYield > 0

Settlement Date

 

Valuation date of the bond.

 

Date

 

SetDate < MatDate
SetDate
>DatedDate

Dated Date

 

Date on which the bond begins to accrue interest.

 

Date

DatedDate<MatDate

First CpnDate

 

Date that the first coupon is paid. Only required if bond has an odd first coupon period. If not required, leave either blank or enter 0 as the date.

 

Date

 

F.C.D > DatedDate
F.C.D
< P.C.D
F.C.D < MatDate

Penult CpnDate

 

Date that the penultimate coupon is paid. Only required if bond has an odd last coupon period. If not required, leave either blank or enter 0 as the date.

Date

 

P.C.D > DatedDate
P.C.D
> F.C.D
P.C.D < MatDate

Maturity Date

 

Maturity date of the bond.

 

Date

 

MatDate>DatedDate

Face Value

 

Redemption value for the bond paid at maturity.

 

Double

 

FaceValue >= 0

Coupon Rate

Coupon rate of the bond, expressed as a decimal.

Double

Coupon Rate >= 0

Holiday Schedule

 

Schedule of non-business days (excluding weekends).

 

Date Range

 

Leave blank if not applicable

Output Flag

 

Indicates which result, or set of results, will be displayed in the worksheet. When returning more than one value, the function must be entered as an array function. Entering a 0 will output Domestic Yield, followed by all other equivalent yields (1-10).

 

Enumerated Constant

 

0 - All Equiv Yields
1 - Annual Yield
2 - Semi-Ann Yield
3 - Quarterly Yield
4 - Monthly Yield
5 - True Yield
6 - US Street Yield
7 - US Treasury Yield
8 - JGB Simple Yield
9 - MM actual/360
10 - MM actual/365

 

 

 

 

 

 

 

See Also

Parameter Types

United States (T-Bonds) Bond Pricing Conventions

oBondUS_Price( ) - United States Government Bond Price Function

oBondUS_Yield( ) - United States Government Bond Yield Function

oBondUS_CFM( ) - United States Government Bond Cash Flow Map Function

oBond3_EYield( ) Example

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.