QS.RESULT.CASHFLOW.SUMMARY¶
Spills date and currency with separate signed Interest, Capital, Other and Total amounts; no accrual allocation or FX conversion
Category: QuantSupport - Pricing.
- QS.RESULT.CASHFLOW.SUMMARY(result: text, transpose: logical or blank, headers: logical or blank) spilled range¶
- Parameters:
result (text) – EvaluationResults handle from QS.EVALUATE or QS.EVALUATE.PORTFOLIO; the requested measure must have been returned by the evaluation
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:
Six-column cashflow spill: Payment date, Currency, Interest, Capital, Other, Total. Signed undiscounted payments, with optional transpose and headers; no accrual allocation or FX conversion. 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 inputs, stale or wrong-type handles, unsupported target/pricer/trade combinations or native evaluation errors; #N/A when the result does not contain the requested measure. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.
Formula¶
=QS.RESULT.CASHFLOW.SUMMARY(result, transpose, headers)
Calculation¶
Runs on Excel’s main calculation thread.
Native Declaration¶
fn qs_portfolio_result_cashflows (result : & str , transpose : * const XLOPER12 , headers : * const XLOPER12 ,) -> Result < * mut XLOPER12 , XllError >