Returns Cumulative Twelve Quarter R&D Spending With Linear Decay Weighting

The following SQL query returns the R&D Stock Factor where the dataitemid is 100 for R&D Expenses.

Enhancement Date: 4/18/2022

  • SourceMarket Intelligence
  • Data Packages Required
    Base Data Item MasterFinancials Intraday ReferenceFinancials Premium Intraday Cap Structure NAPubFinancials Premium Intraday Core
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake