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 RequiredBase CompanyBase Data Item MasterCIQ Estimate Consensus DailyCIQ Estimate Core Daily
- Associated DatasetsS&P Capital IQ Estimates
Query Types
- MSSQL
- Snowflake
- Databricks