> 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/examples/filter-50-gain-in-the-past-year.md).
# Filter: 50% Gain in the Past Year
This example creates a filter that returns securities that gained at least 50% at any point in the past year.
To add this filter, open an existing scan and follow the steps below. If you don't have a scan yet, see this [article](/advanced-scanner/readme.md) to create one first.
Add a new filter by clicking on the new filter icon as shown below.
Use the following formula and click "Add".
{% code overflow="wrap" %}
```
[DAILY_VALUE_AT_MAX_AFTER_MIN(price_high_adj, price_high_adj, price_low_adj, -252, -1)] / [DAILY_MIN(price_low_adj, -252, -1)] > 1.5
```
{% endcode %}