MT4 Trading the GAP With Excel | Page 102 | 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,021
  • Jul 2, 2016 1:43pm Jul 2, 2016 1:43pm
Quoting jarfx05
I realize that the vision of the great fortunes can be tempting for you , but fast cash without effort is a fairy tale for the big kids . It is about as likely as meeting the Loch Ness monster or the Yeti Financial market there is no such thing as predicting the future , and the best example of this is the fact that financial analysts (ie modern variant listed diviners ) are of similar magnitude , and often even worse than the monkeys who bet at random , which already confirmed a number of studies practical Therefore, if you think you can beat the...
The question is why don't you stick to the topic and make this thread unreadable by posting your non-related stuff? Just take your dashboard and move on to the dashboard thread. You can show to the members there how successful it works, at least for you. The dashboard threads are empty, the members are waiting on traders like you are. Guide them! Show them how easy the Pips can be collected with such a powerful dashboard!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,022
  • Edited Jul 3, 2016 4:44am Jul 2, 2016 2:11pm | Edited Jul 3, 2016 4:44am
Quoting JibalaPasan
{quote} The question is why don't you stick to the topic and make this thread unreadable by posting your non-related stuff? Just take your dashboard and move on to the dashboard thread. You can show to the members there how successful it works, at least for you. The dashboard threads are empty, the members are waiting on traders like you are. Guide them! Show them how easy the Pips can be collected with such a powerful dashboard! Jibala
There are no easy pips , everything must be patiently developed . You're right. There is no point discuss with someone who thinks so . This is my last entry . Enjoy yourself of the trading.

To all who think about the real earning money would recommend it

http://www.forexfactory.com/showthread.php?t=391229

Attached File(s)
File Type: ex4 CCI Dashboard.ex4   16 KB | 522 downloads
if you're doing we all have results with all
  • #2,023
  • Jul 3, 2016 6:48am Jul 3, 2016 6:48am
I had a look back on your last trades you show here, AUDJPY & GBPJPY, and was wondering if there was not an opposite signal already? If no, then something mus be really wrong!

Example EURCAD:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.01_17h05m16s_137_.png Size: 57 KB

I did not bet a single centavo on this pair anymore to become a winner. Sell signals were present already and it could have been a winner on the sell side with the same TP ~17 Pips. Can be hedging the position a solution? At least it can reduce those big losses by approximately the half. Let's give it a try!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,024
  • Edited 8:48am Jul 3, 2016 8:25am | Edited 8:48am
Quoting JibalaPasan
I had a look back on your last trades you show here, AUDJPY & GBPJPY, and was wondering if there was not an opposite signal already? If no, then something mus be really wrong! Example EURCAD: {image} I did not bet a single centavo on this pair anymore to become a winner. Sell signals were present already and it could have been a winner on the sell side with the same TP ~17 Pips. Can be hedging the position a solution? At least it can reduce those big losses by approximately the half. Let's give it a try! Jibala

GBPJPY had a clear signal in opposite just after the moment the position was open, but because of the ban, it has maxim 1 trade per pair every 30 minutes. So it was block by the existing trade open already.

For some trades the best position possible will be the open a double position lot if a new signal is near SL level without closing the actual position, and moving the SL for the first trade. The position should be take similar to first one, not in opposite direction.

The problem is that is very hard to automatic code and to chose what pairs should have that behavior .

Quoting JibalaPasan
{quote} What we've analyzed that GBP pairs are very strange at the moment, we should exclude them. Next, counts for all currencies, the "failing" levels which you can see in the chart. We currently work with filters for the specified areas but still needs more data to be analyzed. {image} Currencies very often fail on that Fibo extension level. And finally there are many small time-frames all over the day when we should give the market just a break to breath. One reason for all this is of course the fact that we have the situation with the BREXIT...
Regarding this level's , two weeks ago I add this levels in my excel, called them OB/OS . Very simple rules, if the strength basket currency hit the Red fib or green fib in the past 15 minutes I ban the whole pairs of that basket, the ban is applied only with the trend not for counter trends, because If any other trade will be taken there with the trend near that level's I assume it's already late and I lose the perfect momentum , so it's late.

After 2 weeks of observing this, I can say it save me so far 7 SL's. All the wining that would be taken there are not covering that SL's.
At this moment I ignore that levels if I am having a full basket signal, need to see if feature if this is still a good decision or not. Is hard to totally ignore trading around that level's since daily high's / low's are formed and we will totally miss them.


A very important question, should a maxim GAP be measure ? Can we assume if a GAP of 3 or 2.5 or whatever you want as maxim it was reach it late to take a trade?
By failing to prepare, you are preparing to fail.
  • #2,025
  • Jul 3, 2016 10:15am Jul 3, 2016 10:15am
Quoting project13et
{quote} GBPJPY had a clear signal in opposite just after the moment the position was open, but because of the ban, it has maxim 1 trade per pair every 30 minutes. So it was block by the existing trade open already. For some trades the best position possible will be the open a double position lot if a new signal is near SL level without closing the actual position, and moving the SL for the first trade. The position should be take similar to first one, not in opposite direction. The problem is that is very hard to automatic code and to chose what...
How can it give an opposite signal right after entry? Something must be wrong! Doubling, pyramiding, martingale = a gambling system of continually doubling the stakes in the hope of an eventual win that must yield a net profit. This has never worked before and it will never work in the future!

The OBOS area is not the "dead" zone, the zone I was talking about is a zone before the OBOS area. We don't have enough data yet, it has just changed at the end of last week.

You don't need to measure a max. GAP but a min. GAP is mandatory! Secondly, keep in mind for counter trade the ratio should be at least 1:3 whereby -55:165 is not the same as -165:55 which is much better! Just to play a bit with numbers. The GAP of the countered part of a pair should be much more negative than the opposite part is positive.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,026
  • Jul 3, 2016 4:35pm Jul 3, 2016 4:35pm
Quoting JibalaPasan
{quote} You forgot at least two import things: - this is all about scalping and no long term run! FIFO (fast in fast out), small crumbs of a big cake. - the system runs in fully auto mode, has an average of +60 orders / day with an average of ~10 Pip / order What the heck I do need more than to sit back and count the Pips?
Wow that would sure make me a happy camper! You deserve it, I am sure you and your boss worked your butts off to get to this point.
  • #2,027
  • Jul 4, 2016 6:37am Jul 4, 2016 6:37am
Probably this trade would never get executed manual, we can easy see on chart that USD and JPY are high correlated and we know there normal behavior , so if there is a risk for JPY trade's it should be for USD also, but is way too restrictive for automatic coding ... or is not?... At the time of the enter the LBAR didn't prevent it for less then 2 pip's.

The trade was late executed because waited for the sync.

Quoting JibalaPasan
{quote} How can it give an opposite signal right after entry? Something must be wrong! Doubling, pyramiding, martingale = a gambling system of continually doubling the stakes in the hope of an eventual win that must yield a net profit. This has never worked before and it will never work in the future! The OBOS area is not the "dead" zone, the zone I was talking about is a zone before the OBOS area. We don't have enough data yet, it has just changed at the end of last week. You don't need to measure a max. GAP but a min. GAP is mandatory!...
The opposite signal was given because GD has change in the other direction , at that time only GD was giving the direction of the trade, probably I need more MTF gap's for the direction, but then it will slow it down until it get the confirmation .....
Attached Image(s) (click to enlarge)
Click to Enlarge Name: GBPUSD.png Size: 249 KB
Click to Enlarge Name: GBPUSD2.png Size: 73 KB
By failing to prepare, you are preparing to fail.
  • #2,028
  • Jul 4, 2016 2:39pm Jul 4, 2016 2:39pm
Some trades today,all automated
London open +3 hours hit ratio 100%

wondering Leet and Jibala what update interval are currently using for their excel files
1 hour?
30 min?
15 min?

Today results 30 minutes
Attached Image(s) (click to enlarge)
Click to Enlarge Name: AUDJPYM15.png Size: 64 KB
Click to Enlarge Name: EURAUDM15.png Size: 64 KB
Click to Enlarge Name: EURCADM15.png Size: 68 KB
Click to Enlarge Name: london_trades_today.png Size: 20 KB
DO UT DES
  • #2,029
  • Jul 4, 2016 2:48pm Jul 4, 2016 2:48pm
Quoting the bourne
Some trades today,all automated London open +3 hours hit ratio 100% wondering Leet and Jibala what update interval are currently using for their excel files 1 hour? 30 min? 15 min? Today results 30 minutes {image} {image} {image} {image}
I have no update interval, everything goes live tick by tick, no VBA involved, all ticks get exported to be more clear, since JibalaPasan always let this par unclear
By failing to prepare, you are preparing to fail.
  • #2,030
  • Jul 4, 2016 3:09pm Jul 4, 2016 3:09pm
Quoting project13et
Probably this trade would never get executed manual, we can easy see on chart that USD and JPY are high correlated and we know there normal behavior , so if there is a risk for JPY trade's it should be for USD also, but is way too restrictive for automatic coding ... or is not?... At the time of the enter the LBAR didn't prevent it for less then 2 pip's. The trade was late executed because waited for the sync. {quote} The opposite signal was given because GD has change in the other direction , at that time only GD was giving the direction of the...
You never walk alone!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.04_14h49m12s_023_.png Size: 58 KB

If actually there is a loser, it's a GBP pair for sure!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,031
  • Jul 4, 2016 3:18pm Jul 4, 2016 3:18pm
Quoting the bourne
Some trades today,all automated London open +3 hours hit ratio 100% wondering Leet and Jibala what update interval are currently using for their excel files 1 hour? 30 min? 15 min? Today results 30 minutes {image} {image} {image} {image}
I have three of yours only and almost the same time only EURAUD 20 min. early.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.04_21h57m09s_029_.png Size: 58 KB

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

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.04_21h51m35s_028_.png Size: 85 KB

My today's favorite:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.04_16h58m23s_025_.png Size: 70 KB

Don't know what update interval you are talking about, all is tick by tick via DDE!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,032
  • Jul 4, 2016 4:57pm Jul 4, 2016 4:57pm
iam out too... after month here as a "silent reader" i see this threat grow and as a "comunity based project". down the roadmap one guy is postig his profits everyday without any worth for the community and maybe ends as many good threats here in the "selling system" subforum

cheers
  • #2,033
  • Jul 5, 2016 1:05am Jul 5, 2016 1:05am
Quoting vanberger
iam out too... after month here as a "silent reader" i see this threat grow and as a "comunity based project". down the roadmap one guy is postig his profits everyday without any worth for the community and maybe ends as many good threats here in the "selling system" subforum cheers
There is nothing to sell here, everyone is free to develop his own system with little knowledge of mql coding and excel, only the one that failed trading are looking to sell stuff.
Beside that there are trading ideas and analyze, ideas that have been present also in other threads but didn't got developed so far with this complexity.
By failing to prepare, you are preparing to fail.
  • #2,034
  • Jul 5, 2016 6:31am Jul 5, 2016 6:31am
Quoting JibalaPasan
{quote} I have three of yours only and almost the same time only EURAUD 20 min. early. {image} {image} {image} My today's favorite: {image} Don't know what update interval you are talking about, all is tick by tick via DDE!
Can you check please you're AUDUSD and AUDNZD GC, the values seams to be inverted to each other. Thanks,
By failing to prepare, you are preparing to fail.
  • #2,035
  • Edited 10:31am Jul 5, 2016 10:13am | Edited 10:31am
Quoting JibalaPasan
{quote} I have three of yours only and almost the same time only EURAUD 20 min. early. {image} {image} {image} My today's favorite: {image} Don't know what update interval you are talking about, all is tick by tick via DDE!

Leet and Jibala,thx for the replies
I was talking about the GAP interval update
into my Excel I can choose between 3 time intervals,15min,30min and 1hour
and my Excel is updated tick by tick as well
but I guess you both can see multiGap updating from H4 to M15 into your files,and 5m updates for Spaghetti
I'm almost there

tonight first Tokyo attempt,100% hit ratio
some losses from other Sessions,in the last 30 hours 22 trades,4 losses,18 winners
hit ratio 81.8%
TP 9pips
SL 27 pips
2 trades closed manually,'cos I don't like to let trades browsing around into dead hours

Jibala,thx for the trades comparison,very useful

your trade AUDJPY at 2016.07.04 12:45:06 ,I had a signal but trade was not entered 'cos I have the rule 1 trade x session
your trade NZDCHF at 2016.07.04 10:49:09, I had a very late buy signal,31 minutes later,not traded by automated EA 'cos it was too close to Fibo level
your trade NZDUSD at 2016.07.04 16:45:00 , I have had 3 buy signals: a previous buy signal at 15:36 rejected by the EA 'cos price was too close to Fibo level (0.721904), a later signal rejected 'cos it was into the last 5 minutes of a 30 minutes candle at 16:25, AND at 16:44-almost your entry timezone- I had another Buy signal rejected 'cos price was above and too close to Fibo level (0.721904). I currently use a no trading zone(=buffer) of 4 pips above Fibo levels.
Your trade AUDUSD at 2016.07.04 17:19:37 , I had a later signal not traded for the last 5 minutes rule explained above ,it was delivered at 17:25, so I was 6 minutes in late
Your trade USDCAD at 2016.07.04 17:19:35,my sell signal has come at 17:25,and the last 5 minutes rule kicked in again rejecting the trade
your 2 trades about GBPCAD, the first at 2016.07.04 13:51:35 is out of my trading zone,that is London opening + 3 hours,about the other one 2016.07.04 12:04:01,this time I had a signal at 2016.07.04 11:56 , 8 minutes before you, not traded for the last 5 minutes rule.

thx very much for your attention and your post #2031

bye
Attached Image (click to enlarge)
Click to Enlarge Name: 30_hours_result.png Size: 54 KB
DO UT DES
  • #2,036
  • Jul 5, 2016 10:52am Jul 5, 2016 10:52am
Quoting the bourne
{quote} Leet and Jibala,thx for the replies I was talking about the GAP interval update into my Excel I can choose between 3 time intervals,15min,30min and 1hour and my Excel is updated tick by tick as well but I guess you both can see multiGap updating from H4 to M15 into your files,and 5m updates for Spaghetti I'm almost there tonight first Tokyo attempt,100% hit ratio some losses from other Sessions,in the last 30 hours 22 trades,4 losses,18 winners hit ratio 81.8% TP 9pips SL 27 pips 2 trades closed manually,'cos I don't like to let trades browsing...
Try to adjust you're TP based on pairs movement at least an ADR or ABR , because you can't put a equal TP for GBPJPY and EURCHF , the non volatile pairs could end in loses even if they where in profit good enough for there volatility during that hour, on the other hand you will not get the maxim TP for most volatile pairs. If you use ADR or ABR look on them to not be that big, start from low TP and see how much can reach
By failing to prepare, you are preparing to fail.
  • #2,037
  • Jul 5, 2016 1:21pm Jul 5, 2016 1:21pm
The signal seams too look better now, 1 SL hit at AUDJPY otherwise we would have 50+ trades win in a row, maybe better like that I don't want to get near personal record with testing amounts.

The second SL reach the TP but was prevented because of spread. Even like that I will need a solution to prevent that 2 SL's without affecting any winning trade, this is the most hard part when a signal is build, since sometimes seams impossible .
Attached Image(s) (click to enlarge)
Click to Enlarge Name: SL1.png Size: 50 KB
Click to Enlarge Name: SL2.png Size: 37 KB
Click to Enlarge Name: trades.png Size: 118 KB
By failing to prepare, you are preparing to fail.
  • #2,038
  • Jul 5, 2016 5:01pm Jul 5, 2016 5:01pm
thx Leet for your post

about your hint for TakeProfits,I totally agree with you about ADR%
but the problem is,during these post Brexit days, ADR % could be tricky
i.e. If I put a TP ADR at 9% ,for AUDJPY - ADR 5 days 117p -- TP would be around 10 pips
but for GBPJPY - ADR 5 days 264 - - TP would be 23 pips !

As I can see,your TPs are often 6\8 pips ,for some pairs TPs are at 12\13pips
I can see normal trades and counter trend trades in your posts

For the moment I'm focused on trend trades
my Counter trend trades module is under development

Which TP ADR% are you using for trend trades?
And what period for ADR calculation?

you seem to use a Break even buffer,to save 4 pips when in profit,or is it a trailing stop?
thx
DO UT DES
  • #2,039
  • Jul 6, 2016 8:14am Jul 6, 2016 8:14am
First of all thanks to project13et for his statement for the non contributing and non productive lurker! 2nd big thanks at project13et for his eagle eyes! There was something wrong with the correlation of the 2 named pairs. Only good that I haven't been fired for not taking notice of that problem.

The idea with the ADR for TP is pretty good and works if you only make it time based! Don't use same ADR % TP for all sessions! 10% during LO is good indeed for both, trend and counter trades.

After hard work of analyzing we started again last night and the result is very impressive after the adjustment:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.06_12h09m46s_049_.png Size: 99 KB

Attached Image

My today's favorite, TP manually extended. Initial TP was just below DO:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.06_13h10m26s_051_.png Size: 92 KB

A time filter for the 2 losers is implemented already. What and how did we analyze? See the little video of my analyzer.
Attached File(s)
File Type: zip trade analyzer.zip   1.8 MB | 1,304 downloads

Some more details and explanation on the analyzer with small screens:
Attached Image

5 trades taken already, watching the values and how price moves
Attached Image

Just compare to the prior screen. EURCAD hit TP and I thought EURGBP will be the next. But I can tell tell you already EURGBP was the last in the row!
Attached Image

Status of the 4 when hit TP
Attached Image

And finally EURGBP hit TP too!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.05_14h03m14s_037_.png Size: 20 KB

The numbers are:

(1) - standard deviation strength base currency
(2) - standard deviation strength quote currency
(3) - ratio / relation base / quote currency
(4) - GAP base / quote currency
(5) - ratio / relation of (3) and (4)

Accordingly to this I hope that this will help to find the right values or to develop an algorithm.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,040
  • Jul 6, 2016 8:54am Jul 6, 2016 8:54am
Quoting JibalaPasan
First of all thanks to project13et for his statement for the non contributing and non productive lurker! 2nd big thanks at project13et for his eagle eyes! There was something wrong with the correlation of the 2 named pairs. Only good that I haven't been fired for not taking notice of that problem. The idea with the ADR for TP is pretty good and works if you only make it time based! Don't use same ADR % TP for all sessions! 10% during LO is good indeed for both, trend and counter trades. After hard work of analyzing we started again last...


Most interesting and informative stuff Jibala, for which many thanks.

In the little spare time I have, I am still "ploughing" through this thread.

STDEV is def one of my favourites and I use it in a lot of forex stuff. Will give this a thought and think about ways of sensibly applying this to gap trading.

One question regarding the "(4) - GAP base / quote currency".
Is that a gap measured over an M5, M15, M30, ... or even multiple periods ?

As always, green pips to y´all !

LuXing
Wisdom begins in wonder
0 traders viewing now