SR Analytics

SR Analytics provides access to comprehensive market data and analytics through SQL queries. Key features include:

• Live and prior day SpiderRock Connect volatility surfaces
• Live and prior day implied volatilities and Greeks
• Rate curve, dividend, and earnings estimates
• Historical underlying volatility tables

SR Analytics Tables

The following images show the available tables in SR Analytics:

LiveImpliedQuoteAdjust Table

The LiveImpliedQuoteAdj table is the most heavily used table within SR Analytics. It contains option NBBO data, the midpoint of the underlying, the SpiderRock volatility surface, and all corresponding Greeks.

This table is primarily used for scanning trade ideas and calculating client-specific PnL values. There are two calculation sources for this table:

• Loop process: Updates all values continuously
• Tick process: When the NBBO changes for a given strike, that strike exits the loop and performs an immediate update. Additionally, if the underlying price moves while the option NBBO remains unchanged, the implied markets are adjusted to reflect the updated underlying price.

Query Examples

1. Retrieve all equity option records from the LiveImpliedQuoteAdj table:

   SELECT * FROM sranalytics.msgliveimpliedquoteadj WHERE okey_at = 'EQT';

2. Retrieve live implied quotes for December 5th AAPL options with strikes above 180:

   SELECT * FROM sranalytics.msgliveimpliedquoteadj WHERE okey_tk='AAPL' AND okey_mn=12 AND okey_dy=5 
   AND okey_xx > 180;
   

OptionQuoteProbability Table

A complementary table to LiveImpliedQuoteAdj is OptionQuoteProbability. This table contains option NBBO data along with the top-level bid and ask sizes. It also displays the bid-take and ask-take probabilities (the same metrics displayed in the Symbol Viewer) and the trailing 10-minute average market width calculation.

Query Example

1. Retrieve all equity option records from the OptionQuoteProbability table:

   SELECT * FROM sranalytics.msgoptionquoteprobability WHERE okey_at = 'EQT';
   

OptionPrintSet Table

The OptionPrintSet table displays option trade prints. Each print record includes individual trade details along with the total volume for the day. For every print, SR Analytics provides a full markup that includes the corresponding SpiderRock surface values and Greeks as they were at the time of the print.

Query Example

1. Retrieve all equity option prints:

   SELECT * FROM sranalytics.msgoptionprintset WHERE okey_at = 'EQT';
   

Live Surface ATM & Live Surface Curve Tables

The LiveSurfaceCurve and LiveSurfaceAtm tables contain the full SpiderRock curve records, including all forward expiration values and spline points.

Query Examples

1. Retrieve the live surface curve for AAPL equity options:

   SELECT * FROM sranalytics.msglivesurfacecurve WHERE ekey_at = 'EQT' AND ekey_tk = 'AAPL';

2. Retrieve the live surface ATM for AAPL equity options:

   SELECT * FROM sranalytics.msglivesurfaceatm WHERE ekey_at = 'EQT' AND ekey_tk = 'AAPL';

3. Retrieve all available surfaces for June AAPL options:

   SELECT * FROM sranalytics.msglivesurfaceatm WHERE ekey_tk='AAPL' AND ekey_mn=6;
   

Global Rates, Dividends, and Stock Earnings Calendar Tables

SpiderRock provides access to the risk-free rates and dividend values used in the calculation of SpiderRock volatility surfaces. Clients can also view the earnings calendar referenced in these calculations.

Query Examples

1. Retrieve all global rates from the GlobalRates table:

   SELECT * FROM sranalytics.msgglobalrates;

2. Retrieve all global dividends from the GlobalDividends table:

   SELECT * FROM sranalytics.msgglobaldividends;

3. Retrieve the stock earnings calendar from the StockEarningsCalendar table:

   SELECT * FROM sranalytics.msgstockearningscalendar;

Stock Dividend Detail Table

The StockDetail table provides information about upcoming dividends and the time remaining until the next dividend.

Query Examples

1. Retrieve all stock detail records:

   SELECT * FROM sranalytics.msgstockdetail;

2. Retrieve stocks announcing earnings in the next 3 days:

   SELECT * FROM sranalytics.msgstockdetail WHERE nextEarnDays < 3 AND nextEarnDays > 0;
   

Definition Tables

Definition tables provide product and security identification information.

Query Examples

1. Retrieve root definitions for equity assets from the RootDefinition table:

   SELECT * FROM sranalytics.msgrootdefinition WHERE root_at = 'EQT';

2. Retrieve all option expiry definitions from the OptionExpiryDefinition table:

   SELECT * FROM sranalytics.msgoptexpirydefinition;

3. Retrieve all industry definitions from the IndustryDefinition table:

   SELECT * FROM sranalytics.msgindustrydefinition;

4. Retrieve ticker definitions from the TickerDefinitionExt and the TickerDefinition tables. This includes all the different ways a security can be labeled, such as BBG composition, OCC, LEI, CFI, CIC, etc.:

   SELECT * FROM sranalytics.msgtickerdefinitionext;

   SELECT * FROM sranalytics.msgtickerdefinition WHERE ticker_at = 'EQT';

Open/Close Mark Tables

Query Examples

1. Retrieve SpiderRock opening marks and Greeks for SPY from the OptionOpenMark table:

   SELECT * FROM sranalytics.msgoptionopenmark WHERE okey_tk='SPY';
   

2. Retrieve the SpiderRock close mark for AAPL from the StockCloseMark table:

   SELECT * FROM sranalytics.msgstockclosemark WHERE ticker_tk='AAPL';
   

3. Retrieve the beta value for TSLA from the StockBeta table:

   SELECT * FROM sranalytics.msgstockbeta WHERE ticker_tk='TSLA';