The Grid Trend Multiplier Excel Model
Use this model to establish your account size, grid size or trading range assumption
Please watch this video which will explain how you can use this Excel Model
Download the Excel model here
17 thoughts on “The Grid Trend Multiplier Excel Model”
Leave a Reply
You must be logged in to post a comment.
Cheers – thats saved me a few hours!
rgds
Tim
How do you get the latest version for the GTT EA? Especially if you have the original version? Is it going to be an automatic download? This would count as an upgrade and we get all upgrades for free correct?
thanks Alex, nice tool! Good explanation.
in this video you don’t talk about pruning.
Do you have some suggestions as to when and where you would advise to prune?
Nice tool,thank you saves a lot of calculating
I want advice to about when,where to prune from what grid level and so?
thx
First thing to do in make sure you are on the GTT mailing list – if you are not you can’t be communicated with
Hi Alex,
A great tool, should be very helpful in trying to estimate some reasonable settings for the EA.
Just a thought regarding a possible upgrade to the EA in the future as far as setting the account balance. Instead of having to open seperate accounts etc. Would it be possible to have the option to set an amount of starting capital the GTM EA uses from your account. That way any profit would automatically be preserved, rather than trying to determine when to take profits. It would also allow you to open a number of grids on the one account in a portfolio type of approach.
I’m sure this has already been thought of, and may not be possible, but I thought it was worth mentioning.
Kind Regards
Roland
Hi Alex,nice tool.
I have a question.
We have the possibility to disable one leg of the trading system, long or short. Is it possible to disable one leg while both are playing, and what happens to the open positions? For instance, long and short enabled with 6 sell and 1 buy. The trend is becoming clearly long: I modify the settings, disabling the short leg. The short positions remain opened, I suppose, and no more short positions were open. When the market return neutral, we enable the sell leg. Do you think this could be a valid strategy?
Best to check these on demo accounts with small gaps so that you can see the results quickly.
Yes you can disable and enable the sell leg once both have been trading. The EA will stop opening sell transactions. Whether it will close the open sell transaction when it should has not been tested.
At this stage you might have to manage this manually by using stops or targets or a manual close. Unfortunately I don’t think this will be added as an upgrade as it detracts from the way the GTM should be traded a bit. Brokers will generally allow you to open as many accounts as you like.
Hi Alex
Could you explain the ideal withdrawal timing alittle better please?
What I have been doing is
Say starting balance is $400 and I have 500.1 leverage, now once I have a grid financed and my equity is = to or greater than my starting balance I withdraw from my balance and bring it back to the starting value say $400. It’s like starting again but the grid is already there. I am at the point where I can withdraw again and if I do this would make the rest of this grid a free investment as I would have withdrawn all the initial investment.
Am I making the withdrawals to soon?
Cheers
As long as your are withdrawing true gains you are OK. True gains are 1) Cashed in trades less 2)open trades less 3) what you have already withdrawn – . If +1-2-3 is negative do not withdraw. I would suggest that you withdraw only after 20% to 30% gains. The object is to create a risk free investment as soon as possible because you will just be printing money if the price stays in a reasonable “paid for” range.
Current Balance Starting Balance Cash in Deals
623 – 400 = 223
-127.66 Current DD cost
95.34 Profit / Loss
So are you saying if I setup a spreadsheet something like this and targeted 20% to 30% of starting balance in Profit / Loss then that’s the time to withdrawal the funds. So in this case if I wanted too I could withdraw the $95.34 as that would be the profit ?
My Broker’s Mini account = EURUSDm 400:1 and 1.00 mini lot is $1. The figures i get for the spredsheed is confusing. lf i want to use nano lots eg 0.01 how much should l use if Grid size is 12 and want to have 30 open levels.
You question is specifically addressed in this link https://gridtrendmultiplier.com/determining-the-forex-broker-account-size-you-need-to-trade-the-forex-grid-trend-multiplier/. In general $400 per 0.01 lot applies to 400:1 leveraged using that type of gap size. I would suggest that you consider maximum open trades of 20 as that will give better financing costs once the price has move 30 price levels.
hi alex,
what means the “margin” in the inputs…what i have to give in there?
thanks
Hi,
Am I correct that the assumption of 0.1 mini lot traded is on a per trade basis? So 0.1 lot for every level?
Yes that can be achieved. You can vary lot sizing or keep them consistent