QS.CURVE.TABLE

Spills a curve’s pillar dates, discount factors, zero rates, and forwards; rate convention defaults to Simple/Annual

Category: QuantSupport - Market.

QS.CURVE.TABLE(curve: text, compounding: text or blank, frequency: text or blank, transpose: logical or blank, headers: logical or blank) → spilled range
Parameters:

  • curve (text) – Discount-curve handle returned by QS.CURVE.GET or QS.CURVE.FLAT

  • compounding (text or blank) – Compounding convention; omitted or blank input defaults to Simple

  • frequency (text or blank) – Frequency for the rate convention; omitted or blank input defaults to Annual

  • transpose (logical or blank) – Optional TRUE transposes the entire spill; omitted or blank defaults to FALSE; table headers move with their fields

  • headers (logical or blank) – Optional TRUE includes table headers (default); FALSE removes the first header row before transposing; omitted or blank defaults to TRUE

Returns:

Five-column spill with headers Pillar, Date, Discount factor, Zero rate, Forward from prior node. Dates are ISO text, discount factors dimensionless, and rates decimal. The reference-date zero rate and first-node forward are blank. headers=FALSE removes the header row before transposing; omitted headers defaults to TRUE. transpose=TRUE exchanges rows and columns; omitted transpose defaults to FALSE. Empty output returns a blank cell.

Return Type:

spilled range

Errors:

#VALUE! for invalid rate conventions or curve handles, curves exposing no nodes or an empty node set, or zero/forward-rate evaluation failures. Flat curves need not expose nodes; use scalar curve queries instead. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.

Formula

=QS.CURVE.TABLE(curve, compounding, frequency, transpose, headers)

Calculation

Runs on Excel’s main calculation thread.

Native Declaration

fn qs_curve_table (curve : & str , compounding : Option < String > , frequency : Option < String > , transpose : * const xll_rs :: types :: XLOPER12 , headers : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut XLOPER12 , XllError >

Rust source