> 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/examples/calculation-examples.md).

# Calculation Examples

The Advanced Scanner supports a set of arithmetic functions that can be applied to available data points. Available functions include **Average, Sum, Max, Min, First,** and **Last.** Each function is evaluated directly within the scan, allowing you to construct filters and columns that return calculated results. This article provides examples of how to use each function.

## Average

This example creates a column that returns the average volume over the previous 5 trading days.

<figure><img src="/files/pn6D9uJUAETBjWrxX0qL" alt=""><figcaption></figcaption></figure>

## Sum

This example creates a column that returns the total volume for the first 30 minutes of trading.

<figure><img src="/files/hBVpaGqbaENePJF1c6Os" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
In this example, **Bar Size** is set to 30 minutes, but using 1, 5, 15, or 30 minutes will all produce the same result.
{% endhint %}

## Max

This example creates a column that returns the highest price during the first 15 minutes of trading.

<figure><img src="/files/8BL5vZeXpJXePMYjwOfD" alt=""><figcaption></figcaption></figure>

## Min

This example creates a column that returns the lowest price during the first 15 minutes of trading.

<figure><img src="/files/sCixBxxkJQ4SmoVHM9Ik" alt=""><figcaption></figcaption></figure>

## First

This example creates a column that returns the first traded price between 7:00 AM and 9:29 AM.

<figure><img src="/files/0ySzbrre328SgD1OgNJz" alt=""><figcaption></figcaption></figure>

## Last

This example created a column that returns the last traded price between 7:00 AM and 7:59 AM.

<figure><img src="/files/CPkGTEUCimX4goZ592Hx" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
**Tip:** You can use these same selections to create a filter instead of a column.
{% endhint %}


---

# 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/examples/calculation-examples.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.