Skip to main content
Version: 8.4.08.4

Risk Management System

SpiderRock Connect operates an integrated risk management platform suitable for use as the primary risk monitoring-and-management platform for large and complex, multi-account, equity, future, and options trading strategies.

This risk management platform consists of several components that work together to ensure an accurate real-time risk picture for individual traders, as well as risk managers.

The SpiderRock Connect risk management platform consists of the following components:

  • SR Risk Servers: Live risk computation and aggregation.
  • SR prior-day position-rotation loaders.
  • SR and client start-of-day clearing position loaders.
  • SR live execution notification [SR execution engines => SR risk servers].
  • Integrated away execution notifications [FIX or SRSE upload].
  • SRSE SQL API: Live position and risk detail via an SQL style interface.
  • SR Risk Viewer (RV): Live symbol-level risk detail.
  • SR Risk Manager (RM): Live asset-level risk, flexible aggregation, risk span calculations.
  • SR Risk Analyzer (RA): Historical asset-level pivot-table style risk analyzer.
  • SR Hedge Tool (HT): Live symbol-and-expiration-level option hedge basket manager.
  • SR ElasticRock risk and trading data cluster: Quasi-real-time (< 5 sec latency).

This risk management platform is well integrated with SpiderRock Connect's execution systems and can substantially simplify the workflow required to manage and scale complex multi-asset active trading strategies.

SpiderRock Risk and Trading Accounts

SpiderRock will assign unique account codes (usually 4 - 6 letters and numbers) for each distinct clearing/trading account handled by the SpiderRock Connect systems. This short account code usually corresponds to a single clearing firm sub-account and is used when viewing and accessing risk as well as when executing trades via SpiderRock Connect.

Clients can request creation of as many accounts as necessary to organize their activity. Thereafter, clients can control aspects of account configuration, including the account tagging that facilitates flexible aggregation groups and organizational structure.

If you would like SpiderRock to assign specific account codes or explore alternative account configurations, contact the SpiderRock Client Support Desk for assistance.

Start-of-Day Position Loaders

SpiderRock Connect can directly load start-of-day positions from most prime brokers/clearing firms. If so authorized, SpiderRock will arrange for start-of-day position records to be transferred from a client's clearing firm to the SpiderRock Connect platform and will be loaded automatically. SpiderRock will also account for any corporate action events before a day's trading session begins.

Note that any given client can typically authorize only those accounts that they would like loaded into SpiderRock Connect systems. Alternatively, a client can directly load start-of-day positions into SpiderRock Connect systems via the SRSE SQL API if they do not wish SpiderRock to receive information directly from their clearing firm.

Clients can compare SpiderRock Connect's uploaded records against their own uploaded SOD positions to see possible position breaks such as assignments, exercises, or actual trade breaks. These comparisons can be done via SRSE, Risk Viewer, or Symbol Viewer.

SpiderRock Connect will load positions as a client's clearing firm or prime broker makes them available. For NMS equity and equity options accounts this is typically between 4:00 am and 7:00 am, Monday-Friday.

On request, SpiderRock Connect can load start-of-day positions from the previous-day SpiderRock position and trade archive. This is usually only done if a client's prime broker or clearing firm was unable to provide files in a timely fashion, and can be very valuable in emergencies.

View the SodClearingRecordV5 message for table definitions and example queries.

Intraday Execution Drops

All executions resulting from orders managed by the SpiderRock Connect execution engines are reported to the SpiderRock Connect risk management system as they occur. This includes orders sent to SpiderRock Connect systems via FIX, SRSE, or SpiderRock Citrix tool suite.

In addition, clients can notify SpiderRock Connect of done away executions either via a FIX drop or via the SRSE SQL API. SpiderRock Connect can also frequently integrate with other execution providers in order to receive real-time done away execution notifications, typically via FIX drop copy.

SpiderRock Symbology

SpiderRock Connect systems operate with a unified asset symbology that include three different asset class keys: Stock keys, future keys, and option keys.

  • Stock Key = AssetType + TickerSrc + Symbol
  • Future Key = AssetType + TickerSrc + Symbol + Expiration
  • Option Key = AssetType + TickerSrc + Symbol + Expiration + Strike + CPFlag

AssetType is a 3-letter code describing the asset class and is usually one of EQT, IDX, or FUT.

TickerSrc is a 2-4-letter code describing the issuing authority associated with the symbol. NMS is used for all US equity and equity-option products. Other ticker sources include CME, NYMEX, COMEX, CBOT, ICE, and CFE.

Symbol is usually an exchange or issuing authority ticker consisting of 1–9 letters or numbers. For equities, this symbol will be an exchange issues ticker with special flags appended using the CMS convention (‘.A’, ‘.RT’, ‘.PR’, ‘PRA’, etc.). Equity option symbols are OPRA roots. Futures and options on futures symbols are exchange-issued product codes (‘ES’, ‘ZN’, ‘RT’, etc.).

Note that SpiderRock Connect creates synthetic stock keys for all futures and options on futures chains and the symbol portion of these keys starts with ‘@’. For example, @ES is the stock key for a synthetic stock object that is the root of all ES future and options.

Note that SpiderRock Connect creates synthetic stock keys for all multi-hedge settlement baskets and the symbol portion of these keys starts with an underscore (_).

Expiration is a future or option expiration date in YYYY-MM-DD or year, month, day format.

Strike is a decimal number representing the strike price of an option. This is typically in display-format rather than exchange raw-format.

CPFlag is either ‘Call’ or ‘Put’.

SpiderRock Live Risk Servers

SpiderRock Connect's live risk servers aggregate start-of-day positions and intraday executions along with live market and analytic data and publish detailed risk records for all positions in an account. These records are visible in SpiderRock's Citrix tool suite and are available via SRSE SQL servers.

The SpiderRock Connect risk servers handle equity, future, equity option, and future option asset classes. They operate from Sunday morning through Friday night and are suitable for account, firm, and strategy risk management tasks, including precision static and dynamic surface-hedging, dynamic PnL attribution, greek aggregation, scenario and SPAN slide-aggregation, pin and early exercise management, and client theoretical surface-performance attribution.

SpiderRock Connect's risk servers also manage top-of-day risk rotations in which current positions and executions are aggregated into a previous period-position record for use either as a new start-of-day initial positions or to perform break checks against start-of-day positions loaded from a client's clearing firm. Top-of-day rotation time are product-specific: CME products rotate at 4:45 pm, ICE products at 5:45 pm, and NMS tickers at 7:45 pm Monday - Friday. Both current-day (live) and prior-day (frozen, as of rotation time) records are available in SRSE at any time. All frozen records for the trailing 90 days are available in the ElasticRock data cluster.

The SpiderRock Connect risk servers update the following risk records and aggregates quickly when positions change (usually from trading activity), and somewhat more slowly (usually about every 60 seconds) if positions have not changed. More information for all records below can be obtained from SRSE record documentation or, alternatively, from Citrix-tool-embedded grid column selectors.

Stock-Position Records - Accnt + StockKey

Stock-position records are created and updated during the day when either a start-of-period position or an execution exists. Stock-position records include the following data:

  • Start-of-day position: CLR and SR positions and marks.
  • Cumulative shares bought and sold during the trading day.
  • PnL from CLR and SR start-of-day positions, and PnL from all executions during the day.
  • Live marks and both SR and CLR closing marks.

Future-Position Records - Accnt + FutureKey

Future-position records are created and updated during the day when either a start-of-period position or an execution exists. Future-position records include the following data:

  • Start-of-day position: CLR and SR positions and marks.
  • Cumulative contracts bought and sold during the trading day.
  • PnL from CLR and SR start-of-day positions, and PnL from all executions during the day.
  • Live marks and both SR and CLR closing marks as well as exchange settlement marks.
  • Definition details such as tick value, point value, and years to expiration.

Option-Position Records - Accnt + OptionKey

Option-position records are created and updated during the day when either a start-of-period position or an execution exists. Option-position records include the following data:

  • Start-of-day position: CLR and SR positions and marks.
  • Cumulative contracts bought and sold during the trading day.
  • PnL from CLR and SR start-of-day positions, and PnL from all executions during the day.
  • Start-of-day and trading PnL from SR live surface marks (usually more accurate).
  • Live marks and both SR and CLR closing marks as well as exchange settlement marks (if any).
  • Definition details such as underliers per contract, tick value, point value, years to expiration.
  • Multihedge allocation details (underlier is a basket of 2 or more stocks).
  • Hedge deltas including binary (near expiry) and dynamic surface-hedging factors.
  • Live and prior-period option greeks include greek PnL attribution.
  • Standard risk slides (underlier +/- X%) including cash takeout and earnings scenarios.
  • Client theoretical surface edge and Pn-attribution (for clients that have uploaded surfaces).

Symbol Risk-Summary Records - Accnt + StockKey

Symbol risk-summary records aggregate stock-position records, future-position records, and option-position records into a symbol or product-level view of positions, risk, and PnL. These records are suitable for making accurate symbol-level hedging decisions and are the primary input in the SpiderRock Hedge Tool as well as the SpiderRock Symbol Viewer. These records are also the source for the SpiderRock Risk Viewer (all symbol-level detail tabs). Symbol risk-summary records contain the following data:

  • Stock, Future, and Option position and trade counts.
  • Symbol-level start-of-day position break summary (SR view vs. CLR view)
  • Symbol-level PnL: Start-of-day and trading. SR and CLR marks.
  • Symbol-level cumulative greeks: Delta, Vega, Gamma, Theta, Rho, Phi, etc.
  • Symbol greek PnL-attribution: VePnL, GaPnL, ThPnL, RhoPnL, PhiPnL, etc.
  • Symbol-level hedging data including dynamic surface-hedging aggregation.
  • Symbol-level haircut and margin values.
  • Multihedge risk allocations (option risk allocated to component underliers).
  • Theo surface edge and performance attribution (for clients that have uploaded surfaces).
  • Hypothetical continuous-hedging PnL (assumes mid-market hedging at 1 min frequency).
  • Time and skew bucket time-weighted vega aggregation (5 + 5).
  • Early exercise and pin risk-management alerts.

Expiration Risk Records - Accnt + Year/Moth/Day

Expiration risk records aggregate option position records for each expiration month. These records include the following data:

  • Long/short greek aggregation: Vega, WVega, WtVega, Theta, Rho.
  • Skew bucket time-weighted vega aggregation (5 buckets).
  • Greek PnL-attribution: VePnL, GaPnL, ThPnL, RhoPnL, PhiPnL, etc.
  • Expiration-level standard risk slides [underlier +/- X%].
  • Theo surface edge and performance-attribution (for clients that have uploaded surfaces).

Industry Risk Records - Accnt + IndCode

Industry risk records aggregate symbol risk-summary records by industry, sub-industry and group using a SpiderRock industry-classification scheme. These records include the following data:

  • PnL metrics: SR and CLR, start-of-day and trades.
  • Long/short greek aggregation: Vega, WVega, WtVega, Theta, Rho.
  • Time and skew bucket time-weighted vega aggregation (5 + 5).
  • Greek PnL attribution: VePnL, GaPnL, ThPnL, RhoPnL, PhiPnL, etc.
  • Theo surface edge and performance attribution (for clients that have uploaded surfaces).
  • Standard risk slides [underlier +/- X%].
  • Aggregate symbol haircut and margin values.

Account Risk Record - Accnt

Account risk records aggregate symbol risk-summary records by account. These records include the following data:

  • PnL metrics: SR and CLR, start-of-day and trades.
  • Long/short greek aggregation: Vega, WVega, WtVega, Theta, Rho.
  • Time and skew bucket time weighted vega aggregation (5 + 5).
  • Greek PnL attribution: VePnL, GaPnL, ThPnL, RhoPnL, PhiPnL, etc.
  • Theo surface edge and performance attribution (for clients that have uploaded surfaces).
  • Standard risk slides [underlier +/- X%].
  • Aggregate symbol haircut and margin values.

Risk Cube Detail Records - Stock, Futures, Options

Risk cube detail records mirror stock, future, and option position records. These records have a common layout for all asset types and are suitable for use in historical and pivot-table-style applications such as the SpiderRock Risk Analyzer. These records are published live during the day (visible in SRSE) and are uploaded to the ElasticSpider cluster at the end of each trading day.

Trade Cube Detail Records - Stock, Futures, Options

Trade cube detail records mirror SpiderRock Connect's parent execution records. These records have a common layout for all asset types and are suitable for use in historical and pivot-table-style applications such as the SpiderRock Trade Analyzer. These records are published live during the day (visible in SRSE) and are uploaded to the ElasticSpider cluster at the end of each trading day.

Multi-Hedge Option Handling - Equities

Equity options that settle into multiple stocks have special handling within SpiderRock Connect's systems. First, a synthetic stock ticker is created for the settlement basket. By convention, this ticker is the multihedge option root preceded by an underscore (‘_’). SpiderRock Connect publishes live synthetic prices for each settlement basket as component quotes change, and prices the corresponding multihedge options using these synthetic settlement basket markets. PnL and greeks including delta, vega, gamma, and theta are then aggregated from option position records (root) into symbol risk summary records (‘_’ + root). These same values are also proportionately allocated from (‘_’ + root) symbol risk-summary records to basket component symbol risk-summary records.

Typically, when examining the set of symbol risk summary records, total account PnL and greeks equals the aggregation of all records EXCEPT records whose ticker starts with (‘_’), as the risk from these records will have been allocated to records who’s symbols do not start with (‘_’). Including the (‘_’) records in the aggregation with double-count multi-hedge risk and PnL, if any exists in an account.

SpiderRock Position, Mark, and PnL Conventions

SpiderRock Connect's risk systems calculate PnL relative to multiple mark conventions. One convention attempts to mirror the industry standard or official marks for all asset classes. Other standards attempt to provide marks that are either more accurate, more stable over time, or more consistent across asset classes.

The main SR mark conventions are:

  • Clearing firm standard (CLR): Usually the official closing or settlement mark, if available. This can be either the last trade, a value determined by settlement committee, or the mid-point of the prevailing NBBO quote on close. These marks are product-specific and represent end-of-day marks but are not set at the same time for related assets.
  • SpiderRock synchronized (MID): Usually the mid-point of the prevailing quote at a single mark time for all related assets. The NMS close time is set to regular day market close, less 1 minute,for all equity and equity option assets including ETFs. CME and ICE close times are product-specific.
  • SpiderRock vol surface marks (VOL): Usually an SR surface volatility price taken at the same time as the MID marks above. These marks will be adjusted to be between the prevailing quote if necessary. This mark set is typically (significantly) more accurate for equity options than either MID or CLR in the sense that it is more likely both to be economically realistic and to exhibit less spurious noise over time. These marks are available for assets such as FLEX options that do not have public markets.

When calculating PnL, SpiderRock Connect typically breaks total PnL into two components:

  1. PnL attributable to positions held at the start-of-day, referred to as open (OPN) PnL.
  2. PnL attributable to trading activity during the day, referred to as day (DAY) PnL.

Note that day rotation times differ by product group. NMS start-of-day is 7:45 pm CST. CME start-of-day is 4:45 pm CST. ICE start-of-day is 5:45 pm CST.

Open (OPN) PnL calculations are typically of the following form:

  1. Asset PnL = Position Size x (New Mark – Old Mark) x Multiplier.
  2. Aggregate PnL = SUM ( AssetPnL ).

Where ‘Position Size’ and ‘Old Mark’ are established at the start-of-day and are equal to closing positions and marks the previous day, unless a corporate action has occurred overnight.

Note that PnL computed in this fashion is an estimate of effective one-day PnL. Simply summing Aggregate PnL over time is unlikely to give an accurate representation of PnL for longer periods of time as this calculation does not take all account activity into consideration.

In order to more accurately account for PnL over extended periods of time, the following calculation form is more appropriate:

  1. Initial Asset Value = SUM(Position Size x Old Mark x Multiplier) (as of T).
  2. Final Asset Value = SUM(Position Size x New Mark x Multiplier) (as of T + N).
  3. Trading PnL = SUM(Realized Gains and Losses).
  4. Other Fees = SUM(other account fees including interest and brokerage).
  5. Aggregate PnL = Final Asset Value – Initial Asset Value + Trading PnL + Other Fees.

SpiderRock Connect's systems generally are not aware of all of the components of the above calculation and do not attempt to replicate it.

Clearing Firm (CLR) Open PnL

SpiderRock Connect clearing firm PnL is intended to be an indication of how assets held at the start-of-day have performed.

    Asset Position Size - Clearing firm start-of-day position (can be corporate-action-adjusted).

    Old Mark - Clearing firm start-of-day mark (can be corporate-action-adjusted).

    New Mark - SpiderRock mid-point mark.

Most (but not all) clearing firms apply corporate actions by the time SpiderRock Connect receives start-of-day positions from them. For clients directly loading positions and marks these values will be as uploaded.

SpiderRock Synchronized (MID) Open PnL

SpiderRock synchronized PnL is intended to be an indication of how assets held at the start of day have performed when using marks that are fully synchronized.

    Asset Position Size - Clearing firm start-of-day position (can be corporate-action-adjusted).

    Old Mark - Clearing firm start-of-day mark (can be corporate-action-adjusted).

    New Mark - SpiderRock mid-point mark.

Note that synchronized marks are taken slightly before the official close, and at the same time for all assets in a category. This can significantly improve mark quality when the official mark is deriving from a quoted market and the quotes in question are being pulled at the end of the day. Also, these marks can synchronize ETF and index-based marks, which avoids the time-mismatch issues inherent to some products.

SpiderRock Surface Mark (Vol) Open PnL

SpiderRock surface mark PnL is intended to provide a more accurate measure of asset value and PnL for portfolios containing options, especially when the options in question are relatively wide and/or inconsistently marked.

    Asset Position Size - Clearing firm start-of-day position.

    Old Mark - Prior period closing SR surface mark (options) or SR mid-point mark (equities and futures).

    New Mark - SpiderRock live SR surface mark (options) or SR mid-point mark (equities and futures).

SpiderRock Connect is continuously fitting the option implied markets with a constrained spline to produce a per-symbol-expiration surface. For almost all markets, these constrained spline surfaces ride between live market bids and offers and can be used to create a mark more representative of true value that the mid-point of the individual market bids and offers.

Note that for very tight markets (either 1 or 2 ticks wide) SpiderRock Connect uses mid-market values rather than surface marks. Also, when a SpiderRock surface is at, or outside of, a bid-ask market, then the actual market (bid + ½ tick, ask – ½ tick) is used rather than the surface mark.

SpiderRock surface PnL is typically more accurate and less noisy (over time) than corresponding PnL based on traditional mid-market marking techniques. For example, for common US equity option portfolios, SpiderRock surface PnL can exhibit a 25%+ reduction in day-over-day PnL standard deviation.

Note that equity start-of-day marks will not equal top-of-day prior period marks if a corporate action has been applied to positions and marks between top-of-day and start-of-day. Most (but not all) clearing firms apply corporate actions by the time SpiderRock Connect receives start-of-day positions from them. For clients directly loading positions and marks, these values will be as uploaded.

SpiderRock Hedge Delta Computation

SpiderRock's symbol risk-summary records contain a hedge delta field that represents market exposure to the stock (equities) or front month future (future product groups).

By default, hedge delta is the delta corresponding to the SpiderRock surface volatility for the option in question. If no SpiderRock surface volatility exists, then mid-quote volatility is used instead.

The definition of hedge delta can be modified as follows:

  1. For options with less than Binary Days to expiration, force delta calculations to [-1,0,+1] (or +/- 0.5 if the underlier quote is straddling strike).
  2. Use a delta derived from a client-upload theoretical surface volatility instead of SR surface volatility.
  3. Include a VeSlope (surface slide) term derived by assuming SR or client surfaces slide left/right with the underlier. This is sometimes called sticky-delta hedging as opposed to the default sticky-strike hedging.

Contact SpiderRock Client Support Desk for help configuring hedging behavior as needed.

Risk Management Citrix Tool Suite

SpiderRock Connect provides an elaborate collection of risk GUI tools for analyzing account and strategy risk, and acting to either hedge or modify account risk profiles. This collection includes:

SR Risk Viewer (RV)

This tool allows easy visibility of symbol, industry, expiration, and account aggregate details in a live-monitor format. Features include:

  • Symbol-level positions and break details.
  • Greek and standardized slide risk.
  • OPN PnL details including greek attribution.
  • DAY PnL including T+1m and T+10m as well as DeltaNeutral measures.
  • TheoEdge details including prior-day edge performance metrics.
  • Facilities for managing early exercise and pin risk.

Read our Risk Viewer guide here.

SR Hedge Tool (HT)

This tool is a live symbol-level hedge basket manager that can substantially automate the process of computing appropriate portfolio hedging baskets for complex option positions. It can target either trades done today, start-of-day positions, or both. It includes options for setting hedging bandwidth targets and can scheduled to run repeatedly during the trading day or selectively as needed.

Read our Hedge Tool guide here.

SR Risk Manager (RM)

This tool has full live asset-level detail and allows flexible aggregation along multiple dimensions. This tool is suitable for viewing and managing risk in a single account or across groups of accounts. Features include:

  • Risk aggregation: Client Firm, Account, Symbol, Expiration, Industry, Skew Bucket, iVol Range, User View Groups, etc.
  • Custom-span slide calculation: Custom slide levels and configuration (Pct or Log, StickyStrike or SlidingSurface, Simple or Beta or VolRatio Adjusted, StdDev adjusted, etc.).
  • Exchange standard-span slide calculations: Based on exchange span parameter files.
  • Flexible-span slide aggregation: Similar to risk aggregations. Can be used to get portfolio risk insight for complex portfolios when used in conjunction with custom-span calculations.
  • Delta, Gamma, Vega, and WtVega greek slides for all span calculations.
  • Highly configurable integrated market scanning (Risk Macro) tool that can be used to automatically generate portfolio-wide risk opening and/or closing orders. Can be used globally for groups of accounts or locally, based on selected risk context.

Read our Risk Manager guide here.

SR Risk Analyzer (RA)

This tool is a historical asset-level pivot-table style tool that is useful for analyzing risk details over time. This tool typically offers an ability to view and access 90 days of historical risk data in fast and flexible manner.

Read our Risk Analyzer guide here.

FLEX Positions (Coming Soon)

SpiderRock Connect will soon be able to support FLEX positions. Clients would be able to upload Start-of-Day clearing records that include FLEX Options and SpiderRock Connect would no longer reject any FLEX positions entered via a parent order message.

In the SpiderRock Connect system, FLEX options will be marked by having a route that begins with a number. FLEX multi-hedge options would have their routes start AND end with a number. The number will indicate the exercise type and AM/PM settlement. As an example: 1 = AM American, 2 = PM American, 3 = AM European, 4 = PM European, 5 = Asian, 6 = Cliquet.

Therefore, a FLEX o_tkey as “1APPL” to indicate that it is an APPL contract with an American exercise type and an AM settlement.

    Please note that the above nomenclature is not guaranteed to be the final design and the above example only serves to further understanding.