MT4 Trading the GAP With Excel | Page 122 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Trading using Excel and MT4? 29 replies

MT4 Trading without GAP and without Excel 669 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Integration between excel and MT4 prices 3 replies

Attachments: MT4 Trading the GAP With Excel
Exit Attachments

MT4 Trading the GAP With Excel

  • #2,421
  • Sep 15, 2016 2:52am Sep 15, 2016 2:52am
Quoting Murysco
{quote} Hi HP, How do you trail the basket in EAX? The basket (TRAIL THE LAST SET LOCK) does not work. After reaching the last set lock, i set to trail by $10 but it remains on the last lock even after $20 increase. Thanks.
He trail through BTM (BDM). And ... as i see, he open JPY basket. HP, am i right?
Stay hungry to be free...
  • #2,422
  • Edited 10:24am Sep 15, 2016 9:24am | Edited 10:24am
Quoting Murysco
{quote} Hi HP, How do you trail the basket in EAX? The basket (TRAIL THE LAST SET LOCK) does not work. After reaching the last set lock, i set to trail by $10 but it remains on the last lock even after $20 increase. Thanks.
Quoting myself from other thread...
Quoting aeseme
You modified the basket lock trail settings with the higher lock already acquired and the lock enabled, that seems to explain your statement of "does not work".
Next time please try to disable/enable Lock after doing changes on it's settings..
Cheers!
Have you already read the #Post 1 of this thread yet?
  • #2,423
  • Sep 24, 2016 2:15pm Sep 24, 2016 2:15pm
Hello everybody
looks like this thread has been shut down for months !!

well,I'm still workin on the project
I am currently testing 2 slightly different automated trading styles

  1. one is the usual "my own excel" 2 algorithms trading style,following the original WSD Jibala's system (In sport the saying goes, "Do not change a winning team")
  2. the other is a slight adjustment of the first,the main trigger here is the correlation of some couples of pairs, such as AudJpy-NzdJpy, GbpUsd-EurUsd, GbpUsd-GbpJpy and so on. It's a more selective system.

both automated systems
both are very advanced developments of Speedometer excel file

System one results:

23rd Sept trades
TOTAL TRADES 15
WINNING TRADES 11
HIT RATIO 73,33%
Trade management TP 7% , SL 15% ADR 5 days

System two results

23rd Sept trades
TOTAL TRADES 7
WINNING TRADES 6
HIT RATIO 85,71%
Trade management TP 7% , SL 10% ADR 5 days

I hope this thread could go back to the roots
A place where like-minded individuals gather to promote the exchange of ideas

Attached Image (click to enlarge)
Click to Enlarge Name: 23rd_sept_16.png Size: 119 KB
DO UT DES
  • #2,424
  • Sep 26, 2016 11:48am Sep 26, 2016 11:48am
Well done and well said the bourne. I could not agree more. The sharing of ideas is the foundation of this thread. Excel is spread sheets and formulas. To share ideas on excel development requires sharing the same spread sheets and formulas so the like minded individuals can discuss and test variants of the same spread sheets and formulas. This thread devolved into individuals showing off brief glimpses of successful runs on secret systems with what seems to be high discretionary factors. Any evidence of long term results with a firm set of formulas and rules has been absent. To me this is evidence of a lot of blown up accounts. We need to share files and set up several long term tests with fixed variables to succeed in this endeavor. I believe it is possible. I am in if we can assemble such a group again.
  • #2,425
  • Sep 26, 2016 2:40pm Sep 26, 2016 2:40pm
Quoting the bourne
Hello everybody looks like this thread has been shut down for months !! well,I'm still workin on the project I am currently testing 2 slightly different automated trading styles one is the usual "my own excel" 2 algorithms trading style,following the original WSD Jibala's system (In sport the saying goes, "Do not change a winning team") the other is a slight adjustment of the first,the main trigger here is the correlation of some couples of pairs, such as AudJpy-NzdJpy, GbpUsd-EurUsd, GbpUsd-GbpJpy and so on. It's a more selective system. both automated...
Hello Bourne,

Your method 2 might have a potential but not method 1.
Here is the explanation:

Method 1 winning expectancy = 15/(7+15) = %68
Total 15 trades so the standard deviation would be sqrt(pqn) which would result in sqrt(15*0.50*0.50)=1.94
Meaning that you winning trades should vary between (10.2 + 1.94*1.96) = 14 (maximum winning trades in 15 trades)
and (10.2 - 1.94 * 1.96) =6.4 (minimum expected winning trades out of 15 trades).
So your result of the method 1 Z Score would be 0.41, not too great.

Method 2:
Expectancy = 10/(10+7) = %58.8
Actual winning % = % 85.71
Stdev = 7 * 0.588 * 0.412 = 1.30
Z-Score = (6-4.12) / 1.30 = 1.44

Although the sample size on method 2 is small, on paper method 2 looks much better at this stage.

Hope this helps. Good luck....
  • #2,426
  • Sep 27, 2016 4:24am Sep 27, 2016 4:24am
"The sharing of ideas" , Let's face it , this thread doesn't exist without @JibalaPasan, she keep it alive not only because of the daily posts , but the IDEAS she shared here with us, without getting to much in return. Some of us doesn't have forex like a job, and just a part job or a passion so the time invested is smaller and can't keep up with the working volume, there is also another part that they expect to be "spoon-feed" and to get a holy grail from a forum, I think I said too many times that this is not gone happen.
And there is also another part of members here, that they develop a very wealthy trading system from this thread, with good results but they just prefer to stay "stealth" and not involved in the situation.

I always took a risk when I pushed for more information from @JibalaPasan, and in the end I made my mentor to take a pause from the thread. Even from that I could find a benefit because I start reading everything from 0 , from her first post and when you have a complete puzzle and you start to read everything from begin you understand thinks different then reading in the first time when you was in complete dark. I wounder how many would do that, even when they are that advanced with there system.

Are my "secret" & "hidden" formulas same like @JibalaPasan ? For sure many of them are different, there are different ways to get same results.
But they are good enough for me and maybe one day they will get better if I keep working.

Thanks @JibalaPasan & @nasap.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_AUDJPY_1tick_11-53-07.gif Size: 11 KB
By failing to prepare, you are preparing to fail.
  • #2,427
  • Sep 28, 2016 12:21pm Sep 28, 2016 12:21pm
What "I" have done or what "we" can do? This is the answer to the life or death of this thread. It has only made it this far due to the collaborative effort of many contributors who share information and developments. The thread is dying because there are no new informative formulas or coding being contributed.

What good is it to see a short one day run of success without knowing what criteria it represents? Or even to know if it is sustainable over a extended period of time and is capable of supporting a profitable business model. We need more good information like what the bourne is providing, extended time frames and defined variables. We need to step up and share ideas and even better yet spread sheets. If we can all work off of the same base sheet and test variables in a coordinated effort there is a chance that we can discover which combination of criteria work in what markets and what "flexi filters" need to be implemented to be consistently profitable.

What have you got too loose? I will go out on a limb here and say none of us has developed a consistently profitable automated system based on the gap theory. If it has been done why not publish YTD results and show everyone it has been done? If not why not share what has been learned to date and engage the rest of the available brain trust? This is a business , Bragging < Profits, Knowledge = Profits.

I have been watching the development of this system since nasap appeared in Udine's thread. There have been many attempts to quantify and code it into a profitable EA or spread sheet. I have read them all end to end. Every time we get close and define the known variables into code they change or new variables are added, always shrouded in vague terminology or secrecy. I have yet to see proof of a consistently profitable automated system. Yet I still feel hope that there is a way. It is a challenging road. Without a fixed and defined set of formulas and variables we are all lost wandering in the forest with no map.

In closing there have been attempts to create some unity. See the definitions on page one. (you are welcome.) and much coding has been contributed by the thread starter and other CONTRIBUTERS. I myself have participated by sharing and publishing the testing of EAs based on this system in another thread. Much was learned, many were discouraged and lost hope. Are we going to finish this thing? If we nail it a profitable EA can be created with the system and we can all retire.
  • #2,428
  • Sep 29, 2016 8:52am Sep 29, 2016 8:52am
hello friends, I would be grateful if someone can you indicate a paper ecxell dedicated to volumes. thanks in advance for all your answers
  • #2,429
  • Oct 11, 2016 6:39am Oct 11, 2016 6:39am
After bank holiday's there is always move, lot of activity today AUD / NZD and USD / JPY , like we learn from @JibalaPasan that's a dream for a scalper's isn't it ?

Since there is no holy grail here, we also got few SL's but is ok we can "tank" them.

Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_EURUSD_M30_14-31-48.gif Size: 12 KB
Attached Image(s) (click to enlarge)
Click to Enlarge Name: AUDUSD.gif Size: 54 KB
Click to Enlarge Name: GBPCAD.gif Size: 50 KB
By failing to prepare, you are preparing to fail.
  • #2,430
  • Oct 11, 2016 6:42am Oct 11, 2016 6:42am
To be "politically correct", a CT also.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_USDJPY_M30_14-41-31.gif Size: 53 KB
By failing to prepare, you are preparing to fail.
  • #2,431
  • Edited 8:35am Oct 11, 2016 7:59am | Edited 8:35am
Quoting dlouw
What "I" have done or what "we" can do? This is the answer to the life or death of this thread. It has only made it this far due to the collaborative effort of many contributors who share information and developments. The thread is dying because there are no new informative formulas or coding being contributed. What good is it to see a short one day run of success without knowing what criteria it represents? Or even to know if it is sustainable over a extended period of time and is capable of supporting a profitable business model. We need more...

Very well said. As a non coder, I can say that I've for the most part tried to share whatever ideas i had. The challenge is that a coder needs to like the idea enough to waste a whole bunch of time to code it to find it may not work as well as hoped. Nobody wants to waste another person's time. Yet, I don't have time to chase the ideas down myself, so without me proving it profitable that is exactly the risk. Yet without an EA it can't really be determined if the ideas are profitable. the whole chicken or egg thingy.

anyway for the sake of sharing here is what my brain has to offer, based on reading all of it since the beginning.

I like the idea of double gap only. Single gap is not good enough, yet pullbacks are where to enter on lower timeframes.

I've yet to see anybody make a free, simple 'double gap' version in MT4 based on percent change. It is my belief that it is a must to square price & time. I've an idea how to square price & time that I'm not going to share unless i can have it coded & tested properly. but i digress.....Some have said that it can be accomplished with normalizing of the price. I have no idea. I'm not a math expert or coder. my simple brains take is that currencies comparison must be made apples to apples. squaring the currencies. If currency A is at 160 on a scale of 20 to 205 and currency B is at 1.6 on a scale of .12 to 1.9 how are you going to compare them and expect good results? There must be a math to do so. my dumb brain would like to think percent chage would do so. who knows. perhaps someon can share here.

I've pointed out clearly that i thought nasap combined strength with correlation. Yet not one person has coded an mt4 indicator or EA that combines them both LOGICALLY so as to only take trades when both separately would present a trade opportunity.

The way that worked best for me to utilize the strength indicators is to identify strength & simply put up a fib manually, enter IF there is a pullback to get into the trade. Perhaps you could use a zig zag with fibo levels on it or something? complicated & or automated has not worked.

PS accept the fact that some people are more interested in coming here for there own ego than to do good work SO OTHERS/ALL BENEFIT.... those people will never ACTUALLY help you or me or anyone. I am aware of it so it no longer bothers me. I realize that it is liely someone will "claim" the ideas i present & code them & not share with me & may even sell them. I hope they check themself from that very normal human urge. i may never benefit from sharing but i've chosen to do the right thing anyway. I simply ignore the egomaniacs, since we all start out that way.

Thanks Guys
  • #2,432
  • Oct 11, 2016 9:37am Oct 11, 2016 9:37am
Quoting dagoods
{quote} Very well said. As a non coder, I can say that I've for the most part tried to share whatever ideas i had. The challenge is that a coder needs to like the idea enough to waste a whole bunch of time to code it to find it may not work as well as hoped. Nobody wants to waste another person's time. Yet, I don't have time to chase the ideas down myself, so without me proving it profitable that is exactly the risk. Yet without an EA it can't really be determined if the ideas are profitable. the whole chicken or egg thingy. anyway for the sake...
A code in MT4 is not going to help you , you can't backtest this strategy in MT4 , because is using tick by tick data! M1 bar's will be total irrelevant for any strategy tester. Of course you can go to other platform and use API with every tick history(something that MT4 is missing) but that requires even a higher level of coding knowledge

For trading only without strategy testing, multiple dashboards have been developed some free other private, an example of a private one.

It doesn't meter from where the signal's come , MT4 or M$ Excel are just platforms that send signal to broker, for some of us is more easy in M$ for other is easier to code mql.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_AUDJPY_M30_17-31-06.gif Size: 238 KB
By failing to prepare, you are preparing to fail.
  • #2,433
  • Oct 11, 2016 9:42am Oct 11, 2016 9:42am
Call it a day !
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Prtscr_EURUSD_M30_17-27-45.gif Size: 12 KB
Click to Enlarge Name: Prtscr_EURJPY_M15_17-41-51.gif Size: 52 KB
Click to Enlarge Name: Prtscr_NZDJPY_M15_17-42-10.gif Size: 55 KB
By failing to prepare, you are preparing to fail.
  • #2,434
  • Oct 11, 2016 1:11pm Oct 11, 2016 1:11pm
http://www.forexfactory.com/showthre...74#post9192174
  • #2,435
  • Oct 13, 2016 11:52pm Oct 13, 2016 11:52pm
The thread has everything it needs , all the ideas are here and have not been developed by me , all the credits go to @JibalaPasan . Idea's sharing, are more important then any formula or coded EA or any other spoon feed that other expect. Give the knowledge and maybe I can handle it better then you.


I just wake up and I can call it a day and a week ! No holy grail here like you can see, I still got SL , my WR is around 86% so far away from teacher results.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_EURUSD_M30_07-40-52.gif Size: 10 KB
Attached Image
By failing to prepare, you are preparing to fail.
  • #2,436
  • Oct 14, 2016 12:01am Oct 14, 2016 12:01am
Attached Image (click to enlarge)
Click to Enlarge Name: GBP.jpg Size: 133 KB


The time it enter the trade
Attached Image


Something that we already learn is that the fib's in spaghetti act like support and resistance, so trading around that level's is at high risk.

Attached Image (click to enlarge)
Click to Enlarge Name: basket2.png Size: 143 KB
By failing to prepare, you are preparing to fail.
  • #2,437
  • Oct 14, 2016 8:55am Oct 14, 2016 8:55am
hi, whats that EA? send or share the downloadable link ,
  • #2,438
  • Oct 18, 2016 11:58am Oct 18, 2016 11:58am
Dream scalping today, Tokyo session started with high volatility and it keep that way all day long. GBP this days it move side ways so I prefer more the counter trade technique.

Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_GBPUSD.e_M30_19-48-41.gif Size: 50 KB



Like you can see I still have SL's and few trades are closed early by the system because TP was not reach in right momentum and they are at a high risk of reversal.

Attached Image (click to enlarge)
Click to Enlarge Name: 1.png Size: 118 KB

Attached Image (click to enlarge)
Click to Enlarge Name: 2.png Size: 112 KB




Enough for today , time to sleep !

Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_AUDUSD.e_M30_19-44-25.gif Size: 14 KB


Market is already sleeping

Attached Image (click to enlarge)
Click to Enlarge Name: Sleep.png Size: 137 KB


Where did @the_bourne and @blacmoni go ? I would like to see other results for at least 200-300 consecutive trades.

Green pips !
By failing to prepare, you are preparing to fail.
  • #2,439
  • Oct 18, 2016 5:25pm Oct 18, 2016 5:25pm
deleted post
DO UT DES
  • #2,440
  • Oct 21, 2016 2:11pm Oct 21, 2016 2:11pm
Quoting project13et
The thread has everything it needs , all the ideas are here and have not been developed by me , all the credits go to @JibalaPasan . Idea's sharing, are more important then any formula or coded EA or any other spoon feed that other expect. Give the knowledge and maybe I can handle it better then you. I just wake up and I can call it a day and a week ! No holy grail here like you can see, I still got SL , my WR is around 86% so far away from teacher results. {image} {image}
Your analysis are very good also the results. Our system you've copied perfectly. Yet another hint to reduce false signals. See how the values of AUDUSD look like:

AUDUSD, Order Details: Main Trend DOWN, BR: 0.05 (+/- 0.69), RS: -6.38 (+/- 6.62), BS: -4.25 (+/- 1.54), BS GAP: 0.18 (+/- 0.45), APS: -2.72, AMS: 3.32, BSR: 50.00% / 50.00% (65.06%), Bs&Bs: 0.33 / 0.00 (+/- 0.74), AUDUSD -1.99 / 2.26

Would you buy AUDUSD? Not really, right? Because the values are speaking against a buy order. How many times I was talking about the power of correlation and correlation gap?

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.10.21_20h25m01s_004_.png Size: 237 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.10.21_20h30m27s_006_.png Size: 80 KB

Attached File(s)
File Type: zip correl_gap.zip   2.7 MB | 1,505 downloads

I will not explain more about it, just find out and complete the puzzle.

Wish you all a peaceful weekend.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
8 traders viewing now