Returns LTM Net Income Values For A Company For All The Calendar Month

The following sample query retrieves LTM Net Income month-end entries for every month of the calendar, filling in the dataItemValue with the latest figure.

Enhancement Date: 11/19/2021

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyBase Data Item MasterBase Equity SecurityFinancials Intraday ReferenceFinancials Premium Intraday Cap Structure NAPubFinancials Premium Intraday Coreub
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake