DEUSHARVEST
Simple Moving Average (SMA)
The Simple Moving Average (SMA) is a fundamental technical analysis tool that calculates the average price of a security over a specified number of periods. Its primary purpose is to smooth out price data by filtering short-term volatility, making it easier for traders to identify the direction of the underlying market trend.
SMA
=SMA(data, period) Example Usage
=SMA(A2:F500, 50)
Parameters
| Parameter | Type | Description | Status |
|---|---|---|---|
data | Range | The input range of columns containing the Date, Open, High, Low, Close, and Volume data. | Required |
period | Number | The number of periods (days) over which the Simple Moving Average is calculated. | Required |
Returns
A two-column array of dates and their corresponding SMA values.
