Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY range object parameter.

You simply provide the 'KEY' string and the name of the parameter used within the function that created the 'KEY'. Thus if you used the FloatingRateBond() function and later on wanted to know the value entered for the 'spreads' range object parameter, simply enter the key value returned from the FloatingRateBond() function here, along with the string 'spreads' (without the single quotes) for the ParamName parameter and the value entered during the construction of the FloatingRateBond() function will be returned.

Variant CTQueryDB.QueryRangeDB( _
String Key, _
String ParamName)

=CT.DB.QueryRangeDB(
Excel String Cell Key,
Excel String Cell ParamName)

static CTRangeDataCPP QueryRangeDB(
std::string Key,
std::string ParamName);

CTRangeData CTQueryDBSA.QueryRangeDB(
System.String Key,
System.String ParamName);

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.