Return a range of different Bond yield types (Equivalent annually compounded, Equivalent semi-annually compounded, True yield annual act/365F, True yield semi-annual act/365F, Equivalent (semi-annually compounded with an act/act), Equivalent JGB Simple Rate, Equivalent annually compounded act/365 and Equivalent annually compounded act/360), given a Bond object.

The bond's settlement date and theoretical price are used within the calculation.

The Bond object that is to be queried must have been previously created via one of the numerous Bond creation functions present within the CapeTools Bonds, CapeTools Bonds (Yield), CapeTools Bonds (Price) or CapeTools Forward Bonds category of functions.

These functions would have returned a string 'KEY' which is to be passed to the 'BondKey' parameter of this function.

Please refer to the large number of enumeration functions present within the CapeTools Enums category of functions.

The CapeTools Enums category of functions return correct string codes that can be passed to parameters taking fixed string values defined by the library (ie - DayCount codes, frequency codes, currency codes, compounding codes, business day convention codes etc...).

You can thus execute these enumeration functions which return the proper code, instead of trying to remember the string code needed or making spelling mistakes which can be difficult to debug.

Variant CTQryBonds.BondYields( _
String BondKey)

=CT.BOND.Yields(
Excel String Cell BondKey)

static CTRangeDataCPP BondYields(
std::string BondKey);

CTRangeData CTQryBondsSA.BondYields(
System.String BondKey);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.