MAE + MFE CALCULATION SPREADSHEET - Psychology and Money Management | futures trading

Go Back

> Futures Trading, News, Charts and Platforms > Psychology and Money Management

Started:March 17th, 2011 (04:17 PM) by jsengxx Views / Replies:2,641 / 2
Last Reply:March 18th, 2011 (05:23 AM) Attachments:0

Welcome to

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread


Old March 17th, 2011, 04:17 PM   #1 (permalink)
Membership Temporarily Revoked
Futures Experience: Advanced
Platform: Ninjatrader
Posts: 54 since Nov 2009
Thanks: 0 given, 21 received



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

Old March 17th, 2011, 04:17 PM   #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


Old March 18th, 2011, 05:23 AM   #3 (permalink)
Elite Member
Northern Germany
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
vvhg's Avatar
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,789 received

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


Hic Rhodos, hic salta.
Reply With Quote

Reply > Futures Trading, News, Charts and Platforms > Psychology and Money Management > MAE + MFE CALCULATION SPREADSHEET

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum Favorable Excursion (MFE) % and optimization strategies RM99 Psychology and Money Management 26 January 28th, 2016 04:11 AM
Scaling-in/Adding near your average MAE; why not? Gary Psychology and Money Management 37 May 18th, 2011 07:06 AM
[NinjaTrader] Calculating the MAE and MFE for output Jura The Elite Circle 11 February 16th, 2011 09:44 AM
MFE Big Mike Terms (Glossary) 0 July 15th, 2010 12:40 AM
MAE Big Mike Terms (Glossary) 0 July 15th, 2010 12:38 AM

All times are GMT -4. The time now is 05:33 PM.

Copyright © 2016 by 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.
no new posts

Page generated 2016-10-28 in 0.07 seconds with 19 queries on phoenix via your IP