Returns Most Recent Annual Filing Date For A Universe Of Companies As Of An Observation Date

This query takes an observation date, and then for a universe of companies determines the most recent annual filing as of the observation date. Query can be customized for other period types and data items

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium CoreFinl Premium DetailFinl Premium MarketFinl Premium RatioFinl Premium StatementFinl Latest CoreBase CompanyBase Data Item MasterBase Foundation Company Daily
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake