Returns From And Thru Dates For Each FiscalChainSeriesId Change, Including When The ID Changes Back To A Previous FiscalChainSeriesId (i.e., Morgan Stanley 472898)

The following sample query below retrieves from and thru dates for each fiscalChainSeriesId change, including when the Id changes back to a previous fiscalChainSeriesId (i.e., Morgan Stanley 472898). Note: The FiscalYear value in the Quarterly table is just the year of the periodEndDate and not not perfectly align with all companies

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium CoreFinl Premium DetailFinl Premium MarketFinl Premium RatioFinancials Premium Intraday CoreBase Data Item Master
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake