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

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

Enhancement Date: 7/8/2025

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyBase Data Item MasterFinl Premium StatementFinl Premium Core
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • Snowflake