Need help formulating an equation in excel - Off-Topic | futures trading

Go Back

> Futures Trading, News, Charts and Platforms > Off-Topic

Need help formulating an equation in excel
Started:March 7th, 2015 (09:39 PM) by mmeyerin Views / Replies:202 / 0
Last Reply:March 7th, 2015 (09:39 PM) 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

Need help formulating an equation in excel

Old March 7th, 2015, 09:39 PM   #1 (permalink)
Trading Apprentice
Futures Experience: Beginner
Platform: NinjaTrader
Favorite Futures: ETF
Posts: 3 since Jan 2015
Thanks: 0 given, 0 received

Need help formulating an equation in excel

I have a summary worksheet where I track all of my option investments. I want to systematically withdraw money from my trading balance. I formulated an equation that gives me the ideal withdraw amount for a given balance. I decided to make the withdraw whenever my account balance doubled. When the balance doubles I make the withdraw and I don't make another withdraw until this new balance doubles again. The next withdraw will be calculated using this new balance as well. Anyone have any idea how to set this up? Right now I have a column that tracks the balance every week after my trades.(I can send you the document and give you a visual if you're having difficulty understanding)

Reply With Quote

Reply > Futures Trading, News, Charts and Platforms > Off-Topic > Need help formulating an equation in excel

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
EasyLanguage and Excel - An Example ericbrown EasyLanguage Programming 3 January 31st, 2013 04:33 PM
Interesting Equation redratsal Off-Topic 13 December 14th, 2012 06:03 PM
Vant Tharp's Percent Volatility Position Sizing - FX equation - PLEASE ANYONE? fxhst329 Psychology and Money Management 5 November 16th, 2012 10:58 PM
ES - Volume analysis and formulating a plan trendisyourfriend Index Futures Trading 12 May 3rd, 2012 02:44 PM
The Trader's Equation: Should I Take This Trade? Anagami The Elite Circle 1 March 21st, 2011 05:33 PM

All times are GMT -4. The time now is 11:15 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-26 in 0.06 seconds with 19 queries on phoenix via your IP