Returns Annual Historical Fundamentals For Specific Data Items Query Library Profile

Returns Annual Historical Fundamentals For Specific Data Items

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

SourceMarket Intelligence
Data Packages Required
Finl Premium Core Finl Premium Capital Structure Finl Premium Detail Finl Premium Market Finl Premium Ratio Finl Premium Segments Finl Premium Statement Finl Premium Supplemental Base Company Base Data Item Master Base Equity Security Base Foundation Company Daily Base Security

To unlock this content, please sign in with your credentials

Other Queries for this Dataset(s)

S&P Capital IQ Financials

Retrieves Annual Financial Data for Specified Companies While Handling Conflicts Across Multiple FiscalChainSeriesIDs

S&P Capital IQ Financials

As Reported Transparency

S&P Capital IQ Financials

Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry

S&P Capital IQ Financials

Returns Point In Time EVIC Data Available As Per The Observation Date For MI Keys

S&P Capital IQ Financials

Returns Financial Reporting Data By Company and Financial Statement Type

S&P Capital IQ Financials

Returns Unconsolidated Financial EVIC Data Available As Per The LTM Holding Dates