Query Library

This sample query pulls a benchmark for an ETF.

This sample query finds consensus estimates for a company with multiple trading items.

The following sample queries provide ownership summary for a particular company

The following sample SQL query demonstrates how to provide the GICS classifications for each segment associated to a filing date. The sample query below retrieves company information for International Business Machines (companyId 112350). Note: This query uses the GICS package (in the SymbolHelper files) and the S&P Capital IQ Key Documents package

This sample query returns the geographic segment name for a specified Segment ID using the S&P Capital IQ Fundamental in Xpressfeed. NOTE: For reference Not all records from the segment table have records in the segment classification table

The following SQL query displays the order of Items in an Financial Statement. The description corresponding to the reportingTemplateId is provided within the query

The following sample query provides options and warrants add-on display options and warrants data

This sample query pulls historical Assets Under Management (AUM) for an ETF.

This query calculates BETA 5 year value for S&P500 Index of IBM from Compustat

This sample query finds forward / historical estimates on a specific observation date.

The following sample queries provides S&P CreditStats Data For US Public Finance Data for New York in 2022

The following sample query provides price to book values for compustat data.

The following sample queries provides price to earnings for different time periods.

The following sample query provides options data using treasury method calculation

This sample query uses relative constant to limit the estimate period to the forward 3 periods.

This query returns the Last Close Balance Sheet Shares Outstanding (Data Item ID #100053) for IBM for fiscal-year 2014 using the S&P Capital IQ Market Data package in Xpressfeed

The following sample query returns the weight of the constituents in the Energy Sector for the S&P 500.

The following sample query obtains the most current constituents for the S&P 500 index.

The following sample query obtains a constituent list as of a particular date

The following sample query is linking from ICAType to ICATypeID to dataItemId.

The following sample query identifies all the data items delivered to the index packages.

The following sample query returns the current TOPIX 100 INDEX (NEW INDEX SERIES) by selecting attributes.

The following sample SQL query demonstrates how to use the ciqSymbol table to retrieve company information by a different identifier. The sample query below retrieves company information for Sony Corporation

The following sample query constructs the TOPIX index market cap.

The following sample query returns ciqGvkeyIID linking for the current S&P 1200 constituents.

The following sample query returns the available TOPIX security identifiers.

The following sample SQL query demonstrates how to view the latest annual business segment financials for International Business Machines Corp. (in the reported currency)., Note: This sample query includes data from all Segment Add-On packages and loads into ciqFinCollectionDataLatest table for Snowflake

This following sample query returns all firms with specific investment allocation such as ESG and alternatives

This following sample query returns all firms using a specific provider type such as consultant based on provider name

This following sample query returns all firms using a specific manager by Name and/or managed allocation.

This following sample query returns all firms in specific geographical region with assets greater than or equal to specific AUM

This query returns all of the available FormTypes in Xpressfeed for a particular finanacialPeriodId

The following sample SQL query pulls data for COMEX High Grade Copper, United States, Spot Price

The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For North America

The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For Global Coverage

The following sample SQL query searches Data items by various items (mnemonics, banks, labels, frequency, series types, geography)

The following sample SQL query provides CIQ Legacy IHS Macroecon Mnemonics-to-TimeseriesId mapping

This query can be used to validate differences for the same periods that may occur when a company has a fiscal-year change with details for Calculated vs. Reported periods and the number of months covered

The following sample SQL query calculates monthly average with daily frequency data for US treasury 10-Year constant maturities

The following sample query below retrieves from and thru dates for each fiscalChainSeriesId change, including when the Id changes back to a previous fiscalChainSeriesId (i.e., Morgan Stanley 472898). Note: The FiscalYear value in the Quarterly table is just the year of the periodEndDate and not not perfectly align with all companies

This following sample query provides State level branch stats.

The following sample query provides the ability to look up branch service values .

This following sample query provides MSA level branch stats.

The following sample query returns constituents, float shares, weight, and price for a specific index on a specific date with from and thru dates.

This following sample query links the SNL institutionId to the S&P Capital IQ companyId.

This following sample query links the SNL institutionId to the Compustat GVKEY.

Calculates a quarterly time series of TEV/EBITDA by joining pricing date to period end date

This following sample query provides Federal market level branch stats.

This following sample query provides city level branch stats.

This following sample query provides branch deposit data with address. Please note that branch ownership history is available from July 1, 2001.

The following sample query provides aggregated data for deposits and branches by institution in a state.

The following Query Passes DataitamDescription and returns parent and child DataitemIDs Hierarchy

The overall main goal of this query is mapping listing level SEDOLs to CIQ Market Data.

The following query finds all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.

The following query finds all securities issued by a company and display the S&P Global Ratings.

This query returns the S&P Capital IQ annual financials data for a company restated for the latest fiscal-year change (FiscalChainSeriesId) in Xpressfeed. The fiscal year used are 1994 , 1995 , 1996 , 2008 , 2009

The following sample SQL query returns Question Description and Survey Level Data for Question 'Biodiversity Commitment' in 2022 Assessment

The output of the query provides the total debt and total EBIT (Earnings Before Interest and Taxes) annually for each year, along with the calculated percentage of total debt to total EBIT. The calculation excludes all rows with nulls in either of the following columns: b.dltt, b.dlc, and b.ebit. The query does EXCLUDE corporations NOT incorporated in the United States of America (USA). Finally, we also EXCLUDED Financials Services Firms and Banks incorporated in the USA.

The following sample query returns List of Research Report Filings in 2022 with Broker, Analyst and Target Company Name

This query pulls the BETA value for IBM (Current Period) from the CIQ tables in Xpressfeed. Note: Here the ticker symbol is used to identify the company. Beta is only pre-calculated for a company's fiscal period end dates. To calculate a daily Beta, one needs to use the S&P Capital IQ Market Data tables and perform the necessary calculation

The following sample SQL query returns all the timeseriesIDs that are overlapping across different packages.

The following sample SQL query demonstrates the global employment index values across various private sectors such as Banking, Beverages and Food, Metals and Mining, Pharaceuticals and BioTechnology, Real estate, Technology, Tourism and Transportation.

The following sample SQL query counts number of times the dataitemvalue has gone up/down/no change for each analyst on the given input companyid.

The following sample SQL query returns takes a parent company (Apple Inc.) and displays its top three countries with respect to the count of customers of a company for Business Relationships dataset.

The following sample SQL query takes a parent company (Apple Inc.) and displays its current Business Relationships.

The following sample SQL query displays basic balance sheet items for a single company for the most recent four quarterly periods

The following sample query returns risk of inflation for Europe vs Asia/Pacific since the last year.

The following sample query returns outlook and risk scores for US sub-aggregate categories in the last 180 days.

The following sample query returns risk categories for US where the outlook is Up post the current year.

This following sample query Searches for all contacts of Family Offices firm for Cazenove Capital Management Limited.

This following sample query Lists all Family Offices firms where Charles Schwab is Custodian.

The following query provides detailed pricing information for a specific leveraged loan facility as of a certain date ("ASOF" stands for "As of Date"), along with static data information related to leveraged loan facilities associated.

The following query provides insights into the liquidity metrics, such as the number and size of dealer quotes, for leveraged loan facilities as of a designated date, along with static data information related to leveraged loan facilities, aiding in liquidity analysis , risk management and building of security master.

The following query retrieves the close bid-offer prices for loan facilities as of a specific date, enabling the end user to assess market conditions, risk, and liquidity for that date for better portfolio management and to be able to mark their books where applicable.

This following sample query returns the total number of operating and operating subsidiary companies grouped by simple industry description and company type

This following sample query returns the total number of companies with market cap greater than usd 25 million grouped by the year ranges and region the primary ttd is trading at

For the fiscal year of 2021, here are the Top 50 companies on the basis of ecosystem footprint.

For Toyota Motors, in fiscal year 2021, here are the assets with overlapping Key Biodiversity area(s) and Key Protected area(s).

The following sample SQL query returns trading item counts by industry for Short Squeeze Data.

The following sample SQL query returns short position profit concentration for a company(here Netflix Inc.).

The following sample SQL query displays global coverage by ISO Country of unqiue trading item IDs since 2011.

The following sample SQL query returns aggregate weighted PnL, PnL daily maximum and PnL daily minimum for a company(here Netflix Inc.).

This query returns the data values, restatement types, and filing dates of the different sources for Earnings from Continuing Operations (dataItem Id = 7) from the S&P Capital IQ Premium Fundamentals

The following sample SQL query provides the style Ids and style names associated with each factor.

The following sample SQL query retrieves global monthly universe population for each global universe in Alpha Factor Library.

The following sample SQL query retrieves count of securities by style by year.

The following sample SQL query retrieves count of securities by relative factor by year.

The following sample SQL query ranks companies in the EMEA region by ROE factor.

The following sample SQL query retrieves the total number of tradingItemIDs covered by style using daily international data.

Returns Companies With An Involvement In The Screen Military Contracting For FY 2021

Returns All Involvements (Screening Lists) Of A Specific Company (KI - 4000193) For The Latest FY

Returns All Companies With A Specific Revenue Range Or Ownership Range In A Screen For The Latest FY (i.e. more than 10% revenues from Alcohol screens under group name - Consumer Product & Services)

Standard interest rates for 30-year fixed mortgages at Citibank, N.A. branches in California.

This query shows the 30-year fixed mortgage rates at Citibank NA branches in New York, within the specified date range.

This query displays the product rates of banks in Nassau County, New York, as of a specific date.

The following sample query returns sustainability data for the Leed and Energy Star certification year of 2020.

The following sample query returns active liens filed in Mississippi.

This query presents the monthly sales trends of Tesla Model 3 for the year 2023.

This query calculates the total revenue for each model, for the year 2023.

The following sample SQL query returns commitment level data(interims) for British American Tobacco company (SBTI commitment to set net zero target).

These queries calculate the year-over-year growth in sales for automotive makes for the year 2023 compared to 2022. Sales are only considered if they are greater in 2023 than in 2022.

This query calculates the average sales volume per company for the year 2023, ranking the top 10 best selling vehicle makes.

This query provides a detailed overview of vehicle make features and types for the year 2023.

This query aggregates the total sales volume by country for the year 2023.

PIVOTING Premium Financials for a few specific items for a set CompanyID , for a set Calendar Year. LatestPeriodFinancialFlag=1

The query calculates the market share of different vehicle models in Greece for the year 2023.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample query returns specific S&P Capital IQ financial data items by either ticker or company ID. Note: In this sample query, the ticker symbol for Amazon (AMZN) is used. If you wish to query by company ID, you can uncomment c.companyId

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This sample query displays North American Industry Classification System (NAICS) codes for the designated segment id using the S&P Capital IQ data tables in Xpressfeed

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample SQL query returns GDP Weighted US Exposure Score greater than or equal to 50 to Pluvial Flood Hazard of Counties in Michigan for Scenario Level High and Forecast Years 2030, 2040 and 2050.

This following sample query returns company tree with entity relationships and its associated ratings

This following sample query returns all the exchangeCodes for the mmdentityids using pivot

The following query shows how to retrieve all articleIds and all published Scores And Factors for all Sovereigns with Article Primary Entity.

This query provides the annual trend of global sales volumes for Battery Electric Vehicles (BEVs), highlighting the growth over the years.

The query displays the sales volume by global sales segment for the year 2023.

This query outlines the sales volume for different types of propulsion systems in China for the year 2023.

This query lists the top 10 assembly plants by production volume in 2023.

This query illustrates the global sales volume trends for different propulsion systems across years.

The following sample SQL query returns Year on Year average exchange rates for all countries.

This query returns the lowest, highest, average, and total daily trading volume including the number of trading days for Microsoft during 2002

This query identifies the most current datadate for multiple companies where quarterly financial data is available in Xpressfeed

This query returns quarterly Fair Value Asset Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159

This query returns the Open Price (PRCOD) for the constituents of the S&P 500 Index for December 1, 2016 in Xpressfeed

This query counts the number of companies from Popsrc D that went inactive in 2007. Note: Remove co_adesind.popsrc = 'D' to count he number of companies from the entire global ", database that went inactive in 2007

This query returns non MSCI indices with constituents available in Xpressfeed

This query calculates market capitalization for a Global company with multiple issues with fundamental data available

This query returns an Industrial format Income Statement for companies from Korea

This query pulls a list of all of the EXCHGTIER codes and descriptions for each Stock Exchange (EXCHGCD). Note: Uncomment the second query to return all of the companies in the sec_history table that have Stock Exchange Tier (EXCHGTIER) data available

The following sample query selects all constituents of the S&P 500 and their weights as of July 14th, 2010.

The following sample query returns other TOPIX security identifiers.

The following sample query returns the dividends for the constituents of the S&P 500 on the observation date.

The following sample query returns current TOPIX 100 INDEX (NEW INDEX SERIES) by linking.

The following sample query creates a time series of index values for the S&P 500.

The following sample query is retrieving Russell ICB Financials Industry Cascade for the Russell 3000 Index.

This query returns a data item in the reported currency and translated into a target currency using the S&P Capital IQ Premium Financials packages and the v2 Exchange packages in Xpressfeed: NOTE:Displays item from S&P Capital IQ Premium Financials package in reported currency and same item translated to target currency

This following sample query returns all firms for all contacts with emails

The following sample SQL query returns licensed content which is subscribed by the User

The following query returns share buyback data for US corporates for the last 10 years.

The following sample query returns all the sector indices that make up the S&P 500.

This following sample query provides county level branch stats.

The following sample query provides aggregated data for deposits and branches by institution in an MSA.

The following sample query provides aggregated data for deposits and branches by institution in a federal market.

The following sample query provides aggregated data for deposits and branches by institution in a county.

This query returns the data values reported in the original filings for a single data item for a company. Note: Here Sony is the company name and the period type is annual and restatement type is original

The following query pulls numerous SNL Data Items and displays them in a singular row.

The resulting query is a PIT ratio that provides a measure of how efficiently a company is generating cash flow in relation to its total assets.

The following sample SQL query returns Fact Level Company Response to Question 'Employee Turnover Rate' for Walmart Inc. in 2022 Assessment

The following sample SQL query returns Disclosure Analysis Data for Companies in 'Health Care' Sector in 2022 Assessment

The following sample query returns Number of Company Report filings by country in 2022

The following sample query returns Number of Company Report filings in the S&P500 universe by Industry Sector over the last five years

The Following Sample Query Provides platform representation of CIQ Latest Financials(Annual) via Xpressfeed Data.

The Following Sample Query Provides platform representation of CIQ Premium Financials(Annual) via Xpressfeed Data.

The following sample SQL query returns the subscribed Data Packages and the count of available TimeseriesIDs

The following sample SQL query demonstrates two PMI observation data, Global Manufacturing PMI - Backlog of Work Index and Global Manufacturing PMI - New Orders - classic supply and demand model.

The following sample SQL query returns current distributors/customers for a supplier company(Apple Inc.) from the CIQ Business Relationships tables.

The following sample SQL query finds count of unique companies in Business Relationships dataset for each Business Relationship Source Type.

The following sample SQL query returns total number of companies per region included in the Business Relationships Dataset.

The following sample query returns all the distinct risk categories including aggregates and sub-aggregates.

The following sample SQL query demonstrates how to view as reported details for IBMs FY 2009 debt capital structure. Note: This query is for the Debt Capital Structure Add-On delivered via a separate package

The following query provides the suggested changes or updates related to specific leveraged loan facilities, accompanied by foundational industry identifiers, to assist in keeping portfolio management, risk assessment, and trading strategies up-to-date.

The following query provides the targeted pricing and liquidity data for a specific batch of leveraged loan facilities as of a given date, along with associated liquidity metrics and industry identifiers to aid in market analysis, risk management, and trading decisions.

The following query provides the foundational industry identifiers and organizational information related to specific leveraged loan facilities, offering context but not necessarily detailed pricing or liquidity data, useful for general portfolio management and initial market analysis.

This following sample query returns the total number of operating and operating subsidiary companies grouped by the 4th level primary industry classification and company type

The following example demonstrates how to build a time series using filing dates. The sample query below retrieves one data item, quarterly cost of goods sold, for Anadarko Petroleum Corp (GVKEY 011923) that will be presented in a time series

This sample query uses observationDate,currencyCode,periodtypeid and companyIDs to give data items like AP, Total Revenue, Net Income, Net Income Margin, ROE, Return Assets, Non Performing Loans, Total Capital Ratio, Current Ratio, Quick Ratio and Total Assets.

The following sample SQL query displays the transaction level securities finance data with event indicators to provide insights into predicting short squeeze events for all companies.

The following sample SQL query returns Short Squeeze Comp Score and Daily Close Price for a company(here Netflix Inc.).

The following sample SQL query displays the distribution of a stock’s short loan position profit/loss based on a predefined set of bins for all companies.

The following sample SQL query retrieves the total number of factors by style using daily international data.

The following sample SQL query retrieves universe population for each universe in Alpha Factor Library.

This query provides the count of distinct analysts participating in Apple Inc.'s earnings calls during the fourth fiscal quarter, grouped by the company ID and the specific quarter in the fiscal year.

The query below displays the 30-year fixed mortgage rates offered by Citibank NA branches in New York, covering a specific date range.

The following query provides the average bank product rates as of a specific date.

The following sample query returns mortgages expiring within 6 months in Texas.

The following sample query returns the datacenter list for a selected period.

The following sample query returns values from the Datacenter Knowledgebase aggregated by 451 Market for a selected period.

This query assesses the accuracy of fuel data for each model by calculating the percentage of estimates versus actual data in 2023.

The following sample SQL query returns net zero pathway for British American Tobacco company (SBTI commitment to set net zero target).

This query provides the capital expenditures (Capex) for approximately 26,000 companies, each identified by their companyID, with the latest segment financial data, and then categorizes these expenditures according to the Global Industry Classification Standard (GICS) code.

This query calculates the weighted average MSRP for each vehicle make in 2023.

This query analyzes the average seasonality and total sales by year and ISO country code for the year 2023.

This query calculates the total revenue and weighted average MSRP for each company in the year 2023.

This query aggregates sales volume by propulsion system for the year 2023.

This query evaluates AutoCompanies in 2023 by comparing their total revenue and average Manufacturer's Suggested Retail Price (MSRP) per model sold.

This query calculates the total sales volume for each vehicle make's subsegment in 2023.

This query provides insights into the Battery Electric Vehicle (BEV) market in 2023 by segment and subsegment, using the sales volumes and market share percentages to highlight the impact and penetration of BEVs in the automotive market.

The following query retrieves the Latest Instance for the Current Financial Period for the specific income statement items for Nestle S.A

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This query returns the most recent annual geographic or business segment data in the reported currency for a company from the S&P Capital IQ Fundamental data in Xpressfeed

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This query compares the number of companies with annual filings to the number of companies with quarterly filings for a specific year by country using the S&P Capital IQ files in Xpressfeed. Note: Comparing the results between countries in the two lists shows you an approximation of countries that have a high percentage of companies that file quarterly reports

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample SQL query returns Issue Level Municipal Physical Risk Data for Fixed Income Securities(GO/Municipal Debt) for Issuer - Wayne County, Michigan, for Pluvial Flood, Forecast Year 2050 and Scenario Level High.

This following sample query returns the industry hierarchy for a selected company

This query shows the yearly production volume trend for China.

This query calculates semi-annual cash flow from operating activities (OANCFY) for international companies

This query finds Master Limited Partnerships (MLP) using Compustat data in Xpressfeed

This query returns the Income Statement (IS) balancing model for broker companies in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for broker companies in Xpressfeed

This query returns the constituents of the SP/Barra 500 Growth as of July 29, 2005

This query calculates the frequency of dividends paid during a calendar year in Xpressfeed

This query returns Total Assets for Aetnas financial services format as of 12/31/2009

This query search to return only SPDRs in Xpressfeed

This query calculates dividend yield for IBM as of December 31, 2007 based on Indicated Annual Dividend Rate - Monthly (DVRATE) and Price-Close Monthly (PRCCM)

This query calculates Debt-to-Equity (aka Risk, Gearing or Leverage) ratio annually. Note:Uncomment the second query to return Debt-To-Equity Ratio for quarterly basis

This query returns a true or false based on how many records exist in the Snapshot North America database for COGSQ for IBM:

The following sample query returns all the data available for the REIT Index in Xpresfeed

This query returns the most recent value for Total Return Factor - Daily (TRFD) using the Compustat database in Xpressfeed. Note:Uncomment the second query to return TRFD for a specific datadate

This calculates the Daily Total Returns for IBMs primary issue (GVKEY = 006066, IID = 01) for three time periods:Note: The 1-year return (TRT1Y) is calculated over the period from March 6, 2012 thru March 6, 2013. The 3-year return (TRT3Y) is calculated over the period from March 4, 2010 thru March 6, 2013. The 5-year return (TRT5Y) is calculated over the period from March 4, 2008 thru March 6, 2013

This query provides the daily close price (PRCCD), adjustment factor (AJEXDI), and common shares outstanding (CSHOC) for a security over a specified date range

This query returns the current ratio quarterly for IBM for the quarter ended March 31, 2008

This query returns all reported product lines for Georgia Pacific as of December 31, 2002

This query subtract the number of companies with market data that also have an annual descriptor record indicating the availability of fundamental data, and returns the number of companies with market data only

This query approximates Common Equity - Tangible (CEQT) on a quarterly basis using a particular gvkey and date

This query returns the company-level notes for a company after a specific data date

This query retrieves detailed information on earnings calls for a specific company. Note: The Global Events Plus package is required to run this query.

This query returns all participants in conferences announced by HSBC Holdings in the last three years. Note: The Global Events Plus package is required to run this query.

This query returns a list of speakers who were CFOs at the time for a specific company in 2016. Note: The Global Events Plus package is required to run this query.

This query lists all board meetings of Charles Schwab Corporation. Note: The Global Events Plus package is required to run this query.

This sample query returns average TEV/NTM Total Revenue Value for a company for an observation year.

This following sample query returns total eligible and total aligned data split by revenue for iberdrola, S.A.

This following sample query returns companies in france with eligible revenue exposure Percentage Revenue for manufacturing sector

This following sample query returns revenue level alignment metrics for Iberdrola, S.A.

This query returns all companies that have issued more than 10 securities

Returns constituents AND weights using MSCI daily index data using S&P Capital IQ index data.

The following sample query returns all US Equities with a value on loan greater than one million.

The following sample query provides market cap for all GVKeysas well as the currency for a given GVKey.

This query returns companies where the ISO Currency Code - Annual is different from the ISO Currency Code - Quarterly for the same year

This query identifies quarterly periods that have an AG footnote on Assets-Total - Quarterly (ATQ) in Xpressfeed

This query returns the liqudity average, per ISIN, for 30, 60, and 90 days.

The following sample query returns comparison two countries Portugal and Spain population % exposure to extreme heat for forecast year 2024 and scenario level 'High'.

The following sample query returns physical risk gdp exposed metric for all US geographies for coastal flood, forecast year 2050 and scenario level 'High'.

The following query finds all security identifiers for a particular company.

The following sample SQL query returns Disclosure Analysis Data for Walmart Inc. in 2022 Assessment

The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication

The following sample SQL query demonstrates difference between Input Price (cost of materials) and Output Price (sales price) is the profit margin., High input price + high output price indicates inflationary trend, where high input price + low output price indicates softening demand in the inflationary condition., Quartile distribution visualizes which economies are in what profit margin condition.

The following sample SQL query demonstrates the comparable Copper input price index for geographical regions Europe and Asia.

The following sample SQL query returns takes a parent company (Apple Inc.) and displays its top five current customers with respect to the marketcap for Business Relationships dataset.

The following sample SQL query takes a parent company (Apple Inc.) and displays its current strategic alliances.

The following sample SQL query takes a parent company (Apple Inc., IBM and Samsung) and displays the count for each of its current business relationships.

The following sample query Returns Countries and their categories that fall in the extremely risky band in the last 90 days.

The following query provides the suggested changes or updates related to leveraged loan facilities, accompanied by industry identifiers (lxids), to assist in portfolio management, risk assessment, and trading strategies up-to-date.

The following sample SQL query demonstrates how to view the latest annual business segment financials for International Business Machines Corp. (in the reported currency). Note: This sample query includes data from all Segment Add-On packages: the Segment Financial Data Add-On package (loads into ciqFinCollectionData table), the Segment Financials Add-On, and the Segment Profiles Add-On

The following query retrieves the evaluated market price of a loan facility/ies for a specified date ("asof"), along with relevant analytics and liquidity metrics, for risk management, trading decisions, or portfolio strategy.

This following sample query returns the total number of operating and operating subsidiary companies according to their number of employees grouped by region

This following sample query returns the total number of companies with market Cap Greater than usd 25 million in the database grouped by the region the primary ttd is trading at

The following sample SQL query returns topic tags and keywords for IBM.

The following sample SQL query displays a time series for a single data item for a company

For Toyota Motors, in the fiscal year of 2021, here are the top 10 assets owned by the company on the basis of ecosystem footprint.

The following sample SQL query returns Short Squeeze Comp Score and Maximum OTM Across 20 days, with Positive Market Sentiment Events Score for a company(here Netflix Inc.).

The following sample query below retrieves one data item, quarterly total revenue, for Abbott Laboratories (Ticker ABT) that is presented in a time series

The following sample SQL query change through time of company types ranked in short squeeze score.

This query returns a list of reported GAAP names (related to Financial Statement Accounting Standard)

The following sample SQL query provides the identifier and name of the relative factor.

The following sample SQL query retrieves North America monthly universe population for each North America universe in Alpha Factor Library.

The following sample SQL query retrieves North America daily universe population for each North America universe in Alpha Factor Library.

The following sample SQL query retrieves count of securities by style by year.

The following sample SQL query retrieves base and historical relative factor data for a North America based company(Here IBM).

The following sample SQL query returns sustainable Investment Data for Walmart Inc.

This query identifies the top 10 banks in California offering the most competitive 30-year fixed mortgage rates

This query selects distinct vehicle makes. The results are ordered alphabetically by the make of the vehicle.

This query returns records from the S&P Capital IQ Fundamentals with a filing date of Mar-30-2018

This query lists the top 5 vehicle makes in the United States, by sales volume in 2023.

This query assesses the growth rate of AutoCompanies by comparing their sales in the current year (2023) against the previous year (2022).

This query summarizes the total sales of each car model in 2023, ranked from highest to lowest sales.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample query retrieves a specific company's business segment revenue for a specific period end date, along with the primary NAIC classification and primary SIC classification

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This sample query returns the latest annual financials data for 500 companies for a filing date on or before the given observation date. Note: The population of 500 companies is generated using a TOP 500 in a select statement

The following query shows how to retrieve articleIds, the associated entity, and publication dates where the entity is tagged as the primary entity.

This following sample query returns SFDR data and EVIC in USD and EUR for a given company.

This query shows the total global production volume for each year.

This query shows the total global production volume for each sales sub-segment in 2023.

This query provides the total production volume for China in the year 2024.

This query lists the models with the highest production volume in Europe for the fourth quarter of 2023.

This query compares the sales growth of BEV brands in China between the years 2023 and 2024.

The query compares the growth of different auto brands in China between the years 2023 and 2024.

This query identifies the year-over-year sales growth for each region.

This query calculates the total sales volume for each vehicle type.

This query calculates the total production powertrain volume of commercial vehicles by country.

This query identifies the top manufacturers in each region by vehicle type and production powertrain volume.

This query calculates the total sales volume for each company.

This query compares the performance of engines based on their configuration and aspiration.

This query calculates the average engine displacement by manufacturer.

This query retrieves the distribution of different alternative propulsion systems by their Design Parent.

This query returns When Issued stocks in Xpressfeed

The following sample query below retrieves Total return calculation for company INTL BUSINESS MACHINES CORP (006066). /

This query returns Debt in Current Liabilities (DLC), Debt-Total Long Term (DLTT), and the sum of both items to calculate the Total Debt for IBM as of 12/31/2007

This query returns the identifiers and the exchanges that were active for each issue during specified times

This query return Real Estate Investment Trust (REIT) companies by searching for companies with a Standard Industrial Classification (SIC) code of 6798 or a Global Industry Classification Standard (GICS) Industry code of 404020 in the company table in Xpressfeed.(Uncomment the second query to get GICS)

This query returns the transparency calculations of Cost of Goods Sold - Quarterly (COGSQ) on one datadate using the Compustat Transparency data in Xpressfeed

This query returns Quarterly Income Statement (IS) balancing model for banks in Xpressfeed. Note: Uncomment the second query to return the Quarterly Balance Sheet balancing model for banks in Xpressfeed

This calculates Enterprise Value on a quarterly basis for IBM in Xpressfeed

This query returns pure Canadian companies by searching for companies with IID ending with C and Stock Exchange Code (EXCHG) = 7-10 to represent the Canadian exchanges, which are both from the Security table, and Country of Incorporation (FIC) = CAN (Canada) from the Company table

This query returns the Primary Issue for a company in the Global database for a specific from and thru date

This formula calculates the price-to-book ratio, also called market-to-book, for American Depository Receipts (ADRs) (PRCCMCSHOC/ADRRC)/CEQQ Note:This query returns the price-to-book ratio for Loreal - ADR in Xpressfeed

This query returns Price-Close Daily for IBMs domestic issue for March 18, 2004

This query returns Price-to-Earnings ratio (PE), Price-to-Book (Book Value per Share) , and Price-to-Sales (Price/Sales) for the S&P 500 Index in Xpressfeed

This query returns the one-year price history for the S&P 500 Index from June 3, 2003 through June 2, 2004

This query returns the GVKEYs and the Company Names for U.S. and Canadian companies with fundamental data. Note:To get fundamental data for active companies use: WHERE ( A.costat = A ), To get fundamental data for inactive companies use: WHERE ( A.costat = I ). To get the number of active and inactive Canadian companies with fundamental data available for the 2012 fiscal year use: AND ( b.datadate = 6/30/2012 AND b.datadate = 5/31/2013 )

This query returns the number of companies that have finalized data by month

This query returns the number of companies on the NYSE that have a value for Trading Volume - Monthly (CSHTRM) value on January 31, 2011

This query returns all companies that are not actively trading on any exchange, but are still active

This query is used to screen Xpressfeed for closed-end funds only, search for SIC code of 6726, Issue Type (TPCI) of 7 (Mutual or investment trust fund), and Net Asset Value (NAVM) is a value

This query returns all international companies and their auditors on a specific datadate

This query returns the Long-Term Debt to Shareholders Equity for companies on a specific datadate using the Compustat packages in Xpressfeed. Note:This query replicates the Long-Term Debt/Shareholders Equity (DSE) concept in Research Insight

This query returns the Long-Term Debt to Common Equity ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Long-Term Debt/Common Equity (DCE) concept in Research Insight

This query returns the Income Statement (IS) balancing model for Real Estate Investment Trusts (REITs) in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for REITs in Xpressfeed

This query returns the Income Statement (IS) balancing model for banks in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for banks in Xpressfeed

These queries return all indices with constituent markers including the start date for when the first constituents are available for each respective index

Query the Xpressfeed database on the data item I/B/E/S Recommendations Consensus (IBRECON). This item is located in the ibwrecom data group. This item is the mean recommendation consensus. It is also helpful to pull in I/B/E/S Number of Recommendations (IBNOREC) from the same table because it gives more meaning to the mean recommendation. The possible recommendations are:1- Strong Buy2- Buy3- Hold4- Underperform5- Sell SQL Query:

This query returns the Compustat historic company tickers from the Corporate Tracker package in Xpressfeed

This query returns the Fortune 1000 companies by rank as of a given year in Xpressfeed. Note: Uncomment the second query to return the Fortune 500 companies by rank as of a given year in Xpressfeed

This query displays available footnotes for Quarterly Income Statement data for the specified GVKEY for the specified quarter

This query finds changes to the ISO Country Code - Incorporation (FIC) in the last 20 years using the cscompany table in North America Snapshot

This query returns securities described as Exchangeable Shares in Xpressfeed using the term EXCH in the Security Description (DSCI) data item from the security data group

This query finds multiple company names that exist for more than one distinct GVKEY in Xpressfeed

This query returns all companies that have both an a U.S. security listing (IID of 01) and a non-U.S. security listing (IID of 01C), meaning they are double-followed Canadian companies

This query returns GVKEYs and IID with a Par Value and the associated Exchange Country

This query returns the Global Industry Classification Standard (GICS) Sector, GICS Description (GICDESC), International Organization for Standardization (ISO) Currency Code (CURCD), Revenue -Total (REVT) displayed in U.S. Dollars (USD), USD Translation Rate, and the 12-month moving Average Exchange Rate (EXRAT12M) for all European companies in Xpressfeed

This query returns the daily exchange rate to translate Hong Kong Dollars (HKD) to U.S. Dollars (USD) since inception

This query calculates the daily total return and daily price return for the S&P 500 Index from the current date, as far back as data is available for Index Value - Total Return - Dividends (PRCCDDIV) and Index Value - Price (PRCCD):

This query returns all customer names and customer sales for Apple as of September 30, 2017 using Compustat Segment data in Xpressfeed

This query returns all of the data items from the security table for issues of stock classified as Special Stock (TPCI = Q) in Xpressfeed

This query returns U.S. holidays in Xpressfeed

This query returns a list of the banks included in the Xpressfeed database population and removes duplicate names

This query returns details of conference speakers who were CFOs at the time for a specific company in 2023. Note: The Global Events Plus package is required to run this query.

This query returns companies without common or ordinary stock, but with preferred shares in Xpressfeed

The following sample query returns earnings calls for a company using specific keywords. Note: The Global Events Plus package is required to run this query.

This query returns an analysis of the number of distinct analysts who asked questions during Apple's quarterly earnings call. Note: The Global Events Plus package is required to run this query.

This query lists the earnings calls for Southwest Airlines with additional details. Note: The Global Events Plus package is required to run this query.

This query retrieves all participants in HSBC�s conferences announced in the last three years. Note: The Global Events Plus package is required to run this query.

The sample query returns Physical Risk Asset Financial Impact Data for companies(here Tesla Inc) for forecast year as 2050 and scenario level as High.

This following sample query returns sector level EUT independent assessment data for iberdrola, S.A. for latest year

This query returns all companies with multiple issues of stock

This following sample query returns EUT As Reported data for Iberdrola, S.A. for year 2022.

This query returns the Price-to-Earnings (PE) ratio for S&P 500 on an observation date using the S&P Capital IQ Premium Financials packages in Xpressfeed. Note: The Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.

This query returns constituents and weights using MSCI month-end index data using S&P Capital IQ index data.

The following sample query returns Value On Loan for the last three years for BYND.

The following sample query returns the top ten UK Equities ranked by the percentage of shares outstanding on loan.

This query returns all companies that filed an amended 10-K for the fiscal year ending 12/31/2009

This query returns a line for each company and time period when the company reports a Cash Flow Statement using the Direct Method

Returns shipment data for a specified company and its subsidiaries based on company ID, country, start date, and end date, including imports and exports of all 19 countries

This query returns all of the companies trading pink sheets or OTC

Companies that have adopted International Financial Reporting Standards (IFRS) can be identified by an AN or AN-combination footnote on the Comparability Status item (COMPTS). This query returns companies that adopted IFRS indicated by an AN or AN-combination footnote in COMPST preceded by a DS footnote

This query returns companies who adopted SFAS 158 by looking for an AC footnote on Pension - Funded Status (PCPPAO_FN) from the aco_pnfnta datagroup

This query finds companies in Colorado and displays their City, ZIP/Postal Code, and GICS Sub-Industry Code and description

The following sample query returns subnational level physical risk absolute hazard frequencies for all countries within southeastern asia for forecast year 2050s and scenario level 'High'.

The following sample query returns country level physical risk exposure scores for all countries within southeastern Asia for forecast year 2050s and scenario level 'High'.

The following sample SQL query returns annual broker view revision estimates. For more information on annual broker view revision estimates, please refer to CIQ Pro Template here: https://www.capitaliq.com/CIQDotNet/Estimates/CIQ/Revisions.aspx?stateKey=bf75adc66b3d452db4e5d674787d8524&companyid=112350&dataVendorId=1&accountingStandardId=-1

The following SQL query returns point in time data as per the ObservationDate, the FilingDate where PeriodEndDate will be less than or equal to ObservationDate.

The following sample SQL query provides Licensed Data for US Treasury 10-Year Constant Maturities

The following query returns share buyback data for Europe corporates for the last 10 years.

The following sample query provides zip code level branch stats.

This following sample query provides historical deposits, aggregated at an institution level.

This query returns the data items collected and calculated for S&P Capital IQ Fast Financials in Xpressfeed

The following sample query provides aggregated data for deposits and branches by institution in a city.

The following query finds all trading items for a security.

This sample query pulls the BETA for IBM (Current Period) from Xpressfeed. Note: Here the company ID is used to identify the particular company. Beta is only pre-calculated for a company's fiscal period end dates. To calculate a daily Beta, one needs to use the S&P Capital IQ Market Data tables and perform the necessary calculation

The following sample query returns SFDR data for Walmart Inc. for 2021

The following sample SQL query Returns Concepts and Count Of TimeseriesID For PMI Data.

The following sample SQL query displays basic income statement items for a single company as of a specific period end date for original and all restatement filings

The following sample SQL query returns takes a parent company (Apple Inc.) and displays its current business relationships with their source type.

The following sample query returns security risk worldwide in the last 90 days.

This following sample query returns List all Family Offices firms in United States with assets greater than 1 Bn.

The following query provides the industry identifiers and organizational information related to leveraged loan facilities, offering context but not necessarily detailed pricing or liquidity data, useful for general portfolio management and initial market analysis.

The following query provides current live pricing information for a loan facility/ies as of a particular date ("asof"), to make real time decisions, price discovery, risk assessment, or portfolio management.

The following query obtains liquidity metrics, such as the number of dealers quoting and the average size quoted, for loan facility/ies on a particular date ("asof"), to assess liquidity and make informed trading or risk management decisions.

The following sample SQL query identifies all the topic tags along with keyword combination.

This sample query uses CompanyID, datobserve and currencyCode to give Estimates data items like Net Income Margin CY+0 and Net Income Margin CY+2.

The following query provides the Enterprise Value to Invested Capital for Trucost.

For Toyota Motors, in the fiscal year of 2021, here are the top 3 ecosystem services the company depends upon.

The following sample SQL query displays the transaction level securities finance data for all companies including PnL, OTM (Out-of-the-money) and Transaction Duration used to build the Short Squeeze Model.

The following sample SQL query returns total number of unique trading items per year and the average unique trading items per day by year.

The following sample SQL query returns market sentiment composition score and market sentiment factors for a company(here Netflix Inc.) in a particular region.

The following sample SQL query provides provides the identifiers and details for Alpha Factor Library universes.

The following sample SQL query returns number of factors by relative factor for each year for international companies.

This query returns the primary and secondary GICS mapping per segmentId for a company using the S&P Capital IQ files in Xpressfeed

The following sample SQL query retrieves base and historical relative factor data for a global based company(Here IBM).

The following sample SQL query displays all of the factor idenfifiers and correspdonging names, abbreviations, defintions, and indentifier that are all found within the ciqAfFactor table.

The following sample SQL query displays global coverage by region of data in 2021 by unique TradingItemID.

The following sample SQL query uses the Premium Financials Instance Date package to calculate the average lag for US companies, based on the restatement and form types. The query limits the universe to US, Original 10-Q collection for post 2009 records

Returns All Involvement Data (Facts) Of A Specific Company (KI - 4004205) For The Latest FY

Returns All Data (Facts) Of All Companies With An Involvement In All The Screens Under Healthcare (Abortion, Contraception, Stem Cells) For A FY 2021

This query lists parent banking institutions by the number of banking products they offer.

How many branches does Hanmi Bank have in California, and where are they located?

This sample query returns the most recent consolidated annual financial data for RedcapTour Co., Ltd. (exchangeSymbol = KOSE, tickerSymbol = A038390) in Xpressfeed

This query calculates the weighted average Manufacturer's Suggested Retail Price (MSRP) for each car model in 2023.

These queries analyze the sales and prices of vehicles by their propulsion system for the year 2023.

This query calculates the total revenue for auto companies in the fourth quarter of 2023.

This query ranks the model sales by their propulsion systems in 2023, showing which types of propulsion systems were most popular.

This query identifies the top 5 best selling Toyota models in 2023, showing which models were most popular.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This following sample query returns all the exchangeCodes for the mmdentityids using dynamic pivot

The following query shows how to retrieve all articleIds and all published Scores And Factors for Insurance Companies with Article Primary Entity.

The following query shows how to retrieve all articleIds and all published Scores And Factors for Corporates with Article Primary Entity.

The query lists unique vehicle models sold by a specific companyID (Mercedes-Benz) in the year 2023.

This query displays the total sales volume of Battery Electric Vehicles (BEVs) in China for the year 2023.

The query displays the total global sales volume trend over the years.

The query shows the sales volume trend for the Cybertruck over the years.

The query shows the total sales volume for China in the year 2023.

This query provides the total production volume by production type for China in 2023.

The query calculates the market share percentage of different companies in China for the year 2023.

The query compares domestic versus import sales volume trends for China over the years.

This query shows the market share of various companies in terms of BEV sales for the year 2023.

The following sample query returns latest Median PD Fundamentals Data Item values like total revenue, corporate risk score, return on equity etc. as per a company.

The following sample query returns 7 Day gas trading volume for Chicago trading hub

This query calculates the total sales volume by BodyType.

This query calculates the total sales volume for each Gross Vehicle Weight (GVW) rating.

This query shows the trend of total sales volume over different sales periods.

This query calculates the total sales volume by vehicle and cab type.

This query shows the trend of production powertrain volumes over time.

This query provides detailed emission levels categorized by vehicle type and manufacturer.

This query calculates the average sales volume for each region.

This query calculates the average battery capacity for each alternative propulsion system.

The following sample query returning constituents, weight in the index, and index divisor as of a specific date.

This query returns the Friday prices for each week using the daily pricing data available for IBM iid 01

This query returns the Total Debt to Total Assets ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Total Debt/Total Assets (DAT) concept in Research Insight

This query r returns Structured Products using Compustat tables in Xpressfeed

This query returns a list of all segment items and their descriptions

This query returns selected security detail information for Philippine Telephone

This query calculates Return on Invested Capital (ROIC) for a company using the Compustat packages in Xpressfeed

This query returns the Return on Assets (ROA) for the S&P 500 Index as of December 31, 2016 using the Compustat files in Xpressfeed

This query returns the record count for a specified table for a specified time period

This query returns transparency data for Cost of Goods Sold Quarterly (COGSQ), Net Sales Quarterly (SALEQ), and Selling, General, and Administrative Expenses Quarterly (XSGAQ) for Wells Fargo Co (WFC) at September 30, 2007 in Xpressfeed

This query returns quarterly Fair Value Liability Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159

This query returns both the static and dynamic quarterly transparency for a GVKEY on a specific datadate

This query finds pro-forma companies using the Compustat database in Xpressfeed

This query returns the primary and secondary Standard Industrial Classification (SIC) codes for a company in Xpressfeed. Note: Uncomment the second query to return the historical SIC Xpressfeed

This query returns Price-Close Daily (PRCCD) on the day of a companys Initial Public Offering (IPO) in Xpressfeed

This query returns the Company Name (CONM), Global Company Key (GVKEY), and Security Description (DSCI) for pre-FASB companies in Xpressfeed

This query returns the companies with public debt in the Compustat population in Xpressfeed

This query returns all operating segments for ALLIS-CHALMERS ENERGY INC as of 12/31/2007 _ /

This query identifies Non-Voting Depositary Receipts (NVDRs) by returning all issues with NVDR in the Security Description (DSCI) in Xpressfeed

This query returns the number of securities issued per company

This query returns the number of companies that have a value for SALE in the co_afnd2 table in Xpressfeed Note: Uncomment the second query to get the number of securities per DATADATE in the sec_dprc table in Xpressfeed

This query counts the number of final updates for Y07 fiscal-year domestic industrial companies as of 5/21/08:

This query returns the number of companies in Great Britain that report semi-annual data for the period ending June 30, 2006. Note: For Annual Data there is no need for any 'AND co_idesind.rp = ' condition

This query returns the number of companies in the co_adesind data group

This query returns the Standard Industrial Classification Code - Segment (SICS) and North American Industry Classification Code - Segment (NAICSS) for a companys segments

This query returns the 3-Month Total Return for McGraw-Hill Financial (GVKEY: 007163) using monthly pricing from December 13, 2006 to March 31, 2007

This query returns the Market Identifier Code (MIC) and the Stock Exchange Code (EXCHG) for all of a companys equity listings in Xpressfeed

This query returns quarterly transparency for Level 3 assets and liabilities in Xpressfeed

This query returns the Income Statement (IS) balancing model for insurance companies in Xpressfeed Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for insurance companies in Xpressfeed

This query returns interim fundamental data for Samsung Electronics Co Ltd. in Xpressfeed

This query returns the Index Name, GVKEY and the first date that price data was available for the Index

This query returns the dates that a company was a constituent of an index along with the name of the index it was a member of

This query calculates Gross Margin on an Annual basis in the Compustat database. Note: Uncomment the second query to get quarterly results

This query finds Global Depository Receipts (GDS) by searching the Issue Description item (DSCI) for GDR and returns all items in the the security data table

This query returns the sales values for each geographic segment for IBM for fiscal year 2010 as a percentage of total sales in Xpressfeed

This query returns the date of the first occurrence of pricing in the database for a security

The economic indicator data does not have its own reference table. In order to access the country names for the ISO codes, link to the r_country table. This query returns a list of country codes

This query determines when Common Shares Outstanding - Current (CSHOC) values change from one day to the next for a company and calculates the difference in those values

This query used to return a date for a specified period of time back from today. Note: Uncomment the second query to return ate one year earlier than another date, where a.datadate is the specified date and -1 is the relative reference

This query returns the Daily Total Return of one issue for a one-year time period using the 1-year return for S&P Global, Inc. from November 1, 2017 to November 1, 2018 in this example

This query returns the details of the Comparable Sales (%) - Quarterly for a company in Xpressfeed

This query returns companies on the TSX Venture Exchange OR the Toronto Stock Exchange (TSX)

This query provides an indication how liquidity is evolving, per ISIN(s).

This query identifies the top five markets for electrified models in 2023, focusing on electric propulsion systems.

This query provides a sales overview for each country in 2023, highlighting the countries with the highest vehicle sales.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This query counts the number of vehicles for each emission level.

This query identifies the top 5 countries by total sales volume.

This query compares forecasted and actual production volumes by period and region.

This query returns the Borrowing Rate by dividing Interest Expense by Total Debt multiplied by 100 to return a percentage for IBM for the fiscal-year ending 12/31/2008

This query returns the one-year sales growth for the S&P 500 Index as of December 31, 2016 using the Compustat files in Xpressfeed

This query returns company that have had a final quarterly update over the last two days

This query returns the components of Pension Plan Assets and the Total Plan Assets in Xpressfeed

This query returns the adjusted close price, common shares outstanding current, adjusted common shares outstanding current, ticker symbol, and the market value for members of the STOXX Index on a specific date in Xpressfeed

This query searches for LP as the last 2 letters in the CONM (Company Name) data item from the company data group. Note: Uncomment the second query to find Limited Partnerships by searching for LP in the DSCI (Security Description) data item from the security data group

This query returns the North America Industrial Format (INDFMT = INDL) Income Statement Balancing Model. Uncomment the second query to get the North America Industrial Format (INDFMT = INDL) Balance Sheet Balancing Model. Uncomment the third query to get the North America Industrial Format (INDFMT = INDL) Cash Flow Balancing Model

This query returns all geographic segments and sales for each segment for IBM as of December 31, 2016 using Compustat Segment packages in Xpressfeed

This query calculates the impact of SFAS 158 on Shareholders Equity for years prior to adoption (assuming a statutory tax rate of 35%)

This query identifies companies who have adopted FASB 132 and returns the date of adoption

This query counts the number of occurrences of specific data items for Domestic (POPSRC = D) and International (POPSRC + I)companies in each Industry Format (INDFMT) in the Compustat database in Xpressfeed

This query links transcripts to events for Apple Inc. Note: The Global Events Plus package is required to run this query.

This query displays after-market earnings releases for a specific date. Note: The Global Events Plus package is required to run this query.

This following sample query returns company level EUT independent assessment data for iberdrola, S.A. for latest year

The following sample SQL query returns GDP Exposed metrics for Extreme Heat Hazard for all US states under a Scenario Level High and Forecast Year of 2030.

This query returns the companies with the highest market cap that also had a fiscal-year change using the Compustat packages in Xpressfeed

This query provides trade volume statistics, per ISIN(s), for the past 1, 10, 30, and 90 days.

This query returns the components of the Working Capital changes on the Cash Flow Statement for a company using the Compustat data in Xpressfeed

This query returns Cash Flow per Share for companies using the Compustat packages in Xpressfeed. Note: This query replicates the Cash Flow per Share (CFLPS) concept in Research Insight

For the CURRENT constituents of the major indexes: This example queries the indexcst_his data group to return the current constituents of the S&P 500 Index

This query returns an Industrial Balance Sheet for companies from Korea

This query uses the economic indicator tables in Compustat to retrieve forecast and historical Gross Domestic Product indicators for the United States in Xpressfeed. Note: Uncomment the second query which uses the economic indicator reference table in Compustat to retrieve descriptive information about the Gross Domestic Product indicators for the United States in Xpressfeed

The following sample query provide detailed ownership data for a particular company

The following sample SQL query displays the order of Items in an Income Statement. The description corresponding to the reportingTemplateId is provided within the query

This sample query returns companies that have 5-day revisions changes.

This sample query returns estimates for Sony in USD using currency translation.

The following sample query retrieves capital structure data for Apple Inc.For more information about capital structure data, please refer to the CIQ Pro Template here: https://www.capitaliq.spglobal.com/web/client?auth=inherit#company/capitalStructureDetails?ID=4004205

The following sample query provides price to sales ratio each year.

The following sample query provides price to sales ratio for each quarter.

The following sample query provides Price to Cash flow for compustat data.

The following sample query provides 1 year sales growth for compustat data.

This query returns the GAAP (Generally Accepted Accounting Principles) that a company uses in their financial reporting for a specific period using the S&P Capital IQ Fundamentals packages in Xpressfeed

This query returns Compustat annual transparency notes for Net Sales (SALE), Cost of Goods Sold (COGS), Selling, General and Administrative Expenses (XSGA), Depreciation and Amortization (DP), and Special Items (SPI) for IBM (GVKEY 006066), McCormick Co Inc (GVKEY 007146), and S&P Global, Inc.(GVKEY 007163) for any time periods after November 30, 2016 in Xpressfeed

This query integrates Visible Alpha Estimates with S&P CIQ Base Data, identifying the isocode used for reported financials and converting it to a target isocode.

The query returns earnings surprise for all companies in a business group. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query provides the daily dividends on an adjusted and unadjusted basis

This querypulls the quarterly common shares outstanding (CSHOQ) on an unadjusted and adjusted basis

This SQL query returns current estimates, forward estimates and NTM estimates for the given datapoints as on a given observation date.

This query identifies line items and views that fit specific business models like banking, insurance, or REITs.

This query identifies the business group and industry for a set of company tickers, providing insights into their market positioning. (Note: This query will only work with only the enhanced version of this package; the final data that will be returned is based on your subscription.)

This query identifies the latest consensus data for periods.

This query tracks the sales of iPhone units over time for each model, providing insights into product performance.

This query calculates the earnings per share (EPS) surprise by comparing the latest reported and consensus estimates.

This query provides a time series of consensus data for a specific parameter of a company, showing how estimates have evolved over time.

The following sample SQL query returns latest LTM Total Revenue value along with annual values for a company.

This SQL query returns latest available data for greenhouse gas (GHG) Scope of specific company data identified by their institutions IDs.

This SQL query returns financial metrics such as total assets (ACT), total liabilities (LT), capital expenditures (CAPX), and earnings before interest and taxes (EBIT) for a specific company identified by its GVKEY as of a given observation date.

The following sample query pulls the Common Shares Outstanding - Current (CSHOC) values, include From and To dates (fromDate and toDate), for a company from the Security - Daily Pricing (sec_dprc) table in Xpressfeed

The following sample query returns all Merger / Acquisition activities IBM has been involved with as Buyer or Seller in 2010 (showing company relationships).

The following sample query returns the history for TRFD for a single company (Here INTL BUSINESS MACHINES CORP)

This query returns the most recent Operating Income after Depreciation (OIADP) for the current constituents of the S&P 500 Index

The following sample SQL query returns Net EPS from CIQFinancials and EPS Normalized Consensus Mean, EPS Normalized Consensus Median from CIQEstimates based on MostImportantDateUTC for an event from Keydevs

This query calculates how long each key development remained in the database before being marked as no longer valid. Note: The Key Developments Plus package is required to run this query.

This query counts key developments by their source type. Note: The Key Developments Plus package is required to run this query.

Analyzes the frequency of key developments related to executive changes over the past five years. Note: The Key Developments Plus package is required to run this query.

This query provides a monthly count of key developments for trend analysis. Note: The Key Developments Plus package is required to run this query.

This sample query returns the companies that have defaulted on debt in the last two months.

This query retrieves key developments where the company role type is Advisor. Note: The Key Developments Plus package is required to run this query.

The following sample query returns the market pricing data with carryforward logic based on the specified date range.

The following sample SQL query displays the SP Capital IQ entity Id, name, country, and region, along with the corresponding identifier name and Id in BECRS. It also indicates whether the identifier is flagged as the primary identifier. Note: Top 100000 companies are selected to reduce execution time.

The following sample SQL query returns a one-to-one mapping of the CUSIP6 or CINS6 (CC6) to the Company ID using the BECRS packages. Note: We have used a single companyId for the query to run faster.

The following sample query Returns Point In Time EVIC Data Available As Per The Observation Date for MI Keys

The following sample query calculates the average Common Shares Outstanding (CSHOQ) for the most recent four quarters multiplied by the average price close monthly for the most recent four quarters, creating an average Market Value for the most recent four quarters for a single company.

The following sample query provides return on assets for compustat data.

The following sample query returns the latest Index-based Median Credit Model Score and Implied PD for S&P 500

The following sample query returns fiscal year payments for a company from the given year.

The following SQL query returns industry specific dimension and criteria weights trend for last 5 years.

This sample query allows you to use an entity's ticker symbol to pull style classification characteristics for an ETF

The following sample query calculate CIQ Indices '5 Year Beta' using input parameters CompanyId,ObservationDate, and TradingitemID. Tags - BETA, IQ_BETA_5YR

The following sample SQL query returnsRussell ICB Financials Industry Cascade for the Russell 3000 Index

The following sample query returns Company coverage by Broker and Region in 2022

The following sample query returns time series of trade for a given country pair & HS Code

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample query returns Paris Alignment FTP data for sample companies for 2018 annual report year

The following sample SQL query returns financial metrics and bond ratings with filtering out Muni ratings for an entitys securities using SP Global Ratings packages in Xpressfeed.

The following sample query returns RecordUpdateDate for specific Entity, Instrument And Security Symbol Values along with currentratingsymbol

This following sample query creates a list of the indices available in the current CIQ index package and their associated tradingItemIDs.

The following sample queries returns credit default swaps data for Credit Tranches.

The following sample query returns credit default swaps data for single names.

This SQL query returns historical exchange rates for two currencies and computes a 365-day rolling average to highlight trends.

This sample query assess companies trend over time of absolute carbon emissions, or carbon intensity on a sector- and/or country-level, to determine which companies are driving their emissions down while still growing revenues

The following sample query retrieves funding rounds that took place in the last 6 to 18 months along with detailed monthly headcount information for a company.

The following sample query returns the average tenure per role and department for a particular company.

This sample query identifies the sensitivity scores for S&P 500 companies for year 2019 for seven physical risk indicators

This sample query returns High scenario-based score for forecast year 2030 for top ten S&P 500 companies with most number of assets

This sample query identifies utilities that are poorly positioned in the face of rising carbon prices due to their fossil fuel-heavy energy mix

The following SQL sample query returns volatility, forward curve and dividend yield data on equity index as per a valuation date.

The following SQL sample query returns volatility, forward curve and dividend yield data on equity index as per a valuation date.

The following sample query earnings calls where CEO answers questions using specific keywords using the S&P Capital IQ Transcripts package in Xpressfeed. This example uses earnings calls where Tim Cook answered a question for Apple Inc using the word acquisition.

The following sample query returns earnings calls for a company using specific keywords using the S&P Capital IQ. Transcripts package in Xpressfeed. This example uses earnings calls for Macys / Nordstrom / J.C. Penny using the word weather.

The following sample query returns aggregate count of mentions of a specific keyword, such as weather for this example, during earnings calls for an index by year using the S&P Capital IQ Transcripts package in Xpressfeed.

The following query maps as-reported annual income statement data to our CIQ Financials, ensuring transparency by linking raw reported figures to standardized CIQ formats. It facilitates a clear understanding of how as-reported data translates into our CIQ framework, allowing users to analyze financial information consistently

The following query returns Physical Risk data for a company (here Toyota Motor Corporation) for forecast year as 2050 and scenario level as High.

This query returns all the constituents of the S&P 500 (GVKEYX 000003) from March 31, 1964 thru December 31, 1991 in Xpressfeed

The following sample query returns gross premium written for all insitutions for input european countries.

Returns the filing dates for all 10-K and 10-Q forms filed with the U.S. Securities and Exchange Commission (SEC) for all of the companies that are constituents of the S&P 500 Index between specified start and end dates using the CIQ packages In Xpressfeed

returns the corporate action of a name change for an index constituent company as of a particular date using the S&P Global BMI Index data in Xpressfeed

Returns S&P 500 Index constituents by industry as of a specified date and includes the GVKEY, company name, close divisor, weight, index shares, and share price using the S&P Capital IQ packages in Xpressfeed

The following SQL query tracks Investible Weight Factor (IWF) for Weight Watchers International Inc. effective on 11/02/2015 using S&P Global BMI index data in Xpressfeed

The following sample query displays prior executives found at IBM

The following sample query displays for a given financial year, the top 100 companies with the highest CEO pay ratio, along with company details (company name) and CEO information (name, title, biography) from other S&P Global Capital IQ packages

The following sample request will retrieve the RiskGauge 3.0 Country Benchmark using GDSP, GDSHE and GDST Function for different Benchmark types and pdtype as IQ_RG3_SOV_1YR_PD Note: Please refer to API properties Doc and RG 3.0 release notes for details regarding different properties and functions. API Properties Doc: https://www.support.marketplace.spglobal.com/content/dam/spglobal/mi/en/documents/marketplace/api/reference/api-properties-matrix.pdf RG 3.0 Release Notes: https://www.support.marketplace.spglobal.com/en/api/release-notes/riskgauge-3-0-model-now-available-on-sp-capital-iq-api-june-27-2025

This query returns data related to the CLO (Collateralized Loan Obligation) profile and its monitoring metrics for a specified instrument symbol value, including both current and historical data. For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxclomonitormetrics/ratingsxpress-clo-monitor-metrics-user-guide" target="_blank"><b>CLO Monitoring Metrics</b>

The following sample query returns the Price Return and Total Return values for a company in Local Currency, British Pounds (GBP), U.S. Dollars (USD), and Euros (EUR) for a specified period of time using the Compustat database in Xpressfeed.

This query returns distinct CLO performance distribution metrics for a specified instrument symbol value representing collateral performance, including both current and historical information., For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxsfperformancedata/ratingsxpress-structured-finance-performance-data-user-guide" target="_blank"><b>RatingsXpress Structured Finance Performance</b>

The following sample query calculates Book Value per Share with adjustment factors using the Compustat database in Xpressfeed. NOTE:To calculate a quarterly book value per share: (SEQQ-PSTKQ)/CSHOQ Quarterly Common Shares Outstanding (CSHOQ) should be adjusted by the adjustment factor if looking at historical periods. The calculation is: (SEQQ-PSTKQ)/(CSHOQ*AJEXQ)

The following sample SQL query provides timeseries for ISIN, CUSIP, BRD and Markit ticker history for Input list of companies.

This query returns company specific line items.

The following sample query returns the number of companies per country that have quarterly or semi-annual financials available using the Compustat database in Xpressfeed.

This query retrieves the latest market metrics and instrument details for specified ISINs as of a given date.

This query returns trading item data from Factors Connections, focusing on the 12-month and 6-month moving average ranks, raw ratios, and the 9-month z-score.

This SQL query returns company connections for compustat Gvkey and Iid for a specific date.

This query retrieves the earnings event data for selected companies, showing the last and next earnings dates, relevant headlines, and the days since and until each event.

The following SQL query retrieves Provides historical financial data for a given metric and company, with clear indicators of fiscal year shifts and fiscal chain resolution logic.

This query returns the Free Cash Flow historical estimate data for Hudson Technologies Inc for fiscal years 2016 through 2018 using the S&P Capital IQ Consensus Estimates tables

The following sample query returns emission data for a specific institution ID and associated data items.

This query returns the Data Item IDs mapping the S&P Capital IQ Estimates Actuals to the Surprise using the CIQ Estimates Details package

This query returns S&P Capital IQ Estimates for Natural Gas using S&P Capital IQ Estimates packages

This query returns S&P Capital IQ Estimate contributors for the non-periodic recommendation item ABB Ltd (companyId = 18527) using the S&P Capital IQ, this including the Broker Name and Analyst Name for EPS Normalized (Detailed) for ABB Ltd (companyId = 18527) using the S&P Capital IQ Details Estimates packages

The following sample query returns the probability of default at the state level for a selected business listing.

The following sample query returns whether a company is overly reliant on a few suppliers, which could pose risks in case of disruptions.

The following sample SQL query retrieves the count of CompanyIDs within S&P Capital IQ Latest Financials with non-Null revenue for each Calendar Year and groups them into revenue bands of less than 10 million, between 10 and 50 million, and greater than 50 million. All revenue figures are converted to USD

The following sample query returns the new suppliers or customers entering high-growth markets or emerging industries (e.g., AI, electric vehicles, etc.).

This query returns new customers and HSCodes import data for a specified company based on company ID, start date, and end date.

The following sample SQL query returns low, high, close and average TEV/LTM EBITDA values for a company as per an observation date.

Calculate company-level, aggregated shares outstanding on a particular historical date, incorporating both traded and non-traded shares outstanding and any relevant conversion factors

The following sample SQL query returns the 2017 annual Wireless industry-specific data for Verizon Communications using the S&P Capital IQ Latest Instance Fundamental packages in Xpressfeed

The following SQL sample query returns capletfloorlet normal volatilities, log normal volatilities expressed in relative strikes as per a valuation date which also includes SABR parameters.

The following SQL sample query returns caplet floorlet normal volatilities, log normal volatilities expressed in absolute strikes as per a valuation date which also includes SABR parameters.

The following SQL sample query returns seasonality increments/adjustments for additive, multiplicative and exponential.

The following SQL sample query returns capfloor normal volatilities, log normal volatilities expressed in absolute strikes as per a valuation date.

The following SQL sample query returns swaption normal volatilities, log normal volatilities expressed in relative strikes as per a valuation date which also includes SABR parameters.

The following SQL sample query returns swaption normal volatilities, log normal volatilities expressed in relative strikes as per a valuation date.

Returns Ultimateparent Details With Levels Recursively For A Given Company. Tags - Backward Recursion, UltimateParentID, Corporate tree, Corporate Hierarchy, Company Hierarchy,Levels, RelationshipType Between Child UltimateParent

Returns Sector Revenue/Total Revenue Of Different Institutions For The Year 2019

The following sample query checks availability of data from all countries or regions.

Returns All The Data Items Delivered In The Trucost Environmental Data Packages

The following sample query returns a list of competitors for IBM with Artificial Intelligence Topic Tag

The following SQL sample query returns Equity-Equity correlation tenor points as per a valuation date.

The following SQL sample query returns Precious Metals volatility, forward curve data, risk reversals and market strangles as per a valuation date.

The following sample SQL query displays the SP Capital IQ securityId associated to the CUSIP9 for IBM using the Global Instruments Cross Reference Service (GICRS) package

The following sample SQL query returns the Primary Trading Items associated with Alphabet Inc. (GOOG) using the Global Instruments Cross Reference Service (GICRS) Foundation tables in Xpressfeed

The following query retrieves MSA case details for a given institution and assessment year which replicates the view seen on Capital IQ Pro. It combines ESG scores, related criteria, and company responses, listing all criteria linked to each MSA case.

The following query returns detailed ESG dimension and criteria-level scores for a selected institution and assessment year, score type, and optionally a specific dimension which replicates the view seen on Capital IQ Pro. It includes key metrics, benchmarks, and filters to focus on specific ESG dimensions.

The following sample query returns Latest Holdings Data For SPDR Sector ETFs In Xpressfeed Using CIQ Ownership

The following sample query returns the insider trading activity for AIG and specifically the individual with last name Dooley in Xpressfeed

The following sample query returns the ownership by Calculated Investment Style (type of investors) that own stock in Blackrock

The following query returns headline-level Net Zero commitment details for a selected institution and forecast year, including target categories, reduction types, scope-level commitments, target status, and consolidated pledge information.

The query returns financials of current reinsurers associated with the input cedent institution.

The query returns NAIC cash and invested assets for United Automobile Insurance Company.

The query returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Using SNL NAIC Insurance Snowflake Packages.

This sample query returns all funds under a parent company and their ownership

The following sample query returns the latest momentum factor scores for all companies, ranks them across the full universe, and reports universe-based ranks and percentiles only for a selected stock basket (e.g., S&P 100).

The following sample query returns credit default swaps data for sector curves.

This SQL query returns the latest Bond to Equity Factors for Apple Inc.

This SQL query returns the 5-Year Z-spread With Substitution - RawRatio for NVIDIA Corporation starting in 2024.

This query will provide bid, mid, and ask prices for government, sovereign, agency, and corporate bonds.

This query returns the Company Name, GVKEY, Data Date, Segment Name, and Segment Sales for business segments for the entire history of a company in Xpressfeed. Note: Uncomment the second query to get the number of all active segments specified per segment for a company on each available data date using Compustat packages in Xpressfeed

This query returns the quarterly Berry Ratio for a company using the Compustat packages in Xpressfeed. Note: This query replicates the quarterly Berry Ratio (BERRYQ) concept in Research Insight

This recursive query traverses the fund ownership hierarchy, retrieving details for each level, including owned and owner company information, shareholding metrics, and changes in shares. It returns key ownership data across multiple levels for the specified year range.

The following query returns all merger and acquisition subsidiary transactions details of Seller And Seller - Target Role

This query returns Canadian companies by annual datadate

This query returns all of the annual fundamental financial data items for all annual periods for a company . Note: Uncomment the second query to return ll data in the Company table for all companies that contain Enron anywhere in the company name (CONM)

The following query returns Physical Risk Company and Asset Exposure Score Data for companies (here Toyota Motor Corporation) for forecast year as 2050 and scenario level as High. The counties, states, and subnational geographies are also returned, allowing for comparison of the company and asset locations to the physical risk profile of the wider geographic entities in which the company headquarters resides.

The query blends two decades of real-world CIQ Estimates data ('2003' – '2023') with forward-looking Visible Alpha Esimtates forecast ('2024' – '2039'). The query delivers a comprehensive view of growth trends for industry leaders Johnson & Johnson, Pfizer Inc., Novartis AG, and Roche Holding AG.

This query returns a Cash Flow Statement for companies from Korea

This query retrieves the most recent prices for each instrument, including key price metrics.

This query query specifically identifies original values and the corresponding changes from the original to restated values for Quarterly Selling, General Administrative expenses for GVKEY 149049:

This query provides line items typically included in a balance sheet using Visible Alpha's standard financial metrics.

This query assesses financial health by calculating the debt-to-equity ratio for fiscal years.

This query is showing how much estimates for a company-specific KPI have changed over time. In addition to the consensus (mean), we're also retrieving the min, max, and median values.

This query returns all active companies in Xpressfeed. Note: Uncomment the second query to get all inactive companies

This query finds companies that have pricing in the last year and have a filed bankruptcy flagged with a TL/GL footnote on Total Assets using the Compustat financials in Xpressfeed

The SQL query returns the performance of a specific trading item and its financial metrics including earnings, revenues and market capitalization over time and adjusted for currency fluctuations.

This query examines changes in estimated total revenue for a company over the past six months, highlighting recent revisions.

This query returns all the company specific parameterIDs and their associated names, for a specific company.

This query retrieves a list of companies that have consensus data available.

This query helps recreate the views from the Insights web application by filtering and arranging data by sort order.

This query provides a comprehensive list of industries and business groups for all companies, aiding in market analysis. (Note: This query will only work with only the enhanced version of this package; the final data that will be returned is based on your subscription.)

This query identifies all line items included in the standard financial statement templates.

This query provides the most recent data for all parameters associated with a specific vaCompanyId.

This query fetches the quarterly actual values for a specific parameter of a company, detailing the calculation method and revision history.

This query lists common financial statement lines with high availability across the coverage universe.

This SQL query returns the constituents of the S&P 500 Index, categorized by sector, as of a specified date. It collects various data points including company names, unique identifiers (GVKEY), index weights, market capitalization, share prices, and sector classifications.

This SQL query returns forward estimates EBITDA values for the Forward Five Periods of a company using ticker symbols.

This SQL query returns financial data including financial metrics such as Earnings Per Share (EPS), Total Revenue, EBITDA, and Revenue Growth. Additionally, it provides valuation ratios like Price-to-Earnings Ratios, Enterprise Value to Revenue Ratios (EV/Revenue), and EV/EBITDA Ratios, and also debt metrics, including Net Debt, Interest Expense, and Market Capitalization for a specific company covering the years 2024 to 2025.

The following sample query returns the earnings and shares used to validate the Compustat values for Primary EPS (EPSPX and EPSPI) and Fully Diluted (EPSFX and EPSFI) in Xpressfeed

Returns Private Companies With Over 75% Of Their Revenue (As A Percentage Of The Total Revenue) Generated By Activities In Crude Petroleum And, Natural Gas Extraction Sector

This query returns the dates that the constituents of the S&P 500 Index change using the Compustat packages in Xpressfeed

The following sample query shows the Key Developments for a company as it was available on a particular date historically. Note: The Key Developments Plus package is required to run this query.

This query counts the number of key developments related to dividends. Note: The Key Developments Plus package is required to run this query.

The following sample query shows point-in-time updates for a particular action, showing only the specific columns that changed with each row Note: The Key Developments Plus package is required to run this query.

The following sample query returns all of the Key Developments for a company ordered by their announced date using the CIQ Company ID using Key Development package in Xpressfeed.

The following sample query all of the changes that happened to the ciqKeyDev table over a 24 hour period (adds/updates/deletes), showing only the specific columns with changed values. Note: The Key Developments Plus package is required to run this query.

This query identifies the top 5 event types with the highest number of changes within a 15-minute span. Note: The Key Developments Plus package is required to run this query

This API request pulls time series estimates to see how an estimate adjusts through time for 1 year forward looking total revenue and earnings per share. This request uses relative period type with integer offset to set fiscal period.

The following sample SQL query displays a company and the corresponding identifiers, including DUNS, LEI, GVKEY, and Markit Ticker, associated with that company based on the companyId in BECRS. Note: Increase the number companyIds as needed

This sample query uses CompanyID, datobserve and currencyCode to give ROIC.

The following sample query returns companies that mentioned Boeing in their earnings calls in the first calendar quarter of 2021 unsing Nerd on Transcripts. Confidence scores are limited to > .93 on the latest transcript.

The following query returns price to sales calculation for compustat financials on a specific observation date.

The following sample queryreturns the Standard Poors Common Stock Ranking for a CUSIP in Compustat.

The following sample query returns constituents of the SP 1500 since June 30, 2015 that have had their Global Industry Classification Standard (GICS) code changed prior to quarter-end in Xpressfeed

The output of the query provides the total revenue, the total cost of goods sold, and total EBIT (Earnings Before Interest and Taxes) quarterly for each year. In addition, the query uses those columns to calculate the gross profit and the gross margin (as a percentage).

The following sample query returns the constituents of the SP 500 Index as of a specified date and their corresponding identifiers, including Company ID (companyId), Trading Item ID (tradingItemId), and GVKEY.

The following sample query returns Fundamental PD and Implied Scores for IBM for a specific period (Q1-2017Y).

The following sample query returns the latest Index-based Median Market Signal PD and Implied Score for S&P 500

The following sample query returns CreditModel Score and Implied PD for IBM for a specific period (Q1-2017Y).

The following sample query returns datacenter quarterly power supply and usage.

The following sample query returns the number of operational and planned datacenters by period

The following sample SQL query Compares Annual index value vs. monthly percent change from a year ago

The following query returns security identifiers (ISIN, CUSIP9, SEDOL) for S&P Global Ratings securities.

The following sample query calculate MSCI Indices '1 or 2 Year Beta' using input parameters CompanyId,ObservationDate,Beta 1YR or 2YR, and TradingitemID. Tags - BETA, IQ_BETA_1YR, IQ_BETA_2YR

The following sample query returns Research Report Along with Metadata and Target company (Paypal Holdings)

The following sample query below retrieves Latest Instance For Financial Period Annual Net EPS - Diluted value for International Business Machines Corporation (112350)

This sample query returns portfolio style of IBM displaying shares held, percent of institutional ownership and percent of shares outstanding.

The following sample query displays aggregate shipments by port of unlading, HS Code, and consignee. It displays associated weights and shipment counts

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample SQL query returns Latest Sustainable Investment Data for (Uniti Group Inc.) for Good Governance related metrics.

The following sample query returns Latest SFDR Data for Textiles, Apparel and Luxury Goods Companies for year 2021

The following sample SQL query returns both the SP Rating and the Moodys Rating for a specific ISIN in Xpressfeed.

The following sample SQL query returns financial metrics and Issuer ratings with filtering out Muni ratings for an entitys securities using SP Global Ratings packages in Xpressfeed.

The following sample query uses data groups in the Compustat Point-in-Time Backtest Package to create a complete time series and return a footnote for all pointdate-datadate combinations for Sales Quarterly for GVKEY 001487. It effectively creates a rolling 20-quarter history for the footnote at each pointdate

The following sample query finds the first occurrence of SALEQ in the PIT database, whether it is preliminary or final, for GVKeys 006066 and 012141 for the 12/31/2008 period

The following sample query builds an annual change series for annual sales (SALE) for GVKEY 007435 (3M)

The following sample query returns the Buyside Instrument data for the last seven years for SBLK.

This sample query identifies the sector-based physical risk asset count as a percentage of total for year 2018

The following sample query displays the top 10 next employers for Target Corporation with detailed headcount information.

The following sample query returns the top 10 and bottom 10 companies in the New York metro area based on their 12 months growth rate.

The following sample query returns the top and bottom metro growth areas for Health Care Providers and Services companies that have a total headcount between 100 and 300.

The following SQL sample query returns volatility and discount factor data on equity VarSwap as per a valuation date.

Find the IndexID for the desired index.Pull the fromDate and toDate for the specified company in relation to the IndexID and to determine if a company is a current or historical constituent of a specific index using the Capital IQ files in Xpressfeed

The following sample SQL query returns spark spreads at various heat rates and implied heat rate for Gas Spark on a specific date

The following sample query returns the address details from a Professional ID (proId) using the SP Capital IQ files in Xpressfeed. Note: Uncomment the second query to return a list of address associated with a CIQ Address ID (addressId)

The following sample request will retrieve the Riskgauge 3.0 Sovereign 1 year Probability of Default for the below mentioned company using GDSP, GDSHE and GDST Function for Latest CIQ data (restatmenttypeid:LC). Note: a. You can retrieve prop data using LP, ciq data using LC and latest available data using LA b. Please refer to API properties Doc and RG 3.0 release notes for details regarding different properties and functions. API Properties Doc: https://www.support.marketplace.spglobal.com/content/dam/spglobal/mi/en/documents/marketplace/api/reference/api-properties-matrix.pdf RG 3.0 Release Notes: https://www.support.marketplace.spglobal.com/en/api/release-notes/riskgauge-3-0-model-now-available-on-sp-capital-iq-api-june-27-2025

The following sample request will retrieve the RiskGauge 3.0 Country Benchmark using GDSP, GDSHE and GDST Function for different Benchmark types and pdtype as IQ_RG3_SOV_1YR_PD Note: Please refer to API properties Doc and RG 3.0 release notes for details regarding different properties and functions. API Properties Doc: https://www.support.marketplace.spglobal.com/content/dam/spglobal/mi/en/documents/marketplace/api/reference/api-properties-matrix.pdf RG 3.0 Release Notes: https://www.support.marketplace.spglobal.com/en/api/release-notes/riskgauge-3-0-model-now-available-on-sp-capital-iq-api-june-27-2025

This query identifies a large group of companies that have omitted or suspended dividends in September 2008, including Lehman, AIG, Fannie Mae and Freddie Mac

This query returns unique records of liabilities and credit enhancements associated with a specific instrument identified by its instrumentsymbolvalue, including both current and historical information., For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxsfperformancedata/ratingsxpress-structured-finance-performance-data-user-guide" target="_blank"><b>RatingsXpress Structured Finance Performance</b>

This query returns distinct S&P generated metrics for all summary issuance scenarios based on the supported identifier instrumentSymbolValue, including both current and historical data., For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxsfperformancedata/ratingsxpress-structured-finance-performance-data-user-guide" target="_blank"><b>RatingsXpress Structured Finance Performance</b>

This query returns data about the CLO (Collateralized Loan Obligation) profile and Deal/Collateral Performance for a specific instrument symbol value, including both current and historical information., For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxsfperformancedata/ratingsxpress-structured-finance-performance-data-user-guide" target="_blank"><b>RatingsXpress Structured Finance Performance</b>

The following sample query returns the most current GICS codes for all of the companies trading on a specified stock exchange using the Compustat packages in Xpressfeed. Most current GICS for all companies trading on an exchange, in this case AMEX.

The following sample query a public or formerly public company that has at least one entry in the security data group trading on an exchange NOTE: Uncomment the second query to return companies that have pricing in the sec_dprc data group.

The following sample query finds all late quarterly filings for quarter ending in 2010.

This query retrieves an in-depth analysis of liquidity trends and instrument performance over time.

This query retrieves the latest market metrics along with relevant instrument details for specified identifiers, including instrument IDs, ISINs, and liquidity scores for the past 30, 60, and 90 days.

This query returns all records from Factors Connections within the specified date range.

This query returns the latest S&P Capital IQ consensus EPS estimates for fiscal years 2012 through 2016 along with the effective date and estimate consensus notes using S&P Capital IQ Estimates Consensus tables

The following sample query returns credit index options pricing data.

This query Returns the Estimate Target Price (dataItemId = 100161) AND the currency that the data is reported in for a single TradingItemId using the S&P Capital IQ Estimates package

The following sample query returns annual report data for a specific institutionID.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

This query returns S&P Capital IQ Estimate contributors for Polymet Mining Corp (companyId = 875530) using the S&P Capital IQ, this including the Broker Name and Analyst Name For 2014 Fiscalyear EPS Normalized (Detailed) for Polymet Mining Corp (companyId = 875530) using the S&P Capital IQ Details Estimates packages

This query returns returns the Total Same Store Sales Growth percent using the S&P Capital IQ tables in Xpressfeed Note:Here a specific periodType is taken

The following sample query returns where are the supplier of S&P 500 companies are based and sort the regions by value.

The following sample query returns company dependent on a few key suppliers for critical materials or services.

The following sample SQL query counts the number of companies that report to a particular dataitem from 1989 to 2019 annually (PeriodTypeId=1)

The following SQL query demonstrates how to create and execute the necessary MS SQL queries to view basic income statement items for a single company as of a specific period end date

Pulling US Primary Listed IPO from Transactions for given YEAR range and then pulling Fundamentals for those based on another YEAR range.", Can set Fundamentals Range - Default is 3 Years pre-IPO and 3 Years Post-IPO. Also running a REPLACE on DataItemName to switch commas with hyphens for CSV exporting. Built for The Capital Group to replace a CIQ screenexcel sequence

This query returns the latest EPS estimates along with the company's security identifiers (CUSIP, SEDOL, ISIN).

The following SQL sample query returns discount curves which include the zero rate, discount factor, spot and implied FX forward as per a valuation date.

The following query aggregates data to the Ultimate Parent and displays all company IDs associated with that Ultimate Parent across all levels.

The following query returns Scope-level target information for the selected institution, including target categories, types, baseline and horizon years, forecast values, and scope coverage. It pivots key scope metrics for easier comparison and highlights whether each target falls under the Scope Category flag.

The following query aggregates data to the Ultimate Parent and displays all company IDs associated with that Ultimate Parent across all levels.

This SQL query returns non-null 20-Day Aggregated Bond Return - RawRatio for a specific date and Universe ID.

The following query returns all merger and acquisition subsidiary transactions details of Buyer And Buyer - Target Role

This query returns the Berry Ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Berry Ratio (BERRY) concept in Research Insight

This query retrieves comprehensive company details, including company ID, company name, total revenue, status, AUM, preqinAUM, total employees, federal tax ID, NAICS and more, utilizing multiple datasets.

This query returns all annual item notes and note subtypes for Starbucks Corp later than September 30, 2007 in Xpressfeed

The following sample SQL query uses the Premium Financials Instance Date package to display Apple's filing vs. point-in-time date progression

This query returns annual fundamental data for Shanghai Electric Group Co Ltd. in Xpressfeed. ---Pulls Annual Issue Data , Footnotes, and Data Codes

This query returns annual Fair Value Asset Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159

This query returns all of the I/B/E/S EPS estimates for IBM

This sample query retrieves consensus EBITDA forward estimate time series data for the specified index focusing on annual period type.

This query uses tables in the Compustat Point-in-Time Backtest Package to show original values and any subsequent changes to a data item over time. It returns the datadate, pointdate, value and data code for the original and revised instances. The query represents an abbreviated time series in that it does not return all datadates and pointdates for the item: It only returns datadates and pointdates for when there is an original value or a change. Note:This query specifically identifies original values and changes to quarterly sales for GVKEY 001487.The mnemonic and GVKEY can be changed to run for other items and companies

This query calculates a specific companies year-over-year revenue growth.

The query returns quarterly net income, for a specific example company, to identify trends.

The following sample query counts the number of quarterly instances by Region using Dynamic Pivot

The following sample query returns paid loss ratios by accident year loss triangle

This query calculates total non-interest bearing current liabilities

This This query maps Market Identifier Codes (MIC) to Stock Exchange Codes (EXCHG) in Xpressfeed

This query joins Semi-Annual Sales from the Income Statement items with Quarterly Total Assets from the Balance Sheet items for International companies

This query fetches the most recent reported total revenue for a company from its filings.

This query identifies the business groups and industries associated with a specific company, providing insights into its market classification. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query retrieves the most recent estimated total revenue for a company, focusing on the period following the latest reported data.

This query finds companies that have data for specific financial statement line items.

This query lists companies within a specific business group, helping to identify peers and competitors. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query calculates the revenue weight of a company's total revenue within a sector, providing insights into segment performance. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query lists all key performance indicators for a specified business group, providing insights into the metrics used for performance evaluation. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This SQL query returns the unadjusted outstanding shares of a specific trading item over a defined date range, adjusting for any stock splits that occurred.

This SQL query returns and analyzes financial data and market prices for the trading items and gives companies' financial performance and market activity over the specified time period from 2014 to 2023.

This SQL query returns TEV/NTM EBITDA data for a specific company over the period from 2020 to the present date.

This SQL query returns the fiscal years and fiscal quarters for the latest transcripts data, using fallback logic that includes Event Headline, Premium Financials Package, CIQEventCallBasicInfo Table, and Event Date.

The following sample query returns the GICS code description for all level of GICS codes as well as the numeric code in Xpressfeed for a given company(Here INTL BUSINESS MACHINES CORP)

The following sample returns the datadate that a new adjustment factor is applied for stock splits

This query identifies the key developments with the highest number of modifications. Note: The Key Developments Plus package is required to run this query.

The following sample query shows only the specific columns that changed with each row in key developments. Note: The Key Developments Plus package is required to run this query

The following sample query shows transaction-related Key Developments along with details of the transactions from the Transactions feed.

This sample query shows all Announced/Completed Transactions for a company. Note: The Key Developments Plus package is required to run this query.

This query counts the number of key developments by event type in the last week. Note: The Key Developments Plus package is required to run this query.

The following sample request will retrieve the Sovereign Risk inclusive of Probability of Default scores in the RiskGauge model for International Business Machines Corporation (NYSE:IBM) for the months January through August 20, latest as of August 20, 2021.

The following sample query returns the U.S. Securities and Exchange Commission (SEC) Central Index Key (CIK) for a company from the Capital IQ tables in Xpressfeed

The following sample query shows industries of interest,investment styles and transaction types of a particular company., Note: Change the companyId as needed, currently it runs for Bain Pvt Equity,LP.

The following sample query finds companies with merger or spin-off NOTE: The following tables can be queried in order to find companies with either mergers or spin-offs in Xpressfeed: For Mergers:table sec_mth item isalrt = PA or PM prior to 2000 or PA after 2000table sec_mthdiv item cheqvm is not null For Spin-offs:table sec_mth item isalrt is null and table sec_mthdiv item cheqvm is not null The data item Comparability Status Code (COMPST and COMPSTQ) can be used for North American Companies to identify those that have had a merger or acquisition during the current year with an AA or an AA-combination code. Uncomment the second query to return the footnote on Sales-Net which can also be used to find acquisitions.

The following sample query returns the risk of currency depreciation between USD vs GBP vs CAD since 2015.

The following sample SQL query returns Fact Level Responses to Question 'Board Gender Diversity' for Companies in 'Consumer Staples' for 2022 Assessment

The following sample SQL query returns Question Level Scores, Weights, Disclosure Data, and Industry Level Aggregate Scores for Walmart Inc. for 'Corporate Governance' Criteria in 2022 Assessment

The following sample query calculate CIQ Indices '5 Year Beta' using input parameters CompanyId,ObservationDate,Beta 1YR or 2YR, and TradingitemID. Tags - BETA, IQ_BETA_1YR, IQ_BETA_2YR

The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication

The following sample query returns risk factor section (Item 1a) from all available 10-K filings for a company.

The query finds and shows the public trading portion, total value, and the average trading volume over the last 30 days for main stocks and trading entities of companies that are currently in business. It adjusts these figures to US dollars by applying past currency exchange rates and focuses on the data for a specific company identified by its unique ID.

The following sample query returns the 52-week high price and the 52-weel low price for SBUX (TID:2654392) using the ciqpriceEquity table in Xpressfeed

This sample query returns Ownership by Fund – expand the holder (e.g., The Vanguard Group, Inc.) and see how the ownership position is built using underlying funds for a given owner (e.g., Wells Fargo & Company)

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample query builds a time series for one item for one company as of a particular observation date

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following sample query returns a time-series for filing dates for GVKEY 012141 (Microsoft Corp)

The following sample SQL query returns all Global Issuer (GI) entity ratings put on a positive CreditWatch.

The following sample query returns the most recent security identifiers for all issues for a company through the latest date

The following sample SQL query returns the current Long Term Local currency ICR Rating, Outlook and Credit Watch values as of the given observation date for an Entity. The rating type can be modified using the where clause values.

The SQL query returns unconsolidated financial metrics (EVIC Data) for selected companies as per the LTM holding dates.

The following sample queries returns credit default swaps data for Credit Indices.

The following sample query returns the top ten US Equities ranked by the percentage of shares outstanding on loan.

The following sample query displays the top 10 previous employers for Target Corporation with detailed headcount information.

This sample query identifies the physical risk asset count for S&P 500 companies for year 2018

The following SQL sample query returns volatility, forward curve and dividend yield data on equity Stock/ETF as per a valuation date.

This sample query identifies companies that derive revenues from coal-based activities to isolate portfolio exposure to transition risks

This sample query determines which companies own fossil fuel reserves and, therefore, may be holding stranded assets as we transition to a lower-carbon economy

The following sample query returns latest transcript for an event using the S&P Capital IQ Transcripts package in Xpressfeed.

The following sample query returns earnings calls where an analyst asked a question for an Index Constituent using the S&P Capital IQ Transcripts package in Xpressfeed.

The following sample query returns aggregate count of distinct analysts who asked a question for a companys quarterly earnings call using the S&P Capital IQ Transcripts package in Xpressfeed. (Here for Apple Inc.)

This sample query returns ownership summary including the total shares held and the percentage of shares outstanding for the specified tickers over the last five periods with categorized owner types.

The query below aggregates direct written premiums for all companies across all states in the U.S., categorized by line of business in 2024.

The query returns direct written premiums for a specific company across all states in the U.S., categorized by line of business in 2024.

The following sample query uses data groups in the Compustat Point-in-Time Backtest Package to create a, complete time series and return a value for all pointdate-datadate combinations for Sales, Quarterly for GVKEY 001487. It effectively creates a rolling 20-quarter history for the item, at each pointdate.

The following sample query retrieves one forward period EBITDA estimates using the relative constant concept and TEV from market capitalization to calculate the 10-year TEV/EBITDA average for a specific company.

The following sample query shows Visible Alpha Estimates industry metrics related to a company within the Technology Sector and Application Software Group, covering the period from calendar year 2023 to 2027., Note: Change the companyId as needed, currently it runs for Oracle Corporation.

Returns the members of the Euro Topix Index

The following sample SQL queries display latest Annual Filing for a company for the current period

Returns key constituent data on a particular date for an S&P Global BMI Index using the S&P Global BMI index data package in Xpressfeed

This sample query returns a series of current EPS values for the 2024 fiscal year, adjusted for splits.

This sample query returns the current year revenue estimate for a company as of April 14, 2022:.

This sample query returns all NTM mean EPS data, current and historical, as it existed at a particular point in time for a company, displayed on today’s split basis.

The following sample query returns current board members for IBM

The following sample query identifies for a given financial year and GICS Sector, the top 10 companies with the highest CEO pay ratio,along with company details (company name)

The following sample request will retrieve the Riskgauge 3.0 Sovereign Credit Score for the below mentioned company using GDSP, GDSHE and GDST Function for Latest Available data (restatmenttypeid:LA) Note: a. You can retrieve prop data using LP, ciq data using LC and latest available data using LA b. Please refer to API properties Doc and RG 3.0 release notes for details regarding different properties and functions. API Properties Doc: https://www.support.marketplace.spglobal.com/content/dam/spglobal/mi/en/documents/marketplace/api/reference/api-properties-matrix.pdf RG 3.0 Release Notes: https://www.support.marketplace.spglobal.com/en/api/release-notes/riskgauge-3-0-model-now-available-on-sp-capital-iq-api-june-27-2025

The following sample request will retrieve the Riskgauge 3.0 Sovereign 1-100 score for the below mentioned company using GDSP, GDSHE and GDST Function for Latest prop data (restatmenttypeid:LP) Note: a. You can retrieve prop data using LP , ciq data using LC and latest available data using LA b. Please refer to API properties Doc and RG 3.0 release notes for details regarding different properties and functions. API Properties Doc: https://www.support.marketplace.spglobal.com/content/dam/spglobal/mi/en/documents/marketplace/api/reference/api-properties-matrix.pdf RG 3.0 Release Notes: https://www.support.marketplace.spglobal.com/en/api/release-notes/riskgauge-3-0-model-now-available-on-sp-capital-iq-api-june-27-2025

This query returns unique records of trustee-reported tests along with performance data at both deal and tranche levels with a specified instrument symbol value (only collateral performance), including both current and historical information., For User Guide, refer: <a href=" https://www.support.marketplace.spglobal.com/en/datasets/ratings/rxsfperformancedata/ratingsxpress-structured-finance-performance-data-user-guide" target="_blank"><b>RatingsXpress Structured Finance Performance</b>

This query returns the time-series for S&P Capital IQ Broker Consensus Recommendations (DataItemId: 100160) for a company using the S&P Capital IQ Estimate Consensus packages

This Snowflake query dynamically constructs and executes a SQL query to aggregate import data from multiple tables in the XPRESSFEED schema matching the pattern '%PANJIVA%IMPORT%'. It ensures a consistent set of columns across tables, handles missing columns, and aggregates data by ultimate parent company, region, and date range. The query joins with reference tables to filter by company IDs and applies region-specific shipment counting logic.The query adapts joins based on shppanjivaid or conpanjivaid availability, aggregates metrics like shipment counts and values by company and region, and maps regions to country names. Optimized with metadata caching, it delivers robust, error-handled results for import analysis. Tags: Snowflake Scripting, Snowflake Automation, Dynamic Column Handling, Metadata Caching, Cursor Operations, Dynamic SQL

The following sample query calculates semi-annual cash flow from operating activities (OANCFY) for international companies

The following SQL sample query returns XCCY basis swap curve data, payment frequencies and accrual basis as per a valuation date.

The following SQL sample query returns inflation LPI spreads as per a valuation date.

The following SQL sample query returns inflation swap curve data which includes the zero-coupon inflation swap rate and forward inflation index as per a valuation date.

The following SQL sample query returns inflation LPI rates as per a valuation date.

The following sample query returns parent and ultimate parent company for 'Valim'.

The following sample query validates all the details from platform.

The following sample query checks if there are any records in between where subsidiarycompany is the ultimateparentcompany.

Returns Environmental Data (Textual) Of American Electric Power Company, Inc. For The Year 2018

Returns Environmental Data (Numeric) Of American Electric Power Company, Inc. For The Year 2018

Returns Carbon Intensity As Company GHG Emissions Divided By Company Power Generation Where Carbon_Intensity>408

The following sample query returns a list of Peer companies in the S&P 500 IT Services Industry and a Artificial Intelligence Topic Tag Name

The following sample SQL query displays the number of identifiers that exist for each identifier type in BECRS

The following SQL sample query returns FX-Equity correlation tenor points as per a valuation date.

The following sample query returns the top holders of a company using the SP Capital IQ Ownership and Base Files packages

The query returns direct written premiums for a specific company across all states in the U.S., categorized by line of business in 2024 Using SNL NAIC Insurance Snowflake packages.

The following sample query Ranks companies across the full universe by network centrality and upstream momentum, computes a composite percentile, and displays results only for a selected company bucket to highlight firms with both high influence and strong momentum.

This SQL query returns unpivoted Bond to Equity Factors data for the Z-Spread, Z-Spread With Substitution, Shift, and Divergence Factors for a specific Trading Item Id as of a given date.

The following sample SQL query returns business involvement screens data for S&P 500 companies for all groups for the year 2023.

This query returns annual Fair Value Liability Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159

This sample query link the Visible Alpha Esimates Vacompanyid to the S&P Capital IQ companyId. The companyId is the S&P Capital IQ unique identifier for an entity.

This sample query links the Visible Alpha Estimates to S&P Capital IQ Market Data. It provides key metrics such as market cap, total enterprise value (TEV), and implied market cap (as well as shares outstanding, including limited partner shares).

This query returns the Cash Flow for companies using the Compustat packages in Xpressfeed: Note: This query replicates the Cash Flow (CFL) concept in Research Insight

This query In Compustat Xpressfeed, AJEXQ is tied to quarterly fundamental data availability so AJEXQ is not available until the fundamental data for that period is available. You can find more current information in Compustat Xpressfeed utilizing the co_adjfact data group. Co_adjfact is organized with effective from and thru dates rather than specific data periods. Note: Uncomment the second query to return the adjustment factor as of a specific date returning only one row of data

The query returns Estimate consensus Coverage between 2014-2021 for companies listed on The Stock Exchange of Hong Kong Ltd.

Use this sample query (attached) filters data for the years 2020–2024 and includes the location, type, and subtype of Product Filings for Legacy SNL Insurance packages

This query ranks key performance indicators (KPIs) for a specific business group, helping to identify the most important metrics for analysis. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query lists all companies within a specific business group, including their industry and country information. (Note: This query requires a subscription to Visible Alpha Consensus Estimates Premium package.)

This query returns the primary issue when more than one issue is listed as primary in the Compustat Company table in Xpressfeed

This SQL query returns and aggregates comprehensive data related to companies, including key company details, risk scores, and benchmark metrics specifically identifies records using DUNS and GICS identifiers.

This SQL query returns and analyzes TEV and EBITDA ratios for a specified group of companies as of the observation date by using company identifiers and trading item details.

The following sample query returns Short Interest data using Compustat packages (Here for Nasdaq Stock Market)

Because there is so much daily history, it is recommended to input a datadate range or the query will take a long time to run. To pull the entire history, remove and sec_dprc.datadate = 12/31/2008 from the query

This SQL query returns available data on Absolute Carbon Emissions for Greenhouse Gas (GHG) Scope 1, specifically for companies identified by their institution IDs.

This query retrieves key developments announced in the past 30 days. Note: The Key Developments Plus package is required to run this query.

Identifies the companies with the highest number of key developments over the past five years. Note: The Key Developments Plus package is required to run this query.

This sample query displays the current list of Key Development Types available in your subscription.

The following sample query returns top 100 companies with an Initial Public Offering (IPO) using the S&P Capital IQ Key Developments package in Xpressfeed.

This SQL query returns key development events related to venture capital (VC) and private equity (PE) firms from 2017 to 2022.

This sample query returns the M/A Transaction closings where Boeing (BA) is the buyer.

The following sample query returns private company financial EVIC data as per the observation date with fallback logic.

The following sample query returns the Market Derived Signal (MDS) value, MDS Z-Score, Probability of Default (PD)-based MDS Value, and PD-based MDS Z-Score for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed

The following sample query calculates monthly price to book ratio using daily pricing

The following sample query returns the latest Index-based Median Fundamental PD and Implied Score for USA - Oil & Gas

The following sample queries provides S&P CreditStats Data For US Public Finance Data for New York in 2022 with CUSIPs from RatingsXpress v4

The following sample SQL query returns Product, BankId and count of TimeseriesID

The following sample query calculate MSCI Indices '5 Year Beta' using input parameters CompanyId,ObservationDate, and TradingitemID. Tags - BETA, IQ_BETA_5YR

The following sample query provides HS Code and HS Methodology For Panjiva Data

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

Please reach out to Support.energy@spglobal.com for any assistance on the below query.

The following query returns interval results across commodities based on requested criteria is Input grade x interval, Region, Country & Date Range.

The following sample SQL query returns the entitySymbolValue assigned to countries or sovereigns using the SP Global Ratings V4 packages in Xpressfeed

The following SQL query returns all levels of index hierarchy using Index Key provided for each BMI index.

This query retrieves the most recent data for equity instruments in the US greater than 1000 ranked by Active Utilization.

The following sample query returns month over month headcount changes for a particular company.

The following SQL sample query returns volatility, forward curve and dividend yield data on equity Stock/ETF as per a valuation date.

The following sample query compares a company carbon footprint (intensity) within the same GICS industry to assess relative carbon efficiency over the course of a financial year

The following sample query returns linkage of transcripts to events for a company using the S&P Capital IQ Transcripts package in Xpressfeed.

This SQL query returns the primary earnings per share (EPS) data for a specified list of companies and price-to-earnings (P/E) ratios.

This sample query returns ownership detailed including the total shares held and the percentage of shares outstanding for the specified ticker with categorized owner types.

The following sample query builds a time-series for quarterly sales (SALEQ) for GVKEY 001078 (Abbott Labs), in Xpressfeed.

The following query returns disclosed Restricted Cash(31508) values from 2023 annual reports for companies in the Semiconductor simple industry.

Returns the Tokyo Stock Price Index (TOPIX) constituent weights in Xpressfeed as per the date and indexid we input

Returns the ticker symbol, GVKEY, Issue ID, and GICS Sub-Industry Code from the Xpressfeed company and security tables for the S&P 500 Index constituents into a CIQ Index data query that includes index weight, shares, price, and index price

The following sample query shows pivoted Visible Alpha Estimates industry metrics related to a company within the Technology Sector and Application Software Group, covering the period from calendar year 2023 to 2027., Note: Change the companyId as needed, currently it runs for Oracle Corporation.

Returns the GVKEY, IID, GSUBIND, and CUSIP from the Xpressfeed company and security tables for the S&P 500 Index constituents from the S&P Capital IQ Index data tables on 7/9/10

Returns The Daily Or Monthly MSCI Index Values Using The S&P Capital IQ Index Data Packages In Xpressfeed

Returns the constituents of the S&P Americas BMI Financials (Sector) Index for 1 day using the BMI Index feed in Xpressfeed

This query returns S&P 500 Index constituents by sector as of a specified date and includes GVKEY, company name, close divisor, weight, index shares and share price

The following sample query identifies the trends in CEO pay ratio, CEO annual compensation, or employee median salary for the selected fiscal years (For a given company)

This sample query analyzes footnotes for Normalized EPS (ID: 100173) to infer whether stock-based compensation and/or Amortization of Intangibles is included or excluded, based on keyword positions in the note text. It returns period-level flags (sbc_status, intangible_status) to support custom tagging for Capital Group.

The following sample query returns the key executives with the highest annual cash compensation between 01/01/2010 and 12/31/2010

The following sample query Returns the growth rate of a particular companys CEOs annual compensation for a two-year period

The following sample query displays a persons profile with biography, education, and board memberships

This query returns GVKEYs where the Customer Name contains foreign government (GOVFRN)

The following sample query calculates Return on Invested Capital (ROIC) for a company (Here INTL BUSINESS MACHINES CORP) using the Compustat packages in Xpressfeed.

This SQL query retrieves distinct bond names along with their associated CUSIP, ISIN, unique ID, and issuer's long name.

This query returns the most recent CIQ EPS Normalized (Detailed) Estimates for the 2012 fiscal year for IBM using the S&P Capital IQ Estimates package

The following sample SQL query returns Fact Level Details for Criteria 'Corporate Governance' and Question 'Board Gender Diversity'

The following sample query returns business listings with their link to institutionId.

The following sample query returns the SIC hierarchy for a selected business.

The following sample query returns businesses with sales in a county and their contacts.

The following sample query returns the business listing for Six Flags New England and its link to UCC Filings and Commerical Properties.

The following sample query returns how customer and supplier relationships vary across different industries or sectors, helping identify potential growth opportunities or vulnerabilities.

This query returns Total Average Common Equity / Total Average Assets % (Data Item ID #4287) for four companies in the Financial Services industry sector (Toronto Dominion - GVKEY 23515, Royal Bank of Canada - GVKEY 109809, The Bank Of Nova Scotia - GVKEY 873647, and Canadian Imperial Bank of Commerce - GVKEY 386873) from the S&P Capital IQ tables in Xpressfeed

The following sample query returns the most valuable customer-supplier relationships, helping to evaluate long-term revenue potential and assess risk associated with customer/supplier concentration

The following sample SQL query queries display the currency in which financials were reported and convert the data to a target currency

This query returns the Price-to-Earnings (P/E) ratio, Price to Book Value (P/BV), and Total Enterprise Value (TEV) for Verizon on a daily basis using the S&P Capital IQ Latest Financials packages in Xpressfeed. Note: The Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement. Note: Uncomment periodtypeId IN (2) to get quarterly results

The following SQL sample query returns inflation forward curve data which includes the forward Inflation index and inflation swap rate as per a valuation date.

The following SQL sample query returns capletfloorlet normal volatilities, log normal volatilities expressed in relative strikes as per a valuation date.

The following SQL sample query returns XCCY swap curve data, payment frequencies and accrual basis as per a valuation date.

The following SQL sample query returns zero rate yield curve data and discount factors as per a valuation date.

The following SQL sample query returns yield curve rates data and payment frequencies and accrual basis as per a valuation date.

The following SQL sample query returns swaption normal volatilities, log normal volatilities expressed in absolute strikes as per a valuation date.

The following SQL sample query returns basis swap curve data, payment frequencies and accrual basis as per a valuation date.

Returns Company Relationships Recursively, currently returning output for IBM, if you want to see for universe, please comment WHERE condition. Please read the comments for more information Tags - Corporate tree, Corporate Hierarchy, Company Hierarchy

The following sample SQL query displays a company and the corresponding SP OrgId, the Fitch OrgId, and the Moody’s OrgId associated with that company based on the SP Capital IQ companyId in BECRS

The following sample query returns a list of companies with Artificial Intelligence as a Topic Tag and rank of 1.

The following sample SQL query returns the institutionID from a companyId using the BECRS package in Xpressfeed

Returns Company Relationships Recursively, currently returning output for IBM, if you want to see for universe, please comment WHERE condition. Please read the comments for more information. Tags - Corporate tree, Corporate Hierarchy, Company Hierarchy

The following query retrieves ESG (Environmental, Social, and Governance) transparency and disclosure scores for selected institutions and assessment years, similar to what’s shown on Capital IQ Pro. It includes both raw and modeled scores to give a detailed view of each institution’s ESG performance.

The following query Returns ESG (Environmental, Social, and Governance) scores for a given institution and assessment year, similar to what’s shown on Capital IQ Pro. It includes detailed E, S, and G scores with their weights, the overall ESG score, and the industry average and supports both raw and modelled scores.

The following sample query returns Ownership Details For Active Mutual Funds, Excluding Exchange-Traded Funds (ETFs) And Index Funds, From The S&P Capital IQ Ownership Package

The following sample query returns Market Value Of the securities owned by a specific holder, or position, as of a specified period-end date using the S&P Capital IQ Ownership and Base Files packages

This query returns multiple transaction types and provides the detailed transaction-level information. It currently filters results using companyID, which can be substituted with any other set of IDs as needed.

The following sample query returns All Of The Institutional Owners, Excluding Individuals, For A Company Using The CIQ Ownership Tables In Xpressfeed View by All Owners (excludes individuals)

The query returns net premiums earned for united automobile insurance company.

The query returns current common stock holdings for the input company.

This query returns a recursive corporate ownership hierarchy for a given company, starting from the selected company and recursively climbs upward through parent ownership relationships based on specific relationship types. Tags - Backward Recursion, UltimateParentID, Corporate tree, Corporate Hierarchy, Company Hierarchy,Levels, RelationshipType Between Child UltimateParent

The following sample query returns the latest network centrality measures (weightIn and weightOut) for all companies, ranks them within their respective sectors, and displays sector-relative rankings only for a selected company basket (e.g., S&P 100).

This query returns the legacy Capital IQ corporate tree for a selected Company ID using the company relationship dataset. It includes selected filters: current investments, subsidiaries/operating units, investment arms, and merged entities, across all ownership types. Up to level 2, the hierarchy expands across all stake types; from level 3 onward, only entities with Majority ownership are returned, with recursion limited to seven levels. Link - https://www.capitaliq.com/CIQDotNet/CorporateTree/CorporateTree.aspx?CompanyId=25915843

This query returns the legacy Capital IQ corporate tree for a selected Company ID using the company relationship dataset. It includes selected filters: current investments, subsidiaries/operating units, investment arms, and merged entities, across all ownership types. Up to level 2, the hierarchy expands across all stake types; from level 3 onward, only entities with Majority ownership are returned, with recursion limited to seven levels. Link - https://www.capitaliq.com/CIQDotNet/CorporateTree/CorporateTree.aspx?CompanyId=25915843

The following sample query returns live credit default swaps data for single names 5 days a week.

The following sample query returns live credit default swaps data for credit indices 5 days a week.

This SQL query returns all Bond to Equity factors for the specific Trading Item ID as of a given date.

This SQL query returns Monthly Export Shipping volume trend over the past year for Dell Technologies.

This SQL query returns the Credit Revisions - 3 Month - RawRatio grouped by geographical region.

This SQL query returns and ranks countries by the 1-month change in trailing twelve-month (TTM) shipping volumes for both exports and imports.

This SQL query returns the Top 10% trading items by CDS Divergence - Rank for a specific date and universe ID. Rank is 1-100, with 1 being most favorable, as percentile.

The Following Sample Query Provides all datapoints and its components involved in the platform representation of CIQ Premium Financials(Annual) via Xpressfeed Data.

This SQL query returns the most recent institutional ownership data for the current year, showing the top 10 institutional holders’ rank and ownership ratio for each company.

This SQL query returns the recent trends in institutional activity for U.S. securities, focusing on active share changes and average ownership changes over the past year. It provides insights into institutional trading behavior and ownership dynamics within the AFL US universe.

This SQL query returns the institutional ownership activity for the past year, including overall net flow (shares and institutions) and pure buying and selling activity for a specific trading item.

The following sample SQL query returns MA transactions for tender offers where the percent sought on the announced date is greater than the percent acquired on the final date using the SP Capital IQ tables in Xpressfeed.

This SQL query returns the 5-Year Z-spread grouped by geographical region.

This SQL query returns industry-relative monthly export shipment ratios for all companies within the AFL US universe as of a given date, linking each company to its respective GICS sector and industry classification.

The following sample SQL query returns the consideration details including Consideration to Shareholders, Offer Per Share, and Total Stock for a specific transaction using the SP Capital IQ Transaction packages in Xpressfeed

The following sample SQL query returns the financials for a company using the SP Capital IQ Transactions package in Xpressfeed.

The following sample query returns securities excluding REITs, Mutual Funds, and ETFs using the SP Capital IQ packages in Xpressfeed

This request returns daily values for six EWS 1.0 metrics (signal, days, PD threshold, YoY PD change, and dimension statuses) for IQ112350 between 01/02/2026 and 01/10/2026, leveraging the GDST function with frequency set to "Daily". Note: For more details, please refer to EWS release notes

The following sample query returns the Primary Industry Classification Simple Industry level (3rd level) for a company using the SP Capital IQ Company Foundation schema in Xpressfeed

The following SQL sample query returns FX bid ask volatility, forward curve data, risk reversals and market strangles as per a valuation date.

The following sample query returns all of the data groups (packages) that a data item is located in and the SP Capital IQ Excel Plug-In Formula (CIQ Plug-In ID) in Xpressfeed

The following sample query returns the SQL equivalent for the API mnemonic IQ_REVENUE_EST (Revenue Consensus Mean). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SP Capital IQ data item name and definition for the Data Item IDs 4220 - 4233

The following sample query returns the SQL equivalent for the API mnemonic SP_EPS_EST (EPS Normalized Consensus Mean). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_ASSET_TURNS (Asset Turnover). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_DA_SUPPL_CF(Depreciation and Amortization). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_WORKING_CAP (Working Capital). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_UFCF_MARGIN (Unlevered Free Cash Flow Margin). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SP_TOTAL_RETURN (Total Return). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_REV_1YR_ANN_GROWTH (Total Revenues, 1 Yr. Growth %). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_OPER_INC (Operating Income). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_RD_EXP_FN (Research And Development Expense From Footnotes). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_NET_DEBT_EBITDA (Net Debt By EBITDA). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_NET_INVEST_INC (Net Investment Income). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_CORE_EPS_GROWTH (Core EPS Growth). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

This query retrives market reactions to buyback announcements by extracting relevant events and tracking stock closing prices for 10 days before and after each around announcement date.

The following sample query returns credit default swaps 5-year mid for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed

The following sample query returns Top 10 contributors to sovereign territorial GHG emissions for Italy for the year 2024.

The following sample query returns IBMs competitors from the SP Capital IQ Company Intelligence package in Xpressfeed

The following sample query returns the market capitalization for the non-U.S. shares when they are the primary issue of stock

The following sample SQL query retturns currently effective Capital Expenditure (CapEx) guidance values including base, high, and low estimates for a specified company and annual reporting periods.

This request retrieves all watchlists created by or shared with the user. Note: Use 'Universe' as the identifier to retrieve all user-accessible watchlists. For more details on functionality, please refer to Maxlimit 2.0 release notes

This example shows how to retrieve a specific watchlist ID using a watchlist name and vice versa. Note: Pass watchlist name as an identifier to retrieve specific watchlist ID and vice versa. For more details on functionality, please refer to Maxlimit 2.0 release notes.

This end-to-end example retrieves portfolio maxlimit, adjusted maxlimit, and portfolio company IDs. Note: For more details on functionality, please refer to Maxlimit 2.0 release notes

The following sample query returns loss triangle for number of claims closed with loss payment direct assumed at year end using Schedule P

The following query returns all merger and acquisition subsidiary transactions details of Buyer And Buyer - Target Role

The following sample SQL query identifies all the topic tags along with keyword combination.

This query lists common financial statement lines with high availability across the coverage universe.

The following sample query returns the Occupancy Rate percentage for the last five fiscal years using the SNL Real Estate package in Xpressfeed

The following sample query below returns Beneish M Scores for particular companies

The following VA Industry Segmentation sample query lays out the standardized taxonomy in parent to child order, indented by level, with the full path so you can read the hierarchy from sector down to the most detailed segment.

The following sample query returns the total return in descending date order from the SP Capital IQ Market Data for company ID 112350 (IBM). The return period can be adjusted by changing the lookback period in the last line of the script.

The following sample query returns amounts payable on assumed losses and LAE which have been recognized as paid by the ceding company in 2019 where Reinsurer is Berkley insurance company

API Request to search and return a company name with it's associated company id

API request to return the top 10 holders of the passed in identifier with the associated holder company name. The ranking is always current ranked by value. As ownership can change over time this output will contain all line item names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. If all holders are required, please set EndRank to highest value supported. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

API request to request BECRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags

API request to pull Business Segment Revenue with associated business segment name. As segments can change over time this output will contain all segment names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

API request pulls companies direct relationships. To see additional relationships(Example. SGPI's subsidiaries' hierarchy) please extend EndRank to a max level of 8. We recommend to use 1 identifier at a time as the response size for a corporate tree can be very large and may cause the API to time out.

API Request pulls 2 years looking forward detailed contributor and their related revenue estimate. This request uses relative period type with integer offset to set fiscal period. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

This API request pulls 1 year forward looking total revenue and earnings per share using relative period type with integer offset to set fiscal period.

The following sample query returns total unpriced carbon cost for S&P 500 companies for forecast year 2030, scenario level LOW

The following sample query returns EBITDA as risk for the S&P 500 electric utilities companies for all forecast years, scenario level HIGH

The following sample query returns Company Carbon Emission Alignment for Exxon Mobil Corporation

The following sample query reconstructs Carbon Earnings at Risk FTP data for sample companies for 2019 financial year

Return All The Data Items Delivered in The Trucost Paris Alignment Data Packages

The following sample query returns latest Country Industry based on the Median Fundamental PD and Implied Score for USA - Oil & Gas

The following sample query returns latest Corporate Industry Risk Score for USA - Oil & Gas., Note: Uncomment the second query to get the latest Country Risk Score and Banking Economic Risk Score for USA.

The following sample query returns IBM’s PD-based Market Signal.

The following sample query returns Fundamental PD and Implied Scores for IBM for a specific period (Q1-2017Y)., NOTE: Uncomment the second query to get companyId from a companyName.

The following sample query returns the latest Country Industry based on the Median Credit Model Score and Implied PD for USA - Oil & Gas

The above JSON request using mnemonic 'IQ_CURVE_TRANSPARENCY' with GDSHV and applicable properties StartDate, EndDate, Sector and Energy will retrieve: 1.ISIN, 2. DerivedBondPrice, 3. ZSpread, 4. ValuationDate, 5. MaturityDate, and 6. IssuerName.

The above JSON request using mnemonic 'IQ_FULL_CURVE_ANNUAL' with GDSP as a function will retrieve the Sector based yield curve compounded annually. The applicable properties to use along with GDSP function are StartDate and tenor. The max tenor value you can pass is 30Y (30 Year tenor).

Returns a flattened dataset from the Trucost Envronmental Data similar to the legacy csv file delivery.

The following sample query returns all possible GICS Codes and descriptions. Tag: CoInd

The following sample query returns all possible GICS codes and descriptions (recursive reference query showing visual tree structure). Tag: CoInd

This query returns the consolidated revenues where available, otherwise the query generates non-consolidated values.

The following sample query gives bite size information of a particular company., Note: Change the companyId as needed, currently it runs for Bain Pvt Equity,LP.

The following sample query returns all current subsidiaries and its headquarters of a parent company along with the total revenue reported and converted to USD of the subsidiary companies., Note: Change the parent companyId as needed, currently it runs for IBM. For current investment change the companyRelTypeId=1

The following sample SQL query pulls consolidated and unconsolidated Financials income statement data.

The following sample query below displays U.S. import and export shipments for a particular ticker

The following sample query displays all levels of HS Code by category

The following sample query links Panjiva trade data to S&P Capital IQ Business Relationships data, by creating temporary table

The following query returns the recent changes for the companies by the Brokers.

The following sample query returns S&P, Moody's and Fitch Ratings with issuer number for the specific CompanyID

The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin M&A deals to CIQ Transactions offering packages.

This query returns the quarterly broker estimates for the upcoming quarter that have changed in the last 24 hours based on observation date.

The following sample query display data items for an aggregate entity -- NYC Commercial Banks.

The following SQL query returns MSA impact on raw ESG Scores for McDonald's Corporation for 2021 assessment.

This sample query returns ESG Scores in detail for Abbott Laboratories for 2019 assessment year., Note - This is applicable to legacy package.

This example shows how to create a query that displays the identifierTypeId associated with each identifier.

The following query generate a list of property M&A transactions for gold >500,000 ounces.

The query returns properties that are in the development stage in North America, with a copper resource greater than 500,000 tonnes of contained copper.

This sample query returns the Payment-In-Kind (PIK) bonds for a company using the S&P Capital IQ debt capital structure tables in Xpressfeed

This sample query retrieve the Toyo data: Owned company count per TSE 33 industry of an investor.

This sample query retrieve the history of financial auditors for Verizon Communications Inc.

This SQL query returns the CDS Slope - 5 year minus 1 year - RawRatio for Uber Technologies, Inc. starting in 2024.

This SQL query returns shipping factors for the AFL US universe for a specific date range where export market concentration is not NULL.

The following sample SQL query returns the IPO Transaction Prices using the SP Capital IQ Transaction Offering packages in Xpressfeed.

The following sample SQL query returns magnitude of restatements of Total Revenues within 500 days of original filings region wise. NOTE: Here it is only done for company, for a larger universe it will take some time to run.

The following SQL sample query returns Precious Metals bid ask volatility, forward curve data, risk reversals and market strangles as per a valuation date.

The following sample query returns the SQL equivalent for the API mnemonic IQ_EST_ACT_REV (Revenue Actual). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SP_EST_ACT_EPS (EPS Normalized Actual). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_INVENTORY_OUT (Days Outstanding Inventory). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_EBIT_INT (EBIT / Interest Expense). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the Data Item ID (dataItemId) along with the SP Capital IQ Excel Plug-In Formula (CIQ Plug-In ID)

The following sample query returns the SQL equivalent for the API mnemonic IQ_EBIT_MARGIN (EBIT Margin Percentage). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_ROCE (Return on capital employed (ROCE)). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_GROSS_MARGIN (Gross Profit Margin). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the current profile for a deletedObjectID

The following sample query returns the SQL equivalent for the API mnemonic IQ_AUM (Assets Under Management). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_PE_NORM (PE Normalized). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_SGA_MARGIN (SG&A Margin). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_EBITDA_MARGIN (EBITDA Margin %). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SP_EARNINGS_ANNOUNCE_DATE (Earnings Date).

The following sample query returns the SQL equivalent for the API mnemonic SNL_AUM_NET_CLIENT_FLOWS (AUM Net Client Flows). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns securities from the S&P Capital IQ population where the exchangeSymbol contains UNQ or where the exchangeName contains Unquoted in Xpressfeed

The following sample query returns the SQL equivalent for the API mnemonic SNL_TIER_1_COMMON_RATIO (Tier 1 Common Capital (CET1) Ratio). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query below retrieves buyback announcement data for S&P 500 constituents across a defined date range.

The sample query returns five‑year EPS growth by isolating contributions from business performance and share-count reductions, using buyback data to validate whether changes in shares outstanding were caused by active repurchase programs.

The following sample query evaluates buyback follow-through by comparing authorized versus executed buyback amounts over a rolling lookback period and computes the execution rate for a given company.

The following sample query returns all equities trading on a U.S. stock exchange using the SP Capital IQ tables in Xpressfeed

This query compares buyback activity across peers by measuring executed buybacks against market capitalization within an industry group.

This sample query returns the series of current EPS values for the 2025 fiscal year, adjusted for splits. Note: Detail Estimates (estPITDetailNumericData) are sourced from the XFL_Ownership_Intraday database.

The following sample query returns a list of Peer companies in the S&P 500 IT Services Industry and a Artificial Intelligence Topic Tag Name.

This query identifies the latest consensus data for periods.

The following sample query returns the institutionID from a company name using the SNL package in Xpressfeed

The following sample query returns annual flow data for a company using the SNL packages in Xpressfeed. Note: This example uses Cost-to-Income for Deutsche Bank AG

The following VA Industry Segmentation sample query lists every company reporting a named segment with the revenue analysts expect for upcoming calendar years and the number of analysts behind each estimate so you can read where the segment is headed and how firm the view is.

API request to return the top 10 Professionals of the passed in identifier with the associated professional title. The ranking is always current ranked by value. No history available. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

API request to pull time series exchange rates for the last year. All data is EOD. Identifiers supported are all ISO Currency Codes combinations.

API request to pull last 10 fiscal year end periods for total revenue, total assets and Filing Date. This request uses relative period type with an integer offset to control the number of periods returned and aligns perioddate with filing date with the MetaDataTag property.

API request to 1st request the last 10 unique transaction identifiers then request transaction data points for the specified transaction.

API request to 1st request all unique key dev event identifiers that are related to C2 - Announced or Completed Transactions for the last year. Then request key development data points for the specified event.

The following sample query returns region- and country-based count of companies with EBIT at risk for forecast year 2025, scenario level HIGH

The following sample query returns S&P 500 companies having unpriced carbon cost as a percent of EBITDA in excess of 50% for forecast year 2040, all scenarios

The following sample query returns Carbon Budget Alignment Summary for Exxon Mobil Corporation

This sample query returns quarterly Book Value Per Share for Analog Devices Inc. using the S&P Capital IQ Fundamentals in Xpressfeed

The following sample query returns Roche Holding AG Company (Non-SEC Filings) 2019 Annual Report.

This JSON request is using the mnemonic 'IQ_Z_CURVE_ANNUAL_DESC' with GDSPV as a function. This function retrieves an array (a set of values) for the most current availability of content either end of day or intraday. The applicable properties to use with the GDSPV are sector and rating. The output of this metric describes characteristics of the curve itself. The output columns include: 1. Number of Bonds, 2. Number of Credits, 3. Either 'Observed' or 'Derived', 4. Standard Deviation, and 5. Valuation Date.

Returns a flattened dataset from the Trucost Paris Alignment Data similar to the legacy csv file delivery.

The following sample query returns the industry tree for Coca-Cola Company, with related SIC codes. Tag: CoInd

The following sample query returns the S&P Capital IQ industry tree for AT&T. Tag: CoInd

The following sample query returns all possible industries in the S&P Capital IQ industry classification. Tag: CoInd

The following sample query returns the value of restricted stock units granted by current S&P500 index constituents in fiscal year 2020.

The following sample query returns all board members related to a company and his/her title and board rank., Note: Change the parent companyId as needed, currently it runs for IBM.

The following sample query pulls out top 10 transcations based on announced date and all other relevant information related to a particular company., Note: Change the companyId as needed, currently it runs for IBM.

The following sample SQL query pulls consolidated and unconsolidated income statement data side by side

The following sample query displays the first instance of the fully matching HS Code for a given panjivaRecordId

The following sample query links Panjiva trade data to S&P Global Market Intelligence industry sector data

The following sample query links Panjiva identifiers to S&P Capital IQ data. Note: Here TOP 100 are shown for better query execution

The following sample request will retrieve the Expanded Probability of Default (EPD) scores for General Motors Holdings LLC for the fiscal year 2019, latest as of July 30, 2021, using the new threshold property.

The following sample query finds data in countries that do not have a data source

This query screens the S&P Capital IQ Fundamentals database for the number of private companies with Total Revenues available. Please note that this query is specific to the S&P Capital IQ Fundamentals offering via Xpressfeed. There is additional private company financials data in our Private Company Fundamentals offering

Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining

The following sample query identifies all the current and prior funds sponsored by Yamaguchi Capital.

The following sample query identifies Current, Prior and cancelled fund investors of SA Corporate Real Estate Limited.

The following sample query identifies Current, Prior and cancelled fund investors of Shanghai Liansheng Venture Fund.

The following sample query returns the current GISF Entity rating based on Recordupdatedate and long term and short term assessment view.

The following sample query returns Physical Risk Asset Level Data for Ford Motor Company for scenario 'High' and forecast year 2050.

The following sample query returns global branches for JP Morgan Chase Bank at over 50 percent high risk of Water Stress for forecast year 2030.

The following SQL query returns all Score data points with Score and Value Description for CORP Score Group

The following SQL include all Score data points with Score and Value Description as well as rating data including Org Debt Type is equals to ICR, Entity Symbol Value, Entity Name, Rating, Rating Date, Outlook, Outlook Date, CreditWatch, CreditWatchDate.

The following sample query returns the rating and entitylevel data for the given LoanX symbol.

The following sample SQL query returns entities with an underlying Rating for Credit Program in Xpressfeed.

The following sample SQL query returns the current and historical sovereign ratings for a country using its country code.

The following sample SQL query returns the SP Global Ratings Sector and Instrument Type for an instrument for a set of ISINs using the Ratings v3 packages in Xpressfeed

The following sample SQL query returns the components of the Triple Component Rating, which is a combination of the long-term rating, Outlook or CreditWatch, and short-term rating

The following sample SQL query returns the current (ratingStatusIndicator = 1) Foreign Currency Preliminary LT (ratingTypeId = 276) and the Local Currency Preliminary LT (ratingTypeId = 278) ratings using the SP Capital IQ packages

The following sample SQL query returns all ISINs that have a current Unsolicited Rating using the SP Capital IQ packages in Xpressfeed

The following sample SQL query returns Commercial Paper (CP) ratings data and Maturity ID (maturityId) using the 6-digit CUSIP (CUSIP6) in Xpressfeed

The following sample SQL query returns the entity-level long-term and short-term ratings changes for the last 24 hours, including CreditWatch and Outlook changes

The following sample query returns the top 10 total operational square footage current market share

The following sample query returns the global view of data center knowledgebase metrics

The following sample query provide accurate estimate change stats as per company's Fiscal Quarter end dates.

The following sample query returns latest dividend details.

The following SQL query returns point in time data as per the ObservationDate, the FilingDate where PeriodEndDate will be less than or equal to ObservationDate.

The following sample query return a unique TIC, ISIN, CUSIP and SEDOL that represents the most recent public company for any given GVKEY.

This query calculates historical, company-level shares outstanding using the S&P Capital IQ Market Data and Equity Capital Structure packages in Xpressfeed for a particular CompanyId (Here for Apollo Global Management.Inc.)

The following SQL query returns industry grouping for S&P 500 companies as applied in Corporate Sustainability Assessment (CSA).

This sample query returns the top 10 most sustainable companies in the Automobile industry in 2019 assessment., Note - This is applicable to legacy package.

This SQL query returns the top 10 companies with the highest industry-relative monthly export shipment ratio for August 2025 using shipping factors time series data.

This SQL query returns unpivoted CDS to Equity Factors data for Trading Item ID 2630413 (Microsoft) as of a specific date.

This SQL query returns all CDS to Equity factors for the specific Trading Item ID as of a given date.

This SQL query returns CDS to Equity Factors data with the CIQ Company ID and GVKEY IID from the CIQ Base tables.

This SQL query returns the latest CDS to Equity Factors for Apple Inc.

This SQL query returns the hedge fund share ratio over time for a specified company, highlighting changes in hedge fund ownership based on institutional ownership time series data.

This SQL query returns the top 10 percentile companies based on their average Application Security rank for 2025

This SQL query returns the five worst-performing U.S. companies based on their 52-week BitSight Rating Z-score as of 31-Dec-2024.

This SQL query returns Returns the company’s Application Security, Patching Cadence, BitSight Rating raw ratios, and the distance from the industry median rating for the selected period, grouped by date.

This SQL query returns the average BitSight Rating by Region using the FBITSIGHTRATINGRAWRAWRATIO

The following sample SQL query rovide workaround to screen the SP Capital IQ Transactions package for Regulation D offerings in Xpressfeed. Note: Uncomment the second query for Private Placement Transactions (To optimize time select for Top 10000 companyIds)

The following sample SQL query returns the offering date for fixed-income offering of corporate bonds closed during 2017 for issuers located in specific countries using the SP Capital IQ Transactions package in Xpressfeed

The following sample query builds a corporate hierarchy (up to three subsidiary levels) for a given input company and identifies business relationships where the company or its subsidiaries act as either suppliers or customers. It retrieves the latest available relationship data and provides supplier, customer, subsidiary, hierarchy level, immediate parent, and connection value details in a consolidated output.

The following sample SQL query returns PIT Premium Financials Translated To USD using the Premium Financials Package NOTE: To run for full universe, comment out the companyId.

This SQL query returns the latest regional export and import exposure ratios for Abbott Laboratories across major global regions.

The following sample request fetches six key Early Warning Signal (EWS) 1.0 metrics—including signal, days, PD threshold, YoY PD change, and dimension statuses—for IQ1832129752 as of 02/28/2026 using the GDSP function. Note: For more details, please refer to EWS release notes

The following sample query returns the Primary Stock Exchange, including the name (exchangeName) and ID (exchangeId), from the SP Capital IQ Security Files in Xpressfeed

The following sample query returns the number of companies comprising the database population by country and region using the SP Capital IQ tables in Xpressfeed

The following sample request fetches six key Early Warning Signal (EWS) 1.0 metrics—including signal, days, PD threshold, YoY PD change, and dimension statuses—for IQ112350 over the date range 01/02/2026 to 01/10/2026 using the GDSHE function. Note: For more details, please refer to EWS release notes

The following sample query returns the inactive tickers for a company using SP Capital IQ tables in Xpressfeed

The following sample query returns the SQL equivalent for the API mnemonic SP_ENTITY_ID (Entity ID).

The following sample query returns the SQL equivalent for the API mnemonic SP_EST_EPS_SURPRISE_PERCENT (EPS Surprise Percentage). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_EST_ACT_NI (Net Income Normalized Actual). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_DEBT_EBITDA (Total Debt / EBITDA). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_PBV (Last Close Price / Book Value). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_REV (Total Revenues). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_DAYS_PAYABLE_OUT (Average Days Payable Outstanding). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_ASSETS (Total Assets). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_CASH_CONVERSION (Cash Conversion Cycle (Average Days)). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_EFFECT_TAX_RATE (Effective Tax Rate (Ratio)). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the currency name and currency ID for IBM (tradingitemid = 2621697) using the SP Capital IQ packages in Xpressfeed

The following sample query returns the SQL equivalent for the API mnemonic IQ_DAYS_SALES_OUT (Days Sales Outstanding (Average Receivables)). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_RETURN_EQUITY (Return On Equity %). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_RETURN_ASSETS (Return on Assets). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_AUM_NET_ACQUISITIONS_TRANSFERS_OTHER (AUM Net Acquisitions, Transfers & Other). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_OPER_INC_GROWTH (Operating Income Growth). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

This query analyzes share repurchase (buyback) trends at the sector level for S&P 500 constituents and benchmarks sector-level buybacks against overall index buybacks across a selected year range.

The following sample query returns credit default swaps data for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed

The following sample query returns all active suppliers for a company from the CIQ Business Relationships tables in Xpressfeed

The following sample query returns a list of deceased professionals for a company using the SP Capital IQ packages in Xpressfeed

The following sample query returns Sovereign GHG emissions history for Italy from 2021 to 2025.

The following query retrieves the latest valid LTM financials by selecting filings closest to the observation date and combines them with corresponding market data

The following sample query returns all pricing data in descending date order from the SP Capital IQ CIQPriceEquity table for the ticker PGF (PowerShares Financial Preferred)

The following sample SQL query returns consensus Capital Expenditure (CapEx) guidance values including base, high, and low for selected companies.

This request retrieves both the portfolio-adjusted maximum limit for each company within the specified watchlist and the corresponding company IDs. Note: For more details on functionality, please refer to Maxlimit 2.0 release notes.

The following VA Industry Segmentation sample query shows the revenue of a chosen segment and its share of total revenue for several named companies side by side so you can see who relies on it most.

The following VA Industry Segmentation sample query lists the segments a company reports for a chosen calendar year in parent to child order with a total revenue line, and for each line it shows revenue, year on year growth, share of revenue, and contribution to total growth.

The following sample query returns topic tags for Apple.

The following VA Industry Segmentation sample query lists the top reported segments for a company in a calendar year with the share of total revenue for each one, and a final line that adds to 100 percent.

The following sample query returns government issued govt. bonds owned by Berkshire Hathaway and reported in 2018 and 2019

The following sample query returns All Bonds And Stocks Disposed By New York Life Insurance since 2018

The following sample query returns yearly average CO2 emissions and gross generations of all powerplants in Texas

The following sample query returns Companies Under Berkshire Hathaway And Their Distribution Channels, Auditors And Actuaries

API request to request GICRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags.

The following sample query returns DIA 2017 Annual Report, along with the company name, filing language, source and type.

This query returns returns estimate values using the primary accounting standard

This sample query returns the number of companies that have segment data available before and after a specified date. Note: This example uses April 19, 2009 for the date

The following SQL query returns the default and ratings transitions of all instrument issues.

The following sample query returns Long term interest rates.

The following sample SQL query demonstrates how to view summary debt information for IBM over a 10-year period. Note: This sample query is for the Capital Structure Add-On delivered through the ciqFinCollectionData table in the Premium Financials Core Package

The following SQL query returns the R&D Stock Factor where the dataitemid is 100 for R&D Expenses.

The following sample query link the SNL institutionId to the Compustat GVKEY.

The following sample query link the SNL institutionId to the S&P Capital IQ companyId.

This query returns the Shares Outstanding in the Other Components section of Equity Capital Structure (ECS) for TerraForm Power in Xpressfeed

The following SQL query returns raw ESG Score breakdown for NextEra Energy, Inc. for 2021 Assessment.

The following SQL query returns historical raw ESG Score performance for NextEra Energy, Inc. for last 5 Years.

The following SQL query returns estimated (modeled) ESG Score breakdown for NextEra Energy, Inc. for 2021 assessment.

This sample query returns the ESG Score trend for top 10 companies in the Biotechnology Industry starting 2013, Note - This is applicable to legacy package.

This sample query returns the average S&P Global ESG Score for five countries in Latin America and Caribbean in 2019, for actively participating companies., Note - This is applicable to legacy package.

The following query returns all security identifiers for a particular company.

The following sample SQL queries display the currency in which financials were reported and convert the data to a target currency

The following query returns industrial format Income Statement, Balance Sheet, and Cash Flow Balancing Models with period end dates as the column names.

The following query returns list of metals and mining companies with 2020 gold exploration budget for Australia >US$1M.

The following sample SQL query displays data items associated with each Premium Financials Package. The dataItemGroupId corresponding to each package is listed in the where clause

The following sample query returns all Merger / Acquisition activities IBM has been involved with as Buyer or Seller in 2010 (showing company relationships).

This sample query retrieve the Toyo data: Industry-company composition.

This query returns the Price-to-Earnings (PE) ratio, Price to Book Value (PBV), and Total Enterprise Value (TEV) for IBM on a daily basis using the S&P Capital IQ Premium Financials packages in Xpressfeed.

This sample query returns all Alternate, Native and Search company names for Sony Corporation.

This sample query Identify auto parts companies headquartered in the U.S. and with an office in China or Japan, including all business descriptions.

This sample query link the SNL institutionId to the Compustat GVKEY.

The following SQL sample query returns Bond Repo Price, Par Rate and RFR Spread as per a valuation date.

The following sample query returns the SQL equivalent for the API mnemonic SP_ENTITY_NAME (Entity Name).

The following sample query returns the SQL equivalent for the API mnemonic IQ_EST_REV_SURPRISE_PERCENT (Revenue Surprise Percentage). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_NET_INC_MARGIN (Net Income Margin Percentage). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_LFCF_MARGIN (Levered Free Cash Flow Margin). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_DEBT_EQUITY (Total Debt/Equity). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_OPER_EXPEN (Total Operating Expenses). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_NET_INTEREST_INC (Net Interest Income). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic IQ_CAPEX (Capital Expenditure). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_ROE (Return on Average Shareholders' Equity). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_TOTAL_POLICY_INC (Total Policy Income). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_OPER_EXP_GROWTH (Operating Expense Growth). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

This query analyzes whether a company’s share repurchase (buyback) activity aligns with valuation indicators such as the P/E ratio and enterprise value (TEV) by linking buyback announcement dates with relevant market and financial data.

The following sample query returns Key economic data for Italy for the year 2024.

The following sample query returns current products for a company using the SP Capital IQ Products package in Xpressfeed

The following sample query returns trends in revenue and cost changes in customer-supplier relationships, helping predict future growth or declines.

The following sample query returns ISCRS (Industry Sector Cross Reference Service) data for IBM in Xpressfeed.

The following sample SQL query returns consensus Adjusted Funds From Operations (FFO) guidance values including base, high, and low for selected companies.

The following sample request retrieves IQ_MAXLIMIT_COMPANY_STANDALONE for the same company across multiple currencies (USD, INR, AUD). Note:- USD is used as the default currency if none is provided. For more details on functionality, please refer to Maxlimit 2.0 release notes.

The following request fetches IQ_MAXLIMIT_PORTFOLIO" for watchlistid:1198095291 using different properties (PFExpCap, risktolerance etc). Examples showing valid and invalid parameter combinations. Note: User can only pass 1 of the 3 inputs(RiskTolerance/PFExpCap/PFExpCapPct),. For more details on functionality, please refer to Maxlimit 2.0 release notes.

The following sample query returns the latest ownership holdings for a specified company for the most recent reporting period,excludes mutual fund owners, and provides shares held and percentage of shares outstanding.

The following query returns all merger and acquisition subsidiary transactions details of Buyer And Buyer - Target Role

The following sample SQL query returns topic tags and keywords for IBM.

The following sample SQL query returns topic tags and keywords for APPLE.

The following sample queryreturns a list of SNL Industry IDs in Xpressfeed

The following sample query looks for mentions of the keyword 'acquisition' in the isolated section of the filing.

The following sample query returns information about the annual flow data of Berkshire Hathaway Direct Insurance Company

The following sample query returns all filings companies under the ultimate parent travelers companies Inc with disposition as Of 2018 and 2019

The following sample query returns Contract Details Of The Northern Natural Gas Company Reported In 2020 With The Interconnect Natural Gas Facility

API requests for a single data point for company level reference data

API request to pull as-presented Revenue with associated financial line item name. As line item names can change over time this output will contain all line item names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

API request to 1st map CIQ id to BECRS Entity Rx id, then to request Issuer, local currency long term ratings. Please note, you must extract the primary and active RX id out of BECRS_ENTITY_RX and prefix a RX to the id returned prior to requesting the rating mnemonic.

The following sample query returns latest Index-based Median Fundamental PD and Implied Score for USA - Oil & Gas

The following sample query returns the GICS code and description for Intel Corporation, showing upper branches of GIC structure (recursive query). Tag: CoInd

This query returns the financial information for Celio EspaIa Moda Sa, a private company.

This query returns the data items associated with each Private Company Financials package.

The following sample query returns latest 10 key devs across catetories for announced/completed transactions, company forecasts & ratings, customer/product related., Note: Change the companyId as needed, currently it runs for FB.

The following sample query shows generic information related to a company along with previous day market cap, latest EBITDA and Total Revenue for most recent Fiscal Year., Note: Change the companyId as needed, currently it runs for IBM.

The following sample query displays all three levels of an HS Code in order to create a full six digit view

Top 10 private companies in United Kingdom with highest scope 3 downstream emissions in 2019

The following sample query returns the current GISF rating for the security based on Recordupdatedate given by the EntityIssuer and the associated ratingtype, maturitydate, currentcytype, etc.

The following sample query returns Entity Name with respective CompanyIDs mapped to SIC and NAICS codes

The following sample query identifies all the current and prior funds sponsored by BMO Fund Management Limited.

The following sample query returns the current GISF Assessment Rating for the security based on Recordupdatedate given by the EntityIssuer and the associated ratingtype, maturitydate, currentcytype, etc.

The following sample query returns the current GISF rating for the Instrument based on Recordupdatedate given by the EntityIssuer and the associated long term view.

The following query retrieves WACC for IBM company. User has choice to execute this query by changing parameters like SizePremium, Vcurrentyear, PeriodType, CalendarQuarter, TaxRate, CostOfDebt,CostOfPreferred, MarketReturn and IndexId. Please read the comments in query to get more information on the WACC Formulae and Input Parameters.

The following SQL query returns the companies and fiscal period between a given date range.

The following SQL query Display all data items within the Balance Sheet - Adjusted template organized by section.

The following SQL query generates data items associated with each S&P CreditStats Package. The dataItemGroupId corresponding to each package is provided in the commented text.

The following SQL returns scoreObjectSymbolValue, scoreDetailId, scoreObjectTypeId, scoreObjectName, scoreGroup, scoreType, scoreBusinessName, scoreValue, scoreValueDescription & scoreCurrentIndicator.

The following sample query returns receivables of all Companies in Texas for the last two fiscal years

The following sample SQL query returns a list of rating changes for a specific instrument type using the SP Capital IQ packages in Xpressfeed

The following sample SQL query returns the state codes for the top 100 Public Finance securities from the SP Credit Ratings package in Xpressfeed

This query returns the Unit Type Name (unitTypename) for data items using the S&P Capital IQ tables in Xpressfeed

The following sample SQL query returns the issue level ratings for a LoanX ID from the SP Credit Ratings package in Xpressfeed

The following sample SQL query returns securities that have multiple rating types where one is NR while the other(s) are actively rated using the SP Capital IQ packages in Xpressfeed

The following sample SQL query returns an issuer credit rating on a specific date in Xpressfeed

The following sample SQL query returns the current Entity Level Issuer Credit Rating for a company with a non-null QualifierValue using the Capital IQ data tables in Xpressfeed

The following sample SQL query returns the current long-term rating for a portfolio of Committee on Uniform Security Identification Procedures (CUSIP) numbers from the SP Credit Ratings package in Xpressfeed

The following sample SQL query returns securities based on the SP Capital IQ company ID (objectId) using the RatingsXpress v4 tables in Xpressfeed

The following sample SQL query returns the current long term rating for McDonalds from the SP Credit Ratings package in Xpressfeed

The following sample SQL query links a program to its securities using ratingDataItemId 82 in the spInstrumentLevelData table and using the Ratings v4 packages in Xpressfeed

The following sample query returns ESG Focused Financial Data Points for General Electric Company.

The following sample query calculates the dividend yield for all primary trading items on the observation date. Note: Because price and the indicated annual dividend may be in different currencies, both are converted to U.S. Dollars (USD) for the calculation.

The following sample query display a sample of multiple restatement data.

The following SQL query returns MSA impact details on raw ESG Score breakdown for McDonald's Corporation for 2021 assessment.

The following SQL query returns historical raw ESG Score breakdown for NextEra Energy, Inc. for Last 5 Years.

The following sample query pulls all S&P Capital IQ same day income data for the quarter specified. Please note that this query pulls data collected via Fast Financials (CIQ-FF). The Fast Financials data is meant to be there temporarily until our collection analysts have collected the data with all of the information analyzed in order to standardize and finalize the collection instance. The FF data in Xpressfeed is maintained for up to 90 days or until the same instance is collected via the full method, whichever comes first. As such, the calendar year and/or calendar quarter will need to be updated in the query in order to continue to retrieve the relevant data

This sample query returns the ESG Score trend for Biogen Inc. starting 2013., Note - This is applicable to legacy package.

The following query returns all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.

The following query returns list of properties based on commodity, total resource, grade & stage.

The following sample SQL query returns the Transaction Data Items.

The following sample query returns all bankruptcies announced in 2009 or later that have since emerged or reorganized (showing company relationships).

This sample query retrieve the Toyo data: Main company attribute data.

This sample query returns competitors of United Technologies Corp. by Industry.

This sample query returns the Hewlett-Packard Company’s new name.

The following sample query returns the SQL equivalent for the API mnemonic IQ_TOTAL_CL (Total Current Liabilities). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic Returns The SQL Equivalent For The API Mnemonic IQ_ASSETS_UNDER_ADMINISTRATION (Assets Under Administration). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the SQL equivalent for the API mnemonic SNL_TOTAL_REV_TO_AVG_EMPLOYEES (Total Revenue/ Avg Employees). Note: Minor differences between the Excel plugin and XF table results may occur due to aggregation and rounding.

The following sample query returns the primary identifiers for a company by using the companys ticker symbol using the S&P Capital IQ Base Security and GICRS Identifier packages in Xpressfeed

This sample query compares a company’s capital return approach over time by analyzing executed share buybacks and cash dividends paid, categorizing the firm annually as buyback‑focused, dividend‑focused, or balanced.

The following sample query returns Power Generation data for Italy from 2021-2025, distributed between multiple sources as a percent of total power generated.

The following sample query returns Standard Industrial Classification (SIC) codes and SIC descriptions using the Industry Sector Cross Reference Service (ISCRS) tables in Xpressfeed.

The following sample query returns the market capitalization for a company for the most recent period using the SP Capital IQ tables in Xpressfeed

The following sample SQL query returns currently effective Adjusted Funds From Operations (FFO) guidance including base, high, and low estimates for annual reporting periods.

The following sample query calculates the dividend-adjusted price time-series for IBM using the SP Capital IQ packages in Xpressfeed

The following sample query returns a list of SNL data items by industry in Xpressfeed

The following VA Industry Segmentation sample query screens all companies reporting a named segment such as Gold and keeps only those whose segment revenue falls inside a range you set.

The following VA Industry Segmentation sample query returns a clean roster of every covered company with its ticker, internal identifier, country, sector, and industry so you can locate and identify any name quickly.

The following VA Industry Segmentation sample query rolls up segment revenue across a weighted list of holdings and reports how much of the portfolio revenue is tied to each segment.

This API request pulls current total revenue and total assets values using relative period type

API request to pull equity time series pricing data. All data is EOD

API request to pull Geographical Segment Revenue with associated geographical segment name. As segments can change over time this output will contain all segment names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.

The following sample query returns data items in the Trucost Carbon Earnings at Risk data package.

The following sample query returns tonnes CO2e over 2 degree budget and current alignment for S&P 500 companies in decreasing order

The following sample query below returns Humana, Inc. 2017 10-K Filing

Return All The Data Items Delivered in The Trucost Climate Change Physical Risk Data Packages

The following sample query returns latest Index-based Median Market Signal PD and Implied Score for S&P 500

The following sample query returns country industry based on the Median Market Signal PD and Implied Score for USA - Oil & Gas

The following sample query returns local score from Global Metric PD value (CATypeId - 385)

The following sample query returns IBM's current PD values together with its daily stock price.

The following sample query returns latest Index-based Median Credit Model Score and Implied PD for S&P 500

The above JSON request using mnemonic 'IQ_DISCOUNT_FACTOR_CURVE' with GDST function will retrieve the historical values for a mnemonic over a range of dates. Using the GDST function, the applicable properties to use are StartDate, EndDate and Frequency.

Returns a flattened dataset from the Trucost Data similar to the legacy csv file delivery.

The following sample query returns the GICS code and description for Intel Corp. Tag: CoInd

The following sample query shows generic information related to a company financials for the last 5 periods (starting from current date) along with market capitalization., Note: Change the companyId as needed, currently it runs for IBM.

The following sample query returns all current competitors and its headquarters of a parent company along with the total revenue reported and converted to USD of the competitor companies., Note: Change the parent companyId as needed, currently it runs for Apple.

The following sample query displays a companys ultimate parent in S&P Capital IQ data

The following sample query returns all companies mentioned by IBM on their call, alongside the call text using NERD on Transcripts

The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin deals to CIQ Transactions offering packages.

The following sample query returns the currencyCode, amountOffered, identifierValue, etc by linking preqin deals to MI Transactions Rounds of Funding package.

The following sample query retrieves a specific company's business segment revenue for a specific period end date, along with the primary NAIC, SIC & GICS classification.

The following sample query retrieves LTM Net Income month-end entries for every month of the calendar, filling in the dataItemValue with the latest figure.

The following SQL include all Score data points with Score and Value Description as well as rating data including Org Debt Type is equals to ICR, Entity Symbol Value, Entity Name, Rating, Rating Date, Outlook, Outlook Date, CreditWatch, CreditWatchDate.

The following SQL query returns all Score data points with Score and Value Description for BANK Score Group.

The following sample SQL query returns securityId,instrumentId,entitySymbolValue from a ratingDataId in Xpressfeed

The following sample SQL query returns ratings data using the MaturityID in Xpressfeed.

The following sample SQL query displays the sources, values and filing dates for a specific company and data item as of a specific period end date

The following sample SQL query returns Muni ICR ratings for an entitys securities using SP Global Ratings packages in Xpressfeed

The following sample SQL query displays the original filings for a single data item for a given company

The following sample query returns the number of operational datacenters by country as of Dec. 31st 2020

The following sample query returns the datacenter knowledgebase regional dashboard

The following sample query retrieves five forward estimates using relative constant concept for given dataitems such as EBITDA, EBIT, Net Income, DPS, EPS & FCF for a given company.

The following sample query returns Environmental, Financial and Market Data points for S&P 500 Electric Utilities Companies for Fiscal Year 2020.

The following SQL query returns the Relative Strength Index for a specific company.

The following SQL query returns the instrument level CreditPro data item name.

The following SQL query returns the entity level CreditPro dataitem name.

The following sample query returns US versus China GDP values.

The following sample query returns GDP Growth Forecasts.

The following SQL query returns latest data available as per the ObservationDate where the FilingDate can be greater than ObservationDate.

The following sample query display data items from stock and flow tables for Bank of the West.

The following SQL query returns Industry Range and Averages against Historical Raw ESG Score Performance for NextEra Energy, Inc. (Last 5 Years).

The following SQL query returns estimated (modeled) ESG Scores for NextEra Energy, Inc. for 2021 Assessment.

The following sample query returns market derived signals data for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed

This sample query returns the current year revenue estimates for a company as of April 14, 2024. Note: Detail Estimates (estPITDetailNumericData) are sourced from the XFL_Ownership_Intraday database.

This query returns the individual tranches of a buyback transaction, showing how the repurchase was executed over time in terms of shares and monetary value, and allowing comparison with the total planned transaction size.

The following sample query returns comparables for properties within Thailand by commodity, stage, mining and processing methods, etc.

This API request pulls current total revenue and total assets values using relative period type

The following sample query returns all professionals related to a company and his/her title/biography., Note: Change the parent companyId as needed, currently it runs for IBM.

Returns Intensity Metrics For Jaguar Land Rover Automotive Plc

The following sample query returns the current GISF rating for the Entity based on Recordupdatedate and the associated ratingdate, creditwatchdate, outlookdate, etc.

The following sample query returns the current GISF rating for the Instrument based on Recordupdatedate given by the EntityIssuer and the associated long term and short term assessment view.

The following sample query returns Power Plant Sites of S&P 500 Electric Utility companies at medium risk scenario of Wildfire for forecast year 2050.

The following SQL returns scoreObjectSymbolValue, scoreDetailId, scoreObjectTypeId, scoreObjectName, scoreGroup, scoreType, scoreBusinessName, scoreValue & scoreCurrentIndicator.

The following sample SQL query returns the most recent and previous Recovery Rating using a CUSIP as the identifier in Xpressfeed

The following sample SQL query returns the Historical Financial Strength Rating for an insurance company in the SP Credit Ratings package

The following sample query provides historical to latest market cap as well as the currency for a given GVKey.

The following SQL query returns the default and ratings transitions of all issuers.

The following sample query returns dividend details.

The following SQL query returns the YTD total return with reinvested dividends.

The following SQL query returns raw ESG Scores for NextEra Energy, Inc. for 2021 Assessment.

This sample query derives score weights for 2019 assessment year industries., Note - This is applicable to legacy package.

The following query returns all trading items for a security.

The following query returns properties that have achieved a copper intercept >1% with an interval >50m in South America.

The following sample query returns U.S. Private Placement transactions that have closed in 2010 with Financial Institutions as investors (showing company relationships).

The following sample query returns all transaction history where Casey’s General Stores Inc. is the target, showing their advisors.

This sample query returns the global business addresses for Hewlett-Packard Co.

This sample query link the SNL institutionId to the S&P Capital IQ companyId.

The following sample query returns Region, Country and GICS Industry Group Based Count of Companies for Different Alignment Types

The following sample query returns local score from Global Metric Score value (CATypeId - 101)

The following sample query builds a quarterly change series for all available dates for quarterly EPS (EPSPXQ) for ICG Group Inc (GVKEY 122536) with data codes. Note: To build a time-series for quarterly sales (SALEQ), use c.item = 'SALEQ' and add", c.valuei AS saleq, c.datacode AS saleq_dc in the select statement

The following SQL sample query returns volatility and discount factor data on equity VolSwap as per a valuation date.

The following returns detailed financial data for the selected statement types like income statements, balance sheets, and cash flow reports for specified companies within a set date range and period type annual, quarterly, or YTD.

This query returns a list of all MSCI Indices in Xpressfeed

The following sample query calculates market value of preferred shares.To calculate Market Cap for Preferred Shares: (PRSHOQ + PNRSHOQ) * PRCCD.This query takes the most recent day of pricing for PRCCD.

This SQL query returns the latest instrument and price details for a given date, concentrating on a specific list of ISINs and batch identifiers.

This query returns the latest S&P Capital IQ broker detail recommendations for a company using the CIQ Estimates packages

This query returns target price as well as buy, sell and hold recommendations of IBM (112350) company for the analyst coverage using the S&P Capital IQ Estimates packages

This query pulls the Period Last Market Cap (dataItemId = 100010) using the S&P Capital IQ files in Xpressfeed for a specific period end date and a specific company

The following sample SQL query identifies the dataitemId and descriptions associated with the latest financials package

The following SQL sample query returns swaption normal volatilities, log normal volatilities expressed in absolute strikes as per a valuation date which also includes SABR parameters.

The following SQL sample query returns caplet floorlet normal volatilities, log normal volatilities expressed in absolute strikes as per a valuation date.

The following SQL sample query returns FX volatility, forward curve data, risk reversals and market strangles as per a valuation date.

The following sample SQL query returns the SP Capital IQ Security ID (securityId) for Repertoire General des Actions (RGA) identifiers using the Global Instruments Cross Reference Service (GICRS) package in Xpressfeed

The following sample query returns final industry tree branch in a company industry tree. Tag: CoInd

The following sample query returns the Activist Investor companies for The Clorox Company using the SP Capital IQ Ownership package

The following sample query returns the latest momentum factor scores for all companies, ranks and percentiles them within their respective sectors, and displays sector-relative rankings only for a selected stock basket (e.g., S&P 100).

This SQL query returns Bond to Equity Factors data with the CIQ Company ID and GVKEY IID from the CIQ Base tables.

This query returns S&P Capital IQ Estimates as of a specific observation date using the CIQ Estimates Consensus packages

The following demonstrates how to create and execute the necessary MS SQL queries to view a time series for a single data item for a company

The following sample SQL query tries to find out the current annual (periodTypeId=1) financial information about a particular company using the ticker symbol

The following sample SQL query displays the company name, the companys ultimate parent, and the country and region for both using the Business Entity Cross Reference System (BECRS) package in Xpressfeed.

The following sample query returns the top 20 shareholders for Microsoft Corporation using the CIQ Ownership package and the CIQ Professionals package in Xpressfeed

This sample query display annual flow data items for latest annual filings for a single company.

This sample query display all SNL institutionIds with restatements due to fiscal year changes.

This sample query returns dividend data for a specified tradingItemId and date range using the ciqDivFrequencyType table.

This sample query display latest quarterly total assets value for a single company.

This sample query identify prices for a range of dates using a CUSIP identifier through the ciqSymbol table. This query also pulls data from the ciqPriceDivAdjFactor and ciqPriceEquitySharesOutstanding tables.

This sample query returns shares held by owner type for a small list of companies.

The following sample SQL queries display multiple instances for one period for a single company

This sample query display data for a particular company/period type in a column-based format.

This sample query returns public float percent for Bank of America identified by ticker symbol.

This sample query display institutionIds with filings in the last week, month, or year.

This sample query returns Portfolio statistics by industry subtype for ALPS Advisers.

This sample query returns ownership details with top holders of Oracle Corp. by rank on 12/31/2009, with owner names and owner source, using the ciqOwnCompanyHolding table.

This sample query returns companies where the CFO had purchased shares on the open market during the past 2 months.

This sample query returns aggregate issue-level ownership information for Berkshire Hathaway Class B shares.

This sample query identify how the underlying funds are rolled up to the parent investment manager and their aggregated funds for a given owner (e.g., Wells Fargo & Company).

This sample query compare the positive to negative sentiment between analysts and executives on a particular call.

This sample query returns the non-forecast level data for metric 'Drought' for Ford Motor Company for year 2022.

This sample query provides top 10 private auto premium underwriter in colorado in 2021.

This sample query provides period offset

This sample query rolls up into parent lob category, category, LOB line of business for Metlife.

The query below gives direct premiums written data for all lines of business during the year 2016 and period type Annual (Flow data and Geo type - State).

The following is a sample query that pulls the fund distributor, advisor, and sponsor for an ETF.

This sample query pulls the current professional managers for an ETF.

This sample query returns Portfolio Style of Vanguard Wellington Fund indicating the portfolio value, growth and dividend yield scores.

This sample query display high/low annual stock price value for a single company.

This sample query returns the view metric types and values for each component of a transcript. Please note this sample query uses the componentText field in the ciqTranscriptComponent table in the Transcripts package. This field is not provided in the Textual Data Analytics - Transcripts Core File.

This sample query returns the forecast based exposure score data for metric Drought, and for new sensitivity adjusted metrics for expanded forecast horizon of '2080' and 'Medium' scenario level for Ford Motor Company

The query below gives the information about the flow data of a company for the fiscal year 2021. (Income Statement data).

This sample query pulls all ETFs associated with a specific asset category, in this case, coffee. You can find the appropriate style classification code in the style classification tree

This sample query display annual stock data items for the latest annual filings for a single company.

This sample query display a single list for a particular company/period type.

The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the best instance to use if you are trying to select between these two instances. A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release), To view the latestbest source for a company, always screen for latestForFinancialPeriodFlag=1

This sample query returns annual dividends in December 2009 for German companies traded on the Deutsche Boerse, from the ciqDividendCache and ciqDividend tables.

This sample query returns securities experiencing more insider buys than sells in the past 3 months.

This sample query returns securities experiencing at least 5 different insiders who had purchased shares in the prior 3 months but no sellers as of 12/31/2010.

This sample query returns public float group shares held by holding type for a specified group of securityIds.

This sample query returns Portfolio statistics by region subtype for SEI Investments Company.

This sample query returns the Data for physical risk sensitivity adjusted scores for S&P 500 companies for year 2022 for eight physical risk indicators.

The query below gives direct losses unpaid during the year 2016 (Stock data and Geo type - State)

This sample query identify US public companies with non-traded shares outstanding that have a market cap of more than $20 billion.

This sample query identify the currency for market cap and TEV figures in the ciqMarketCap table.

This sample query identify companies that trade primarily on the NYSE and had a stock split during the 2006 calendar year. Also included are the ciqSplitCache and ciqSplitType tables.

This sample query list the top 50 holdings of Fidelity Contrafund as of 12/31/2011

This sample query display quarterly total assets for a single company.

This sample query returns portfolio turnover for the Fidelity Contrafund.

This sample query returns Portfolio Statistics by market cap subtype for Janus Capital.

The following sample query below Calculating Moving Averages in CIQ Price Equity for company Andeavor Logistics LP (Tradingitemid - 119026799)

This sample query returns historical Public Float Percentage and Number of Public Float Shares for Apple Inc.

This sample query uses Ownership Float History data linked to the S&P Capital IQ Base Data Sets, Premium Financials and Market Data packages.

This sample query returns aggregate company-level ownership information for Berkshire Hathaway.

This sample query list the current holdings of Fidelity Contrafund (based on most recently available reporting and current prices).

This query pulls in the most recent EPS items for a specific company, period type, and filing type from Xpressfeed. Note:Here IBM is taken as an example and periodType is Annual

To assist our SQL Server clients, we have created a sample Full-Text Index script against the ciqTranscriptComponent table and ComponentText column which assists in improving query performance (speed of queries improved ~9x based on our testing). The ComponentText column within the ciqTranscriptComponent table is a SQL nvarchar(max) datatype that contains large strings of text. Using the LIKE predicate in the WHERE clause against this column results in slow query speeds. With Full-Text Indexing, users are able to use the CONTAINS predicate which utilizes the Full-Text Indexed columns thus improving query speed.

This sample query compare the fog index on all available calls from IBM since 2013

This query takes an observation date, and then for a universe of companies determines the most recent annual filing as of the observation date. Query can be customized for other period types and data items

The query below gives the information about the stock data of a company for the fiscal year 2021. (Balance Sheet data).

This query returns the most recent(Latest Period Flag=1) annual(periodTypeId=1) fundamental financial data for Teletech Holdings Inc (companyId = 348722) in the Latest Financials package

This following sample query that pulls style classification codes and their names for a particular asset class, in this case Commodity.

This sample query pulls the sector emphasis for an ETF and the sector emphasis hierarchy.

This sample query pulls a benchmark for an ETF.

This sample query that pulls all S&P Global Market Intelligence ETF characteristics for a companyId.