Query Library
Search a comprehensive library of pre-built queries designed to help you quickly maximize the value of our data offerings. For each query, the library provides a brief description along with the data packages necessary to execute the query.
Transactions
Returns Analysis Of Buyback Activity Based On Valuation Signals
Transactions
Returns Event Study Using Price Close Around Buyback Announcements
Transactions
Returns Analysis Of Sector Level Buybacks Within The S&P 500
Transactions
Returns Peer Buybacks Relative To Market Capitalization
Business Entity Cross Reference Service (BECRS)
Returns The SQL Equivalent For The API Mnemonic SP_ENTITY_ID (Entity ID)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_PBV (Last Close Price By Book Value)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_ASSET_TURNS (Asset Turnover)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_LFCF_MARGIN (Levered Free Cash Flow Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_REV (Total Revenues)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EBIT_MARGIN (EBIT Margin Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_ROCE (Return On Capital Employed)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_PAYABLE_OUT (Average Days Payable Outstanding)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_GROSS_MARGIN (Gross Profit Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_OPER_EXPEN (Total Operating Expenses)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_ASSETS (Total Assets)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_CASH_CONVERSION (Cash Conversion Cycle)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_OPER_INC (Operating Income)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RD_EXP_FN (Research And Development Expense)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_SALES_OUT (Days Sales Outstanding Average Receivables)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RETURN_EQUITY (Return On Equity Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RETURN_ASSETS (Return on Assets)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_CLIENT_FLOWS (AUM Net Client Flows)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_NET_INVEST_INC (Net Investment Income)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_TOTAL_POLICY_INC (Total Policy Income)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_TOTAL_REV_TO_AVG_EMPLOYEES (Total Revenue By Avg Employees)
Transactions
Returns Share Buybacks And EPS Contribution Analysis
Transactions
Returns Buyback Execution Versus Authorization Analysis
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_REVENUE_EST (Revenue Consensus Mean)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EST_EPS_SURPRISE_PERCENT (EPS Surprise Percentage)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_EST_ACT_REV (Revenue Actual)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_EST_ACT_NI (Net Income Normalized Actual)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_DEBT_EBITDA (Total Debt By EBITDA)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_INC_MARGIN (Net Income Margin Percentage)
S&P Capital IQ Financials
Returns the SQL Equivalent For The API Mnemonic IQ_DA_SUPPL_CF (Depreciation And Amortization)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_DEBT_EQUITY (Total Debt By Equity)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic SP_TOTAL_RETURN (Total Return)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_AUM (Assets Under Management)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_REV_1YR_ANN_GROWTH (Total Revenues 1 Year Growth Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EFFECT_TAX_RATE (Effective Tax Rate Ratio)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_SGA_MARGIN (SGA Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_CL (Total Current Liabilities)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EBITDA_MARGIN (EBITDA Margin Percentage)
Key Developments
Returns The SQL Equivalent For The API Mnemonic SP_EARNINGS_ANNOUNCE_DATE (Earnings Date)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_TIER_1_COMMON_RATIO (Tier 1 Common Capital Ratio)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_CORE_EPS_GROWTH (Core EPS Growth)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_OPER_EXP_GROWTH (Operating Expense Growth)
Transactions
Returns The Buyback Announcements For S&P 500 Constituents
Business Entity Cross Reference Service (BECRS)
Returns The SQL Equivalent For The API Mnemonic SP_ENTITY_NAME (Entity Name)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EST_ACT_EPS (EPS Normalized Actual)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_INTEREST_INC (Net Interest Income)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_CAPEX (Capital Expenditure)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_ROE (Return On Average Shareholders Equity)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_WORKING_CAP (Working Capital)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_EST_REV_SURPRISE_PERCENT (Revenue Surprise Percentage)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EPS_EST (EPS Normalized Consensus Mean)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_PE_NORM (PE Normalized)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_INVENTORY_OUT (Days Outstanding Inventory)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EBIT_INT (EBIT By Interest Expense)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_UFCF_MARGIN (Unlevered Free Cash Flow Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_ASSETS_UNDER_ADMINISTRATION (Assets Under Administration)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_DEBT_EBITDA (Net Debt By EBITDA)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_ACQUISITIONS_TRANSFERS_OTHER (AUM Net Acquisitions Transfers And Other)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_OPER_INC_GROWTH (Operating Income Growth)
Transactions
Returns Capital Allocation Strategy Buyback Versus Dividends
Credit Analytics
Retrieves time-series EWS 1.0 metrics at daily frequency using GDST
Credit Analytics
Retrieves Historical EWS 1.0 Metrics For A Specified Period Using GDSHE
Credit Analytics
Retrieves EWS 1.0 Risk Metrics For Proactive Credit Monitoring
Business Relationships Analytics
Returns Multi Level Subsidiary Hierarchy with Supplier and Customer Relationships
Institutional Ownership Factors
Returns Top Institutional Ownership Concentration
Institutional Ownership Factors
Returns Hedge Fund Ownership Trend For Selected Company
Cybersecurity Factors
Returns Diligence Score Response of 5 Worst US Performers
Cybersecurity Factors
Returns Cybersecurity Performance by Region
Institutional Ownership Factors
Returns Institutional Ownership And Active Share Changes In AFL US
Institutional Ownership Factors
Returns Institutional Ownership Activity Net Flow and Trading Behavior over the Past Year
Cybersecurity Factors
Returns Top Percentile by Average Application Security Rank
Cybersecurity Factors
Returns Application Patching Cadence and BitSight Rating Compared to Distance from Industry Median BitSight Rating
Shipping Factors
Returns Industry Relative Monthly Export Shipment Ratio with GICS
CDS to Equity Factors
Returns Unpivoted CDS to Equity Factors for a Specific Date
CDS to Equity Factors
Returns CDS To Equity Factors For Specific Trading Item ID
CDS to Equity Factors
Returns CDS to Equity Factors Data with CIQ Base Data
Shipping Factors
Returns Shipping Factors for a Specific Date Range
CDS to Equity Factors
Returns Latest CDS to Equity Factors for a Specific Company
Shipping Factors
Returns Export Market Concentration for a Company by Region
CDS to Equity Factors
Returns the Time Series of Credit Revisions - 3 Month - RawRatio by Region
Shipping Factors
Returns Shipping Trends over the Past Year for a Specific Company
CDS to Equity Factors
Returns Time Series of CDS Slope - 5 year minus 1 year - RawRatio for a Specific Company
Shipping Factors
Returns Total Import and Export Volume by Country
Shipping Factors
Returns Top 10 Companies with the Highest Shipping Value in a Month
CDS to Equity Factors
Returns CDS Divergence Rank for a Specific Date and Universe ID
Bond to Equity Factors
Returns Latest Bond to Equity Factors for a Specific Company
Bond to Equity Factors
Returns Time Series of 5-Year Z-spread With Substitution for a Specific Company
Bond to Equity Factors
Returns Unpivoted Bond to Equity Factors for a Specific Date
Bond to Equity Factors
Returns the 5-Year Z-spread Grouped by Geographical Region.
CDS Pricing
Returns Live Credit Default Swaps Data For Single Names
CDS Pricing
Returns Live Credit Default Swaps Data For Credit Indices
CDS Pricing
Returns Credit Default Swaps Data For Sector Curves
Company Relationships
Returns The Legacy Capital IQ Platform Corporate Tree Using The Company Relationship Dataset
Company Relationships
Returns The Legacy Capital IQ Platform Corporate Tree Using The Company Relationship Dataset (v3)
Business Relationships Analytics
Returns The Double Ranking Of Network Centrality And Upstream Momentum
Business Relationships Analytics
Returns The Sector Level Momentum Factor Ranking
Business Relationships Analytics
Returns The Sector Level Ranking Of Network Centrality Based On WeightIn And WeightOut
Business Relationships Analytics
Returns The Universe Percentile Ranking By Momentum Factor
Company Relationships
The Ultimate Parent
SNL Insurance Regulatory Data
Returns Net Premiums Earned For United Automobile Insurance Company
SNL Insurance Regulatory Data
Returns Financials Of Current Reinsurers Associated With The Input Cedent Institution
Company Relationships
Returns Ultimateparent Details With Levels Recursively For A Given Company
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company