TD_SMOOTHMA Function Syntax | Teradata Vantage - TD_SMOOTHMA Syntax - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
TD_SMOOTHMA (
  SERIES_SPEC (time_series),
  FUNC_PARAMS (
    MA ({ CUMULATIVE |MEAN | MEDIAN | EXPONENTIAL })
    [ , WINDOW (integer) ]
    [ , ONE_SIDED ({ 0 | 1 }) ]
    [ , LAMBDA (float) ]
    [ , PAD (float) ]
    [ , WEIGHTS (float [,...]) ]
    [ , WELL_KNOWN (“3MA” | “5MA” | “2x12MA” | “3x3MA” |
        “3x5MA” | “S15MA” | “S21MA” | “H5MA” | “H9MA” |
        “H13MA” | “H23MA”) } ]
  )
  [, OUTPUT_FMT (INDEX_STYLE ({ NUMERICAL_SEQUENCE |
        FLOW_THROUGH })) ]
);

Wherever 1 appears in the syntax, the function also accepts a positive integer greater than 0 that it treats as 1.