MT4 Trading the GAP With Excel | Page 73 | 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

  • #1,441
  • May 9, 2016 5:17pm May 9, 2016 5:17pm
Quoting dlouw
Best, dlouw {image}
2016.05.09 10:47:48buy0.67cadjpy83.15083.00083.2202016.05.09 11:27:0183.220-5.050.000.0043.53
2016.05.09 10:46:50buy0.67nzdjpy73.40073.25073.4702016.05.09 11:27:2473.470-5.050.000.0043.52
2016.05.09 10:46:48buy0.67audjpy79.05078.90079.1202016.05.09 11:27:2279.120-5.050.000.0043.52
2016.05.09 10:46:31buy0.67gbpjpy154.750154.600154.8202016.05.09 10:47:36154.820-5.050.000.0043.61
2016.05.09 10:46:10buy0.67chfjpy110.900110.750110.9702016.05.09 10:59:56110.970-5.050.000.0043.56
2016.05.09 10:45:09sell stop0.67chfjpy110.850111.000110.7802016.05.09 10:45:19110.870cancelled
72016.05.09 10:38:37sell0.79eurcad1.474501.476001.473802016.05.09 10:43:411.47380-5.950.000.0042.74
  • #1,442
  • May 9, 2016 5:46pm May 9, 2016 5:46pm
Still not sleepy hence, looking for some trading opportunities.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_00h34m28s_014_.png Size: 11 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_00h37m31s_015_.png Size: 72 KB

GBPAUD, OP_BUY Order Details: Main Trend UP, BR: 0.89 (+/- 0.77), RS: 6.90 (+/- 7.12), BS: 4.50 (+/- 4.39), BS GAP: 4.57 (+/- 0.45)

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,443
  • May 9, 2016 5:49pm May 9, 2016 5:49pm
Quoting JibalaPasan
Still not sleepy hence, looking for some trading opportunities. {image} {image} GBPAUD, OP_BUY Order Details: Main Trend UP, BR: 0.89 (+/- 0.77), RS: 6.90 (+/- 7.12), BS: 4.50 (+/- 4.39), BS GAP: 4.57 (+/- 0.45) Jibala
Dangerous hour ... the continue of the trade in reversal
Attached Image (click to enlarge)
Click to Enlarge Name: cotinue.png Size: 23 KB
By failing to prepare, you are preparing to fail.
  • #1,444
  • May 9, 2016 5:57pm May 9, 2016 5:57pm
Quoting project13et
{quote} Dangerous hour ... the continue of the trade in reversal {image}
It's always a matter of timing! If you tell me 1h before, you are right. Look at the GAP of JPY.
Attached Image

Attached Image

1h before it was red and almost at zero!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,445
  • May 10, 2016 5:35am May 10, 2016 5:35am
mumble..mumble..

I'm thinkin about a flexible trigger for RS and BS,and for the BS GAP,calculated on the Average (+-) Standard Deviation

(+) for RS and BS
(-) for the GAP

what is your opinion?
DO UT DES
  • #1,446
  • Edited 6:16am May 10, 2016 5:57am | Edited 6:16am
Quoting the bourne
mumble..mumble.. I'm thinkin about a flexible trigger for RS and BS,and for the BS GAP,calculated on the Average (+-) Standard Deviation (+) for RS and BS (-) for the GAP what is your opinion?
You should always wear shoes that fit you the best! But keep in mind that a standard deviation is present always, no matter if it's in a weak or a strong market.

To continue from last night:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_00h03m16s_012_.png Size: 11 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.09_23h44m12s_011_.png Size: 71 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_08h10m39s_021_.png Size: 79 KB

CADJPY, OP_BUY Order Details: Main Trend UP, BR: 1.00 (+/- 0.78), RS: 8.99 (+/- 7.18), BS: 7.36 (+/- 2.27), BS GAP: 4.19 (+/- 0.45)

And this morning:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_11h22m24s_002_.png Size: 12 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_11h22m10s_001_.png Size: 16 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_11h25m35s_003_.png Size: 174 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_11h48m44s_006_.png Size: 76 KB

GBPJPY, OP_BUY Order Details: Main Trend UP, BR: 0.98 (+/- 0.83), RS: 8.99 (+/- 7.53), BS: 6.98 (+/- 5.37), BS GAP: 3.29 (+/- 0.45)
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_12h19m18s_007_.png Size: 72 KB

GBPCHF, OP_BUY Order Details: Main Trend UP, BR: 1.00 (+/- 0.83), RS: 8.99 (+/- 7.53), BS: 5.96 (+/- 5.37), BS GAP: 4.97 (+/- 0.45)

Have a nice day all together.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,447
  • May 10, 2016 7:02am May 10, 2016 7:02am
Quoting JibalaPasan
{quote} You should always wear shoes that fit you the best! But keep in mind that a standard deviation is present always, no matter if it's in a weak or a strong market. To continue from last night: {image} {image} {image} CADJPY, OP_BUY Order Details: Main Trend UP, BR: 1.00 (+/- 0.78), RS: 8.99 (+/- 7.18), BS: 7.36 (+/- 2.27), BS GAP: 4.19 (+/- 0.45) And this morning: {image} {image} {image} {image} GBPJPY, OP_BUY Order Details: Main Trend UP, BR: 0.98 (+/- 0.83), RS: 8.99 (+/- 7.53), BS: 6.98 (+/- 5.37), BS GAP: 3.29 (+/- 0.45) {image} GBPCHF,...
Thank you very much for another useful post and for the hint about market strenght,I'm still workin on this part,and I'm currently workin on a market strenght variation through percentage calculation, with proportionally calculated triggers for Relative Strenght, BuySell Ratio and the Gap.
I still have to determine the boundaries for the strenght parameter though
When I will have the buffer size,I will proceed with my own algorithm

Do you still prefer pending orders for your automated trades?

Congratuations for your last trades,almost zero DD !

quick update: 3 good trades just nailed down with new standard deviation parameters,AUDNZD EURNZD long,NZDUSD short
but I will need a lot of screenshots and charts before real trading approval
DO UT DES
  • #1,448
  • May 10, 2016 7:12am May 10, 2016 7:12am
Quoting the bourne
{quote} Thank you very much for another useful post and for the hint about market strenght,I'm still workin on this part,and I'm currently workin on a market strenght variation through percentage calculation, with proportionally calculated triggers for Relative Strenght, BuySell Ratio and the Gap. I still have to determine the boundaries for the strenght parameter though When I will have the buffer size,I will proceed with my own algorithm Do you still prefer pending orders for your automated trades? Congratuations for your last trades,almost zero...
The module for pending orders has been removed, not necessary anymore. It works pretty well with market orders and the right timing for price action.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,449
  • May 10, 2016 7:23am May 10, 2016 7:23am
Quoting JibalaPasan
{quote} The module for pending orders has been removed, not necessary anymore. It works pretty well with market orders and the right timing for price action. Jibala
If pending order was been removed why few post you mention about moving the pending order if price down happen ?

my gap sheet , mondoki indicator has been included in excel, I am getting boring how good the system work, so give us a new challenge
Attached Image (click to enlarge)
Click to Enlarge Name: dash.png Size: 99 KB
By failing to prepare, you are preparing to fail.
  • #1,450
  • May 10, 2016 7:53am May 10, 2016 7:53am
Quoting project13et
{quote} If pending order was been removed why few post you mention about moving the pending order if price down happen ? my gap sheet , mondoki indicator has been included in excel, I am getting boring how good the system work, so give us a new challenge {image}
My statement is something like 2 weeks ago, right? And I clearly have stated, "we do it like that for a long time already but it's hard to automate within Excel"! If we can't automate it then no need to have a headache because of it.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,451
  • May 10, 2016 8:01am May 10, 2016 8:01am
Quoting JibalaPasan
{quote} My statement is something like 2 weeks ago, right? And I clearly have stated, "we do it like that for a long time already but it's hard to automate within Excel"! If we can't automate it then no need to have a headache because of it. Jibala
I work a lot to make it automatic , and now I just need to turn it off It wouldn't be much safer to put a pending order at 1.5 pips from the signal for example? Just to be sure the signal is continues and doesn't get there for 1 second . And here I speck more about wukar trading not the fully gap with mtf.
By failing to prepare, you are preparing to fail.
  • #1,452
  • May 10, 2016 8:09am May 10, 2016 8:09am
Quoting JibalaPasan
{quote} You guys are asking a lot and it's not always possible to take all the screens in time! And sometimes I'm just not in the mood because it means a lot of additional work. Only one option so far for manual trading: {image} {image} {image} GBPJPY, OP_BUY Order Details: Main Trend UP, BR: 0.99 (+/- 0.78), RS: 8.99 (+/- 7.19), BS: 7.11 (+/- 4.55), BS GAP: -0.03 (+/- 0.45) Automated trading: {image} GBPAUD, OP_BUY Order Details: Main Trend UP, BR: 1.00 (+/- 0.79), RS: 8.99 (+/- 7.25), BS: 5.53 (+/- 4.70), BS GAP: 1.06 (+/- 0.45) {image}...
Thanks for your continued time and efforts in education of all the poor souls .
lol. In my case, your statement would read: "It's always not possible to take all the screens in time..."
1 day IŽll get there though (hopefully).

All the best & green pips to you.

LuXing
Wisdom begins in wonder
  • #1,453
  • May 10, 2016 8:41am May 10, 2016 8:41am
Anyone heard of dtlase lately? I hope he is okay.
He was planning an updated dashboard this year. But I noticed that he hasn't posted here since January.
  • #1,454
  • May 10, 2016 10:21am May 10, 2016 10:21am
And now fully automated:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_15h58m59s_009_.png Size: 15 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_15h59m14s_010_.png Size: 11 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_16h50m51s_011_.png Size: 75 KB

AUDJPY, OP_BUY Order Details: Main Trend UP, BR: 0.93 (+/- 0.82), RS: 7.87 (+/- 7.45), BS: 6.23 (+/- 5.19), BS GAP: 2.64 (+/- 0.45)
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.05.10_17h09m56s_012_.png Size: 65 KB

AUDCHF, OP_BUY Order Details: Main Trend UP, BR: 1.00 (+/- 0.81), RS: 8.99 (+/- 7.39), BS: 5.77 (+/- 5.04), BS GAP: 1.95 (+/- 0.45)

PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,455
  • May 10, 2016 1:06pm May 10, 2016 1:06pm
Jibala,I noticed your Gap Trigger has become lower in your last trades
Maybe it is just for the Market behaviour
I can remember from a lot of your old posts,Gap values range was from 0.45 min <---> 1.84 max
So we could simply be at the bottom of "your normal" range
Main Trend UP, BR: 1.00 (+/- 0.81), RS: 8.99 (+/- 7.39), BS: 5.77 (+/- 5.04), BS GAP: 1.95 (+/- 0.45)
We know about MultiGap,but do you still use M30 GAP for your final trigger ? Or do you use M15 sometimes?


Thx

Please bear with me for my questions
about your typical Trade report row,I can remember some of your old posts with APS and Absolute Market Strenght values at the bottom

Could you please sometimes eventually kindly post Absolute Market Strenght value at the moment of your entry again?
I'm sure you can understand the reason for my question THANK YOU
DO UT DES
  • #1,456
  • May 10, 2016 1:52pm May 10, 2016 1:52pm
Quoting the bourne
Jibala,I noticed your Gap Trigger has become lower in your last trades Maybe it is just for the Market behaviour I can remember from a lot of your old posts,Gap values range was from 0.45 min <---> 1.84 max So we could simply be at the bottom of "your normal" range Main Trend UP, BR: 1.00 (+/- 0.81), RS: 8.99 (+/- 7.39), BS: 5.77 (+/- 5.04), BS GAP: 1.95 (+/- 0.45) We know about MultiGap,but do you still use M30 GAP for your final trigger ? Or do you use M15 sometimes? Thx Please bear with me for my questions about your typical Trade report row,I...
That's relatively easy to answer and should be understandable for everybody, it's not a secret. Before the gap calculation was per pair, example 1.6, measured on market strength. The analyses stated that this is ways too much hence, the decision was to measure it per currency. If now the trigger is for example 0.45 means, one currency must reach at least 0.45 to be bought while on the other side is a -0.45 required to be sold which is in total a gap of 0.9. That's quite enough what we can see on the much better entries.

The multi gap calculation is based on 15/30/60/240 minutes. We've tried smaller timeframes but this works the very best.

And last but not least, the APS is included in the email but I never posted it. Example from above AUDCHF:

AUDCHF, OP_BUY 0.71680 SL 0.7133 TP 0.7177 Expiration: 2016.5.10 11:47:22 Order Details: Main Trend UP, BR: 1.00 (+/- 0.81), RS: 8.99 (+/- 7.39), BS: 5.77 (+/- 5.04), BS GAP: 1.95 (+/- 0.45), APS: 3.59, AMS: 2.28, BSR: 75.00% / 25.00% (75.66%), Bs&Bs: 1.29 / 0.00 (+/- 0.51)

The expiration is still from the time we were working with pending orders. Not fixed yet because not really necessary to be fixed.

APS = absolute pair strength
AMS = absolute market strength
BSR = buyer/seller ratio
Bs&Bs = bulls & bears

While APS and AMS are really important, the other 2 are just a "nice to have". To log the price level is necessary that we can see how much the order execution is lagging. In this case, order was sent to buy @0.71680 and we got it @0.71682

I hope you got it!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,457
  • Edited 2:12pm May 10, 2016 2:02pm | Edited 2:12pm
Quoting JibalaPasan
{quote} That's relatively easy to answer and should be understandable for everybody, it's not a secret. Before the gap calculation was per pair, example 1.6, measured on market strength. The analyses stated that this is ways too much hence, the decision was to measure it per currency. If now the trigger is for example 0.45 means, one currency must reach at least 0.45 to be bought while on the other side is a -0.45 required to be sold which is in total a gap of 0.9. That's quite enough what we can see on the much better entries. The multi gap calculation...
Wow I thing I never saw such a detailed explication... stop revealing our secrets ... of course I am joking, really nice post !

But if there is an expiration that mean is a pending order?
By failing to prepare, you are preparing to fail.
  • #1,458
  • May 10, 2016 3:14pm May 10, 2016 3:14pm
You are a genius JibalaPasan
  • #1,459
  • May 10, 2016 4:13pm May 10, 2016 4:13pm
Thx Jibala
it's very kind of you

so now, I SIMPLY will have to find out by myself the proper alghoritm to calculate the right trigger values for RS,BS and GAP,starting from AMS
as easy as pie

just a little question: Are RS and BS trigger values directly proportional to AMS ? Is the GAP trigger value proportional to the AMS?
edit:this is just for confirmation,I know they are
I'm satisfied with my RS and BS triggers,but not so happy with my GAP value trigger calculation
many thx
DO UT DES
  • #1,460
  • May 10, 2016 5:00pm May 10, 2016 5:00pm
Quoting the bourne
Thx Jibala it's very kind of you so now, I SIMPLY will have to find out by myself the proper alghoritm to calculate the right trigger values for RS,BS and GAP,starting from AMS as easy as pie just a little question: Are RS and BS trigger values directly proportional to AMS ? Is the GAP trigger value proportional to the AMS? edit:this is just for confirmation,I know they are I'm satisfied with my RS and BS triggers,but not so happy with my GAP value trigger calculation many thx
For the algorithm a little hint from my side: remember how the strength is calculated. It uses a very rough algorithm. Just extend it to make it more smooth! I know this because it was my task to create this (one of the many) algorithm for the system. It has something like 1000 numbers!

Nothing is proportional, each trigger is based on a special algorithm.

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