Identifying Consensus Estimates Excluding Stock-Based Compensation and or Amortization of Intangibles Using Footnote

This sample query analyzes footnotes for Normalized EPS (ID: 100173) to infer whether stock-based compensation and/or Amortization of Intangibles is included or excluded, based on keyword positions in the note text. It returns period-level flags (sbc_status, intangible_status) to support custom tagging for Capital Group.

Enhancement Date: 6/16/2026

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyBase Data Item MasterCIQ Estimate Consensus DailyCIQ Estimate Core Daily
  • Associated Datasets
    S&P Capital IQ Estimates

Query Types

  • MSSQL
  • Snowflake
  • Databricks