# 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](https://help.edgetracker.com/advanced-scanner/readme) to create one first.

Add a new filter by clicking on the new filter icon as shown below.

<figure><img src="https://1155519678-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fon2dmGeVODO8QCgecDSI%2Fuploads%2FQMa4uTPry4SIXdX4nM2o%2Fdata_filters_formula.png?alt=media&#x26;token=2aaff5f7-a889-4e3f-aab5-083720252da9" alt=""><figcaption></figcaption></figure>

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 %}

<figure><img src="https://1155519678-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fon2dmGeVODO8QCgecDSI%2Fuploads%2Fg5HhUAad570ZwQuL7umd%2Fformula_filter_gain_50.png?alt=media&#x26;token=3f209f0c-689e-4e2c-a9cb-80b4ffee4786" alt=""><figcaption></figcaption></figure>
