QS.CONTEXT.ADD.QUOTES¶
Adds separate identifier and Mid/Bid/Ask arrays to a context; each array can be a row or column
Category: QuantSupport - Pricing.
- QS.CONTEXT.ADD.QUOTES(context: text, identifiers: cell or range, mid: cell or range, bid: cell or range, ask: cell or range) text¶
- Parameters:
context (text) – The same root context cell from QS.CONTEXT.CREATE for every addition; never reference the previous addition
identifiers (cell or range) – Independent quote-identifier array: scalar, row, column or spilled array; may be nonadjacent to quote sides; all supplied arrays must have the same entry count; omit for automatic matching in CONTEXT.ADD.CURVE
mid (cell or range) – Optional independent quote-side array; scalar, row, column or spill; blank omits this side; interior blanks preserve missing observations; supplied arrays match identifier count regardless of orientation
bid (cell or range) – Optional independent quote-side array; scalar, row, column or spill; blank omits this side; interior blanks preserve missing observations; supplied arrays match identifier count regardless of orientation
ask (cell or range) – Optional independent quote-side array; scalar, row, column or spill; blank omits this side; interior blanks preserve missing observations; supplied arrays match identifier count regardless of orientation
- Returns:
Context contribution owned by its source cell. All additions reference the same stable root; edits, removals and failed inputs invalidate registered consumers after the definition pass.
- Return Type:
text
- Errors:
#VALUE! for invalid root context, malformed arrays or conventions, invalid configuration, duplicate observations or registry errors. Market-dependent validation runs at pricing.
Formula¶
=QS.CONTEXT.ADD.QUOTES(context, identifiers, mid, bid, ask)
Calculation¶
Runs on Excel’s main calculation thread.
Native Declaration¶
fn qs_context_add_quotes (context : & str , identifiers : * const XLOPER12 , mid : * const XLOPER12 , bid : * const XLOPER12 , ask : * const XLOPER12 ,) -> Result < String , XllError >