Tessera

MAE and MFE Calculator

Maximum adverse excursion (MAE) is how far a trade went against you before it closed; maximum favourable excursion (MFE) is how far it went your way. Paste your trades to get both for every trade, a scatter plot of MAE against the result, and stop distances taken from your winners' MAE.

Paste

One trade per line: side (long or short), entry, exit, highest high and lowest low while the trade was open. Comma, tab or space separated; a header line is fine.

Trades

15

10 winners, 5 losers

Median MFE, all trades

0.00470

Typical best point reached

Avg giveback, winners

0.00074

MFE minus final result

Losers that were up first

0

MFE at least as big as the final loss

Stop distances from winners' MAE

A starting point, not an answer: a stop just beyond these levels would have kept that share of winners, but it also turns the winners beyond it into losses. Replay the trades with the new stop before using it.

PercentileWinners' MAEWinners beyondLosers beyond
80th0.0011625
90th0.0014415
95th0.0016215

Based on 10 winners. Percentiles from fewer than about 30 are unstable.

MAE against result

Hover or tap a dot for its values

−0.0020.0000.0020.004

MAE (distance against the trade) →

Winners LosersVertical axis: Result
MAE and MFE per trade
LineMAEMFEResult
2 long0.000900.005200.00400
3 long0.002600.00060−0.00240
4 short0.000600.004800.00400
5 long0.001100.005100.00450
6 short0.002800.00160−0.00260
7 long0.000600.005400.00480
8 short0.000800.004900.00420
9 long0.002800.00170−0.00260
10 long0.001800.005200.00410
11 short0.000300.004300.00380
12 long0.002800.00040−0.00260
13 short0.001400.004700.00410
14 long0.000700.004800.00440
15 short0.002800.00090−0.00260
16 long0.000600.004600.00370

How MAE and MFE are calculated

Long:  MAE = Entry − Lowest low      MFE = Highest high − Entry
Short: MAE = Highest high − Entry    MFE = Entry − Lowest low
Result (long) = Exit − Entry         Result (short) = Entry − Exit

The high and low are the extremes while the trade was open. Results are in price units, so for a mix of symbols convert to R (divide by each trade's initial risk) and use the "MAE, MFE, result" input instead.

Suggested stop distances

The calculator sorts your winners' MAE and reports the 80th, 90th and 95th percentiles (linear interpolation, like Excel's PERCENTILE.INC). If the 90th percentile is 0.45R, 90% of winners never went more than 0.45R against you. It also counts how many winners and losers went beyond each level.

That is only half of the trade-off. A tighter stop:

  1. turns the winners beyond it into losses, losing their whole profit;
  2. shrinks the losses on losers that would have run to the old stop;
  3. changes position size if you size by risk, which changes every result in R.

The scatter plot can't give you the net effect. Replaying the trades with the new stop can.

Pitfalls

  • Entry and exit bars. Using the full high and low of the entry bar can overstate MAE if the extreme happened before your fill.
  • Stops cap losers' MAE.A trade stopped at 1R can't show much more than 1R of MAE, so winners are the informative group.
  • Mixed conditions. Quiet and volatile sessions have different excursions; split them before setting one rule for both.

The full method, including where to find MAE and MFE in TradingView, is in our MAE and MFE analysis guide.

TesseraFAQs

Questions about the mae and mfe calculator