Need a compounding excel spreadsheet | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Excel profit / loss tracking spreadsheet? 5 replies

Need forex excel calculation on compounding 2 replies

Need help with importing prices from MT4 into Excel spreadsheet 1 reply

Anyone have a d'alembert excel spreadsheet? 2 replies

Has anyone made an Excel spreadsheet to analyze your MT4 trades? 0 replies

Attachments: Need a compounding excel spreadsheet
Exit Attachments

Need a compounding excel spreadsheet

  • #1
  • First Post: Nov 12, 2011 1:11am Nov 12, 2011 1:11am
hey folks,

can any one good in excell make this compounding spread sheet for me?

10 pips daily

please make options to change starting balance,number of pips as well.

SB / lots / finishingbalance / pips
1001 lot11010
1101lot12010
1201lot13010
1301lot14010
1401lot15010
1501lot16010
1601lot17010
1701lot18010
1801lot19010
1901lot20010
2002lot24010
2402lot28010
2802lot32010
3203lot36010
Trade responsiblypatience is the key/Swing trader
  • #2
  • Nov 12, 2011 6:03am Nov 12, 2011 6:03am
Here it is. Let me know if it works for you.
Attached File(s)
File Type: zip 1.zip   48 KB | 9,272 downloads
  • #3
  • Nov 12, 2011 6:13am Nov 12, 2011 6:13am
Quoting enivid
Here it is. Let me know if it works for you.
perfect thanx a lot
Trade responsiblypatience is the key/Swing trader
  • #4
  • May 2, 2013 11:12pm May 2, 2013 11:12pm
this is the best so far available on INTERNET, hope it helps.
Attached File(s)
File Type: xls TmmForexIncomeCalculator.xls   117 KB | 12,131 downloads
been there done that, Good Bye
  • #5
  • Oct 11, 2015 1:08am Oct 11, 2015 1:08am
Hi all,

I'm very new to this and just started up a trading account and doing lots of reading to get my head around all of it. I'm currently practicing on and finding it very exciting. However, I know I have a long way to go as I get many correct trades but also get many wrong ones too.

I'm now setting up a trading plan to begin with and one of the books that I'm reading ($1000 to $1 Million in 80 days) explains the concept of compounding which is very appealing to me. Unfortunately the book seems to be somewhat outdated as all the links on there are no longer active. Firstly they mention an equity management tool to use, but that link is not available any longer. Secondly they mention many things that confuse me. for example the following:

 

  1. Stage 1 $1000 to $10,000 - 400:1
  2. Stage 2 $10,001 to $25,000 - 200:1
  3. Stage 3 $25,001 to $100,000 - 100:1
  4. Stage 4 $1001, 001 to $1,000,000 - 1:1

  1. Daily goal is 100 pips per day with a stop loss of 100
  2. Initial risk of 10% of the account
  3. when the account reaches $150,000 the risk is reduced to 2.5%
  4. Number of lots per trade to be increased in proportion to the total value of the account

Now some of this I can understand, but i get confused at the very start where it mentions ratios to begin with and secondly, if i have $1000 in my account, how do i manage a certain amount of that when I trade? I know this might be a very stupid question and might get a few of you having a good laugh at me, but I need to start asking if I'm to begin understanding this

Can someone please help me understand this? Every time I call someone they try to sell me courses that are only a couple of days and are worth thousands which I cant afford right now.

  • #6
  • Apr 1, 2019 8:57pm Apr 1, 2019 8:57pm
Quoting Intraforce
Hi all, I'm very new to this and just started up a trading account and doing lots of reading to get my head around all of it. I'm currently practicing on and finding it very exciting. However, I know I have a long way to go as I get many correct trades but also get many wrong ones too. I'm now setting up a trading plan to begin with and one of the books that I'm reading ($1000 to $1 Million in 80 days) explains the concept of compounding which is very appealing to me. Unfortunately the book seems to be somewhat outdated as all the links on there...

Did you figure it out?
Don't compare your trades to others. Most often the masses are the asses
  • #7
  • Apr 1, 2019 9:59pm Apr 1, 2019 9:59pm
Calculate your stoploss too. Then multiply in percent with your equity not account balance.
  • #8
  • Apr 22, 2021 11:08am Apr 22, 2021 11:08am
Quoting Intraforce
Hi all, I'm very new to this and just started up a trading account and doing lots of reading to get my head around all of it. I'm currently practicing on and finding it very exciting. However, I know I have a long way to go as I get many correct trades but also get many wrong ones too. I'm now setting up a trading plan to begin with and one of the books that I'm reading ($1000 to $1 Million in 80 days) explains the concept of compounding which is very appealing to me. Unfortunately the book seems to be somewhat outdated as all the links on there...
Hi bro, please can you send me this book? I want to try out something.. PLEASE BRO
  • #9
  • Last Post: Jul 30, 2021 5:38am Jul 30, 2021 5:38am
Quoting enivid
Here it is. Let me know if it works for you. {file}
Thanks buddy.
King Tornado
King Tornado GBPJPY All Time Return: -17.1%
0 traders viewing now