Point-In-Time Sample Query Which Returns The Average Lag For US Companies Query Library Profile

Point-In-Time Sample Query Which Returns The Average Lag For US Companies

The following sample SQL query uses the Premium Financials Instance Date package to calculate the average lag for US companies, based on the restatement and form types. The query limits the universe to US, Original 10-Q collection for post 2009 records

SourceMarket Intelligence
Data Packages Required
Financial Premium Intraday Core Finl Latest Core Finl Premium Core Base Company Base Foundation Company Daily

请用认证信息登录，可解锁此内容

Other Queries for this Dataset(s)

S&P Capital IQ 财务数据

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

S&P Capital IQ 财务数据

As Reported Transparency

S&P Capital IQ 财务数据

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

S&P Capital IQ 财务数据

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

S&P Capital IQ 财务数据

Returns Financial Reporting Data By Company and Financial Statement Type

S&P Capital IQ 财务数据

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