Query Library
Search a comprehensive library of pre-built queries designed to help you quickly maximize the value of our data offerings. For each query, the library provides a brief description along with the data packages necessary to execute the query.
Recently Added
Returns Physical Risk Asset Level Data
Version Date:11/12/2024
The following sample query returns Physical Risk Asset Level Data for Ford Motor Company for scenario 'High' and forecast year 2050.
Data Packages
Returns ParameterIDs Or Line Items Available For A Specific Company
Version Date:11/06/2024
This query provides a data dictionary of parameters available, for a specific company. (Note: This works for both versions (basic and enhanced) of the packages; the final data that will be returned is based on your subscription.)
Data Packages
Returns Import And Export Shipment Statistics For A Specified Company And Its Subsidiaries Based On CompanyID, Country, Start Date, And EndDate, Including Imports And Exports Of All 19 Countries
Version Date:11/04/2024
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
Data Packages
Returns MarketCap For All Compustat GVKeys On A Particular Day
Version Date:11/01/2024
The following sample query provides market cap for all GVKeysas well as the currency for a given GVKey.
Data Packages
Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed
Version Date:10/08/2024
This query returns constituents and weights using MSCI month-end index data using S&P Capital IQ index data.
Data Packages
Returns All US Equities With A Value On Loan Greater Than One Million
Version Date:10/08/2024
The following sample query returns all US Equities with a value on loan greater than one million.
Data Packages
Returns Value On Loan For The Last Three Years
Version Date:10/08/2024
The following sample query returns Value On Loan for the last three years for BYND.
Data Packages
Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ
Version Date:09/18/2024
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.
Data Packages
Returns State Level Municipal Physical Risk Data
Version Date:08/30/2024
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.
Data Packages
Returns Revenue Level Alignment Metrics For Iberdrola S.A.
Version Date:08/23/2024
This following sample query returns revenue level alignment metrics for Iberdrola, S.A.
Data Packages
Returns EUT As Reported Data For Iberdrola S.A. For Year 2022
Version Date:08/23/2024
This following sample query returns EUT As Reported data for Iberdrola, S.A. for year 2022.
Data Packages
Returns Companies In France With Eligible Revenue Exposure Percentage Revenue For Manufacturing Sector
Version Date:08/12/2024
This following sample query returns companies in france with eligible revenue exposure Percentage Revenue for manufacturing sector
Data Packages
Returns The Company Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Version Date:07/17/2024
This following sample query returns company level EUT independent assessment data for iberdrola, S.A. for latest year
Data Packages
Returns Sector Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Version Date:07/17/2024
This following sample query returns sector level EUT independent assessment data for iberdrola, S.A. for latest year
Data Packages
Returns The Total Eligible And Total Aligned Data Split By Revenue For Iberdrola, S.A.
Version Date:07/17/2024
This following sample query returns total eligible and total aligned data split by revenue for iberdrola, S.A.
Data Packages
Returns Physical Risk Asset Financial Impact Data For Companies For A Forecast Year And Scenario Level Using Dynamic Pivot
Version Date:07/16/2024
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.
Data Packages
Returns Average TEV/NTM Total Revenue Value For A Company For An Observation Year
Version Date:07/12/2024
This sample query returns average TEV/NTM Total Revenue Value for a company for an observation year.
Data Packages
Returns All Participants In Conferences Announced By A Company
Version Date:07/03/2024
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.
Data Packages
Returns Linkage Of Transcripts To Events
Version Date:07/03/2024
This query links transcripts to events for Apple Inc. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns Earning Calls For A Company
Version Date:07/03/2024
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.
Data Packages
Display List Of Speakers CFOs For A Company
Version Date:07/03/2024
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.
Data Packages
Returns Speakers Who Were CFOs At That Time For A Companys Conference
Version Date:07/03/2024
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.
Data Packages
Display All Participants In HSBCs Conferences Announced In The Last Three Years
Version Date:07/03/2024
This query retrieves all participants in HSBC\x92s conferences announced in the last three years. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns Earnings Calls For A Company With Additional Details
Version Date:07/03/2024
This query retrieves detailed information on earnings calls for a specific company. Note: The Global Events Plus package is required to run this query.
Data Packages
Display All Charles Schwab Corporation Board Meetings
Version Date:07/03/2024
This query lists all board meetings of Charles Schwab Corporation. Note: The Global Events Plus package is required to run this query.
Data Packages
Display After Market Earnings Releases For A Specific Date
Version Date:07/03/2024
This query displays after-market earnings releases for a specific date. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns SFDR Data And EVIC In USD And EUR
Version Date:06/27/2024
This following sample query returns SFDR data and EVIC in USD and EUR for a given company.
Data Packages
Alternative Propulsion System Distribution
Version Date:06/25/2024
This query retrieves the distribution of different alternative propulsion systems by their Design Parent.
Data Packages
Key Developments Announced In The Last Month
Version Date:06/25/2024
This query retrieves key developments announced in the past 30 days. Note: The Key Developments Plus package is required to run this query.
Data Packages
Sales Volume By Vehicle And Cab Type
Version Date:06/25/2024
This query calculates the total sales volume by vehicle and cab type.
Data Packages
Year Over Year Sales Growth By Region
Version Date:06/25/2024
This query identifies the year-over-year sales growth for each region.
Data Packages
Total Sales Volume By Vehicle Type
Version Date:06/25/2024
This query calculates the total sales volume for each vehicle type.
Data Packages
Time Series Analysis Of Key Developments
Version Date:06/25/2024
This query provides a monthly count of key developments for trend analysis. Note: The Key Developments Plus package is required to run this query.
Data Packages
Average Sales Volume By Region
Version Date:06/25/2024
This query calculates the average sales volume for each region.
Data Packages
Total Production Powertrain Volume By Country
Version Date:06/25/2024
This query calculates the total production powertrain volume of commercial vehicles by country.
Data Packages
Vehicle Count By Emission Level
Version Date:06/25/2024
This query counts the number of vehicles for each emission level.
Data Packages
Key Developments By Event Type In The Last Week
Version Date:06/25/2024
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.
Data Packages
Impact Analysis Of Executive Changes
Version Date:06/25/2024
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.
Data Packages
Key Developments With Advisor Role Type
Version Date:06/25/2024
This query retrieves key developments where the company role type is Advisor. Note: The Key Developments Plus package is required to run this query.
Data Packages
Production Volume Trend Over Time
Version Date:06/25/2024
This query shows the trend of production powertrain volumes over time.
Data Packages
Duration Of Key Developments In Database
Version Date:06/25/2024
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.
Data Packages
Most Active Companies In Key Developments
Version Date:06/25/2024
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.
Data Packages
Top 5 Event Types By Number Of Changes Within 15 Minutes
Version Date:06/25/2024
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
Data Packages
Key Developments By Source Type
Version Date:06/25/2024
This query counts key developments by their source type. Note: The Key Developments Plus package is required to run this query.
Data Packages
Sales Volume Trend By Period
Version Date:06/25/2024
This query shows the trend of total sales volume over different sales periods.
Data Packages
Detailed Emission Levels By Vehicle Type And Manufacturer
Version Date:06/25/2024
This query provides detailed emission levels categorized by vehicle type and manufacturer.
Data Packages
Sales Volume By Company
Version Date:06/25/2024
This query calculates the total sales volume for each company.
Data Packages
Average Engine Displacement By Manufacturer
Version Date:06/25/2024
This query calculates the average engine displacement by manufacturer.
Data Packages
Engine Performance Comparison By Configuration And Aspiration
Version Date:06/25/2024
This query compares the performance of engines based on their configuration and aspiration.
Data Packages
Top Manufacturers By Region And Vehicle Type
Version Date:06/25/2024
This query identifies the top manufacturers in each region by vehicle type and production powertrain volume.
Data Packages
Forecasted Versus Actual Production Volumes By Period And Region
Version Date:06/25/2024
This query compares forecasted and actual production volumes by period and region.
Data Packages
Top 5 Countries By Sales Volume
Version Date:06/25/2024
This query identifies the top 5 countries by total sales volume.
Data Packages
Returns Median PD Fundamentals Country Industry Benchmark Data As Per A Company
Version Date:06/11/2024
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.
Data Packages
Total BEV Sales Volume Trend Globally
Version Date:06/07/2024
This query provides the annual trend of global sales volumes for Battery Electric Vehicles (BEVs), highlighting the growth over the years.
Data Packages
Production Volume By Country In A Specific Year
Version Date:06/07/2024
This query provides the total production volume for China in the year 2024.
Data Packages
Production Volume Trend For A Specific Country
Version Date:06/07/2024
This query shows the yearly production volume trend for China.
Data Packages
Market Share Percentage By Company For A Specific Year And Country
Version Date:06/07/2024
The query calculates the market share percentage of different companies in China for the year 2023.
Data Packages
Production Volume By Production Type For A Country And Specific Year
Version Date:06/07/2024
This query provides the total production volume by production type for China in 2023.
Data Packages
Production Volume For Sub Segments Globally For A Specific Year
Version Date:06/07/2024
This query shows the total global production volume for each sales sub-segment in 2023.
Data Packages
Sales Volume Trend For Company And Cybertruck By Year
Version Date:06/07/2024
The query shows the sales volume trend for the Cybertruck over the years.
Data Packages
Global Propulsion System Design Trend Volume
Version Date:06/07/2024
This query illustrates the global sales volume trends for different propulsion systems across years.
Data Packages
Auto Brand Growth Comparison By Country From 2023 To 2024
Version Date:06/07/2024
The query compares the growth of different auto brands in China between the years 2023 and 2024.
Data Packages
BEV Sales Growth Comparison By Brands In China From 2023 To 2024
Version Date:06/07/2024
This query compares the sales growth of BEV brands in China between the years 2023 and 2024.
Data Packages
Production Volume Trend Globally
Version Date:06/07/2024
This query shows the total global production volume for each year.
Data Packages
Sales Volume By Global Sales Segment In A Specific Year
Version Date:06/07/2024
The query displays the sales volume by global sales segment for the year 2023.
Data Packages
Models With Production Volume By Region For A Specific Quarter And Year
Version Date:06/07/2024
This query lists the models with the highest production volume in Europe for the fourth quarter of 2023.
Data Packages
Production Volume Of Top 10 Assembly Plants For A Specific Year
Version Date:06/07/2024
This query lists the top 10 assembly plants by production volume in 2023.
Data Packages
BEV Market Share By Company For A Specific Year
Version Date:06/07/2024
This query shows the market share of various companies in terms of BEV sales for the year 2023.
Data Packages
Domestic Versus Import Sales Volume Trend For China
Version Date:06/07/2024
The query compares domestic versus import sales volume trends for China over the years.
Data Packages
Total BEV Sales Volume By Country In A Specific Year
Version Date:06/07/2024
This query displays the total sales volume of Battery Electric Vehicles (BEVs) in China for the year 2023.
Data Packages
Sales By Propulsion System Design For A Specific Country And Year
Version Date:06/07/2024
This query outlines the sales volume for different types of propulsion systems in China for the year 2023.
Data Packages
Sales Volume Trend Globally
Version Date:06/07/2024
The query displays the total global sales volume trend over the years.
Data Packages
Returns All Firms Using A Specific Manager By Name And/Or Managed Allocation
Version Date:05/17/2024
This following sample query returns all firms using a specific manager by Name and/or managed allocation.
Data Packages
Returns Low, High, Close And Average TEV/LTM EBITDA Values For A Company As Per An Observation Date
Version Date:05/16/2024
The following sample SQL query returns low, high, close and average TEV/LTM EBITDA values for a company as per an observation date.
Data Packages
Returns All The Exchangecodes For The MmdentityIds Using Dynamic Pivot
Version Date:05/16/2024
This following sample query returns all the exchangeCodes for the mmdentityids using dynamic pivot
Data Packages
Returns All The Exchangecodes For The MmdentityIds Pivot
Version Date:04/29/2024
This following sample query returns all the exchangeCodes for the mmdentityids using pivot
Data Packages
Returns The Industry Hierarchy For The Company
Version Date:04/29/2024
This following sample query returns the industry hierarchy for a selected company
Data Packages
Returns Company Tree And Associated Ratings
Version Date:04/25/2024
This following sample query returns company tree with entity relationships and its associated ratings
Data Packages
Returns Issue Level Municipal Physical Risk Data For Fixed Income Securities
Version Date:04/15/2024
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.
Data Packages
Returns GDP Weighted US Exposure Score
Version Date:04/15/2024
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.
Data Packages
Retrieve All Tenders For Company
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Unique Country List
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Tenders For Country
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve The Price Each Product Was Traded At By Each Seller Between Specific Time Range
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve The Buyers And Sellers Who Participated In The MOC On 2021-01-20
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Consummated Platts Dubai Trades For November 1 2022
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Trade Data Between 2020-12-31, Limit The Fields Returned, Sort The Response By Market Maker
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Flow Data For The Past Two Days
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All FlowData Values For The Past 5 Years
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For A Specific PipelineName
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Flow Data For The Past 5 Years
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Historical Contract Values For a List Of Curves And Assessment Date Range
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Return All Outages For Refineries Operated By BP In 2020
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Short-Term Refined Product Price Forecast For 2024
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Get Annual Crude Production For Iran In 2022
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Latest Scenarios
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Aggregated Values
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Latest Contract Values For a List Of Curves
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Returns Margins For Dubai Singapore Topping
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Get The Total Crude Supply For December 2022 In Iran
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Return All Unplanned Outages Happening In The US On a Specific Date
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
2023 Best Selling Toyota Models
Version Date:03/05/2024
This query identifies the top 5 best selling Toyota models in 2023, showing which models were most popular.
Data Packages
Make Price Versus Revenue Analysis
Version Date:03/05/2024
This query calculates the total revenue and weighted average MSRP for each company in the year 2023.
Data Packages
Detailed Make Features And Types For 2023
Version Date:03/05/2024
This query provides a detailed overview of vehicle make features and types for the year 2023.
Data Packages
2023 Price Versus Revenue Model Analysis
Version Date:03/05/2024
This query evaluates AutoCompanies in 2023 by comparing their total revenue and average Manufacturer's Suggested Retail Price (MSRP) per model sold.
Data Packages
AutoCompanies Revenue In Q4 Of 2023
Version Date:03/05/2024
This query calculates the total revenue for auto companies in the fourth quarter of 2023.
Data Packages
2023 Model Revenue
Version Date:03/05/2024
This query calculates the total revenue for each model, for the year 2023.
Data Packages
Weighted Average MSRP Model Pricing Overview In 2023
Version Date:03/05/2024
This query calculates the weighted average Manufacturer's Suggested Retail Price (MSRP) for each car model in 2023.
Data Packages
2023 Make Sales Rankings By Subsegment
Version Date:03/05/2024
This query calculates the total sales volume for each vehicle make's subsegment in 2023.
Data Packages
Fuel Data Accuracy In 2023
Version Date:03/05/2024
This query assesses the accuracy of fuel data for each model by calculating the percentage of estimates versus actual data in 2023.
Data Packages
2023 Greece Model Market Share
Version Date:03/05/2024
The query calculates the market share of different vehicle models in Greece for the year 2023.
Data Packages
Propulsion System Make Sales And Prices In 2023
Version Date:03/05/2024
These queries analyze the sales and prices of vehicles by their propulsion system for the year 2023.
Data Packages
Tesla Model 3 Sales Trends
Version Date:03/05/2024
This query presents the monthly sales trends of Tesla Model 3 for the year 2023.
Data Packages
2023 BEV Market Insights
Version Date:03/05/2024
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.
Data Packages
Top Electrified Model Markets In 2023
Version Date:03/05/2024
This query identifies the top five markets for electrified models in 2023, focusing on electric propulsion systems.
Data Packages
Unique Vehicle Makes Overview
Version Date:03/05/2024
This query selects distinct vehicle makes. The results are ordered alphabetically by the make of the vehicle.
Data Packages
Year Over Year Make Sales Growth For 2023
Version Date:03/05/2024
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.
Data Packages
2023 Model Country Sales Overview
Version Date:03/05/2024
This query provides a sales overview for each country in 2023, highlighting the countries with the highest vehicle sales.
Data Packages
Weighted Average MSRP Vehicle Make Prices In 2023
Version Date:03/05/2024
This query calculates the weighted average MSRP for each vehicle make in 2023.
Data Packages
2023 Propulsion System Model Sales
Version Date:03/05/2024
This query ranks the model sales by their propulsion systems in 2023, showing which types of propulsion systems were most popular.
Data Packages
Top 10 Best Selling Vehicle Makes Of 2023
Version Date:03/05/2024
This query calculates the average sales volume per company for the year 2023, ranking the top 10 best selling vehicle makes.
Data Packages
Top 5 United States Vehicle Makes By 2023 Sales
Version Date:03/05/2024
This query lists the top 5 vehicle makes in the United States, by sales volume in 2023.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve all Column And View Definitions From The Data Dictionary
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Returns Net Zero Pathway Data For British American Tobacco Company
Version Date:03/01/2024
The following sample SQL query returns net zero pathway for British American Tobacco company (SBTI commitment to set net zero target).
Data Packages
Capital Expenditure Breakdown By CompanyIDs And Latest Segment With GICS Codes
Version Date:03/01/2024
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.
Data Packages
Returns Commitment Level Data For British American Tobacco Company
Version Date:03/01/2024
The following sample SQL query returns commitment level data(interims) for British American Tobacco company (SBTI commitment to set net zero target).
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date for MI Keys
Version Date:02/21/2024
The following sample query Returns Point In Time EVIC Data Available As Per The Observation Date for MI Keys
Data Packages
Returns Datacenters Aggregated By 451 Market
Version Date:01/26/2024
The following sample query returns values from the Datacenter Knowledgebase aggregated by 451 Market for a selected period.
Data Packages
Returns The Datacenter List From Datacenter Knowledgebase
Version Date:01/26/2024
The following sample query returns the datacenter list for a selected period.
Data Packages
Returns Mortgages Expiring Within 6 Months In Texas
Version Date:01/17/2024
The following sample query returns mortgages expiring within 6 months in Texas.
Data Packages
Returns The Probability Of Default At The State Level
Version Date:01/17/2024
The following sample query returns the probability of default at the state level for a selected business listing.
Data Packages
Returns The Business Listings Link To SNL Institutions
Version Date:01/17/2024
The following sample query returns business listings with their link to institutionId.
Data Packages
Returns Business Listings With UCC Filings And Commercial Properties
Version Date:01/17/2024
The following sample query returns the business listing for Six Flags New England and its link to UCC Filings and Commerical Properties.
Data Packages
Standard Interest Rates
Version Date:12/18/2023
Standard interest rates for 30-year fixed mortgages at Citibank, N.A. branches in California.
Data Packages
Average Bank Product Rate
Version Date:12/18/2023
The following query provides the average bank product rates as of a specific date.
Data Packages
Parent Operating Bank
Version Date:12/18/2023
This query lists parent banking institutions by the number of banking products they offer.
Data Packages
Competitive Interest Rates
Version Date:12/18/2023
This query identifies the top 10 banks in California offering the most competitive 30-year fixed mortgage rates
Data Packages
NY Branches
Version Date:12/18/2023
The query below displays the 30-year fixed mortgage rates offered by Citibank NA branches in New York, covering a specific date range.
Data Packages
Rates During A Specific Timeframe
Version Date:12/18/2023
This query shows the 30-year fixed mortgage rates at Citibank NA branches in New York, within the specified date range.
Data Packages
Returns All Companies With A Specific Revenue Range Or Ownership Range In A Screen For The Latest FY
Version Date:12/15/2023
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)
Data Packages
Returns All Involvements (Screening Lists) Of A Specific Company (KI - 4000193) For The Latest FY
Version Date:12/15/2023
Returns All Involvements (Screening Lists) Of A Specific Company (KI - 4000193) For The Latest FY
Data Packages
Identify All The Topic Tags Along With Keyword Combination
Version Date:11/10/2023
The following sample SQL query identifies all the topic tags along with keyword combination.
Data Packages
Returns Topic Tags And Keywords For IBM
Version Date:11/10/2023
The following sample SQL query returns topic tags and keywords for IBM.
Data Packages
Market Cap To Float USD Currency Conversion With Average 30 Day Trading volume
Version Date:11/03/2023
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.
Data Packages
Assets With Overlapping Key Biodiversity Areas And Key Protected Areas
Version Date:10/30/2023
For Toyota Motors, in fiscal year 2021, here are the assets with overlapping Key Biodiversity area(s) and Key Protected area(s).
Data Packages
Top 10 Assets Owned By The Company On The Basis Of Ecosystem Footprint
Version Date:10/30/2023
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.
Data Packages
Trucost EVIC As Per Financial PeriodEndDate
Version Date:10/26/2023
The following query provides the Enterprise Value to Invested Capital for Trucost.
Data Packages
Returns Latest EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
The following SQL query returns latest data available as per the ObservationDate where the FilingDate can be greater than ObservationDate.
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
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.
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
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.
Data Packages
Returns Premium Financials Data Items Like Net Income, Net Income Margin, Total Revenue Etc
Version Date:10/19/2023
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.
Data Packages
Returns Net Income Margin Estimates
Version Date:10/19/2023
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.
Data Packages
Returns Return on Invested Capital(ROIC) For Premimum Financials
Version Date:10/19/2023
This sample query uses CompanyID, datobserve and currencyCode to give ROIC.
Data Packages
Returns The Total Number Of Companies With Market Cap Greater Than USD 25 Million Grouped By The Year Ranges And Region The Primary TID Is Trading At
Version Date:09/27/2023
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
Data Packages
Returns The Total Number Of Companies With Market Cap Greater Than USD 25 Million In The Database Grouped By The Region The Primary TID Is Trading At
Version Date:09/27/2023
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
Data Packages
Returns The Total Number Of Operating And Operating Subsidiary Companies Grouped By Simple Industry Description And Company Type
Version Date:09/26/2023
This following sample query returns the total number of operating and operating subsidiary companies grouped by simple industry description and company type
Data Packages
Returns The Total Number Of Operating And Operating Subsidiary Companies Grouped By The 4th Level Primary Industry Classification And Company Type
Version Date:09/26/2023
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
Data Packages
Price With Reference Data For Specific ASOF
Version Date:09/18/2023
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.
Data Packages
Price And Liquidity With Reference Data For A Specific Pricing Batch And ASOF
Version Date:09/18/2023
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.
Data Packages
Recommended Update
Version Date:09/18/2023
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.
Data Packages
Recommended Updates With Basic Reference Data
Version Date:09/18/2023
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.
Data Packages
Evaluated Price For A Specific Asof
Version Date:09/18/2023
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.
Data Packages
Liquidity With Basic Reference Data For Specific ASOF
Version Date:09/18/2023
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.
Data Packages
Live Pricing For Specific Asof
Version Date:09/18/2023
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.
Data Packages
Liquidity For Specific Asof
Version Date:09/18/2023
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.
Data Packages
Reference Data
Version Date:09/18/2023
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.
Data Packages
Basic Reference Data With Organization
Version Date:09/18/2023
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.
Data Packages
Lists All Family Offices Firms Where Charles Schwab Is Custodian
Version Date:09/11/2023
This following sample query Lists all Family Offices firms where Charles Schwab is Custodian.
Data Packages
Returns List All Family Offices Firms In United States With Assets Greater Than 1 Bn
Version Date:09/11/2023
This following sample query returns List all Family Offices firms in United States with assets greater than 1 Bn.
Data Packages
Searches For All Contacts Of Family Offices Firm For Cazenove Capital Management Limited
Version Date:09/11/2023
This following sample query Searches for all contacts of Family Offices firm for Cazenove Capital Management Limited.
Data Packages
Returns Outlook And Risk Scores For US Sub-Aggregate Categories In The Last 180 Days
Version Date:08/30/2023
The following sample query returns outlook and risk scores for US sub-aggregate categories in the last 180 days.
Data Packages
Returns Risk Of Inflation For Europe Vs Asia/Pacific Since The Last Year
Version Date:08/30/2023
The following sample query returns risk of inflation for Europe vs Asia/Pacific since the last year.
Data Packages
Returns Security Risk Worldwide In The Last 90 Days
Version Date:08/30/2023
The following sample query returns security risk worldwide in the last 90 days.
Data Packages
Returns All The Distinct Risk Categories Including Aggregates And Sub-Aggregates
Version Date:08/30/2023
The following sample query returns all the distinct risk categories including aggregates and sub-aggregates.
Data Packages
Returns The Risk Of Currency Depreciation Between USD vs GBP vs CAD Since 2015
Version Date:08/30/2023
The following sample query returns the risk of currency depreciation between USD vs GBP vs CAD since 2015.
Data Packages
Returns Countries And Their Categories That Fall In The Extremely Risky Band In The Last 90 Days
Version Date:08/30/2023
The following sample query Returns Countries and their categories that fall in the extremely risky band in the last 90 days.
Data Packages
Returns Risk Categories For US Where The Outlook Is Up Post The Current Year
Version Date:08/30/2023
The following sample query returns risk categories for US where the outlook is Up post the current year.
Data Packages
Returns Current Strategic Alliances Of A Company
Version Date:08/28/2023
The following sample SQL query takes a parent company (Apple Inc.) and displays its current strategic alliances.
Data Packages
Returns Top 5 Current Customers Of A Company With Respect To Marketcap
Version Date:08/28/2023
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.
Data Packages
Returns Coverage By Business Relationship Source Type Of Companies
Version Date:08/28/2023
The following sample SQL query finds count of unique companies in Business Relationships dataset for each Business Relationship Source Type.
Data Packages
Returns Current Business Relationships Of A Company With Their Source Type
Version Date:08/28/2023
The following sample SQL query returns takes a parent company (Apple Inc.) and displays its current business relationships with their source type.
Data Packages
Returns Top 3 Countries With Respect To Count Of Customers Of A Company
Version Date:08/28/2023
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.
Data Packages
Returns Counter For An Upgrade Or Downgrade In Value For Estimates And Revisions
Version Date:08/24/2023
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.
Data Packages
Returns Employment Index Of Different Sectors
Version Date:07/13/2023
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.
Data Packages
Returns Global Manufacturing Order Books
Version Date:07/12/2023
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.
Data Packages
Returns Global Manufacturing Costs Vs Prices
Version Date:07/12/2023
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.
Data Packages
Returns All The TimeseriesIDs That Are Overlapping Across Different Packages
Version Date:07/10/2023
The following sample SQL query returns all the timeseriesIDs that are overlapping across different packages.
Data Packages
Returns The Subscribed Data Packages And The Count Of Available TimeseriesIDs
Version Date:07/10/2023
The following sample SQL query returns the subscribed Data Packages and the count of available TimeseriesIDs
Data Packages
Returns Concepts And Count Of TimeseriesID For PMI Data
Version Date:07/10/2023
The following sample SQL query Returns Concepts and Count Of TimeseriesID For PMI Data.
Data Packages
Platform Representation Of CIQ Premium Financials(Annual) Via Xpressfeed Data
Version Date:06/16/2023
The Following Sample Query Provides platform representation of CIQ Premium Financials(Annual) via Xpressfeed Data.
Data Packages
Platform Representation Of CIQ Latest Financials(Annual) Via Xpressfeed Data
Version Date:06/16/2023
The Following Sample Query Provides platform representation of CIQ Latest Financials(Annual) via Xpressfeed Data.
Data Packages
Returns Number Of Company Report Filings By Country In 2022
Version Date:06/08/2023
The following sample query returns Number of Company Report filings by country in 2022
Data Packages
Company coverage by Broker and Region in 2022
Version Date:06/08/2023
The following sample query returns Company coverage by Broker and Region in 2022
Data Packages
Number Of Company Report Filings In The S&P500 Universe By Industry Sector Over The Last Five Years
Version Date:06/08/2023
The following sample query returns Number of Company Report filings in the S&P500 universe by Industry Sector over the last five years
Data Packages
Returns List Of All Company Reports Issued By Liberum Capital In 2022 With The Report Type Indication
Version Date:06/08/2023
The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication
Data Packages
Returns Research Report Along with Metadata and Target company (Paypal Holdings)
Version Date:06/08/2023
The following sample query returns Research Report Along with Metadata and Target company (Paypal Holdings)
Data Packages
Company Coverage By Broker, Region, And Capitalization in 2022
Version Date:06/08/2023
The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication
Data Packages
Returns Latest SFDR Data for Textiles, Apparel and Luxury Goods Companies for year 2021
Version Date:06/06/2023
The following sample query returns Latest SFDR Data for Textiles, Apparel and Luxury Goods Companies for year 2021
Data Packages
Returns SFDR Data For Walmart Inc. For 2021
Version Date:06/05/2023
The following sample query returns SFDR data for Walmart Inc. for 2021
Data Packages
XIRR Will Calculate The Internal Rate Of Return For A Series Of Cash Flows That May NOT Be Periodic
Version Date:05/25/2023
XIRR will calculate the Internal Rate of Return (IRR) for a series of cash flows that may not be periodic. It does this by assigning specific dates to each individual cash flow. The main benefit of using the XIRR is that such unevenly timed cash flows can be accurately modeled.
Data Packages
Showing Only The Specific Columns With Changed Values To The CiqKeyDev Table Over A 24 Hour Period
Version Date:05/23/2023
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.
Data Packages
Showing The Key Developments For A Company As It Was Available On A Particular Date Historically
Version Date:05/23/2023
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.
Data Packages
Gross Profit And Gross Margin Quarterly Totals For All Companies Incorporated In The United States of America
Version Date:05/18/2023
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).
Data Packages
Shows Only The Specific Columns That Changed With Each Row In Key Developments
Version Date:05/04/2023
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
Data Packages
Shows All Announced/Completed Transactions For A Company
Version Date:05/04/2023
This sample query shows all Announced/Completed Transactions for a company. Note: The Key Developments Plus package is required to run this query
Data Packages
Query Maps Keydevs Events with CIQEstimates And CIQFinancials
Version Date:04/19/2023
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
Data Packages
Returns Fact Level Company Response To Question 'Employee Turnover Rate' For Walmart Inc. In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Fact Level Company Response to Question 'Employee Turnover Rate' for Walmart Inc. in 2022 Assessment
Data Packages
Returns Question Level Scores, Weights, Disclosure Data, And Industry Level Aggregate Scores For Walmart Inc. For Corporate Governance Criteria in 2022 Assessment
Version Date:03/31/2023
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
Data Packages
Question Description And Survey Level Data For Question 'Biodiversity Commitment' In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Question Description and Survey Level Data for Question 'Biodiversity Commitment' in 2022 Assessment
Data Packages
Returns Fact Level Details for Criteria 'Corporate Governance' and Question 'Board Gender Diversity
Version Date:03/31/2023
The following sample SQL query returns Fact Level Details for Criteria 'Corporate Governance' and Question 'Board Gender Diversity'
Data Packages
Returns Fact Level Responses to Question 'Board Gender Diversity' for Companies in 'Consumer Staples' for 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Fact Level Responses to Question 'Board Gender Diversity' for Companies in 'Consumer Staples' for 2022 Assessment
Data Packages
Returns Disclosure Analysis Data For Walmart Inc. In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Disclosure Analysis Data for Walmart Inc. in 2022 Assessment
Data Packages
Returns Disclosure Analysis Data For Companies In 'Health Care' Sector In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Disclosure Analysis Data for Companies in 'Health Care' Sector in 2022 Assessment
Data Packages
Find All Securities Issued By A Company And Displays The SP Global Ratings
Version Date:03/22/2023
The following query finds all securities issued by a company and display the S&P Global Ratings.
Data Packages
Find All Trading Items For A Security
Version Date:03/22/2023
The following query finds all trading items for a security.
Data Packages
Find All Security Level Identifiers For A Private Fund
Version Date:03/22/2023
The following query finds all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.
Data Packages
Estimates Multiples
Version Date:03/20/2023
The following query can return the Primary EPS of a company or companies, which will be dynamically returned.
Data Packages
PIT Ratio Where Levered Free Cash Flow Is Divided By The Last Five Quarters Average Total Assets
Version Date:03/20/2023
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.
Data Packages
The Ultimate Parent
Version Date:03/20/2023
The following query rolls up to the Ultimate Parent then display all companyId\x92s that would fall under that ultimate parent (all levels).
Data Packages
Returns Inter-Dataitemid Relationship(Dataitemid's Hierarchy)
Version Date:03/17/2023
The following Query Passes DataitamDescription and returns parent and child DataitemIDs Hierarchy
Data Packages
Returns The Latest Index-based Median Credit Model Score And Implied PD For S&P 500
Version Date:03/17/2023
The following sample query returns the latest Index-based Median Credit Model Score and Implied PD for S&P 500
Data Packages
Returns The Latest Index-based Median Fundamental PD And Implied Score For USA - Oil & Gas
Version Date:03/17/2023
The following sample query returns the latest Index-based Median Fundamental PD and Implied Score for USA - Oil & Gas
Data Packages
Returns Fundamental PD and Implied Scores For IBM For A Specific Period
Version Date:03/17/2023
The following sample query returns Fundamental PD and Implied Scores for IBM for a specific period (Q1-2017Y).
Data Packages
Returns Share Buyback Data For Europe Corporates For The Last 10 Years
Version Date:03/14/2023
The following query returns share buyback data for Europe corporates for the last 10 years.
Data Packages
Returns Share Buyback Data For US Corporates For The Last 10 Years
Version Date:03/14/2023
The following query returns share buyback data for US corporates for the last 10 years.
Data Packages
Returns Number Of Factors By Relative Factor For Each Year For International Companies
Version Date:03/11/2023
The following sample SQL query returns number of factors by relative factor for each year for international companies.
Data Packages
Returns Total Number Of Factors By Style For International Companies
Version Date:03/11/2023
The following sample SQL query retrieves the total number of factors by style using daily international data.
Data Packages
Returns Base And Historical Relative Factor Data For A Company(North America)
Version Date:03/11/2023
The following sample SQL query retrieves base and historical relative factor data for a North America based company(Here IBM).
Data Packages
Returns Transaction Level Securities Finance Data With Event Indicators For Companies
Version Date:03/11/2023
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.
Data Packages
Returns Changes In Stock Market Prices For Investor Sentiment Analysis
Version Date:03/11/2023
The following sample SQL query retrieves changes in stock market prices that are a reflection of how the public feels about the companies.
Data Packages
Returns Universes Available In Alpha Factor Library
Version Date:03/11/2023
The following sample SQL query provides provides the identifiers and details for Alpha Factor Library universes.
Data Packages
Returns Count Of Trading Items By Country
Version Date:03/11/2023
The following sample SQL query retrieves count of securities by style by year.
Data Packages
Returns Total Number Of TradingItemIDs By Style
Version Date:03/11/2023
The following sample SQL query retrieves the total number of tradingItemIDs covered by style using daily international data.
Data Packages
Returns Base And Historical Relative Factor Data For A Company(Global)
Version Date:03/11/2023
The following sample SQL query retrieves base and historical relative factor data for a global based company(Here IBM).
Data Packages
Returns Transaction Level Securities Finance Data For Companies
Version Date:03/11/2023
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.
Data Packages
Returns Count Per Industry For Retail Flow Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves count per industry for retail flow equity.
Data Packages
Returns Stock Selection Of ETFs In Different Companies Or Within A Company
Version Date:03/11/2023
The following sample SQL query retrieves stock selection of ETFs in different companies or within a company ensures that your asset allocation remains in line with your investment objectives and risk tolerance level.
Data Packages
Returns Equity File Status
Version Date:03/11/2023
The following sample SQL query retrieves equity file status : 1 - Preliminary File and 2 - Final File.
Data Packages
Returns Standard Fund Data Items For Retail Flow
Version Date:03/11/2023
The following sample SQL query retrieves quantities and values of daily traded funds in terms of selling, buying and short selling against each company.
Data Packages
Returns Various Thematic Funds
Version Date:03/11/2023
The following sample SQL query retrieves various thematic funds in specific investment themes, trends, or sectors.
Data Packages
Returns Relative Factors Available In Alpha Factor Library
Version Date:03/11/2023
The following sample SQL query provides the identifier and name of the relative factor.
Data Packages
Returns Stock Popularity For A Company
Version Date:03/11/2023
The following sample SQL query retrieves stock populairty for a company(Here AMC Entertainment Holdings, Inc.)
Data Packages
Returns Volume Of Stock For A Company
Version Date:03/11/2023
The following sample SQL query retrieves volume of stock for a company(Here Apple Inc.)
Data Packages
Returns Global Monthly Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves global monthly universe population for each global universe in Alpha Factor Library.
Data Packages
Returns Minimum File Record Date And maximum File Record Date For Each Company
Version Date:03/11/2023
The following sample SQL query retrieves minimum file record date and maximum file record date for each company.
Data Packages
Returns Trading Item Counts By Industry
Version Date:03/11/2023
The following sample SQL query returns trading item counts by industry for Short Squeeze Data.
Data Packages
Returns Volume To Price Change For A Company
Version Date:03/11/2023
The following sample SQL query retrieves volume to price change for a company(Here Vanguard World Fund - Vanguard Energy ETF).
Data Packages
Returns Retail Flow Data For Assessing Liquidity Of Funds For A company
Version Date:03/11/2023
The following sample SQL query retrieves Retail Flow data for a company(Here iShares ESG Aware MSCI USA ETF) for assessing liquidity of funds.
Data Packages
Returns Total Volume To Analyze Risk Management
Version Date:03/11/2023
The following sample SQL query retrieves total volume to analyze low or negative correlations between asset classes to manage risk.
Data Packages
Returns Global Coverage By Region Of Short Squeeze Data By Unique TradingItemID
Version Date:03/11/2023
The following sample SQL query displays global coverage by region of data in 2021 by unique TradingItemID.
Data Packages
Returns Global Coverage By ISO Country Of Unqiue Trading Item IDs
Version Date:03/11/2023
The following sample SQL query displays global coverage by ISO Country of unqiue trading item IDs since 2011.
Data Packages
Returns Standard And Non Standard Volume For Retail Flow Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves Standard Volume and Non Standard Volume for retail flow equity data.
Data Packages
Returns Global Daily Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves universe population for each universe in Alpha Factor Library.
Data Packages
Returns Non Standard Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves 'OTHER' quantity and notional value is representing Non-Standard Equity that the company is trading.
Data Packages
Returns Yearly Coverage Of Companies
Version Date:03/11/2023
The following sample SQL query retrieves unique number of companies by trading item that got there data coverage each fiscal year.
Data Packages
Returns Top 5 Equity Inflows
Version Date:03/11/2023
The following sample SQL query retrieves top 5 equity inflows.
Data Packages
Returns Short Squeeze Comp Score And Daily Close Price For A Company
Version Date:03/11/2023
The following sample SQL query returns Short Squeeze Comp Score and Daily Close Price for a company(here Netflix Inc.).
Data Packages
Returns North America Monthly Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves North America monthly universe population for each North America universe in Alpha Factor Library.
Data Packages
Returns North America Daily Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves North America daily universe population for each North America universe in Alpha Factor Library.
Data Packages
Ranks Companies In EMEA Region By ROE Factor
Version Date:03/11/2023
The following sample SQL query ranks companies in the EMEA region by ROE factor.
Data Packages
Returns Change Through Time Of Company Types Ranked In Short Squeeze Score
Version Date:03/11/2023
The following sample SQL query change through time of company types ranked in short squeeze score.
Data Packages
Returns Specific Asset Classes
Version Date:03/11/2023
The following sample SQL query retrieves specific asset classes.
Data Packages
Returns Distribution Of Short Loan Position Based On Predefined Set Of Bins For Companies
Version Date:03/11/2023
The following sample SQL query displays the distribution of a stock\x92s short loan position profit/loss based on a predefined set of bins for all companies.
Data Packages
Returns Count Of Securities By Style By Year
Version Date:03/11/2023
The following sample SQL query retrieves count of securities by style by year.
Data Packages
Returns Total Equity Traded
Version Date:03/11/2023
The following sample SQL query retrieves total quantity and notional total including Standard (executed during normal market and post-market close hours) and Non Standard (executed during pre-market open hours) Equity data.
Data Packages
Returns Short Position Profit Concentration For A Company
Version Date:03/11/2023
The following sample SQL query returns short position profit concentration for a company(here Netflix Inc.).
Data Packages
MSA Level Branch Stats
Version Date:03/09/2023
This following sample query provides MSA level branch stats.
Data Packages
Query To Look Up Branch Service Values
Version Date:03/09/2023
The following sample query provides the ability to look up branch service values .
Data Packages
Aggregated Data For Deposits And Branches By Institution In A City
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a city.
Data Packages
Branch Deposit Data With Address
Version Date:03/09/2023
This following sample query provides branch deposit data with address. Please note that branch ownership history is available from July 1, 2001.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A Federal Market
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a federal market.
Data Packages
Federal Market Level Branch Stats
Version Date:03/09/2023
This following sample query provides Federal market level branch stats.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A County
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a county.
Data Packages
Zip Code Level Branch Stats
Version Date:03/09/2023
The following sample query provides zip code level branch stats.
Data Packages
Link The SNL InstitutionId To The Compustat GVKEY
Version Date:03/09/2023
This following sample query links the SNL institutionId to the Compustat GVKEY.
Data Packages
County Level Branch Stats
Version Date:03/09/2023
This following sample query provides county level branch stats.
Data Packages
State Level Branch Stats
Version Date:03/09/2023
This following sample query provides State level branch stats.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A State
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a state.
Data Packages
Aggregated Data For Deposits And Branches By Institution In An MSA
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in an MSA.
Data Packages
Link The SNL InstitutionId To The S&P Capital IQ CompanyId
Version Date:03/09/2023
This following sample query links the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
City Level Branch Stats
Version Date:03/09/2023
This following sample query provides city level branch stats.
Data Packages
Returns Licensed Content Which Is Subscribed By The User For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query returns licensed content which is subscribed by the User
Data Packages
Provides Compustat Mnemonics To ECR TimeseriesId Mapping For North America For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For North America
Data Packages
Returns Product, BankId and Count Of TimeseriesID For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query returns Product, BankId and count of TimeseriesID
Data Packages
Pulls Data For Spot Price Of COMEX High Grade Copper In United States For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query pulls data for COMEX High Grade Copper, United States, Spot Price
Data Packages
Calculates Monthly Average With Daily Frequency Data For US Treasury 10-Year Constant Maturities For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query calculates monthly average with daily frequency data for US treasury 10-Year constant maturities
Data Packages
Provides Licensed Data For US Treasury 10-Year Constant Maturities For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Licensed Data for US Treasury 10-Year Constant Maturities
Data Packages
Data Item Search By Various Items (Mnemonics, Banks, Labels, Frequency, Series Types, Geography) For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query searches Data items by various items (mnemonics, banks, labels, frequency, series types, geography)
Data Packages
Provides CIQ Legacy IHS Macroecon Mnemonics-to-TimeseriesId Mapping For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides CIQ Legacy IHS Macroecon Mnemonics-to-TimeseriesId mapping
Data Packages
Compares Annual Index Value vs. Monthly Percent Change From A Year Ago For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query Compares Annual index value vs. monthly percent change from a year ago
Data Packages
Provides Compustat Mnemonics To ECR TimeseriesId Mapping For Global Coverage In ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For Global Coverage
Data Packages
Retrieves S&P Global (China) Ratings For Issue In English Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issue in English Language
Data Packages
Retrieves S&P Global (China) Ratings For Issuer Chinese Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issuer in Chinese Language
Data Packages
Retrieves S&P Global (China) Ratings For Issuer In English Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issuer in English Language
Data Packages
Returns All Firms For All Contacts With Emails
Version Date:01/17/2023
This following sample query returns all firms for all contacts with emails
Data Packages
Returns All Firms With Specific Investment Allocation Such As ESG And Alternatives
Version Date:01/17/2023
This following sample query returns all firms with specific investment allocation such as ESG and alternatives
Data Packages
Returns All Firms In Specific Geographical Region With Assets Greater Than Or Equal To Specific AUM
Version Date:01/17/2023
This following sample query returns all firms in specific geographical region with assets greater than or equal to specific AUM
Data Packages
Returns Annual Broker View Revision Estimates
Version Date:12/27/2022
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
Data Packages
Returns Price to Sales Calculation For Compustat Financials On A Specific Observation Date
Version Date:12/19/2022
The following query returns price to sales calculation for compustat financials on a specific observation date.
Data Packages
Returns All Merger And Acquisition Subsidiary Transactions Details Of Seller And Seller - Target RoleÂ
Version Date:12/19/2022
The following query returns all merger and acquisition subsidiary transactions details of Seller And Seller - Target Role
Data Packages
Returns All Merger And Acquisition Subsidiary Transactions Details Of Buyer And Buyer - Target RoleÂ
Version Date:12/19/2022
The following query returns all merger and acquisition subsidiary transactions details of Buyer And Buyer - Target Role
Data Packages
Returns HS Code and HS Methodology For Panjiva Data
Version Date:11/22/2022
The following sample query provides HS Code and HS Methodology For Panjiva Data
Data Packages
Returns Options And Warrants Data Using Treasury Method Calculation
Version Date:11/22/2022
The following sample query provides options data using treasury method calculation
Data Packages
Returns Options And Warrants Add-On Display Options And Warrants Data
Version Date:11/22/2022
The following sample query provides options and warrants add-on display options and warrants data
Data Packages
Returns Top 10 Percent Of Low Utilization For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of low utilization for S&P500. Tags: Legacy Offering
Data Packages
Returns Latest Sustainable Investment Data for (Uniti Group Inc.) for Good Governance related metrics
Version Date:11/16/2022
The following sample SQL query returns Latest Sustainable Investment Data for (Uniti Group Inc.) for Good Governance related metrics.
Data Packages
Returns Top 10 Percent Of High Short Interest As Per Shares Outstanding For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of high short interest as per shares outstanding for S&P500. Tags: Legacy Offering
Data Packages
Returns Top 10 Percent Of Low Short Interest As Per Shares Outstanding For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of Low short interest as per shares outstanding for S&P500. Tags: Legacy Offering
Data Packages
Returns Sustainable Investment Data For Walmart Inc.
Version Date:11/16/2022
The following sample SQL query returns sustainable Investment Data for Walmart Inc.
Data Packages
CiqGvkeyIID Linking For The Current S&P 1200 Constituents
Version Date:11/14/2022
The following sample query returns ciqGvkeyIID linking for the current S&P 1200 constituents.
Data Packages
Returning All The Sector Indices That Make Up The S&P 500
Version Date:11/14/2022
The following sample query returns all the sector indices that make up the S&P 500.
Data Packages
Returning Constituents, Weight In The Index, And Index Divisor As Of A Specific Date
Version Date:11/14/2022
The following sample query returning constituents, weight in the index, and index divisor as of a specific date.
Data Packages
Linking From ICAType To ICATypeID To DataItemId
Version Date:11/14/2022
The following sample query is linking from ICAType to ICATypeID to dataItemId.
Data Packages
Identifying All The Data Items Delivered In The Index Packages
Version Date:11/14/2022
The following sample query identifies all the data items delivered to the index packages.
Data Packages
Dividends For The Constituents Of The S&P 500 On The Observation Date
Version Date:11/14/2022
The following sample query returns the dividends for the constituents of the S&P 500 on the observation date.
Data Packages
Current TOPIX 100 INDEX (NEW INDEX SERIES) By Linking
Version Date:11/14/2022
The following sample query returns current TOPIX 100 INDEX (NEW INDEX SERIES) by linking.
Data Packages
Current TOPIX 100 INDEX (NEW INDEX SERIES) By Selecting Attributes
Version Date:11/14/2022
The following sample query returns the current TOPIX 100 INDEX (NEW INDEX SERIES) by selecting attributes.
Data Packages
Creating A List Of The Indices Available In The Current CIQ index Package And Their Associated TradingItemIDs
Version Date:11/14/2022
This following sample query creates a list of the indices available in the current CIQ index package and their associated tradingItemIDs.
Data Packages
Returning The Weight Of The Constituents In The Energy Sector For The S&P 500
Version Date:11/14/2022
The following sample query returns the weight of the constituents in the Energy Sector for the S&P 500.
Data Packages
Retrieving Russell ICB Financials Industry Cascade For The Russell 3000 Index
Version Date:11/14/2022
The following sample query is retrieving Russell ICB Financials Industry Cascade for the Russell 3000 Index.
Data Packages
Returning Constituents, Float Shares, Weight, And Price For A Specific Index On A Specific Date With From And Thru Dates
Version Date:11/14/2022
The following sample query returns constituents, float shares, weight, and price for a specific index on a specific date with from and thru dates.
Data Packages
Creating A Time Series Of Index Values For The S&P 500
Version Date:11/14/2022
The following sample query creates a time series of index values for the S&P 500.
Data Packages
Other TOPIX Security Identifiers
Version Date:11/14/2022
The following sample query returns other TOPIX security identifiers.
Data Packages
Returns Ultimateparent Details With Levels Recursively For A Given Company
Version Date:11/06/2022
Returns Ultimateparent Details With Levels Recursively For A Given Company. Tags - Backward Recursion, UltimateParentID, Corporate tree, Corporate Hierarchy, Company Hierarchy,Levels Between Child UltimateParent
Data Packages
Returns Price To Cash Flow For Compustat Data
Version Date:10/31/2022
The following sample query provides Price to Cash flow for compustat data.
Data Packages
Returns Price To Sales Ratio For Each Year For Compustat Data
Version Date:10/31/2022
The following sample query provides price to sales ratio each year.
Data Packages
Returns 1 Year Sales Growth For Compustat Data
Version Date:10/31/2022
The following sample query provides 1 year sales growth for compustat data.
Data Packages
Returns Return on Assets For Compustat Data
Version Date:10/31/2022
The following sample query provides return on assets for compustat data.
Data Packages
Returns Price To Sales Ratio For Each Quarter For Compustat Data
Version Date:10/31/2022
The following sample query provides price to sales ratio for each quarter.
Data Packages
Returns Price To Earnings Ratio For Different Time Periods
Version Date:10/31/2022
The following sample queries provides price to earnings for different time periods.
Data Packages
S&P CreditStats Data For US Public Finance for New York In 2022 With CUSIPs From RatingsXpress v4
Version Date:10/26/2022
The following sample queries provides S&P CreditStats Data For US Public Finance Data for New York in 2022 with CUSIPs from RatingsXpress v4
Data Packages
How To Find A List Of ArticleIds With Their Primary Entity And Other Associated Data
Version Date:10/14/2022
The following query shows how to retrieve articleIds, the associated entity, and publication dates where the entity is tagged as the primary entity.
Data Packages
How To Find ArtcilesIds And Published Scores And Factors For Corporates
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for Corporates with Article Primary Entity.
Data Packages
How To Find ArtcilesIDs And Published Scores And Factors For All Sovereigns
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for all Sovereigns with Article Primary Entity.
Data Packages
How To Find ArtcilesIDs And Published Scores And Factors For Insurance Companies
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for Insurance Companies with Article Primary Entity.
Data Packages
Returns Detailed Ownership Data For A Particular Company
Version Date:10/07/2022
The following sample query provide detailed ownership data for a particular company
Data Packages
Returns Capital Structure Data For A Particular Company
Version Date:10/07/2022
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
Data Packages
Finds Consensus Estimates For A Company With Multiple Trading Items
Version Date:09/23/2022
This sample query finds consensus estimates for a company with multiple trading items.
Data Packages
Uses Relative Constant To Limit The Estimate Period To The Forward 3 Periods
Version Date:09/23/2022
This sample query uses relative constant to limit the estimate period to the forward 3 periods.
Data Packages
Returns Companies That Have 5-day Revisions Changes
Version Date:09/23/2022
This sample query returns companies that have 5-day revisions changes.
Data Packages
Returns Estimates For Reported Forward Five Periods
Version Date:09/22/2022
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.
Data Packages
Metlife - Rolls Up Into Parent LOB Category, Category, LOB Line Of Business
Version Date:09/15/2022
This sample query rolls up into parent lob category, category, LOB line of business for Metlife.
Data Packages
Net Total Assets For The Fiscal Year 2021 And Period Type Annual
Version Date:09/15/2022
The query below gives the information about the stock data of a company for the fiscal year 2021. (Balance Sheet data).
Data Packages
Top 10 Private Auto Premium Underwriter In Colorado In 2021
Version Date:09/15/2022
This sample query provides top 10 private auto premium underwriter in colorado in 2021.
Data Packages
Net Premiums Earned For All Lines Of Business During The Year 2021 And Period Type Annual
Version Date:09/15/2022
The query below gives the information about the flow data of a company for the fiscal year 2021. (Income Statement data).
Data Packages
Data Packages
Identify ETF Style Classification Codes
Version Date:09/13/2022
This following sample query that pulls style classification codes and their names for a particular asset class, in this case Commodity.
Data Packages
Identify ETF Assets Under Management
Version Date:09/13/2022
This sample query pulls historical Assets Under Management (AUM) for an ETF.
Data Packages
Identify An ETF Benchmark
Version Date:09/13/2022
This sample query pulls a benchmark for an ETF.
Data Packages
Identify ETF Characteristics
Version Date:09/13/2022
This sample query that pulls all S&P Global Market Intelligence ETF characteristics for a companyId.
Data Packages
Identify ETF Fees
Version Date:09/13/2022
This sample query pulls a benchmark for an ETF.
Data Packages
Identify ETFs Associated With A Specific Asset Category
Version Date:09/13/2022
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
Data Packages
Identify ETF Managers
Version Date:09/13/2022
This sample query pulls the current professional managers for an ETF.
Data Packages
Sample Query To Display A Current List Of Key Developments
Version Date:08/16/2022
This sample query displays the current list of Key Development Types available in your subscription.
Data Packages
Returns The Non-Forecast Level Data For Metric Drought
Version Date:08/09/2022
This sample query returns the non-forecast level data for metric 'Drought' for Ford Motor Company for year 2022.
Data Packages
Returns The Forecast Based Exposure Score Data
Version Date:08/09/2022
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
Data Packages
Returns The View Metric Types And Values For Each Component Of A Transcript
Version Date:07/29/2022
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.
Data Packages
Full-Text Index Script Against The CiqTranscriptComponent Table And ComponentText Column
Version Date:07/29/2022
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.
Data Packages
Compare The Positive To Negative Sentiment Between Analysts And Executives On A Particular Call
Version Date:07/29/2022
This sample query compare the positive to negative sentiment between analysts and executives on a particular call.
Data Packages
Compare The Fog Index On All Available Calls From IBM Since 2013
Version Date:07/29/2022
This sample query compare the fog index on all available calls from IBM since 2013
Data Packages
Identify The Currency For Market Cap And TEV Figures
Version Date:07/26/2022
This sample query identify the currency for market cap and TEV figures in the ciqMarketCap table.
Data Packages
Returns Historical Public Float Percentage And Number Of Public Float Shares For Apple Inc.
Version Date:07/26/2022
This sample query returns historical Public Float Percentage and Number of Public Float Shares for Apple Inc.
Data Packages
Returns Portfolio Statistics By Industry Subtype For ALPS Advisers
Version Date:07/26/2022
This sample query returns Portfolio statistics by industry subtype for ALPS Advisers.
Data Packages
Identify Prices For A Range Of Dates Using A CUSIP Identifier
Version Date:07/26/2022
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.
Data Packages
Returns Full Market Cap VS Weighted Market Cap
Version Date:07/26/2022
This sample query uses Ownership Float History data linked to the S&P Capital IQ Base Data Sets, Premium Financials and Market Data packages.
Data Packages
Returns Aggregate Company-Level Ownership Information For Berkshire Hathaway
Version Date:07/26/2022
This sample query returns aggregate company-level ownership information for Berkshire Hathaway.
Data Packages
Identify US Public Companies With Non-Traded Shares Outstanding That Have A Market Cap Of More Than $20 Billion.
Version Date:07/26/2022
This sample query identify US public companies with non-traded shares outstanding that have a market cap of more than $20 billion.
Data Packages
Returns Dividend Data For A Specified TradingItemId And Date Range
Version Date:07/26/2022
This sample query returns dividend data for a specified tradingItemId and date range using the ciqDivFrequencyType table.
Data Packages
Returns Shares Held By Owner Type For A Small List Of Companies
Version Date:07/26/2022
This sample query returns shares held by owner type for a small list of companies.
Data Packages
Returns Ownership Details With Top Holders Of Oracle Corp.
Version Date:07/26/2022
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.
Data Packages
Returns Public Float Percent For Bank Of America Identified By Ticker Symbol
Version Date:07/26/2022
This sample query returns public float percent for Bank of America identified by ticker symbol.
Data Packages
List The Current Holdings Of Fidelity Contrafund
Version Date:07/26/2022
This sample query list the current holdings of Fidelity Contrafund (based on most recently available reporting and current prices).
Data Packages
Identify How The Underlying Funds Are Rolled Up To The Parent Investment Manager And Their Aggregated Funds For A Given Owner
Version Date:07/26/2022
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).
Data Packages
Returns Public Float Group Shares Held By Holding Type
Version Date:07/26/2022
This sample query returns public float group shares held by holding type for a specified group of securityIds.
Data Packages
Returns Companies Where The CFO Purchased Shares On The Open Market During The Past 2 Months
Version Date:07/26/2022
This sample query returns companies where the CFO had purchased shares on the open market during the past 2 months.
Data Packages
Returns Securities Experiencing 5 Different Insiders Who Purchased Shares In The Prior 3 Months But No Sellers As Of 12/31/2010
Version Date:07/26/2022
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.
Data Packages
Returns Portfolio Statistics By Region Subtype For SEI Investments Company
Version Date:07/26/2022
This sample query returns Portfolio statistics by region subtype for SEI Investments Company.
Data Packages
Returns Securities Experiencing More Insider Buys Than Sells In The Past 3 Months
Version Date:07/26/2022
This sample query returns securities experiencing more insider buys than sells in the past 3 months.
Data Packages
Returns Portfolio Style of IBM Displaying Shares Held, Percent Of Institutional Ownership And Percent Of Shares Outstanding
Version Date:07/26/2022
This sample query returns portfolio style of IBM displaying shares held, percent of institutional ownership and percent of shares outstanding.
Data Packages
Returns All Funds Under A Parent Company And Their Ownership
Version Date:07/26/2022
This sample query returns all funds under a parent company and their ownership
Data Packages
Returns Aggregate Issue-Level Ownership Information For Berkshire Hathaway Class B Shares
Version Date:07/26/2022
This sample query returns aggregate issue-level ownership information for Berkshire Hathaway Class B shares.
Data Packages
Returns Portfolio Statistics By Market Cap Subtype For Janus Capital
Version Date:07/26/2022
This sample query returns Portfolio Statistics by market cap subtype for Janus Capital.
Data Packages
Returns The Top 50 Holdings Of Fidelity Contrafund As Of 12/31/2011
Version Date:07/26/2022
This sample query list the top 50 holdings of Fidelity Contrafund as of 12/31/2011
Data Packages
Identify Companies That Trade On NYSE And Had Stock Split During 2006
Version Date:07/26/2022
This sample query identify companies that trade primarily on the NYSE and had a stock split during the 2006 calendar year.â\x80¯Also included are the ciqSplitCache and ciqSplitType tables.
Data Packages
Display Annual Flow Data Items For Latest Annual Filings For A Single Company
Version Date:07/21/2022
This sample query display annual flow data items for latest annual filings for a single company.
Data Packages
Link The SNL InstitutionId To The S&P Capital IQ CompanyId
Version Date:07/21/2022
This sample query link the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
Display A Single List For A Particular Company/Period Type
Version Date:07/21/2022
This sample query display a single list for a particular company/period type.
Data Packages
Link The SNL InstitutionId To The Compustat GVKEY
Version Date:07/21/2022
This sample query link the SNL institutionId to the Compustat GVKEY.
Data Packages
Display Quarterly Total Assets For A Single Company
Version Date:07/21/2022
This sample query display quarterly total assets for a single company.
Data Packages
Display InstitutionIds With Filings In The Last Week, Month, Or Year
Version Date:07/21/2022
This sample query display institutionIds with filings in the last week, month, or year.
Data Packages
Display All SNL InstitutionIds With Restatements Due To Fiscal Year Changes
Version Date:07/21/2022
This sample query display all SNL institutionIds with restatements due to fiscal year changes.
Data Packages
Display High/Low Annual Stock Price Value For A Single Company
Version Date:07/21/2022
This sample query display high/low annual stock price value for a single company.
Data Packages
Display Data For A Particular Company/Period Type In A Column-Based Format
Version Date:07/21/2022
This sample query display data for a particular company/period type in a column-based format.
Data Packages
Display Latest Quarterly Total Assets Value For A Single Company
Version Date:07/21/2022
This sample query display latest quarterly total assets value for a single company.
Data Packages
Returns A Company's New Name
Version Date:07/20/2022
This sample query returns the Hewlett-Packard Company\x92s new name.
Data Packages
Returns Toyo Data: Industry-Company Composition
Version Date:07/20/2022
This sample query retrieve the Toyo data: Industry-company composition.
Data Packages
Retrieve The History Of Financial Auditors For A Company
Version Date:07/20/2022
This sample query retrieve the history of financial auditors for Verizon Communications Inc.
Data Packages
Returns The Global Business Addresses For A Company
Version Date:07/20/2022
This sample query returns the global business addresses for Hewlett-Packard Co.
Data Packages
Returns All Alternate, Native And Search Company Names For A Given Company
Version Date:07/20/2022
This sample query returns all Alternate, Native and Search company names for Sony Corporation.
Data Packages
Identify Auto Parts Companies Headquartered In The U.S. And With An Office In China Or Japan
Version Date:07/20/2022
This sample query Identify auto parts companies headquartered in the U.S. and with an office in China or Japan, including all business descriptions.
Data Packages
Returns Competitors Of A Company By Industry
Version Date:07/20/2022
This sample query returns competitors of United Technologies Corp. by Industry.
Data Packages
Returns Toyo Data: Main Company Attribute Data
Version Date:07/20/2022
This sample query retrieve the Toyo data: Main company attribute data.
Data Packages
Returns Merger/Acquisition Activities Of IBM
Version Date:07/18/2022
The following sample query returns all Merger / Acquisition activities IBM has been involved with as Buyer or Seller in 2010 (showing company relationships).
Data Packages
Returns U.S. Private Placement Transactions Closed In 2010
Version Date:07/18/2022
The following sample query returns U.S. Private Placement transactions that have closed in 2010 with Financial Institutions as investors (showing company relationships).
Data Packages
Returns Transaction History For The Target Company
Version Date:07/18/2022
The following sample query returns all transaction history where Casey\x92s General Stores Inc. is the target, showing their advisors.
Data Packages
Returns MarketCap For Compustat GVKey IID
Version Date:07/02/2022
The following sample query provides historical to latest market cap as well as the currency for a given GVKey.
Data Packages
Returns Industrial Format Income Statement, Balance Sheet, And Cash Flow Balancing Models (Period End Dates As The Column Names)
Version Date:06/15/2022
The following query returns industrial format Income Statement, Balance Sheet, and Cash Flow Balancing Models with period end dates as the column names.
Data Packages
Returns List Of Properties
Version Date:06/09/2022
The following query returns list of properties based on commodity, total resource, grade & stage.
Data Packages
Returns List Of Metals & Mining Companies For Australia
Version Date:06/09/2022
The following query returns list of metals & mining companies with 2020 gold exploration budget for Australia >US$1M.
Data Packages
Rank Properties In North America In Development Stage
Version Date:06/09/2022
The following query rank properties that are in \x93Development Stage\x94, in North America that have a copper resource >500,000 tonnes (contained copper).
Data Packages
Returns Properties With >1% Copper Intercept & >50M Interval
Version Date:06/09/2022
The following query returns properties that have achieved a copper intercept >1% with an interval >50m in South America.
Data Packages
Drill Results for Commodities
Version Date:06/09/2022
The following query returns interval results across commodities based on requested criteria: Input grade x interval, Region, Country & Date Range.
Data Packages
Returns All Security Level Identifiers
Version Date:06/07/2022
The following query returns all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.
Data Packages
Display Identifier Types
Version Date:06/07/2022
This example shows how to create a query that displays the identifierTypeId associated with each identifier.
Data Packages
Returns All Trading Items For A Security
Version Date:06/07/2022
The following query returns all trading items for a security.
Data Packages
Returns Estimated Modeled ESG Scores
Version Date:05/27/2022
The following SQL query returns estimated (modeled) ESG Scores for NextEra Energy, Inc. for 2021 Assessment.
Data Packages
Returns Industry Grouping For S&P 500 Companies
Version Date:05/27/2022
The following SQL query returns industry grouping for S&P 500 companies as applied in Corporate Sustainability Assessment (CSA).
Data Packages
Returns Raw ESG Scores
Version Date:05/27/2022
The following SQL query returns raw ESG Scores for NextEra Energy, Inc. for 2021 Assessment.
Data Packages
Returns MSA Impact Details On Raw ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns MSA impact details on raw ESG Score breakdown for McDonald's Corporation for 2021 assessment.
Data Packages
Returns Industry Specific Dimension and Criteria Weights Trend For Last 5 Years
Version Date:05/27/2022
The following SQL query returns industry specific dimension and criteria weights trend for last 5 years.
Data Packages
Returns Industry Range And Averages Against Historical Raw ESG Score Performance
Version Date:05/27/2022
The following SQL query returns Industry Range and Averages against Historical Raw ESG Score Performance for NextEra Energy, Inc. (Last 5 Years).
Data Packages
Returns Historical Raw ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns historical raw ESG Score breakdown for NextEra Energy, Inc. for Last 5 Years.
Data Packages
Returns MSA Impact On Raw ESG Scores
Version Date:05/27/2022
The following SQL query returns MSA impact on raw ESG Scores for McDonald's Corporation for 2021 assessment.
Data Packages
Returns Historical Raw ESG Score Performance
Version Date:05/27/2022
The following SQL query returns historical raw ESG Score performance for NextEra Energy, Inc. for last 5 Years.
Data Packages
Returns Estimated (Modeled) ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns estimated (modeled) ESG Score breakdown for NextEra Energy, Inc. for 2021 assessment.
Data Packages
Display Data Items For The Given Company
Version Date:05/24/2022
The following sample query display data items from stock and flow tables for Bank of the West.
Data Packages
Return A Unique TIC, ISIN, CUSIP And SEDOL
Version Date:05/24/2022
The following sample query return a unique TIC, ISIN, CUSIP and SEDOL that represents the most recent public company for any given GVKEY.
Data Packages
Display Data Items For An Aggregate Entity
Version Date:05/24/2022
The following sample query display data items for an aggregate entity -- NYC Commercial Banks.
Data Packages
Cross Reference Query Linking CIQ Company
Version Date:05/24/2022
The following sample query link the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
Display A Sample Of Multiple Restatement Data
Version Date:05/24/2022
The following sample query display a sample of multiple restatement data.
Data Packages
Returns Long Term Interest Rates
Version Date:04/19/2022
The following sample query returns Long term interest rates.
Data Packages
Returns US Versus China GDP Over Time
Version Date:04/19/2022
The following sample query returns US versus China GDP values.
Data Packages
Returns GDP Growth Forecasts
Version Date:04/19/2022
The following sample query returns GDP Growth Forecasts.
Data Packages
Returns Latest Dividends
Version Date:04/19/2022
The following sample query returns latest dividend details.
Data Packages
Returns YTD Total Return With Reinvested Dividends
Version Date:04/18/2022
The following SQL query returns the YTD total return with reinvested dividends.
Data Packages
Returns Cumulative Twelve Quarter R&D Spending With Linear Decay Weighting
Version Date:04/18/2022
The following SQL query returns the R&D Stock Factor where the dataitemid is 100 for R&D Expenses.
Data Packages
Returns Default And Ratings Transitions Of All Instrument Issues
Version Date:04/04/2022
The following SQL query returns the default and ratings transitions of all instrument issues.
Data Packages
Returns The Entity Level Details
Version Date:04/04/2022
The following SQL query returns the entity level CreditPro data item name.
Data Packages
Returns The Instrument Level Details
Version Date:04/04/2022
The following SQL query returns the instrument level CreditPro data item name.
Data Packages
Returns The Relative Strength Index
Version Date:04/04/2022
The following SQL query returns the Relative Strength Index for a specific company.
Data Packages
This Query Returns Estimate Values Using The Primary Accounting Standard
Version Date:03/02/2022
This query returns returns estimate values using the primary accounting standard
Data Packages
Returns In Between Records When Subsidiarycompany Is The Ultimateparentcompany
Version Date:02/28/2022
The following sample query checks if there are any records in between where subsidiarycompany is the ultimateparentcompany.
Data Packages
Returns Parent And Ultimate Parent Company
Version Date:02/28/2022
The following sample query returns parent and ultimate parent company for 'Valim' with industry id 2900.
Data Packages
Returns ESG Focused Financial Data Points
Version Date:02/28/2022
The following sample query returns ESG Focused Financial Data Points for General Electric Company.
Data Packages
Returns All The Details From Platform
Version Date:02/28/2022
The following sample query validates all the details from platform.
Data Packages
Returns Environmental, Financial And Market Data Points
Version Date:02/28/2022
The following sample query returns Environmental, Financial and Market Data points for S&P 500 Electric Utilities Companies for Fiscal Year 2020.
Data Packages
Returns Annual Report Along With Metadata And Entity Name
Version Date:02/08/2022
The following sample query returns DIA 2017 Annual Report, along with the company name, filing language, source and type.
Data Packages
Returns Datacenter Knowledgebase Regional Dashboard Values
Version Date:02/03/2022
The following sample query returns the datacenter knowledgebase regional dashboard
Data Packages
Returns Operational and Planned Datacenters by Period
Version Date:02/03/2022
The following sample query returns the number of operational and planned datacenters by period
Data Packages
Returns Top 10 Total Operational Square Footage Current Market Share
Version Date:02/03/2022
The following sample query returns the top 10 total operational square footage current market share
Data Packages
Returns Datacenter Quarterly Power Supply and Usage
Version Date:02/03/2022
The following sample query returns datacenter quarterly power supply and usage.
Data Packages
Returns Global Data Snapshot
Version Date:02/03/2022
The following sample query returns the global view of data center knowledgebase metrics
Data Packages
Returns State And Country Codes For Public Finance Securities
Version Date:01/20/2022
The following sample SQL query returns the state codes for the top 100 Public Finance securities from the SP Credit Ratings package in Xpressfeed
Data Packages
Returns Recovery Ratings By CUSIP
Version Date:01/20/2022
The following sample SQL query returns the most recent and previous Recovery Rating using a CUSIP as the identifier in Xpressfeed
Data Packages
Returns Ratings By LoanX ID
Version Date:01/20/2022
The following sample SQL query returns the issue level ratings for a LoanX ID from the SP Credit Ratings package in Xpressfeed
Data Packages
Screens Rating Changes
Version Date:01/20/2022
The following sample SQL query returns a list of rating changes for a specific instrument type using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Ratings Data Using Maturity ID
Version Date:01/19/2022
The following sample SQL query returns ratings data using the MaturityID in Xpressfeed.
Data Packages
Returns Ratings Data Related To Triple Component Rating
Version Date:01/19/2022
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
Data Packages
Returns Rating Data For Securities With An NR Rating
Version Date:01/01/2022
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
Data Packages
Returns CP Ratings By CUSIP6
Version Date:01/01/2022
The following sample SQL query returns Commercial Paper (CP) ratings data and Maturity ID (maturityId) using the 6-digit CUSIP (CUSIP6) in Xpressfeed
Data Packages
Returns Preliminary Ratings
Version Date:01/01/2022
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
Data Packages
Returns Historical Financial Strength
Version Date:01/01/2022
The following sample SQL query returns the Historical Financial Strength Rating for an insurance company in the SP Credit Ratings package
Data Packages
Returns Ratings Universe For ISINs
Version Date:01/01/2022
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
Data Packages
Returns Entity Level Ratings
Version Date:01/01/2022
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
Data Packages
Returns S&P's and Moodys Ratings For A ISIN
Version Date:01/01/2022
The following sample SQL query returns both the SP Rating and the Moodys Rating for a specific ISIN in Xpressfeed.
Data Packages
Returns ISINs With Current Unsolicited Ratings
Version Date:01/01/2022
The following sample SQL query returns all ISINs that have a current Unsolicited Rating using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns GI Entity Ratings Put on a Positive Creditwatch
Version Date:01/01/2022
The following sample SQL query returns all Global Issuer (GI) entity ratings put on a positive CreditWatch.
Data Packages
Returns Issuer Credit Rating On A Specific Date
Version Date:01/01/2022
The following sample SQL query returns an issuer credit rating on a specific date in Xpressfeed
Data Packages
Returns Sovereign Credit Ratings By Country Code
Version Date:01/01/2022
The following sample SQL query returns the current and historical sovereign ratings for a country using the country code from the CIQ Rating Country (ciqRatingCountry) table in Xpressfeed
Data Packages
Returns SecurityId, InstrumentId,EntityId From RatingDataId
Version Date:01/01/2022
The following sample SQL query returns securityId,instrumentId,entitySymbolValue from a ratingDataId in Xpressfeed
Data Packages
Return IQ_BETA_1YR Or IQ_BETA_2YR (Index) For MSCI Indices (MSCI Eafe Index or MSCI Emerging Markets Index)
Version Date:12/16/2021
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
Data Packages
Return IQ_BETA_5YR (Index) For CIQ Indices (S&P 500 Index or S&P/TSX Composite Index)
Version Date:12/16/2021
The following sample query calculate CIQ Indices '5 Year Beta' using input parameters CompanyId,ObservationDate and TradingitemID. Tags - BETA, IQ_BETA_5YR
Data Packages
Return IQ_BETA_1YR Or IQ_BETA_2YR (Index) For CIQ Indices (S&P 500 Index or S&P/TSX Composite Index)
Version Date:12/16/2021
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
Data Packages
Return IQ_BETA_5YR (Index) For MSCI Indices (MSCI Eafe Index or MSCI Emerging Markets Index)
Version Date:12/16/2021
The following sample query calculate MSCI Indices '5 Year Beta' using input parameters CompanyId,ObservationDate and TradingitemID. Tags - BETA, IQ_BETA_5YR
Data Packages
Returns All Data Items Within The Balance Sheet
Version Date:12/02/2021
The following SQL query Display all data items within the Balance Sheet - Adjusted template organized by section.
Data Packages
Returns Scores And Factors For CORP Score Group With Current Ratings
Version Date:12/02/2021
The following SQL include all Score data points with Score and Value Description as well as rating data including Org Debt Type = ICR, Entity Symbol Value, Entity Name, Rating, Rating Date, Outlook, Outlook Date, CreditWatch, CreditWatchDate.
Data Packages
Returns Scores For BICRA Scores
Version Date:12/02/2021
The following SQL returns scoreObjectSymbolValue, scoreDetailId, scoreObjectTypeId, scoreObjectName, scoreGroup, scoreType, scoreBusinessName, scoreValue, scoreValueDescription & scoreCurrentIndicator.
Data Packages
Returns Companies And Fiscal Periods Updated Within A Given Date Range
Version Date:12/02/2021
The following SQL query returns the companies and fiscal period between a given date range.
Data Packages
Returns Scores And Factors For CORP Score Group
Version Date:12/02/2021
The following SQL query returns all Score data points with Score and Value Description for â\x80\x98CORPâ\x80\x99 Score Group
Data Packages
Returns Scores And Factors For BANK Score Group
Version Date:12/02/2021
The following SQL query returns all Score data points with Score and Value Description for â\x80\x98BANKâ\x80\x99 Score Group.
Data Packages
Returns All Data Items Associated With S&P CreditStats
Version Date:12/02/2021
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.
Data Packages
Identify Tranche Details Of Debt Raised By Buyer Firms For Private Debt Deals
Version Date:11/30/2021
The Following Sample Query Returns Tranche Details Of Debt Raised By Buyer Firms For Private Debt Deals
Data Packages
Identify Investor Exit Details Of Private Equity Buyout Deals
Version Date:11/30/2021
The following sample query returns Investor Exit Details Of Private Equity Buyout Deals
Data Packages
Returns Power Plant Sites Of S&P 500 Electric Utility Companies
Version Date:11/17/2021
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.
Data Packages
Forcast More Than 50 Percent Of High Risk Of Water Stress For Global Branches Of A Company
Version Date:11/17/2021
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.
Data Packages
Returns WACC (Weighted Average Cost Of Capital) Of A Company
Version Date:11/16/2021
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.
Data Packages
Linking Preqin Deals To MI Transactions Rounds Of Funding Package
Version Date:10/25/2021
The following sample query returns the currencyCode, amountOffered, identifierValue, etc by linking preqin deals to MI Transactions Rounds of Funding package.
Data Packages
Linking Preqin M&A Deals To CIQ Transactions Offering Packages
Version Date:10/25/2021
The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin M&A deals to CIQ Transactions offering packages.
Data Packages
Linking Preqin Private Equity Rel Package With Preqin Identifier For Fund Investor
Version Date:10/25/2021
The following sample query identifies Current, Prior and cancelled fund investors of Shanghai Liansheng Venture Fund.
Data Packages
Linking Preqin Private Equity Rel Package For Fund Investors
Version Date:10/25/2021
The following sample query identifies Current, Prior and cancelled fund investors of SA Corporate Real Estate Limited.
Data Packages
Linking Preqin Deals To CIQ Transactions Offering Packages
Version Date:10/25/2021
The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin deals to CIQ Transactions offering packages.
Data Packages
Linking Preqin Private Equity Rel Package With Preqin Identifier For Sponsored Fund
Version Date:10/25/2021
The following sample query identifies all the current and prior funds sponsored by Yamaguchi Capital.
Data Packages
Returns RXtoV4 LoanX_ID Lookup To Issuer Rating
Version Date:10/01/2021
The following sample query returns the rating and entitylevel data for the given LoanX symbol.
Data Packages
Returns RXtoV4 Instrument GISF Current_Assessment
Version Date:10/01/2021
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.
Data Packages
Returns RXtoV4 Instrument GISF Current
Version Date:09/30/2021
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.
Data Packages
Returns RXtoV4 Entity GISF Current_Assessment
Version Date:09/30/2021
The following sample query returns the current GISF Entity rating based on Recordupdatedate and long term and short term assessment view.
Data Packages
Returns RXtoV4 Entity GISF Current
Version Date:09/29/2021
The following sample query returns the current GISF rating for the Entity based on Recordupdatedate and the associated ratingdate, creditwatchdate, outlookdate, etc.
Data Packages
Returns RXtoV4 Security GISF Current
Version Date:09/23/2021
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.
Data Packages
Returns S&P, Moody's And Fitch Ratings
Version Date:09/23/2021
The following sample query returns S&P, Moody's and Fitch Ratings with issuer number for the specific CompanyID
Data Packages
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Version Date:09/22/2021
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Data Packages
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Version Date:09/22/2021
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Data Packages
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
Version Date:09/22/2021
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
Data Packages
Returns Companies That Mentioned Boeing In Their Earnings Calls In The First Calendar Quarter of 2021
Version Date:09/21/2021
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.
Data Packages
Returns All Companies Mentioned By IBM On Their Call Alongside The Call Text
Version Date:09/21/2021
The following sample query returns all companies mentioned by IBM on their call, alongside the call text using NERD on Transcripts
Data Packages
This Query Returns The Quarterly Estimates That Have Changed In The Last 24 Hours
Version Date:09/07/2021
This query returns the quarterly broker estimates for the upcoming quarter that have changed in the last 24 hours based on observation date.
Data Packages
Counts Unique Trademark IPIDs Grouped By NiceClassID
Version Date:09/07/2021
The following sample query counts unique trademark ipIds and groups them by niceClassID.
Data Packages
Counts Unique Patent IpIds And Groups Them Under Specific Patent Classes
Version Date:09/06/2021
The following sample query counts unique patent ipIds and groups them under patent classes containing a description with the phrase 'Golf'.
Data Packages
First Trademark Data And Trademark Innovation Activity Using Point-In-Time Package
Version Date:09/06/2021
Query trademark data and trademark innovation activity data for Apple Inc. with linking of the IPqwery ownerId to the S&P Capital IQ companyId.
Data Packages
Counts Unique PatentID Using Patent Title And Patent Class Description Grouped By Owner Company And Patent Class
Version Date:09/06/2021
The following sample query searchs for unique patent ipIds where the patent title contains the phrase "Golf" and the patent class description containing the phrase "Balls". The counts are grouped by owner company and patent class.
Data Packages
First Patent And Patent Innovation Activity Using Point-In-Time Package
Version Date:09/06/2021
Query patent data and patent innovation activity data for Apple Inc. with linking of the IPqwery ownerId to the S&P Capital IQ companyId.
Data Packages
Returns Broker Recent Changes
Version Date:09/03/2021
The following query returns the recent changes for the companies by the Brokers.
Data Packages
The Following Sample Request Will Retrieve The Expanded Probability Of Default (EPD) Scores
Version Date:08/30/2021
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.
Data Packages
Returns Unconsolidated And Consolidated Income Statement Data For A Company
Version Date:08/10/2021
The following sample SQL query pulls consolidated and unconsolidated Financials income statement data.
Data Packages
Returns Industry/Verticals That Are Tied To An Asset For Funds, Firms, And Service Providers (Strategies, Geographies, Sources Of Capital, Sub-industries)
Version Date:07/15/2021
The following query shows additional information related to a company in an asset classe(Funds, Firms, and Service Providers). Note: Change the prqDescriptorId to view strategies, geographies, sources of capital,sub-industries (and many more more.) Change the prqFirmId as needed, currently it runs for Marqeta, Inc.
Data Packages
Returns CRM Private Equity Company Profile Module (Bite Size)
Version Date:07/10/2021
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.
Data Packages
Returns CRM Company Profile Module
Version Date:07/10/2021
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.
Data Packages
Returns CRM Company Relationship Module (Competitors)
Version Date:07/10/2021
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.
Data Packages
Returns CRM People Profile Module (Professionals)
Version Date:07/10/2021
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.
Data Packages
Returns CRM General Financials Module
Version Date:07/10/2021
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.
Data Packages
Returns CRM Company Relationship Module (Subsidiaries)
Version Date:07/10/2021
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
Data Packages
Returns CRM Private Equity Company Profile Module (Industry, Investment Style and Transaction Types)
Version Date:07/10/2021
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.
Data Packages
Historical Performance Data For A Given Hedge Fund
Version Date:06/30/2021
The following sample query returns historical performance data for a given hedge fund
Data Packages
Rolling Sharpe Ratio RFR For A Given Hedge Fund
Version Date:06/30/2021
The following sample query returns the Rolling Sharpe ratio RFR 2% (since inception, 1Y, 2Y, 3Y and 5Y) for a given hedge fund
Data Packages
Obtain Consolidated And Non-Consolidated Revenues
Version Date:06/07/2021
This query returns the consolidated revenues where available, otherwise the query generates non-consolidated values.
Data Packages
Obtain Financial Data For A Private Company
Version Date:06/07/2021
This query returns the financial information for Celio España Moda Sa, a private company.
Data Packages
Returns The Value Of Restricted Stock Units Granted.
Version Date:05/27/2021
The following sample query returns the value of restricted stock units granted by current S&P500 index constituents in fiscal year 2020.
Data Packages
S&P Capital IQ Industry Classification Reference
Version Date:05/21/2021
The following sample query returns all possible industries in the S&P Capital IQ industry classification. Tag: CoInd
Data Packages
All Possible GICS Codes And Descriptions In Visual Tree Structure
Version Date:05/21/2021
The following sample query returns all possible GICS codes and descriptions (recursive reference query showing visual tree structure). Tag: CoInd
Data Packages
S&P Capital IQ Industry Tree For Coca-Cola Company With Related SIC Codes
Version Date:05/21/2021
The following sample query returns the industry tree for Coca-Cola Company, with related SIC codes. Tag: CoInd
Data Packages
All Possible GICS Codes And Descriptions Reference Query
Version Date:05/21/2021
The following sample query returns all possible GICS Codes and descriptions. Tag: CoInd
Data Packages
S&P Capital IQ Industry Tree For AT&T
Version Date:05/21/2021
The following sample query returns the S&P Capital IQ industry tree for AT&T. Tag CoInd
Data Packages
API JSON Direct (JSON/REST) API Access Method
Version Date:05/07/2021
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).
Data Packages
API Corporate Yield Curve Annual Values
Version Date:05/07/2021
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.
Data Packages
API Request Corporate Yield Historical Data
Version Date:05/07/2021
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.
Data Packages
Returns Annual Report For Non-SEC Filings Company
Version Date:05/04/2021
The following sample query returns Roche Holding AG Company (Non-SEC Filings) 2019 Annual Report.
Data Packages
Return All The Data Items Delivered In The Trucost Climate Change Physical Risk Data Packages
Version Date:04/22/2021
Return All The Data Items Delivered in The Trucost Climate Change Physical Risk Data Packages
Data Packages
Returns Carlyle Group Firm Strategy
Version Date:04/15/2021
The following sample query returns the main strategy for Carlyle Group by joining it with relevant lookup table.
Data Packages
Returns PD Market Signals Country Industry Benchmark Data
Version Date:04/07/2021
The following sample query returns country industry based on the Median Market Signal PD and Implied Score for USA - Oil & Gas
Data Packages
Returns PD Fundamentals Index Benchmark Data
Version Date:04/07/2021
The following sample query returns latest Index-based Median Fundamental PD and Implied Score for USA - Oil & Gas
Data Packages
Returns Fundamental PD And Implied Scores For A Specific Period
Version Date:04/07/2021
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.
Data Packages
Returns Local Scales Data (Score value )
Version Date:04/07/2021
The following sample query returns local score from Global Metric Score value (CATypeId - 101)
Data Packages
Returns Current PD Values Together With Daily Stock Price
Version Date:04/07/2021
The following sample query returns IBM\x92s current PD values together with its daily stock price.
Data Packages
Returns Local Scales Data (PD Value)
Version Date:04/07/2021
The following sample query returns local score from Global Metric PD value (CATypeId - 385)
Data Packages
Returns PD Market Signals Index Benchmark Data
Version Date:04/07/2021
The following sample query returns latest Index-based Median Market Signal PD and Implied Score for S&P 500
Data Packages
Returns PD Based Market Signal For A Company
Version Date:04/07/2021
The following sample query returns IBMâ\x80\x99s PD-based Market Signal.
Data Packages
Returns Credit Model Score And Implied PD For A Company.
Version Date:04/07/2021
The following sample query returns CreditModel Score and Implied PD for IBM for a specific period (Q1-2017Y).
Data Packages
Returns PD Fundamentals Country Industry Benchmark Data
Version Date:04/07/2021
The following sample query returns latest Country Industry based on the Median Fundamental PD and Implied Score for USA - Oil & Gas
Data Packages
Returns Non Financial Data
Version Date:04/07/2021
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.
Data Packages
Risk Factor Section From All Available 10-K Filings For a Company
Version Date:03/29/2021
The following sample query returns risk factor section (Item 1a) from all available 10-K filings for a company.
Data Packages
Returns Institution (Humana, Inc.) 2017 10-K Filing
Version Date:03/29/2021
The following sample query below returns Humana, Inc. 2017 10-K Filing
Data Packages
Transaction Data Items
Version Date:03/29/2021
The following sample SQL query returns the Transaction Data Items
Data Packages
Returns Investors Commitment To PE Funds
Version Date:03/15/2021
The following sample query returns investors commitment to PE funds, committed amount in millions
Data Packages
Returns Descriptor Value For Carlyle Group
Version Date:03/15/2021
The following sample query returns descriptor value for Carlyle Group
Data Packages
Returns Funds Time Series, Benchmark Median IRR By NetIRRPct
Version Date:03/15/2021
The following sample query returns top 10 funds time series, benchmark median IRR by netIRRPct
Data Packages
Returns Statistic Time Series Data For Fund Managers And Investors
Version Date:03/15/2021
The following sample query returns statistic time series data for fund managers and investors
Data Packages
Returns Buyout Or Venture Capital Deals That Carlyle Group Participated As A Seller Or Buyer Since 2015
Version Date:03/15/2021
The following sample query returns buyout/ venture capital deals Carlyle Group participated as a Seller or Buyer since 2015
Data Packages
Returns Net Cash Flow For A Fund
Version Date:03/15/2021
The following sample query returns net cash flow for West Street Capital Partners VII
Data Packages
Returns Funds By Fund Size And Their Fund Managers
Version Date:03/15/2021
The following sample query returns top 10 PE\\VC funds by fund size (millions) and their Fund managers
Data Packages
Returns Buyout,VC Deals Details, Deal Service Providers And Participants Details Involved In A Deal
Version Date:03/15/2021
The following sample query returns buyout & VC deals details, deal service providers and participants details involved in a deal
Data Packages
Returns Mapping Of S&P Institution ID To Preqin Firm ids And Fund Ids
Version Date:03/15/2021
The following sample query returns mapping of S&P institution ID to Preqin Firm id's and fund id's
Data Packages
Returns PE Fund Service Providers And Service Type
Version Date:03/15/2021
The following sample query returns PE Fund service providers and service type
Data Packages
Returns Carbon Budget Alignment Summary
Version Date:03/10/2021
The following sample query returns Carbon Budget Alignment Summary for Exxon Mobil Corporation
Data Packages
Returns Region, Country, and GICS Industry Group
Version Date:03/10/2021
The following sample query returns Region, Country and GICS Industry Group Based Count of Companies for Different Alignment Types
Data Packages
Returns Tonnes CO2e Over 2 Degree Budget
Version Date:03/10/2021
The following sample query returns tonnes CO2e over 2 degree budget and current alignment for S&P 500 companies in decreasing order
Data Packages
Returns Sector Weight
Version Date:02/26/2021
The following sample query returns returns the number of companies in each sector in percentage, for Dec 31, 2020.
Data Packages
Returns Filing Types
Version Date:02/26/2021
The following sample query returns documentfile type with respective percentage of reportings.
Data Packages
Returns Historical Sector Sentiment Scores
Version Date:02/26/2021
The following sample query returns sector sentiment with potential swings in both directions (standard deviation). Note: Total aggregate is a composite of A-Share, NEEQ, and PCPD companies
Data Packages
Returns CSA Companies And Their Primary CIQ Industries
Version Date:02/26/2021
The following sample query ties CSA companies to CIQ Primary Industry.Note: Company Full Industry is a separately licensed product.
Data Packages
Reconstructs Carbon Earnings At Risk FTP Data
Version Date:01/18/2021
The following sample query reconstructs Carbon Earnings at Risk FTP data for sample companies for 2019 financial year
Data Packages
Returns Companies Having Unpriced Carbon Cost As A Percent Of EBITDA In Excess Of 50 Percent
Version Date:01/18/2021
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
Data Packages
Returns Region And Country Based Count Of Companies With EBIT At Risk For Forecast Year 2025
Version Date:01/18/2021
The following sample query returns region- and country-based count of companies with EBIT at risk for forecast year 2025, scenario level HIGH
Data Packages
Returns Data Items In The Trucost Carbon Earnings At Risk Data Package
Version Date:01/18/2021
The following sample query returns data items in the Trucost Carbon Earnings at Risk data package.
Data Packages
Returns Total Unpriced Carbon Cost
Version Date:01/18/2021
The following sample query returns total unpriced carbon cost for S&P 500 companies for forecast year 2030, scenario level LOW
Data Packages
Returns All Filings Companies Under The Ultimate Parent Travelers Companies Inc With Disposition
Version Date:01/06/2021
The following sample query returns all filings companies under the ultimate parent travelers companies Inc with disposition as Of 2018 and 2019
Data Packages
Returns Average Subscribers For National Geographics TV Network
Version Date:01/06/2021
The following sample query returns average subscribers for national geographics TV network
Data Packages
Returns Companies Under Berkshire Hathaway And Their Distribution Channels, Auditors And Actuaries
Version Date:01/06/2021
The following sample query returns Companies Under Berkshire Hathaway And Their Distribution Channels, Auditors And Actuaries
Data Packages
Returns Government Issued Govt. Bonds Owned By Berkshire Hathaway
Version Date:01/06/2021
The following sample query returns government issued govt. bonds owned by Berkshire Hathaway and reported in 2018 and 2019
Data Packages
Returns Contract Details Of The Northern Natural Gas Company Reported In 2020 With The Interconnect Natural Gas Facility
Version Date:01/06/2021
The following sample query returns Contract Details Of The Northern Natural Gas Company Reported In 2020 With The Interconnect Natural Gas Facility
Data Packages
Returns Comparables For Properties Within Thailand By Commodity, Stage, Mining And Processing Methods
Version Date:01/06/2021
The following sample query returns comparables for properties within Thailand by commodity, stage, mining and processing methods, etc.
Data Packages
Returns All Bonds And Stocks Disposed By New York Life Insurance
Version Date:01/06/2021
The following sample query returns All Bonds And Stocks Disposed By New York Life Insurance since 2018
Data Packages
Returns Amounts Payable On Assumed Losses And LAE Which Have Been Recognized As Paid By The Ceding Company
Version Date:01/06/2021
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
Data Packages
Returns 7 Day Gas Trading Volume For Chicago Trading Hub
Version Date:01/06/2021
The following sample query returns 7 Day gas trading volume for Chicago trading hub
Data Packages
Returns Yearly Average CO2 Emissions And Gross Generations Of All Powerplants
Version Date:01/06/2021
The following sample query returns yearly average CO2 emissions and gross generations of all powerplants in Texas
Data Packages
Proximity Postal Code Search
Version Date:01/03/2021
The following sample query returns proximity postal code search: pick up postal codes within X square miles from a specific postal code. One degree of lat / lon change equals to 69 miles in distance.', "Note: If you want 10 square miles from Chicago's O'Hara Airport (60666, IL Cook County) so you can aggregate the weather data 10 / 69 = x degree diff to identify 10 square miles from zip code 60666 = 1 original postal code + 76 alternative postal codes
Data Packages
Daily Average Temperature, Compared To Climatology Min, Avg, Max Values For A Given Location
Version Date:01/03/2021
The following sample query returns daily average temperature, compared to Climatology min, avg, max values for a given location', "Note First 'from' must be a leap year (366 days)
Data Packages
Total Return Using Market Data
Version Date:12/22/2020
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.
Data Packages
Returns Beneish M-score
Version Date:12/21/2020
The following sample query below returns Beneish M Scores for particular companies
Data Packages
Single Financial Data Item For A Single Financial Period
Version Date:12/17/2020
This API request pulls current total revenue and total assets values using relative period type
Data Packages
API Request Pulls 1 Year Forward Looking Total Revenue And Earnings - Estimates
Version Date:12/17/2020
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.
Data Packages
API Request To Return Business Entity Cross Reference Service (BECRS)
Version Date:12/17/2020
API request to request BECRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags
Data Packages
API Request Pulls Time Series Estimates To See How An Estimate Adjusts Through Time For 1 year Forward - Estimates
Version Date:12/17/2020
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.
Data Packages
API Request To Search And Return A Company Name With It's Associated Company Id
Version Date:12/17/2020
API Request to search and return a company name with it's associated company id
Data Packages
API Request Pulls Companies Direct Relationships - Company Intelligence
Version Date:12/17/2020
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.
Data Packages
API Request Pulls 2 Years Looking Forward Detailed Contributor And Their Related Revenue Estimates
Version Date:12/17/2020
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.
Data Packages
API Request To Pull Last 10 Fiscal Year End Periods For Total Revenue
Version Date:12/15/2020
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.
Data Packages
API Request To Pull Equity Time Series Pricing Data
Version Date:12/15/2020
API request to pull equity time series pricing data. All data is EOD
Data Packages
API Request To Pull As-Presented Revenue With Associated Financial Line Item Name
Version Date:12/15/2020
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.
Data Packages
Global Instruments Cross Reference Service (GICRS)
Version Date:12/15/2020
API request to request GICRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags.
Data Packages
API Request To 1st Request The Last 10 Unique Transaction Identifiers
Version Date:12/15/2020
API request to 1st request the last 10 unique transaction identifiers then request transaction data points for the specified transaction.
Data Packages
API Request To Pull Business Segment Revenue With Associated Business Segment Name
Version Date:12/15/2020
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.
Data Packages
API Request To Pull Time Series Exchange Rates For The Last Year
Version Date:12/15/2020
API request to pull time series exchange rates for the last year. All data is EOD. Identifiers supported are all ISO Currency Codes combinations.
Data Packages
Returns Currency Name For A Trading Item ID
Version Date:12/01/2020
The following sample query returns the currency name and currency ID for IBM (tradingitemid = 2621697) using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns CIQ Primary Identifiers By Ticker
Version Date:12/01/2020
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
Data Packages
Returns Data Item ID From CIQ Plugin Formula
Version Date:12/01/2020
The following sample query returns the Data Item ID (dataItemId) along with the SP Capital IQ Excel Plug-In Formula (CIQ Plug-In ID)
Data Packages
Returns CIQ Unquoted Securities
Version Date:12/01/2020
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
Data Packages
Returns Primary Industry
Version Date:12/01/2020
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
Data Packages
Returns Primary Exchange
Version Date:12/01/2020
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
Data Packages
Returns Inactive Ticker Symbols
Version Date:12/01/2020
The following sample query returns the inactive tickers for a company using SP Capital IQ tables in Xpressfeed
Data Packages
Returns CIQ Equities Trading On U.S Exchanges
Version Date:12/01/2020
The following sample query returns all equities trading on a U.S. stock exchange using the SP Capital IQ tables in Xpressfeed
Data Packages
Returns Securities and Exchange Commission (SEC) Central Index Key (CIK)
Version Date:12/01/2020
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
Data Packages
Returns Number OF Companies By Country And Region
Version Date:12/01/2020
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
Data Packages
Returns Securities Excluding REITs, Mutual Funds And ETFs
Version Date:12/01/2020
The following sample query returns securities excluding REITs, Mutual Funds, and ETFs using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Current Profile For A DeletedObjectID
Version Date:12/01/2020
The following sample query returns the current profile for a deletedObjectID
Data Packages
Returns Aggregate shipments by port of unlading, HS Code, and consignee
Version Date:11/23/2020
The following sample query displays aggregate shipments by port of unlading, HS Code, and consignee. It displays associated weights and shipment counts
Data Packages
Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordId
Version Date:11/23/2020
The following sample query displays the first instance of the fully matching HS Code for a given panjivaRecordId
Data Packages
Returns Trade Shipments For A Particular Ticker
Version Date:11/23/2020
The following sample query below displays U.S. import and export shipments for a particular ticker
Data Packages
Returns Three Levels Of An HS Code
Version Date:11/23/2020
The following sample query displays all three levels of an HS Code in order to create a full six digit view
Data Packages
Links Trade Data To Market Intelligence Sector Data
Version Date:11/23/2020
The following sample query links Panjiva trade data to S&P Global Market Intelligence industry sector data
Data Packages
Returns Time Series Of Trade For A Given Country Pair and HS Code
Version Date:11/23/2020
The following sample query returns time series of trade for a given country pair & HS Code
Data Packages
Returns All Levels Of HS Code By Category
Version Date:11/23/2020
The following sample query displays all levels of HS Code by category
Data Packages
Returns Company And Ultimate Parent
Version Date:11/23/2020
The following sample query displays a companys ultimate parent in S&P Capital IQ data
Data Packages
Data In Countries That Do Not Have A Data Source
Version Date:11/23/2020
The following sample query finds data in countries that do not have a data source
Data Packages
Returns Magnitude Of Restatements Within 500 Days
Version Date:11/18/2020
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.
Data Packages
Returns Credit Default Swaps Data
Version Date:10/29/2020
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
Data Packages
Returns Credit Default Swaps 5 Year Mid For A Company
Version Date:10/29/2020
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
Data Packages
Returns Dividend Yield
Version Date:10/27/2020
The following sample query calculates the dividend yield for all primary trading items on January 11, 2011 using the SP Capital IQ tables in Xpressfeed. Note: Because price and the indicated annual dividend may be in different currencies, both are converted to U.S. Dollars (USD) for the calculation
Data Packages
Returns Market Capitalization For Non-U.S Shares
Version Date:10/27/2020
The following sample query returns the market capitalization for the non-U.S. shares when they are the primary issue of stock
Data Packages
Returns 52 weeks high and low Prices
Version Date:10/27/2020
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
Data Packages
Returns Dividend Adjusted Prices
Version Date:10/27/2020
The following sample query calculates the dividend-adjusted price time-series for IBM using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns ISCRS Data
Version Date:10/27/2020
The following sample query returns ISCRS (Industry Sector Cross Reference Service) data for IBM in Xpressfeed
Data Packages
Returns Market Capitalization For A Company
Version Date:10/27/2020
The following sample query returns the market capitalization for a company for the most recent period using the SP Capital IQ tables in Xpressfeed
Data Packages
Returns SIC Codes And SIC Descriptions
Version Date:10/27/2020
The following sample query returns Standard Industrial Classification (SIC) codes and SIC descriptions using the Industry Sector Cross Reference Service (ISCRS) tables in Xpressfeed
Data Packages
Returns Pricing By Ticker Symbol
Version Date:10/27/2020
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)
Data Packages
Returns Deceased Professionals
Version Date:10/26/2020
The following sample query returns a list of deceased professionals for a company using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Current Products For A Company
Version Date:10/26/2020
The following sample query returns current products for a company using the SP Capital IQ Products package in Xpressfeed
Data Packages
Returns Competitors For A Company
Version Date:10/26/2020
The following sample query returns IBMs competitors from the SP Capital IQ Company Intelligence package in Xpressfeed
Data Packages
Returns SNL Real Estate Property Reported Summary Data
Version Date:10/21/2020
The following sample query returns the Occupancy Rate percentage for the last five fiscal years using the SNL Real Estate package in Xpressfeed
Data Packages
Returns List Of SNL Data Items By Industry
Version Date:10/21/2020
The following sample query returns a list of SNL data items by industry in Xpressfeed
Data Packages
Returns List Of Industry IDs
Version Date:10/21/2020
The following sample queryreturns a list of SNL Industry IDs in Xpressfeed
Data Packages
Returns InstituionId From Company Name
Version Date:10/21/2020
The following sample query returns the institutionID from a company name using the SNL package in Xpressfeed
Data Packages
Returns Sector Revenue/Total Revenue Of Different Institutions For The Year 2019
Version Date:10/13/2020
Returns Sector Revenue/Total Revenue Of Different Institutions For The Year 2019
Data Packages
Returns Environmental Data (Textual) Of American Electric Power Company, Inc. For The Year 2018
Version Date:10/13/2020
Returns Environmental Data (Textual) Of American Electric Power Company, Inc. For The Year 2018
Data Packages
Returns Environmental Data (Numeric) Of American Electric Power Company, Inc. For The Year 2018
Version Date:10/13/2020
Returns Environmental Data (Numeric) Of American Electric Power Company, Inc. For The Year 2018
Data Packages
Returns All The Data Items Delivered In The Trucost Environmental Data Packages
Version Date:10/13/2020
Returns All The Data Items Delivered In The Trucost Environmental Data Packages
Data Packages
Returns All Company Relationships Recursively
Version Date:09/30/2020
Returns Company Relationships Recursively, currently returning output for IBM, if you want to see for universe, please comment WHERE condition Please read comments for more information Tags - Corporate tree, Corporate Hierarchy, Company Hierarchy
Data Packages
Returns Latest Holdings Data For SPDR Sector ETFs
Version Date:09/29/2020
The following sample query returns Latest Holdings Data For SPDR Sector ETFs In Xpressfeed Using CIQ Ownership
Data Packages
Returns Primary Trading Items
Version Date:09/29/2020
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
Data Packages
Returns Public Companies Ownership Top Holders
Version Date:09/29/2020
The following sample query returns the top holders of a company using the SP Capital IQ Ownership and Base Files packages
Data Packages
Returns Market Value Of The Securities Owned By A Specific Holder
Version Date:09/29/2020
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
Data Packages
Returns Company And Ultimate Parent
Version Date:09/29/2020
The following sample SQL query displays the company name, the company\x92s ultimate parent, and the country and region for both using the Business Entity Cross Reference System (BECRS) package in Xpressfeed
Data Packages
Returns InstitutionId From CompanyId
Version Date:09/29/2020
The following sample SQL query returns the institutionID from a companyId using the BECRS package in Xpressfeed
Data Packages
Returns SecurityId Associated To CUSIP9
Version Date:09/29/2020
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
Data Packages
Returns CIQ RGA Securities
Version Date:09/29/2020
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
Data Packages
Returns Number Of CIQ Identifiers For BECRS Identifier Types
Version Date:09/29/2020
The following sample SQL query displays the number of identifiers that exist for each identifier type in BECRS
Data Packages
Returns CIQ Identifiers For Entities with an LEI in BECRS
Version Date:09/29/2020
The following sample SQL query displays a company and the corresponding identifiers, including DUNS, LEI, GVKEY, and SP Org Id, associated with that company based on the companyId in BECRS. Note: Increase the number companyIds as needed
Data Packages
Returns Ownership Details For Active Mutual Funds, Excluding Exchange-Traded Funds (ETFs) And Index Funds
Version Date:09/29/2020
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
Data Packages
Returns CIQ Identifiers Associated with CompanyIds
Version Date:09/29/2020
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.
Data Packages
Returns CIQ Activist Investor Data
Version Date:09/29/2020
The following sample query returns the Activist Investor companies for The Clorox Company using the SP Capital IQ Ownership package
Data Packages
Returns Various Rating Agency Identifiers
Version Date:09/29/2020
The following sample SQL query displays a company and the corresponding SP OrgId, the Fitch OrgId, and the Moody\x92s OrgId associated with that company based on the SP Capital IQ companyId in BECRS
Data Packages
Returns Latest Geographic Or Business Segments For A Company
Version Date:09/26/2020
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
Data Packages
Returns Moving Averages In CIQ Price Equity For Company Andeavor Logistics LP
Version Date:09/25/2020
The following sample query below Calculating Moving Averages in CIQ Price Equity for company Andeavor Logistics LP (Tradingitemid - 119026799)
Data Packages
Total Company Shares Outstanding On A Specific Date
Version Date:09/25/2020
Calculate company-level, aggregated shares outstanding on a particular historical date, incorporating both traded and non-traded shares outstanding and any relevant conversion factors
Data Packages
Returns P/E, P/BV, And TEV For A Company
Version Date:09/24/2020
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.
Data Packages
Returns Business Segment Revenue Along With NAIC And SIC Classifications For A Specific Period End Date
Version Date:09/24/2020
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
Data Packages
Returns As-Reported Details For A Company's Debt Capital Structure
Version Date:09/24/2020
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
Data Packages
Returns Summary Debt Information For A Company
Version Date:09/24/2020
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
Data Packages
Primary And Secondary Segment Mapping
Version Date:09/24/2020
This query returns the primary and secondary GICS mapping per segmentId for a company using the S&P Capital IQ files in Xpressfeed
Data Packages
Returns All CIQ Industry Specific Items For A Company
Version Date:09/23/2020
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
Data Packages
Returns P/E, P/BV, And TEV For A Company Using Latest Financials
Version Date:09/23/2020
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
Data Packages
Returns CIQ Period Last Market Cap
Version Date:09/23/2020
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
Data Packages
Time Series For A Single DataItemId
Version Date:09/23/2020
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
Data Packages
Returns The Total Same Store Sales Growth Percent
Version Date:09/23/2020
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
Data Packages
Returns The Number Of Companies With Non-Null Revenue For Each Calendar Year By Revenue Bands
Version Date:09/23/2020
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
Data Packages
Returns Address Details From A Professional ID
Version Date:09/07/2020
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)
Data Packages
Returns Companies With An IPO
Version Date:09/07/2020
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.
Data Packages
Returns Companies With The Highest CEO Pay Ratio ( For A Given Financial Year And GICS Sector)
Version Date:09/07/2020
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)
Data Packages
Returns Growth Rate Of A Particular Company CEOs Annual Compensation
Version Date:09/07/2020
The following sample query Returns the growth rate of a particular companys CEOs annual compensation for a two-year period
Data Packages
Returns A Person Profile
Version Date:09/07/2020
The following sample query displays a persons profile with biography, education, and board memberships
Data Packages
Returns Current Board Members
Version Date:09/07/2020
The following sample query returns current board members for IBM
Data Packages
Returns Companies With The Highest CEO Pay Ratio
Version Date:09/07/2020
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
Data Packages
Returns Latest Transcript For An Event
Version Date:08/31/2020
The following sample query returns latest transcript for an event using the S&P Capital IQ Transcripts package in Xpressfeed.
Data Packages
Returns Earning Calls Where CEO Answers Questions Using Specific Keywords For A Company
Version Date:08/31/2020
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.
Data Packages
Returns Aggregate Count Of Mentions Of A Specific Keyword
Version Date:08/31/2020
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.
Data Packages
Returns Aggregate Count Of Distinct Analysts Who Asked A Question During Quarterly Earnings Call
Version Date:08/31/2020
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.)
Data Packages
Returns Linkage Of Transcripts To Events
Version Date:08/31/2020
The following sample query returns linkage of transcripts to events for a company using the S&P Capital IQ Transcripts package in Xpressfeed.
Data Packages
Returns A Quarterly Change Series For One Item With Data Codes
Version Date:08/25/2020
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
Data Packages
Returns First Occurrence Of Fundamental Data In Point In Time (NEW)
Version Date:08/25/2020
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
Data Packages
Returns FootNotes For All Pointdates
Version Date:08/25/2020
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
Data Packages
Returns Time Series For Quarterly Sales
Version Date:08/25/2020
The following sample query builds a time-series for quarterly sales (SALEQ) for GVKEY 001078 (Abbott Labs) in Xpressfeed.
Data Packages
Returns Complete Time Series And A Value For All Pointdate-Datadate Combinations
Version Date:08/25/2020
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.
Data Packages
Returns A Annual Change Series For One Item With Data Codes
Version Date:08/25/2020
The following sample query builds an annual change series for annual sales (SALE) for GVKEY 007435 (3M)
Data Packages
Returns Time Series For Filing Dates
Version Date:08/25/2020
The following sample query returns a time-series for filing dates for GVKEY 012141 (Microsoft Corp)
Data Packages
Returns Most Recent Security Identifiers
Version Date:08/25/2020
The following sample query returns the most recent security identifiers for all issues for a company through the latest date
Data Packages
Returns Time Series Using Observation Dates
Version Date:08/25/2020
The following sample query builds a time series for one item for one company as of a particular observation date
Data Packages
This Query Returns S&P Capital IQ Estimates As Of A Specific Observation Date Using The CIQ Estimates Consensus Packages
Version Date:08/21/2020
This query returns S&P Capital IQ Estimates as of a specific observation date using the CIQ Estimates Consensus packages
Data Packages
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
Version Date:08/21/2020
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
Data Packages
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
Version Date:08/21/2020
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
Data Packages
This Query Returns S&P Capital IQ Estimate Contributors For Polymet Mining Corp (companyId = 875530) Using The S&P Capital IQ
Version Date:08/21/2020
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
Data Packages
This Query Returns The Time-Series For S&P Capital IQ Broker Consensus Recommendations
Version Date:08/21/2020
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
Data Packages
This Query Returns The Latest S&P Capital IQ Consensus EPS Estimates For Fiscal Years
Version Date:08/21/2020
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
Data Packages
This Query Returns The Data Item IDs Mapping The S&P Capital IQ Estimates Actuals To The Surprise Using The CIQ Estimates Details Package
Version Date:08/21/2020
This query returns the Data Item IDs mapping the S&P Capital IQ Estimates Actuals to the Surprise using the CIQ Estimates Details package
Data Packages
Returns Primary EPS In Compustat
Version Date:08/20/2020
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
Data Packages
Returns Shares Outstanding For A Time Period In Compustat
Version Date:08/20/2020
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
Data Packages
Datadate New Adjustment Factor Is Applied To Given Company
Version Date:08/20/2020
The following sample returns the datadate that a new adjustment factor is applied for stock splits
Data Packages
Returns GICS Code Description For All Level Of GICS Codes
Version Date:08/20/2020
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)
Data Packages
Returns Daily Price History
Version Date:08/20/2020
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
Data Packages
Returns Short Interest Data
Version Date:08/20/2020
The following sample query returns Short Interest data using Compustat packages (Here for Nasdaq Stock Market)
Data Packages
Physical Risk Asset Count For S&P 500 Companies For Given Year
Version Date:08/18/2020
This sample query identifies the physical risk asset count for S&P 500 companies for year 2018
Data Packages
Average S&P Global ESG Score For Five Countries (Applicable To Legacy)
Version Date:08/18/2020
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.
Data Packages
Sector Based Physical Risk Asset Count As A Percentage Of Total For Given Year
Version Date:08/18/2020
This sample query identifies the sector-based physical risk asset count as a percentage of total for year 2018
Data Packages
High Scenario-Based Score For Forecast Year 2030
Version Date:08/18/2020
This sample query returns High scenario-based score for forecast year 2030 for top ten S&P 500 companies with most number of assets
Data Packages
Score Weight Calculation Methodology (Applicable To Legacy)
Version Date:08/18/2020
This sample query derives score weights for 2019 assessment year industries. Note - This is applicable to legacy package.
Data Packages
Company Carbon Footprint
Version Date:08/18/2020
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
Data Packages
Physical Risk Sensitivity Scores For Companies
Version Date:08/18/2020
This sample query identifies the sensitivity scores for S&P 500 companies for year 2019 for seven physical risk indicators
Data Packages
Companies Most Heavily Exposed To Coal-Related Business Activities
Version Date:08/18/2020
This sample query identifies companies that derive revenues from coal-based activities to isolate portfolio exposure to transition risks
Data Packages
ESG Score Trend For Companies In An Industry (Applicable To Legacy)
Version Date:08/18/2020
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.
Data Packages
ESG Score Trend (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns the ESG Score trend for Biogen Inc. starting 2013. Note - This is applicable to legacy package.
Data Packages
Top 10 Most Sustainable Companies An Industry (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns the top 10 most sustainable companies in the Automobile industry in 2019 assessment. Note - This is applicable to legacy package.
Data Packages
ESG Scores In Detail (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns ESG Scores in detail for Abbott Laboratories for 2019 assessment year. Note - This is applicable to legacy package.
Data Packages
Returns The Members Of The Euro TOPIX Index
Version Date:08/09/2020
Returns the members of the Euro Topix Index
Data Packages
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
Version Date:08/09/2020
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
Data Packages
Returns The Tokyo Stock Price Index (TOPIX) Constituent Weights In Xpressfeed
Version Date:08/09/2020
Returns the Tokyo Stock Price Index (TOPIX) constituent weights in Xpressfeed as per the date and indexid we input
Data Packages
Returns The IndexID For The Desired Index AndReturns The FromDate And ToDate For The Specified Company In Relation To The IndexID
Version Date:08/09/2020
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
Data Packages
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
Version Date:08/09/2020
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
Data Packages
Returns S&P 500 Index Constituents By Industry
Version Date:08/09/2020
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
Data Packages
Returns The Ticker Symbol, GVKEY, Issue ID, And GICS Sub-Industry Code From The Xpressfeed
Version Date:08/09/2020
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
Data Packages
Returns Investible Weight Factor (IWF) For Weight Watchers International Inc. Effective On 11/02/2015 Using S&P Global BMI Index Data In Xpressfeed
Version Date:08/09/2020
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
Data Packages
Returns The GVKEY, IID, GSUBIND, And CUSIP From The Xpressfeed
Version Date:08/09/2020
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
Data Packages
Returns The Constituents Of The S&P Americas BMI Fundamentals (Sector) Index For 1 Day Using The BMI Index Feed In Xpressfeed
Version Date:08/09/2020
Returns the constituents of the S&P Americas BMI Financials (Sector) Index for 1 day using the BMI Index feed in Xpressfeed
Data Packages
Returns S&P 500 Index Constituents By Sector As Of A Specified Date
Version Date:08/09/2020
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
Data Packages
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
Version Date:08/09/2020
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
Data Packages
Returns Level 3 Fair Value Transparency
Version Date:07/01/2020
This query returns quarterly transparency for Level 3 assets and liabilities in Xpressfeed
Data Packages
Returns Companies Trading Pink Sheets Or OTC
Version Date:07/01/2020
This query returns all of the companies trading pink sheets or OTC
Data Packages
Returns Changes To Cash Flow Working Capital Changes For FASB 95
Version Date:07/01/2020
This query returns the components of the Working Capital changes on the Cash Flow Statement for a company using the Compustat data in Xpressfeed
Data Packages
Returns Companies With Amended Financial Statements
Version Date:07/01/2020
This query returns all companies that filed an amended 10-K for the fiscal year ending 12/31/2009
Data Packages
Returns Active/Inactive Companies
Version Date:07/01/2020
This query returns all active companies in Xpressfeed. Note: Uncomment the second query to get all inactive companies
Data Packages
Returns IS And BS Balancing Models For Banks
Version Date:07/01/2020
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
Data Packages
Returns Pre-FASB Companies
Version Date:07/01/2020
This query returns the Company Name (CONM), Global Company Key (GVKEY), and Security Description (DSCI) for pre-FASB companies in Xpressfeed
Data Packages
Returns Semi-Annual Cash Flow For International Companies
Version Date:07/01/2020
The following sample query calculates semi-annual cash flow from operating activities (OANCFY) for international companies
Data Packages
Returns Long Term Debt To Common Equity
Version Date:07/01/2020
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
Data Packages
Returns GICS For Companies On A Specific Exchange
Version Date:07/01/2020
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.
Data Packages
Returns PE, BKVLPS And Price Sales
Version Date:07/01/2020
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
Data Packages
Returns Foreign Sales As A Percentage Of Total Sales
Version Date:07/01/2020
This query returns the sales values for each geographic segment for IBM for fiscal year 2010 as a percentage of total sales in Xpressfeed
Data Packages
Returns All Changes To A Compustat Item Over Time In Canadian Point In Time
Version Date:07/01/2020
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:
Data Packages
Returns Record Count For A Specified Table For A Specified Date
Version Date:07/01/2020
This query returns the record count for a specified table for a specified time period
Data Packages
Returns Dates That The Constituents Of S&P 500 Change
Version Date:07/01/2020
This query returns the dates that the constituents of the S&P 500 Index change using the Compustat packages in Xpressfeed
Data Packages
Returns First Occurence For Pricing For A Security
Version Date:07/01/2020
This query returns the date of the first occurrence of pricing in the database for a security
Data Packages
Returns Mutual Funds
Version Date:07/01/2020
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
Data Packages
Returns Customer Names And Sales For A Company
Version Date:07/01/2020
This query returns all customer names and customer sales for Apple as of September 30, 2017 using Compustat Segment data in Xpressfeed
Data Packages
Returns Quarterly Transparency Data For An Item
Version Date:07/01/2020
This query returns the transparency calculations of Cost of Goods Sold - Quarterly (COGSQ) on one datadate using the Compustat Transparency data in Xpressfeed
Data Packages
Non-Interest Bearing Current Liabilities
Version Date:07/01/2020
This query calculates total non-interest bearing current liabilities
Data Packages
Returns companies with merger or spin-off
Version Date:07/01/2020
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.
Data Packages
Returns Compustat Common Equity
Version Date:07/01/2020
This query approximates Common Equity - Tangible (CEQT) on a quarterly basis using a particular gvkey and date
Data Packages
Returns Primary Issue Of Stock
Version Date:07/01/2020
This query returns the Primary Issue for a company in the Global database for a specific from and thru date
Data Packages
Returns The Most Current Datadate With Quarterly Financials
Version Date:07/01/2020
This query identifies the most current datadate for multiple companies where quarterly financial data is available in Xpressfeed
Data Packages
Returns Population Of Private Companies With Public Debt
Version Date:07/01/2020
This query returns the companies with public debt in the Compustat population in Xpressfeed
Data Packages
Returns Companies Where CURCD Differs From CURCDQ
Version Date:07/01/2020
This query returns companies where the ISO Currency Code - Annual is different from the ISO Currency Code - Quarterly for the same year
Data Packages
Returns Average Market Value For The Most Four recent Quarters.
Version Date:07/01/2020
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.
Data Packages
Returns Daily Translation Rates
Version Date:07/01/2020
This query returns the daily exchange rate to translate Hong Kong Dollars (HKD) to U.S. Dollars (USD) since inception
Data Packages
Returns Data Availability For A Particular Index
Version Date:07/01/2020
The following sample query returns all the data available for the REIT Index in Xpresfeed
Data Packages
Returns One Year Price History For An Index
Version Date:07/01/2020
This query returns the one-year price history for the S&P 500 Index from June 3, 2003 through June 2, 2004
Data Packages
Returns Quarterly Transparency Data For A Company
Version Date:07/01/2020
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
Data Packages
Returns Industrial Balance Sheet For Korean Companies
Version Date:07/01/2020
This query returns an Industrial Balance Sheet for companies from Korea
Data Packages
Returns Dual Listed Companies With Both US And Non-US Security Listings
Version Date:07/01/2020
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
Data Packages
Returns Compustat Market Data
Version Date:07/01/2020
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
Data Packages
Returns BerryQ Ratio
Version Date:07/01/2020
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
Data Packages
Returns Quarterly Static And Dynamic Transparency Data
Version Date:07/01/2020
This query returns both the static and dynamic quarterly transparency for a GVKEY on a specific datadate
Data Packages
Returns Security Identifiers For All Issues And All Dates In Snapshot
Version Date:07/01/2020
This query returns the identifiers and the exchanges that were active for each issue during specified times
Data Packages
Returns Trading Information For A Security
Version Date:07/01/2020
This query returns the lowest, highest, average, and total daily trading volume including the number of trading days for Microsoft during 2002
Data Packages
Returns Dividend Yield
Version Date:07/01/2020
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)
Data Packages
Returns Compustat Holidays By Country
Version Date:07/01/2020
This query returns U.S. holidays in Xpressfeed
Data Packages
Returns Current Ratio
Version Date:07/01/2020
This query returns the current ratio quarterly for IBM for the quarter ended March 31, 2008
Data Packages
Returns Quarterly Fair Value Liability Items
Version Date:07/01/2020
This query returns quarterly Fair Value Liability Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159
Data Packages
Returns Adjusted CSHOQ For A Company Over A Specific Time Period
Version Date:07/01/2020
This querypulls the quarterly common shares outstanding (CSHOQ) on an unadjusted and adjusted basis
Data Packages
Returns MIC Data For A Company's Securities
Version Date:07/01/2020
This query returns the Market Identifier Code (MIC) and the Stock Exchange Code (EXCHG) for all of a companys equity listings in Xpressfeed
Data Packages
Returns Indices With Constituent Markers
Version Date:07/01/2020
These queries return all indices with constituent markers including the start date for when the first constituents are available for each respective index
Data Packages
Returns Total Debt To Total Assets
Version Date:07/01/2020
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
Data Packages
Returns Index Name, GVKEYX, And Ist Date Of Pricing
Version Date:07/01/2020
This query returns the Index Name, GVKEY and the first date that price data was available for the Index
Data Packages
Returns Companies With Multiple Issues
Version Date:07/01/2020
This query returns all companies with multiple issues of stock
Data Packages
Returns NVDRs
Version Date:07/01/2020
This query identifies Non-Voting Depositary Receipts (NVDRs) by returning all issues with NVDR in the Security Description (DSCI) in Xpressfeed
Data Packages
Returns ROIC
Version Date:07/01/2020
This query calculates Return on Invested Capital (ROIC) for a company using the Compustat packages in Xpressfeed
Data Packages
Returns AJEXQ For Current Month
Version Date:07/01/2020
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
Data Packages
Returns FIC Changes Using North America Snapshot
Version Date:07/01/2020
This query finds changes to the ISO Country Code - Incorporation (FIC) in the last 20 years using the cscompany table in North America Snapshot
Data Packages
Returns Gross Margin(Annually And Quarterly)
Version Date:07/01/2020
This query calculates Gross Margin on an Annual basis in the Compustat database. Note: Uncomment the second query to get quarterly results
Data Packages
Returns Semi-Annual Cash Flow
Version Date:07/01/2020
This query calculates semi-annual cash flow from operating activities (OANCFY) for international companies
Data Packages
Returns Business Segments For A Company
Version Date:07/01/2020
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
Data Packages
Returns Number Of Companies In Annual Or Monthly Files
Version Date:07/01/2020
This query returns the number of companies in the co_adesind data group
Data Packages
Returns Number Of Observations For A Data Item
Version Date:07/01/2020
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
Data Packages
Returns NAICS And SIC Codes For A Company Segments
Version Date:07/01/2020
This query returns the Standard Industrial Classification Code - Segment (SICS) and North American Industry Classification Code - Segment (NAICSS) for a companys segments
Data Packages
Returns Index Membership For A Country
Version Date:07/01/2020
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
Data Packages
Returns Companies With Highest Market Cap That Had FY Change
Version Date:07/01/2020
This query returns the companies with the highest market cap that also had a fiscal-year change using the Compustat packages in Xpressfeed
Data Packages
Returns ROA For An Index
Version Date:07/01/2020
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
Data Packages
Returns Number Of Companies With Fundamental Data Available
Version Date:07/01/2020
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 )
Data Packages
Returns Total Debt
Version Date:07/01/2020
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
Data Packages
Returns Weekly Prices Using Daily Prices
Version Date:07/01/2020
This query returns the Friday prices for each week using the daily pricing data available for IBM iid 01
Data Packages
Returns Security Detail Information
Version Date:07/01/2020
This query returns selected security detail information for Philippine Telephone
Data Packages
Returns Comparable Sales
Version Date:07/01/2020
This query returns the details of the Comparable Sales (%) - Quarterly for a company in Xpressfeed
Data Packages
Returns Compustat Public Companies
Version Date:07/01/2020
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.
Data Packages
Returns constituents which have their GICS code changed prior to quarter-end
Version Date:07/01/2020
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
Data Packages
Returns Operating Segments For A Company
Version Date:07/01/2020
This query returns all operating segments for ALLIS-CHALMERS ENERGY INC as of 12/31/2007 _ /
Data Packages
Returns Quarterly Book Value Per Share
Version Date:07/01/2020
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)
Data Packages
Returns Limited Partnerships
Version Date:07/01/2020
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
Data Packages
Returns Annual Transparency Notes For Multiple Items Companies Years
Version Date:07/01/2020
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
Data Packages
Returns Financial Services Company
Version Date:07/01/2020
This query returns Total Assets for Aetnas financial services format as of 12/31/2009
Data Packages
Returns Companies With Preferred Stock And Without Common
Version Date:07/01/2020
This query returns companies without common or ordinary stock, but with preferred shares in Xpressfeed
Data Packages
Returns Standard Poors Quality Ranking for a CUSIP
Version Date:07/01/2020
The following sample queryreturns the Standard Poors Common Stock Ranking for a CUSIP in Compustat.
Data Packages
Returns Annual Fair Value Asset Items
Version Date:07/01/2020
This query returns annual Fair Value Asset Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159
Data Packages
Returns Daily Market Data For A Security
Version Date:07/01/2020
This query provides the daily close price (PRCCD), adjustment factor (AJEXDI), and common shares outstanding (CSHOC) for a security over a specified date range
Data Packages
Returns Number Of Companies With A Value Of Market Data Item On A Specific Date
Version Date:07/01/2020
This query returns the number of companies on the NYSE that have a value for Trading Volume - Monthly (CSHTRM) value on January 31, 2011
Data Packages
Returns Number Of Companies Reporting Annual, Semi-Annual, Or Quarterly Data By Country
Version Date:07/01/2020
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
Data Packages
Returns Long Term Debt To Shareholders Equity
Version Date:07/01/2020
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
Data Packages
Returns Pension Plan Assets
Version Date:07/01/2020
This query returns the components of Pension Plan Assets and the Total Plan Assets in Xpressfeed
Data Packages
Returns Daily Total Return For A Time Period
Version Date:07/01/2020
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
Data Packages
Returns Companies In A Located State
Version Date:07/01/2020
This query finds companies in Colorado and displays their City, ZIP/Postal Code, and GICS Sub-Industry Code and description
Data Packages
Returns Annual Fundamental Data At The Issue Level
Version Date:07/01/2020
This query returns annual fundamental data for Shanghai Electric Group Co Ltd. in Xpressfeed. ---Pulls Annual Issue Data , Footnotes, and Data Codes
Data Packages
Returns Annual Transparency Notes For A Company
Version Date:07/01/2020
This query returns all annual item notes and note subtypes for Starbucks Corp later than September 30, 2007 in Xpressfeed
Data Packages
Returns Master Limited Partnership
Version Date:07/01/2020
This query finds Master Limited Partnerships (MLP) using Compustat data in Xpressfeed
Data Packages
Returns GDRs
Version Date:07/01/2020
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
Data Packages
Returns Industrial Income Statement For Korean Companies
Version Date:07/01/2020
This query returns an Industrial format Income Statement for companies from Korea
Data Packages
Returns ETFs And SPDRs
Version Date:07/01/2020
This query search to return only SPDRs in Xpressfeed
Data Packages
Returns The Most Current Operating Income For The Current Constituents Of The S&P 500 Index
Version Date:07/01/2020
This query returns the most recent Operating Income after Depreciation (OIADP) for the current constituents of the S&P 500 Index
Data Packages
Returns Companies With More Than Specified Number Of Securities
Version Date:07/01/2020
This query returns all companies that have issued more than 10 securities
Data Packages
Returns Daily TRFD
Version Date:07/01/2020
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
Data Packages
Returns IS And BS Balancing Models For REITs
Version Date:07/01/2020
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
Data Packages
Returns Companies That Adopted FASB 158
Version Date:07/01/2020
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
Data Packages
Returns CFLPS
Version Date:07/01/2020
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
Data Packages
Returns Company Level Notes
Version Date:07/01/2020
This query returns the company-level notes for a company after a specific data date
Data Packages
Returns ROIC For A Company
Version Date:07/01/2020
The following sample query calculates Return on Invested Capital (ROIC) for a company (Here INTL BUSINESS MACHINES CORP) using the Compustat packages in Xpressfeed.
Data Packages
Returns Dates
Version Date:07/01/2020
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
Data Packages
Returns Global Economic Data
Version Date:07/01/2020
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
Data Packages
Returns Open Price For Index Constituents
Version Date:07/01/2020
This query returns the Open Price (PRCOD) for the constituents of the S&P 500 Index for December 1, 2016 in Xpressfeed
Data Packages
Returns Data Item Translated To USD For Non-US Companies
Version Date:07/01/2020
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
Data Packages
Returns IS And BS Balancing Models For Insurance Companies
Version Date:07/01/2020
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
Data Packages
Returns Companies Who Report Cash Flows Using Direct Method Statement
Version Date:07/01/2020
This query returns a line for each company and time period when the company reports a Cash Flow Statement using the Direct Method
Data Packages
Returns Companies TSX Venture Exchange
Version Date:07/01/2020
This query returns companies on the TSX Venture Exchange OR the Toronto Stock Exchange (TSX)
Data Packages
Returns EXCHANGETIER
Version Date:07/01/2020
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
Data Packages
Returns All Changes To An Item Over Time In Compustat Point-In-Time
Version Date:07/01/2020
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
Data Packages
Returns Annual Fair Value Liability Items
Version Date:07/01/2020
This query returns annual Fair Value Liability Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159
Data Packages
Returns Compustat Product Lines For A Company
Version Date:07/01/2020
This query returns all reported product lines for Georgia Pacific as of December 31, 2002
Data Packages
Returns Number Of Securities Issued Per Company
Version Date:07/01/2020
This query returns the number of securities issued per company
Data Packages
Returns NonTrading Active Companies
Version Date:07/01/2020
This query returns all companies that are not actively trading on any exchange, but are still active
Data Packages
Returns Companies That Emerged From Bankruptcy
Version Date:07/01/2020
This query identifies quarterly periods that have an AG footnote on Assets-Total - Quarterly (ATQ) in Xpressfeed
Data Packages
Returns Fortune 1000/Fortune 500 Companies By Rank
Version Date:07/01/2020
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
Data Packages
Returns Number Of Companies That Went Inactive During A Year
Version Date:07/01/2020
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
Data Packages
Returns FASB 158 Pro Forma Impact On StockHolders Equity
Version Date:07/01/2020
This query calculates the impact of SFAS 158 on Shareholders Equity for years prior to adoption (assuming a statutory tax rate of 35%)
Data Packages
Returns Foreign Government Sales
Version Date:07/01/2020
This query returns GVKEYs where the Customer Name contains foreign government (GOVFRN)
Data Packages
Returns Count Of Data Item Availability
Version Date:07/01/2020
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
Data Packages
Returns Segment Items
Version Date:07/01/2020
This query returns a list of all segment items and their descriptions
Data Packages
Returns Multiple Auditors For Companies
Version Date:07/01/2020
This query returns all international companies and their auditors on a specific datadate
Data Packages
Returns Daily Total Return For An Index
Version Date:07/01/2020
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):
Data Packages
Determining Primary Issues
Version Date:07/01/2020
This query returns the primary issue when more than one issue is listed as primary in the Compustat Company table in Xpressfeed
Data Packages
Returns PRCCD As Of A Specific Date
Version Date:07/01/2020
This query returns Price-Close Daily for IBMs domestic issue for March 18, 2004
Data Packages
Returns Details With Par Value And Exchange Country
Version Date:07/01/2020
This query returns GVKEYs and IID with a Par Value and the associated Exchange Country
Data Packages
Returns Price Close Daily
Version Date:07/01/2020
This query returns Price-Close Daily (PRCCD) on the day of a companys Initial Public Offering (IPO) in Xpressfeed
Data Packages
Returns Quarterly Fair Value Asset Items
Version Date:07/01/2020
This query returns quarterly Fair Value Asset Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159
Data Packages
Returns Monthly Return For A Time Period Using Monthly Pricing
Version Date:07/01/2020
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
Data Packages
Returns Market Value For Global Companies With Multiple Issues
Version Date:07/01/2020
This query calculates market capitalization for a Global company with multiple issues with fundamental data available
Data Packages
Returns IS And BS Balancing Models For Broker Companies
Version Date:07/01/2020
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
Data Packages
Returns Companies That File Financial Statements Late
Version Date:07/01/2020
The following sample query finds all late quarterly filings for quarter ending in 2010.
Data Packages
Returns FootNotes On Quarterly Income Statement Data
Version Date:07/01/2020
This query displays available footnotes for Quarterly Income Statement data for the specified GVKEY for the specified quarter
Data Packages
Returns Canadian Companies
Version Date:07/01/2020
This query returns Canadian companies by annual datadate
Data Packages
Linking MIC To Stock Exchange
Version Date:07/01/2020
This This query maps Market Identifier Codes (MIC) to Stock Exchange Codes (EXCHG) in Xpressfeed
Data Packages
Returns Companies With Quarterly Financials
Version Date:07/01/2020
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.
Data Packages
Returns Cash Flow Statement For Korean Companies
Version Date:07/01/2020
This query returns a Cash Flow Statement for companies from Korea
Data Packages
Returns Companies With Omitted Or Suspended Dividends
Version Date:07/01/2020
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
Data Packages
Returns Daily Total Return For Multiple Periods
Version Date:07/01/2020
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
Data Packages
Returns REITs
Version Date:07/01/2020
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)
Data Packages
Returns Market Value For Preferred Shares
Version Date:07/01/2020
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.
Data Packages
Returns monthly price to book ratio
Version Date:07/01/2020
The following sample query calculates monthly price to book ratio using daily pricing
Data Packages
Returns Annual Fundamental Financial Data Items
Version Date:07/01/2020
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)
Data Packages
Returns Interim Fundamental Data At The Issue Level
Version Date:07/01/2020
This query returns interim fundamental data for Samsung Electronics Co Ltd. in Xpressfeed
Data Packages
Returns Duplicate Company Names
Version Date:07/01/2020
This query finds multiple company names that exist for more than one distinct GVKEY in Xpressfeed
Data Packages
Returns Debt-To-Equity-Ratio Annual And Quarterly
Version Date:07/01/2020
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
Data Packages
Joining Semi Annual Income Statement Items With Quarterly Balance Sheet Items For International Companies
Version Date:07/01/2020
This query joins Semi-Annual Sales from the Income Statement items with Quarterly Total Assets from the Balance Sheet items for International companies
Data Packages
Returns Preliminary And Final Updates Over The Last Two Days
Version Date:07/01/2020
This query returns company that have had a final quarterly update over the last two days
Data Packages
Returns When Issued Stocks
Version Date:07/01/2020
This query returns When Issued stocks in Xpressfeed
Data Packages
Returns Members, Pricing And Market Value For A Specific Date
Version Date:07/01/2020
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
Data Packages
Returns Berry Ratio
Version Date:07/01/2020
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
Data Packages
Returns Major Index Constituents
Version Date:07/01/2020
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
Data Packages
Entity Level ICR Long Term Local Currency Rating at given Observation Date
Version Date:06/26/2020
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.
Data Packages
Returns CIQ Fundamentals In Reported And Target Currency
Version Date:06/03/2020
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
Data Packages
Returns Total Average Common Equity / Total Average Assets % (Data Item ID #4287)
Version Date:06/03/2020
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
Data Packages
Returns PIK Bonds Using CIQ Tables
Version Date:06/03/2020
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
Data Packages
Returns CIQ Annual Values For Restated Fiscal Year Basis
Version Date:06/03/2020
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
Data Packages
Filing Date For CIQ Instance
Version Date:06/03/2020
This query returns records from the S&P Capital IQ Fundamentals with a filing date of Mar-30-2018
Data Packages
Returns CIQ Data Item Values For A Single Data Item From Original Filings For A Company
Version Date:06/03/2020
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
Data Packages
Returns BETA For A Particular Company(Using CompanyId)
Version Date:06/03/2020
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
Data Packages
Returns Annual Historical Fundamentals For Specific Data Items
Version Date:06/03/2020
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
Data Packages
Returns Unit Type Name For The Data Items
Version Date:06/03/2020
This query returns the Unit Type Name (unitTypename) for data items using the S&P Capital IQ tables in Xpressfeed
Data Packages
Returns CIQ Fast Fundamentals Data Item List
Version Date:06/03/2020
This query returns the data items collected and calculated for S&P Capital IQ Fast Financials in Xpressfeed
Data Packages
Returns Shares Outstanding In The Other Component Section Of The ECS
Version Date:06/03/2020
This query returns the Shares Outstanding in the Other Components section of Equity Capital Structure (ECS) for TerraForm Power in Xpressfeed
Data Packages
Returns Latest Annual Fundamental Data
Version Date:06/03/2020
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
Data Packages
Returns The Number Of Companies With Geographic And/Or Business Segment Data
Version Date:06/03/2020
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
Data Packages
Returns CIQ Form Type
Version Date:06/03/2020
This query returns all of the available FormTypes in Xpressfeed for a particular finanacialPeriodId
Data Packages
Returns BETA For A Particular Company
Version Date:06/03/2020
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
Data Packages
Returns Shares Outstanding
Version Date:06/03/2020
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.)
Data Packages
Returns The Number Of Companies Filing Annual Or Quarterly Statements
Version Date:06/03/2020
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
Data Packages
Primary NAICS Codes For Specified Segmentid
Version Date:06/03/2020
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
Data Packages
Returns A List Of Reported Financial Statement Accounting Standards
Version Date:06/03/2020
This query returns a list of reported GAAP names (related to Financial Statement Accounting Standard)
Data Packages
Number Of CIQ Private Companies With Revenue
Version Date:06/03/2020
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
Data Packages
Returns CIQ Fiscal Year Change Period Detail
Version Date:06/03/2020
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
Data Packages
Returns Geographic Segment For A Company By Using Segment Id
Version Date:06/03/2020
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
Data Packages
Returns Most Recent EPS Items For A Specific Company
Version Date:06/03/2020
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
Data Packages
Returns Last Close Balance Sheet Shares Outstanding For A Company
Version Date:06/03/2020
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
Data Packages
Restatement Types For CIQ Premium Fundamentals
Version Date:06/03/2020
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
Data Packages
Latest Consolidated Data For A Company
Version Date:06/03/2020
This sample query returns the most recent consolidated annual financial data for RedcapTour Co., Ltd. (exchangeSymbol = KOSE, tickerSymbol = A038390) in Xpressfeed
Data Packages
Returns Basic Income Statements
Version Date:05/29/2020
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
Data Packages
Returns Financial Information For A Company
Version Date:05/29/2020
The following sample SQL query tries to find out the current annual (periodTypeId=1) financial information about a particular company using the ticker symbol
Data Packages
Returns Number Of Companies Reporting For A Data Item Annually
Version Date:05/29/2020
The following sample SQL query counts the number of companies that report to a particular dataitem from 1989 to 2019 annually (PeriodTypeId=1)
Data Packages
Returns Reported Currency And Convert To Target Currency Using Latest Financials
Version Date:05/29/2020
The following sample SQL query queries display the currency in which financials were reported and convert the data to a target currency
Data Packages
Returns Reported Currency And Convert To Target Currency
Version Date:05/25/2020
The following sample SQL queries display the currency in which financials were reported and convert the data to a target currency
Data Packages
Returns A Time Series Using Filing Dates
Version Date:05/25/2020
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
Data Packages
Latest Annual Filing For Latest Period
Version Date:05/25/2020
The following sample SQL queries display latest Annual Filing for a company for the current period
Data Packages
TEV/EBITDA Time Series
Version Date:05/25/2020
Calculates a quarterly time series of TEV/EBITDA by joining pricing date to period end date
Data Packages
Returns Same Day Updates For Income Statement Data
Version Date:05/25/2020
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
Data Packages
Number Of Quarterly Instances By Region Using Dynamic Pivot
Version Date:05/25/2020
The following sample query counts the number of quarterly instances by Region using Dynamic Pivot
Data Packages
Point-In-Time Sample Query Which Returns The Average Lag For US Companies
Version Date:05/25/2020
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
Data Packages
Returns A Time Series For A Single Data Item
Version Date:05/25/2020
The following sample SQL query displays a time series for a single data item for a company
Data Packages
Returns All Business Segment Fundamentals For A Company
Version Date:05/25/2020
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
Data Packages
Returns Company Information By A Different Identifier
Version Date:05/25/2020
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
Data Packages
Returns Basic Income Statement Items
Version Date:05/25/2020
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
Data Packages
Returns The Order Of Items In A Financial Statement For CIQPremiumFinancials
Version Date:05/25/2020
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
Data Packages
Returns Total Return
Version Date:05/25/2020
The following sample query below retrieves Total return calculation for company INTL BUSINESS MACHINES CORP (006066). /
Data Packages
Returns Multiple Instances For One Period
Version Date:05/25/2020
The following sample SQL queries display multiple instances for one period for a single company
Data Packages
Returns A Time Series
Version Date:05/25/2020
The following sample query below retrieves one data item, quarterly total revenue, for Abbott Laboratories (Ticker ABT) that is presented in a time series
Data Packages
Latest Instance For Financial Period - Annual Net EPS - Diluted Value
Version Date:05/25/2020
The following sample query below retrieves Latest Instance For Financial Period Annual Net EPS - Diluted value for International Business Machines Corporation (112350)
Data Packages
Returns Basic Balance Sheet Items
Version Date:05/25/2020
The following sample SQL query displays basic balance sheet items for a single company for the most recent four quarterly periods
Data Packages
Returns Latest Annual Fundamentals On Given Date
Version Date:05/25/2020
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
Data Packages
Returns The Original Filings For A Single Data Item
Version Date:05/25/2020
The following sample SQL query displays the original filings for a single data item for a given company
Data Packages
Returns From And Thru Dates For Each FiscalChainSeriesId Change, Including When The ID Changes Back To A Previous FiscalChainSeriesId (i.e., Morgan Stanley 472898)
Version Date:05/25/2020
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
Data Packages
Point-In-Time Date Progress Showing Quarterly Records
Version Date:05/25/2020
The following sample SQL query uses the Premium Financials Instance Date package to display Apple's filing vs. point-in-time date progression
Data Packages
Returns Multiple Instances For One Period(Annual)
Version Date:05/25/2020
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
Data Packages
Returns GICS Classifications For Segments
Version Date:05/25/2020
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
Data Packages
CIQ Premium Fundamentals PIVOT
Version Date:05/25/2020
PIVOTING Premium Financials for a few specific items for a set CompanyID , for a set Calendar Year. LatestPeriodFinancialFlag=1
Data Packages
Trucost Environmental Data
Version Date:05/11/2020
Returns a flattened dataset from the Trucost Envronmental Data similar to the legacy csv file delivery.
Data Packages
Trucost Sector Data
Version Date:05/11/2020
Returns a flattened dataset from the Trucost Data similar to the legacy csv file delivery.
Data Packages
Returns Muni ICR Ratings For An Entitys Securities
Version Date:05/10/2020
The following sample SQL query returns Muni ICR ratings for an entitys securities using SP Global Ratings packages in Xpressfeed
Data Packages
Returns Current Long Term Rating For A Portfolio Of CUSIPs
Version Date:05/10/2020
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
Data Packages
Links Program To Security For Ratings
Version Date:05/10/2020
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
Data Packages
Returns Current Long Term Rating For A CUSIP
Version Date:05/10/2020
The following sample SQL query returns the current long term rating for McDonalds from the SP Credit Ratings package in Xpressfeed
Data Packages
Returns Ratings For Securities Using CIQ Company ID
Version Date:05/10/2020
The following sample SQL query returns securities based on the SP Capital IQ company ID (objectId) using the RatingsXpress v4 tables in Xpressfeed
Data Packages
Returns Entity Symbol Values Assigned To Countries Or Sovereigns in Ratings
Version Date:05/10/2020
The following sample SQL query returns the entitySymbolValue assigned to countries or sovereigns using the SP Global Ratings V4 packages in Xpressfeed
Data Packages
Returns Long Term And Short Term Ratings For An Entity For The Last 24 Hours
Version Date:05/10/2020
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
Data Packages
Return All The Data Items Delivered In The Trucost Paris Alignment Data Packages
Version Date:04/22/2020
Return All The Data Items Delivered in The Trucost Paris Alignment Data Packages
Data Packages
Returns Financials
Version Date:01/10/2020
The following sample SQL query returns the financials for a company using the SP Capital IQ Transactions package in Xpressfeed.
Data Packages
Returns Consideration Details For A Transaction
Version Date:01/10/2020
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
Data Packages
Returns Offering Date For Fixed Income Securities
Version Date:01/10/2020
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
Data Packages
Returns Regulation D Offerings
Version Date:01/10/2020
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)
Data Packages
Returns IPO Transaction Prices
Version Date:01/10/2020
The following sample SQL query returns the IPO Transaction Prices using the SP Capital IQ Transaction Offering packages in Xpressfeed.
Data Packages
Returns Tender Offer Transactions With Percent Sought Greater Than Percent Acquired
Version Date:01/10/2020
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.