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.
Trucost Sovereign Carbon Exposure
Returns Top 10 Contributors To Sovereign Territorial GHG Emissions For Italy
Trucost Sovereign Carbon Exposure
Returns Key Economic Data For Italy For 2024
Trucost Sovereign Carbon Exposure
Returns Sovereign GHG Emissions History For Italy
Trucost Sovereign Carbon Exposure
Returns Power Generation Data For Italy From 2021 To 2025
Transactions
Returns Analysis Of Sector Level Buybacks Within The S&P 500
Transactions
Returns Peer Buybacks Relative To Market Capitalization
Transactions
Returns Analysis Of Buyback Activity Based On Valuation Signals
Transactions
Returns Event Study Using Price Close Around Buyback Announcements
S&P Capital IQ Financials
Returns The Latest LTM Financials Based On Filing Date Relative To Observation Date
Business Entity Cross Reference Service (BECRS)
Returns The SQL Equivalent For The API Mnemonic SP_ENTITY_ID (Entity ID)
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 SP_TOTAL_RETURN (Total Return)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RD_EXP_FN (Research And Development Expense)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_CLIENT_FLOWS (AUM Net Client Flows)
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 IQ_EST_ACT_NI (Net Income Normalized Actual)
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_ROCE (Return On Capital Employed)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_WORKING_CAP (Working Capital)
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)
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_OPER_INC_GROWTH (Operating Income Growth)
Transactions
Returns Buyback Execution Versus Authorization Analysis
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 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_PBV (Last Close Price By Book Value)
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_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_TOTAL_DEBT_EQUITY (Total Debt By Equity)
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_UFCF_MARGIN (Unlevered Free Cash Flow Margin)
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_OPER_INC (Operating Income)
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_ASSETS_UNDER_ADMINISTRATION (Assets Under Administration)
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_TOTAL_POLICY_INC (Total Policy Income)
Transactions
Returns The Buyback Announcements For S&P 500 Constituents
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_NET_INTEREST_INC (Net Interest Income)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_CAPEX (Capital Expenditure)
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_EBITDA_MARGIN (EBITDA Margin Percentage)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_ROE (Return On Average Shareholders Equity)
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_REV_TO_AVG_EMPLOYEES (Total Revenue By Avg Employees)
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 IQ_REVENUE_EST (Revenue Consensus Mean)
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 SP_EPS_EST (EPS Normalized Consensus Mean)
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_ASSET_TURNS (Asset Turnover)
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_DA_SUPPL_CF (Depreciation And Amortization)
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_PE_NORM (PE Normalized)
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_DAYS_SALES_OUT (Days Sales Outstanding Average Receivables)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RETURN_ASSETS (Return on Assets)
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_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 Share Buybacks And EPS Contribution Analysis
Transactions
Returns Capital Allocation Strategy Buyback Versus Dividends
Credit Analytics
Retrieves EWS 1.0 Risk Metrics For Proactive Credit Monitoring
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
Business Relationships Analytics
Returns Multi Level Subsidiary Hierarchy with Supplier and Customer Relationships
Institutional Ownership Factors
Returns Institutional Ownership And Active Share Changes In AFL US
Institutional Ownership Factors
Returns Top Institutional Ownership Concentration
Institutional Ownership Factors
Returns Hedge Fund Ownership Trend For Selected Company
Cybersecurity Factors
Returns Top Percentile by Average Application Security Rank
Cybersecurity Factors
Returns Diligence Score Response of 5 Worst US Performers
Institutional Ownership Factors
Returns Institutional Ownership Activity Net Flow and Trading Behavior over the Past Year
Cybersecurity Factors
Returns Cybersecurity Performance by Region
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
Shipping Factors
Returns Shipping Trends over the Past Year for a Specific Company
CDS to Equity Factors
Returns the Time Series of Credit Revisions - 3 Month - RawRatio by Region
CDS to Equity Factors
Returns CDS to Equity Factors Data with CIQ Base Data
CDS to Equity Factors
Returns CDS Divergence Rank for a Specific Date and Universe ID
Shipping Factors
Returns Export Market Concentration for a Company by Region
Shipping Factors
Returns Top 10 Companies with the Highest Shipping Value in a Month
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