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 (clean) price of the bond is taken as input.

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.BondYields2( _
String BondKey, _
Double cleanPrice)

=CT.BOND.Yields2(
Excel String Cell BondKey,
Excel Numeric Cell cleanPrice)

static CTRangeDataCPP BondYields2(
std::string BondKey,
double cleanPrice);

CTRangeData CTQryBondsSA.BondYields2(
System.String BondKey,
System.Double cleanPrice);

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.