QS.EVALUATE

Returns a requested number or table asynchronously from the committed context-owned market

Category: QuantSupport - Pricing.

QS.EVALUATE(context: text, instrument: text, request_name: text or blank, pricer: text or blank, policy: text or blank, transpose: logical or blank, headers: logical or blank) → spilled range
Parameters:

  • context (text) – Stable workbook-scoped root from QS.CONTEXT.CREATE or revisioned historical context; additions belong to the context and commit after the definition pass

  • instrument (text) – Contract or trade handle(s); contracts use Receive at the context date and contractual notional; use a trade for explicit side/date/quantity or bond anchor

  • request_name (text or blank) – One request: Value (omitted or blank default), FairRate(index), YieldToMaturity, ModifiedDuration, ZSpread, OAS; QS.EVALUATE also returns Cashflows or Sensitivities tables

  • pricer (text or blank) – Optional explicit pricer handle; blank selects the product’s native pricer and the context base discount curve; swaptions require an explicit configured pricer

  • policy (text or blank) – Optional discount-policy handle for the default native pricer; omitted or blank uses the context policy; leave blank when passing an explicit configured pricer

  • 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:

Requested scalar or spilled cashflow/sensitivity table directly, without an EvaluationResults handle. Committed market dependencies and identical computations are reused; #N/A means background work is pending. 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 stale, wrong-context or duplicate inputs, missing market data, unsupported request/product or pricing failure; #N/A for an absent table result. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.

Formula

=QS.EVALUATE(context, instrument, request_name, pricer, policy, transpose, headers)

Calculation

Runs on Excel’s main calculation thread.

Native Declaration

fn qs_evaluate (context : & str , instrument : & str , request_name : Option < String > , pricer : Option < String > , policy : Option < String > , transpose : * const XLOPER12 , headers : * const XLOPER12 ,) -> Result < * mut XLOPER12 , XllError >

Rust source