QS.SNAPSHOT.ARCHIVE¶
Builds a complete snapshot archive from a range of snapshot handles; changing or removing rows rebuilds it
Category: QuantSupport - Market.
- QS.SNAPSHOT.ARCHIVE(name: text, snapshots: cell or range) text handle¶
- Parameters:
name (text) – Workbook-unique object name; unchanged recalculation reuses its current handle
snapshots (cell or range) – Range of current MarketSnapshot handles; blank range cells are ignored; an omitted or blank scalar creates an empty archive; duplicate UTC timestamps are rejected
- Returns:
Revisioned MarketSnapshotStore handle rebuilt from all supplied snapshot handles. Removed rows disappear; duplicate UTC instants are rejected. Omitted or blank input creates an empty archive.
- Return Type:
text handle
- Errors:
#VALUE! for nontext snapshot inputs, stale/wrong-type snapshot handles, duplicate UTC timestamps, or registry failures.
Formula¶
=QS.SNAPSHOT.ARCHIVE(name, snapshots)
Calculation¶
Runs on Excel’s main calculation thread.
Native Declaration¶
fn qs_snapshots_create (name : & str , snapshots : * const XLOPER12) -> Result < String , XllError >