Previous Topic

Next Topic

oBondJP_EYield( ) - Japanese Government Bond Equivalent Yield Function


Resolution - Bond Pricing



Function Definition

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

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



Bond Types

Japanese Government bonds (JBG's).



Function Parameters





Parameter Type




Price Method


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


Enumerated Constant

1 - Clean Price
2 - Yield


The clean price or the yield for the bond.




PriceOrYield > 0

Settlement Date


Valuation date of the bond.




SetDate < MatDate

Dated Date


Date on which the bond begins to accrue interest.





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.




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

Maturity Date

Maturity date of the bond.





Face Value


Redemption value for the bond paid at maturity.




FaceValue >= 0

Coupon Rate


Coupon rate of the bond, expressed as a decimal.



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

Japanese (JGB's) Bond Pricing Conventions

oBondJP_Price( ) - Japanese Government Bond Price Function

oBondJP_Yield( ) - Japanese Government Bond Yield Function

oBondJP_CFM( ) - Japanese Government Bond Cash Flow Map Function

oBond3_EYield( ) - Generic Bond Equivalent Yield Function 3

Return to website

Copyright 2013 Hedgebook Ltd.