NexusFi: Find Your Edge


Home Menu

 





MAE + MFE CALCULATION SPREADSHEET


Discussion in Psychology and Money Management

Updated
    1. trending_up 4,978 views
    2. thumb_up 0 thanks given
    3. group 3 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 jsengxx 
POrtugal
 
Posts: 52 since Nov 2009

Hello,

I have seen many spreadsheets but I havenŽt seen one that does something with the MAE and MFE!
IŽam looking for a spreadsheet with some simple inputs that can calculate the stoploss and the target for my trades. I think this is de benefit of keeping a record of all trades taken with the MAE and MFE.
It is important to know the win loss ratio but you only can raise this ratio if you know your MAE and MFE if for example you raise your target to get a higher ratio but your MFE is lower than your target, you finally get a lower win loss ratio because your target is not hit.
So if we can make a spreadsheet that, with the record obtained of all taken trades, can calculate the stoploss and the final target we then can indeed increase our win loss ratio.

IŽam not so good with exel and IŽam keeping my records by hand so I calculate the stoploss and target by hand with that results.
I use one target for al my contracts.

Best regards,
Joăo Soares


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Without Pulisic, USA 61.5% Live vs. Australia -- France …
Prediction Markets & Event Contracts
CME Raises Energy Futures Margins After Iran-War Volatil …
Commodities
World Cup Opens: USA at 45.5% Tonight as Markets Push Ba …
Prediction Markets & Event Contracts
April 2026 Jobs Report: +115k vs +65k Expected
Traders Hideout
Rubios Good News Within Hours and the 30-Day Math: Why H …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
8 thanks
Darmok and Jalad at Tanagra
1 thanks
  #3 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,826


Which formulas do you use to calculate ideal SL and TP?

vvhg


Hic Rhodos, hic salta.
Reply With Quote




Last Updated on March 18, 2011


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts