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.
Visible Alpha Estimates
Quarterly Earnings Trend For A Specific Company
Visible Alpha Estimates
Returns SD Balance Sheet Template
Base Data, Visible Alpha Estimates
Converting Visible Alpha Estimates Using SP Foreign Exchange Rates On A Specific Date
Visible Alpha Estimates
Measuring Financial Health Via Debt To Equity Ratio
Market Data, Visible Alpha Estimates
Connecting Visible Alpha Estimates To CIQ Market Data To Get Daily Pricing And Market Capitalization
Visible Alpha Estimates
Analyze Consensus Time Series
Base Data
Returns ISIN, CUSIP, BRD and Markit Ticker History For Input List Of Companies
Visible Alpha Estimates
Use VaCompanyId To Find Company Specific Line Items
Visible Alpha Estimates
Earnings Surprise For Every KPI For Every Company Within A Business Group
S&P Capital IQ Estimates, Visible Alpha Estimates
Blending Visible Alpha Estimates With CIQ Estimates For Industry Leaders In Pharmaceuticals
Visible Alpha Estimates
Retrieve Latest Reported Revenue
Visible Alpha Estimates
Access Core Financial Templates
Visible Alpha Estimates
Revision History Of Estimates For A KPI
Visible Alpha Estimates
Discover KPIs For A Business Group
Base Data, Visible Alpha Estimates
Linking The Visible Alpha Esimates Vacompanyid To The SP Capital IQ CompanyID
Visible Alpha Estimates
Discover Company Specific Parameters
Visible Alpha Estimates
Recreate Insights Application Views
Visible Alpha Estimates
Identify Companies With Consensus Data
Visible Alpha Estimates
Explore Industry And Business Groups For Companies
Visible Alpha Estimates
Identify Business Groups For A Company
Visible Alpha Estimates
Latest Revenue Growth Rate Calculation
Visible Alpha Estimates
Retrieve Quarterly Actuals For A Company
Visible Alpha Estimates
Identify Companies With Financial Data
Visible Alpha Estimates
Access Latest Ticker Data
Visible Alpha Estimates
Access Latest Consensus For Various Periods
RatingsXpress®: S&P Credit Ratings
Returns Liabilities Summary And Credit Enhancement Data
Credit Analytics
Retrieves Sovereign 1-100 Score In The Riskgauge 3.0 Model Using Different Restatementtypeids.
RatingsXpress®: S&P Credit Ratings
Returns Trustee Reported Tests With Performance Data
RatingsXpress®: S&P Credit Ratings
Returns CLO Performance Distribution Metrics Data
Visible Alpha Estimates
Track IPhone Sales Over Time
RatingsXpress®: S&P Credit Ratings
Returns S&P Generated Metrics For Summary Issuance By Specific Instrument Symbols
RatingsXpress®: S&P Credit Ratings
Returns CLO Profile And Monitoring Metrics Data For Specific Instrument Symbol
Visible Alpha Estimates
Calculate Revenue Weight By Segment
Visible Alpha Estimates
Calculate EPS Surprise
Visible Alpha Estimates
Find Companies In A Business Group
Credit Analytics
Retrieves Sovereign 1-100 score In The Riskgauge 3.0 Model
Credit Analytics
Retrieves Different Absolute Contribution Ratios Under RiskGauge 3.0 Model
Visible Alpha Estimates
Locate Business Model Templates
Visible Alpha Estimates
Identify Business Group And Industry For Tickers
Visible Alpha Estimates
Identify All Companies In A Business Group
Visible Alpha Estimates
Track Revenue Estimate Changes
Visible Alpha Estimates
Explore Standard Financial Templates
Visible Alpha Estimates
Rank Key Performance Indicators
RatingsXpress®: S&P Credit Ratings
Returns CLO Profile And Deal/Collateral Performance Data
Visible Alpha Estimates
Find Latest Estimated Revenue
Credit Analytics
Retrieves RiskGauge 3.0 Country Benchmark Using Pdtype As IQ_RG3_SOV_1YR_PD
Credit Analytics
Retrieves Sovereign 1 Year PD In The Riskgauge 3.0 Model
Commodities Energy Pricing
Returns Spark Spreads At Various Heat Rates And Implied Heat Rate For Gas Spark On A Specific Date
S&P Capital IQ Estimates
Returns all NTM mean EPS data as it existed at a particular point in time
Bond to Equity Factors
Returns Bond To Equity Ratios Records For Specific Date And UniverseID
Bond to Equity Factors
Returns Bond Equity Ratios Analysis
S&P Capital IQ Estimates
Returns a Series of Current EPS Values For the 2024 Fiscal Year
Bond to Equity Factors
Returns Bond To Equity Factors For Specific Trading ItemID
S&P Capital IQ Estimates
Returns the Current Year Revenue Estimate For a Company
S&P Capital IQ Estimates
Identifying Consensus Estimates Excluding Stock-Based Compensation and or Amortization of Intangibles Using Footnote
Retail Flow
Returns Net Buy Sentiment Analysis For Retail Equity Trades
Retail Flow
Returns Retail Equity Trade Summary For TradingitemID
SNL Insurance Regulatory Data
Returns Solvency II Datapoints For Input European Countries
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Module
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Pivot Module
S&P Capital IQ Financials
Returns Financial Reporting Data By Company and Financial Statement Type
S&P Capital IQ Financials
Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry
S&P Capital IQ Estimates
Returns 10 Year Average TEV/EBITDA Estimates For Reported Forward One Period For A Company
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company Across The US In 2024
Ownership
Returns Ownership Summary For Selected Tickers Over Last Five Periods With Categorized Owner Types
Physical Risk
Returns Company Level Physical Risk Data For A Given Forecast Year And Scenario
Ownership
Returns Ownership Detailed For Selected Ticker With Categorized Owner Types
Physical Risk
Returns Physical Risk Company Headquarters And Asset Exposure Score Data Compared To County, State, And Subnational Exposures For A Given Forecast Year And Scenario
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Across The US In 2024
S&P Capital IQ Financials
As Reported Transparency
SNL RateWatch Depository Rates & Fees
Competitive Interest Rates
SNL RateWatch Depository Rates & Fees
Bank Product Rates
SNL RateWatch Depository Rates & Fees
Parent Operating Bank
SNL RateWatch Depository Rates & Fees
Standard Interest Rates
SNL RateWatch Depository Rates & Fees
NY Branches
SNL RateWatch Depository Rates & Fees
Rates During A Specific Timeframe
SNL RateWatch Depository Rates & Fees
Branches And Location
SNL RateWatch Depository Rates & Fees
Average Bank Product Rate
Panjiva Supply Chain Intelligence
Leverages Snowflake Dynamic Scripting To Provide Import Statistics For Specified Companies
S&P Capital IQ Estimates
Returns Estimate EPS Consensus Mean And P/E Ratio
OTC Derivatives Data
Returns Equity Stock ETF Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity VolSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity VarSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity Index Bid Ask Volatility And Forward Curve Data
Headcount Analytics
Headcount By Top 10 Previous Employers
Headcount Analytics
Returns Top And Bottom Metro Growth Areas For An Industry
Headcount Analytics
Top And Bottom 10 Companies In A Metro Area Based On 12 Months Growth Rate
Headcount Analytics
Role And Department Tenure For A Company
Headcount Analytics
Returns Monthly Headcount Changes For A Company
Headcount Analytics
Headcount By Top 10 Next Employers
Headcount Analytics
Monthly Headcount Data With Transactions Rounds Of Funding Information For A Company
Base Data
Returns 365 Days Average Fxrate Historical Data
Business Relationships Analytics
Returns Business Relationship Analytics Report For Customer Supplier Dynamics
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date For MI Keys
CDS Pricing
Return Credit Default Swaps Pricing Data For Single Names
CDS Pricing
Returns Credit Default Swaps Data For Credit Indices
CDS Pricing
Returns Credit Default Swap Pricing Data For Credit Tranches
S&P Capital IQ Financials
Returns Unconsolidated Financial EVIC Data Available As Per The LTM Holding Dates
Index Data
Returns Levels Of Index Hierarchy Using Index Key For A BMI Index
Private Company Financials
Returns Private Company Financials EVIC Data As Per The Observation Date
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Issuer Ratings With Filtered Out Muni Ratings
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Bond Ratings With Filtered Out Muni Ratings
Market Data
Returns Carryforward Market Pricing Data For The Specified Date Range
OTC Derivatives Data
Returns Equity Index Volatility Forward Curve And Dividend Yield Data
Trucost ESG Financial and Market Data
Returns Point In Time EVIC Data Available As Per The Observation Date
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date
OTC Derivatives Data
Returns Equity Stock ETF Volatility Forward Curve And Dividend Yield Data
S&P Capital IQ Financials
Returns Latest EVIC Data Available As Per The Observation Date
Key Developments
Query Maps Keydevs Events With CIQEstimates And CIQFinancials
Trucost Environmental
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Trucost Environmental
Returns Top 10 Private Companies In United Kingdom With Highest Scope 3 Downstream Emissions In 2019
Trucost Environmental
Returns The Latest Data On Absolute Carbon Emissions For Greenhouse Gas(GHG) Scope 1 By InstitutionIDs
Trucost Environmental, Trucost Environmental: Private Companies
Returns Latest Available Data For Greenhouse Gas(GHG) Scope Of An InstitutionId
Trucost Environmental
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Trucost Environmental
Returns Private Companies With Over 75 Percent Revenue In Crude Petroleum And Natural Gas Extraction Sector
CreditPro®
Returns The Instrument Level Details
Machine Readable Transcripts
Returns Fiscal Years And Fiscal Quarters For All Latest Transcripts
Market Data, S&P Capital IQ Estimates, S&P Capital IQ Financials
Returns Financial Multiples And Forward Estimates Data
Base Data
Returns Year On Year Average Exchange Rate For All Countries
Market Data, S&P Capital IQ Financials
Returns TEV And EBITDA Ratios For Selected Companies As Of An Observation Date
Compustat® Financials
Returns Consolidated Financial Data For Company As Of Observation Date
S&P Capital IQ Estimates
Returns TEV/NTM EBITDA Values For Time Series
S&P Capital IQ Estimates
Returns Time Series Forward Estimate EBITDA For A Ticker
S&P Capital IQ Financials
Returns Premium Financials, Market Capitalization, And Market Prices For The Trading Items Pivot
Business Entity Cross Reference Service (BECRS)
Returns Risk Score Analysis Data For DUNS And GICS Identifiers
Index Data
Returns S&P500, R2000 And FALLWORLD Index Constituents And Market Data By Sector As Of A Specified Date
Physical Risk: Country, Subnational & Municipal
Returns Physical Risk GDP Exposed Metric For All US Geographies
Market Data
Returns Analysis Of Unadjusted Outstanding Shares For Stock Splits
S&P Capital IQ Financials
Returns Latest LTM Total Revenue Value Along With Annual Values
Key Developments
Returns Key Developments In Venture Vapital (VC) And Private Equity (PE) Firms
Company Connections: Detailed Estimates
Returns Company Connections For Compustat Gvkey And Iid
Base Data, Market Data, S&P Capital IQ Financials
Returns Currency Adjusted Financial Metrics For Trading Item ID
S&P Capital IQ Estimates
Returns Forward Estimates With Currency Conversion
S&P Capital IQ Estimates
Returns Estimates For Reported Forward Five Periods
SNL Insurance Regulatory Data
Returns Paid Loss Ratios By Accident Year Loss Triangle
SNL Insurance Regulatory Data
Returns Type SubType And Location For Product Filings Using Legacy Insurance Packages
S&P Capital IQ Estimates
Returns Estimate Consensus Coverage Between 2014-2021 For Companies Listed On The Stock Exchange Of Hong Kong Ltd.
Ownership
Returns Recursive Fund Ownership Hierarchy With Company Information, Shareholding, And Ownership Metrics Across Multiple Levels
Base Data
Returns Comprehensive Company Details
Panjiva Supply Chain Intelligence
Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordId
Securitized Products Pricing
Returns The Recent Instrument Prices
Physical Risk: Country, Subnational & Municipal
Return Comparison Of Portugal And Spain Population Percentage Exposure To Extreme Heat
Physical Risk: Country, Subnational & Municipal
Returns Subnational Level Physical Risk Absolute Hazard Frequencies For All Countries
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The GSAC Pricing Data For ISINs
Physical Risk: Country, Subnational & Municipal
Returns Country Level Physical Risk Exposure Scores For All Countries Within Subregion
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Return Liquidity Average Per ISIN Or ISINs
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns Comprehensive Trade Statistics
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The Comparative Liquidity For ISINs
Physical Risk
Returns Physical Risk Asset Level Data
Business Entity Cross Reference Service (BECRS), Company Intelligence
Returns Ultimateparent Details With Levels Recursively For A Given Company
Panjiva Supply Chain Intelligence
Returns Import And Export Shipment Statistics For A Specified Company And Its Subsidiaries Based On CompanyID, Country, Start Date, And EndDate, Including Imports And Exports Of All 19 Countries
Compustat® Financials
Returns MarketCap For All Compustat GVKeys On A Particular Day
Securities Finance: Short Interest Data
Returns Buyside Instrument Data Over The Last Seven Years
Securities Finance: Short Interest Data
Returns Top Ten US Equity Instruments Ranked By The Percentage Of Outstanding Shares On Loan
Securities Finance: Short Interest Data
Returns All US Equity Instruments Ranked By Active Utilization
Index Data
Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed
Securities Finance: Short Interest Data
Returns All US Equities With A Value On Loan Greater Than One Million
Index Data
Returns Constituents And Weights Using MSCI Daily Index Data Using S&P Capital IQ Index Data Xpressfeed
Securities Finance: Short Interest Data
Returns The Top Ten UK Equities Ranked By Percentage Of Shares Outstanding On Loan
Securities Finance: Short Interest Data
Returns Value On Loan For The Last Three Years
S&P Capital IQ Financials
Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ
Physical Risk: Country, Subnational & Municipal
Returns State Level Municipal Physical Risk Data
S&P Global EU Taxonomy Data
Returns Revenue Level Alignment Metrics For Iberdrola S.A.
S&P Global EU Taxonomy Data
Returns EUT As Reported Data For Iberdrola S.A. For Year 2022
S&P Global EU Taxonomy Data
Returns Companies In France With Eligible Revenue Exposure Percentage Revenue For Manufacturing Sector
S&P Global EU Taxonomy Data
Returns The Total Eligible And Total Aligned Data Split By Revenue For Iberdrola, S.A.
S&P Global EU Taxonomy Data
Returns Sector Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
S&P Global EU Taxonomy Data
Returns The Company Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Physical Risk
Returns Physical Risk Asset Financial Impact Data For Companies For A Forecast Year And Scenario Level Using Dynamic Pivot
Market Data, S&P Capital IQ Estimates
Returns Average TEV/NTM Total Revenue Value For A Company For An Observation Year
Global Events
Earnings Call Analysis
Global Events
Returns Earnings Calls For A Company With Additional Details
Global Events
Returns Speakers Who Were CFOs At That Time For A Companys Conference
Global Events
Display List Of Speakers CFOs For A Company
Global Events
Display After Market Earnings Releases For A Specific Date
Global Events
Returns All Participants In Conferences Announced By A Company
Global Events
Display All Charles Schwab Corporation Board Meetings
Global Events
Returns Earning Calls For A Company
Global Events
Display All Participants In HSBCs Conferences Announced In The Last Three Years
Global Events
Display List Of Earnings Calls For Southwest Airlines
Global Events
Returns Linkage Of Transcripts To Events
EU Sustainable Finance Disclosure Regulation (SFDR)
Returns SFDR Data And EVIC In USD And EUR
Key Developments
Time Series Analysis Of Key Developments
Medium & Heavy Commercial Vehicle Forecast
Production Volume Trend Over Time
Medium & Heavy Commercial Vehicle Forecast
Average Sales Volume By Region
Key Developments
Key Developments With Most Frequent Modifications
Medium & Heavy Commercial Vehicle Forecast
Vehicle Sales Volume By BodyType
Key Developments
Top 5 Event Types By Number Of Changes Within 15 Minutes
Key Developments
Most Active Companies In Key Developments
Medium & Heavy Commercial Vehicle Forecast
Total Sales Volume By GVW Rating
Medium & Heavy Commercial Vehicle Forecast
Vehicle Count By Emission Level
Medium & Heavy Commercial Vehicle Forecast
Average Battery Capacity By Alternative Propulsion System
Medium & Heavy Commercial Vehicle Forecast
Forecasted Versus Actual Production Volumes By Period And Region
Medium & Heavy Commercial Vehicle Forecast
Total Production Powertrain Volume By Country
Medium & Heavy Commercial Vehicle Forecast
Sales Volume By Vehicle And Cab Type
Key Developments
Count Of Dividend Related Key Developments
Key Developments
Key Developments By Event Type In The Last Week
Medium & Heavy Commercial Vehicle Forecast
Year Over Year Sales Growth By Region
Medium & Heavy Commercial Vehicle Forecast
Engine Performance Comparison By Configuration And Aspiration
Medium & Heavy Commercial Vehicle Forecast
Detailed Emission Levels By Vehicle Type And Manufacturer
Medium & Heavy Commercial Vehicle Forecast
Sales Volume By Company
Medium & Heavy Commercial Vehicle Forecast
Alternative Propulsion System Distribution
Medium & Heavy Commercial Vehicle Forecast
Sales Volume Trend By Period
Key Developments
Duration Of Key Developments In Database
Medium & Heavy Commercial Vehicle Forecast
Average Engine Displacement By Manufacturer
Medium & Heavy Commercial Vehicle Forecast
Total Sales Volume By Vehicle Type
Medium & Heavy Commercial Vehicle Forecast
Top 5 Countries By Sales Volume
Key Developments
Impact Analysis Of Executive Changes
Key Developments
Key Developments With Advisor Role Type
Medium & Heavy Commercial Vehicle Forecast
Top Manufacturers By Region And Vehicle Type
Key Developments
Key Developments Announced In The Last Month
Key Developments
Key Developments By Source Type
Credit Analytics
Returns Median PD Fundamentals Country Industry Benchmark Data As Per A Company
Light Vehicle Forecast
Domestic Versus Import Sales Volume Trend For China
Light Vehicle Forecast
Production Volume By Production Type For A Country And Specific Year
Light Vehicle Forecast
Sales By Propulsion System Design For A Specific Country And Year
Light Vehicle Forecast
BEV Market Share By Company For A Specific Year
Light Vehicle Forecast
Global Propulsion System Design Trend Volume
Light Vehicle Forecast
Models With Production Volume By Region For A Specific Quarter And Year
Light Vehicle Forecast
Sales Volume By Global Sales Segment In A Specific Year
Light Vehicle Forecast
Sales Volume Trend Globally
Light Vehicle Forecast
Production Volume Trend Globally
Light Vehicle Forecast
Sales Volume By Country In A Specific Year
Light Vehicle Forecast
Production Volume Trend For A Specific Country
Light Vehicle Forecast
Unique Vehicle Models Sold By A Specific Company In A Specific Year
Light Vehicle Forecast
Production Volume Of Top 10 Assembly Plants For A Specific Year
Light Vehicle Forecast
Production Volume For Sub Segments Globally For A Specific Year
Light Vehicle Forecast
BEV Sales Growth Comparison By Brands In China From 2023 To 2024
Light Vehicle Forecast
Total BEV Sales Volume Trend Globally
Light Vehicle Forecast
Production Volume By Country In A Specific Year
Light Vehicle Forecast
Market Share Percentage By Company For A Specific Year And Country
Light Vehicle Forecast
Total BEV Sales Volume By Country In A Specific Year
Light Vehicle Forecast
Auto Brand Growth Comparison By Country From 2023 To 2024
Light Vehicle Forecast
Sales Volume Trend For Company And Cybertruck By Year