Support Board
Date/Time: Sat, 30 Nov 2024 05:32:48 +0000
Post From: Calculating MAE and MFE from trade activity logs
| [2022-12-23 22:11:08] |
| yqz - Posts: 17 |
|
Hi, I've been looking at the trade activity logs as a means to do self-evaluation of my trading. I noticed two columns named HighDuringPosition and LowDuringPosition. I was wondering if it's possible to use these two to calculate maximum adverse excursion (MAE) and maximum favorable excursion (MFE). Looking through the data, it seems that there are many blank values, so not all the necessary information seems to be included. Is there some way to fill in the missing values to make it possible to calculate MAE and MFE? I was thinking that an alternative would be to get the historical time & sales data for the time period of a trade and just find the high/low PnL for that time period. However, I've looked at (Time and Sales Window: Viewing Time and Sales on a Spreadsheet), but it doesn't seem to work when I try to load the study or load the saved file. When I load the study, the study is just a blank space. I can't seem to save the file as a .txt either. It just seems to be like saving a chart book. Thank you for your time. |