> For the complete documentation index, see [llms.txt](https://help.edgetracker.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.edgetracker.com/advanced-scanner/creating-filters-and-columns-using-formulas/function-reference/daily-indicator-functions.md).

# Daily Indicator Functions

Daily Indicator Functions allow you to calculate technical indicators using daily market data. These functions can be applied directly to a specific date or to the date when a security reaches its highest or lowest value within a given range. By combining these indicators with other daily data points, you can create precise filters and columns to analyze market trends, volatility, and momentum.

### DAILY\_SMA

Returns the daily simple moving average (SMA) of a requested data point.

{% code overflow="wrap" %}

```
[DAILY_SMA(requested_data, offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the SMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `offset_days` - Starting point for the calculation, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_SMA(price_close_adj, 0, 20)]
```

{% endcode %}

This example returns the 20-day SMA of the adjusted closing price for the scan date.
{% endtab %}
{% endtabs %}

***

### DAILY\_EMA

Returns the daily exponential moving average (EMA) of a requested data point.

{% code overflow="wrap" %}

```
[DAILY_EMA(requested_data, offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the EMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `offset_days` - Starting point for the calculation, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_EMA(price_close_adj, 0, 20)]
```

{% endcode %}

This example returns the 20-day EMA of the adjusted closing price for the scan date.
{% endtab %}
{% endtabs %}

***

### DAILY\_RSI

Returns the daily relative strength index (RSI).

{% code overflow="wrap" %}

```
[DAILY_RSI(requested_data, offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the RSI for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `offset_days` - Starting point for the calculation, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_RSI(price_close_adj, 0, 14)]
```

{% endcode %}

This example returns the 14-day RSI for the scan date.
{% endtab %}
{% endtabs %}

***

### DAILY\_ATR

Returns the daily average true range (ATR).

{% code overflow="wrap" %}

```
[DAILY_ATR(offset_days, periods)]
```

{% endcode %}

**Parameters**

* `offset_days` - Starting point for the calculation, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_ATR(0, 14)]
```

{% endcode %}

This example returns the 14-day ATR for the scan date.
{% endtab %}
{% endtabs %}

***

### DAILY\_SMA\_AT\_MAX

Returns the daily simple moving average (SMA) of a requested data point for the date another data point reaches its maximum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_SMA_AT_MAX(requested_data, max_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the SMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `max_data` - Data point to evaluate for the maximum value. SMA will be returned for the date when `max_data` reaches its highest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_SMA_AT_MAX(price_close_adj, price_high_adj, -10, -1, 20)]
```

{% endcode %}

This example finds the date with the highest price from the previous 10 trading days, then returns the 20-day SMA of the adjusted closing price for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_SMA\_AT\_MIN

Returns the daily simple moving average (SMA) of a requested data point for the date another data point reaches its minimum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_SMA_AT_MIN(requested_data, min_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the SMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `min_data` - Data point to evaluate for the minimum value. SMA will be returned for the date when `min_data` reaches its lowest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_SMA_AT_MIN(price_close_adj, price_low_adj, -20, -1, 50)]
```

{% endcode %}

This example finds the date with the lowest price from the previous 20 trading days, then returns the 50-day SMA of the adjusted closing price for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_EMA\_AT\_MAX

Returns the daily exponential moving average (EMA) of a requested data point for the date another data point reaches its maximum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_EMA_AT_MAX(requested_data, max_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the EMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `max_data` - Data point to evaluate for the maximum value. EMA will be returned for the date when `max_data` reaches its highest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_EMA_AT_MAX(price_close_adj, price_high_adj, -10, -1, 20)]
```

{% endcode %}

This example finds the date with the highest price from the previous 10 trading days, then returns the 20-day EMA of the adjusted closing price for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_EMA\_AT\_MIN

Returns the daily exponential moving average (EMA) of a requested data point for the date another data point reaches its minimum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_EMA_AT_MIN(requested_data, min_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the EMA for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `min_data` - Data point to evaluate for the minimum value. EMA will be returned for the date when `min_data` reaches its lowest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `250`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_EMA_AT_MIN(price_close_adj, price_low_adj, -20, -1, 9)]
```

{% endcode %}

This example finds the date with the lowest price from the previous 20 trading days, then returns the 9-day EMA of the adjusted closing price for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_RSI\_AT\_MAX

Returns the daily relative strength index (RSI) for the date another data point reaches its maximum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_RSI_AT_MAX(requested_data, max_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the RSI for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price).
* `max_data` - Data point to evaluate for the maximum value. RSI will be returned for the date when `max_data` reaches its highest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_RSI_AT_MAX(price_close_adj, price_high_adj, -10, -1, 14)]
```

{% endcode %}

This example finds the date with the highest price from the previous 10 trading days, then returns the 14-day RSI for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_RSI\_AT\_MIN

Returns the daily relative strength index (RSI) for the date another data point reaches its minimum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_RSI_AT_MIN(requested_data, min_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `requested_data` - Data point to calculate the RSI for. Must be a [daily price data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#price)..
* `min_data` - Data point to evaluate for the minimum value. RSI will be returned for the date when `min_data` reaches its lowest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_RSI_AT_MIN(price_close_adj, price_low_adj, -20, -1, 14)]
```

{% endcode %}

This example finds the date with the lowest price from the previous 20 trading days, then returns the 14-day RSI for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_ATR\_AT\_MAX

Returns the daily average true range (ATR) for the date another data point reaches its maximum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_ATR_AT_MAX(max_data, start_offset_days, end_offset_days, periods)]
```

{% endcode %}

**Parameters**

* `max_data` - Data point to evaluate for the maximum value. ATR will be returned for the date when `max_data` reaches its highest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_ATR_AT_MAX(price_high_adj, -10, -1, 14)]
```

{% endcode %}

This example finds the date with the highest price from the previous 10 trading days, then returns the 14-day ATR for that date.
{% endtab %}
{% endtabs %}

***

### DAILY\_ATR\_AT\_MIN

Returns the daily average true range (ATR) for the date another data point reaches its minimum within a specified date range.

{% code overflow="wrap" %}

```
[DAILY_ATR_AT_MIN(price_low_adj, -10, -1, 14)]
```

{% endcode %}

**Parameters**

* `min_data` - Data point to evaluate for the minimum value. ATR will be returned for the date when `min_data` reaches its lowest value. Accepts any available [daily data point](/advanced-scanner/creating-filters-and-columns-using-formulas/data-point-reference/daily-data-points.md#data-points).
* `start_offset_days` - Start of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `end_offset_days` - End of the date range to evaluate, specified as trading days relative to the scan date. Must be a whole number between `-2,520` and `2,520`.
* `periods` - Number of trading days to include in the calculation. Must be a whole number between `2` and `50`.

{% tabs %}
{% tab title="Example" %}
{% code overflow="wrap" %}

```
[DAILY_ATR_AT_MIN(price_low_adj, -10, -1, 14)]
```

{% endcode %}

This example finds the date with the lowest price from the previous 10 trading days, then returns the 14-day ATR for that date.
{% endtab %}
{% endtabs %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.edgetracker.com/advanced-scanner/creating-filters-and-columns-using-formulas/function-reference/daily-indicator-functions.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.