MT4 Trading the GAP With Excel | Page 58 | 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,141
  • Jan 31, 2016 5:19am Jan 31, 2016 5:19am
Hello everybody. Please can any one reupload all necessary indicator, template, excel file and EAs in one pack to trade with. I tried to collect them, but unsuccesfull. Thank you.
  • #1,142
  • Feb 1, 2016 9:04pm Feb 1, 2016 9:04pm
Hello guys, fellow traders! How is your trading? Yesterday was a boring day, nothing happened until NY when we could fire up some orders.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_22h57m00s_005_USDCHF-M30.png Size: 62 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_22h57m27s_006_NZDUSD-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_22h57m42s_007_GBPUSD-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_22h57m58s_008_EURUSD-M30.png Size: 61 KB

The only signal I was able to catch:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_23h44m13s_009_.png Size: 180 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.02_09h36m51s_010_NZDJPY-M30.png Size: 65 KB

Nothing happened during the night. This morning, Tokyo +18m, EURAUD was ready to go:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.02_09h38m02s_012_EURAUD-M30.png Size: 60 KB

But again not strong enough to run until the end hence, stopped out again by TS (+20.5).

I wish you all a green day!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,143
  • Feb 2, 2016 2:46am Feb 2, 2016 2:46am
Quoting JibalaPasan
Hello guys, fellow traders! How is your trading? Yesterday was a boring day, nothing happened until NY when we could fire up some orders. {image} {image} {image} {image} The only signal I was able to catch: {image} {image} Nothing happened during the night. This morning, Tokyo +18m, EURAUD was ready to go: {image} But again not strong enough to run until the end hence, stopped out again by TS (+20.5). I wish you all a green day!
Hi Jibala,

after analysing your screenshots for a while I come to the conclusion that you have different tables for each currency when it comes to calculating the strength.
In your last screenshot AUD has a strength of 4.94 and a bid ratio of 53.03% while EUR has the same strength of 4.94 but a lower bid ratio (48.98%). The same goes for USD and JPY

I assume that this is something the algo implemented in your DB is responsible for since you always advised for flexible filters that adjust to market conditions. Could you enlighten me on this or drop some clue please?

Thanks in advance.
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot2.png Size: 635 KB
  • #1,144
  • Feb 2, 2016 2:58am Feb 2, 2016 2:58am
Quoting JibalaPasan
Hello guys, fellow traders! How is your trading? Yesterday was a boring day, nothing happened until NY when we could fire up some orders. {image} {image} {image} {image} The only signal I was able to catch: {image} {image} Nothing happened during the night. This morning, Tokyo +18m, EURAUD was ready to go: {image} But again not strong enough to run until the end hence, stopped out again by TS (+20.5). I wish you all a green day!

Was the trade NZDJPY took when was already gap 3? Is not a gap 3 already to risky , because the movement could be big enough and you can enter at the end of that movement ?
By failing to prepare, you are preparing to fail.
  • #1,145
  • Feb 2, 2016 4:18am Feb 2, 2016 4:18am
Quoting Sniper1310
{quote} Hi Jibala, after analysing your screenshots for a while I come to the conclusion that you have different tables for each currency when it comes to calculating the strength. In your last screenshot AUD has a strength of 4.94 and a bid ratio of 53.03% while EUR has the same strength of 4.94 but a lower bid ratio (48.98%). The same goes for USD and JPY I assume that this is something the algo implemented in your DB is responsible for since you always advised for flexible filters that adjust to market conditions. Could you enlighten me...
All pairs using the same table and algorithm.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.02_17h10m30s_015_.png Size: 28 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,146
  • Feb 2, 2016 4:27am Feb 2, 2016 4:27am
Quoting JibalaPasan
{quote} All pairs using the same table and algorithm. {image}
Then I dont get it why there are different strength values attached to AUD and EUR?
Am I missing something?

The relative strength is almost equal. An absolute strength of 4.5 is the basis for relative strength. Each 0.01 increment is a step of 2 in relative strength.
Example: EUR AS = 4.94 therefore (4.94-4.50) * 2 = 0.44 * 2 = 0.88 (As shown on the screenshot). This is true for all the other values.
  • #1,147
  • Feb 2, 2016 4:36am Feb 2, 2016 4:36am
Quoting project13et
{quote} Was the trade NZDJPY took when was already gap 3? Is not a gap 3 already to risky , because the movement could be big enough and you can enter at the end of that movement ?
I fully have trust in the tools I get provided for trading.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,148
  • Feb 2, 2016 4:38am Feb 2, 2016 4:38am
Quoting JibalaPasan
{quote} I fully have trust in the tools I get provided for trading.
Of course you do , we all do
By failing to prepare, you are preparing to fail.
  • #1,149
  • Feb 2, 2016 8:02pm Feb 2, 2016 8:02pm
Quoting JibalaPasan
Hello guys, fellow traders! How is your trading? Yesterday was a boring day, nothing happened until NY when we could fire up some orders. {image} {image} {image} {image} The only signal I was able to catch: {image} {image} Nothing happened during the night. This morning, Tokyo +18m, EURAUD was ready to go: {image} But again not strong enough to run until the end hence, stopped out again by TS (+20.5). I wish you all a green day!
Hi Jibala,

I would like to know why you did not trade GBPJPY?
all the conditions are good for it. GBP GAP +1.42 and JPY -3.41

Best regards
  • #1,150
  • Feb 2, 2016 8:08pm Feb 2, 2016 8:08pm
Hi Jibala,

Would you please give me any hint regarding the marked numbers, i tried to find the way but unfortunately i am not able to identify them
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.01_23h44m13s_009_.png Size: 190 KB
  • #1,151
  • Edited 4:08am Feb 3, 2016 3:03am | Edited 4:08am
Quoting htawfik
{quote} Hi Jibala, I would like to know why you did not trade GBPJPY? all the conditions are good for it. GBP GAP +1.42 and JPY -3.41 Best regards
1. Just have a look on the 2nd meter and you know why! In the short term, GBP has clearly lost strength. Criteria are not met at this point of time.

2. The numbers in the 6th row are for basket strength while the numbers below displaying pair gap.

Edit no. 1: I just scrolled back in the chart to the appointed time, "last bar check" was negative hence, no deal!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,152
  • Feb 3, 2016 8:10am Feb 3, 2016 8:10am
Quoting Husky77
I know i may sound dumb ,but is there a way someone smart from all of you guys here explain or edit first post with clean steps of what must be downloaded,where to add it and how to connect excel with mt4 ? i see only good results ,yes only demo of course but at explanation level stuff like download this and this and put it there ,must look like this and do this ,then do that ... this thread is very hard to understand.I cant even open that excel file my viewer said corrupted file format.what version to use then? I am reading on this since quite...
​i do agree with you . so am i ! i had been reading and looking for solutions ALL DAY LONG. still can't understand.i think no one will care. no one do that.
  • #1,153
  • Feb 3, 2016 8:53am Feb 3, 2016 8:53am
Quoting JibalaPasan
{quote} 1. Just have a look on the 2nd meter and you know why! In the short term, GBP has clearly lost strength. Criteria are not met at this point of time. 2. The numbers in the 6th row are for basket strength while the numbers below displaying pair gap. Edit no. 1: I just scrolled back in the chart to the appointed time, "last bar check" was negative hence, no deal!
Thanks a lot
  • #1,154
  • Feb 3, 2016 8:57am Feb 3, 2016 8:57am
Quoting blueuu
{quote} ​i do agree with you . so am i ! i had been reading and looking for solutions ALL DAY LONG. still can't understand.i think no one will care. no one do that.

Hi blueuu,

you need to understand the numbers, the relation between numbers.

if you have questions we can answer them
  • #1,155
  • Feb 4, 2016 2:01am Feb 4, 2016 2:01am
Quoting JibalaPasan
{quote} 1. Just have a look on the 2nd meter and you know why! In the short term, GBP has clearly lost strength. Criteria are not met at this point of time. 2. The numbers in the 6th row are for basket strength while the numbers below displaying pair gap. Edit no. 1: I just scrolled back in the chart to the appointed time, "last bar check" was negative hence, no deal!

I feel lucky today, and maybe I get an answer from you today


How we avoid this false breakout ?

BR was around 0, RS under -8 , BS -5, Individual <> -2.6, AUD main GAP 1.6, EUR -1.0 , TOP pair vs weak pair.

We also have Trend and previous bar filter that confirm the trade direction. FiB/PiV/Supply and Demand levels are ok, so we have ALL the signals to take this trade...
And almost forgot no news during that time So everything match good....

What I did wrong? How can we avoid this ?
Attached Image (click to enlarge)
Click to Enlarge Name: ^3991D6B33ED0ACAB8E89C62270384C87EE524ACE4DBF408DC3^pimgpsh_fullsize_distr.jpg Size: 144 KB
By failing to prepare, you are preparing to fail.
  • #1,156
  • Feb 4, 2016 3:59am Feb 4, 2016 3:59am
Quoting project13et
{quote} I feel lucky today, and maybe I get an answer from you today How we avoid this false breakout ? BR was around 0, RS under -8 , BS -5, Individual <> -2.6, AUD main GAP 1.6, EUR -1.0 , TOP pair vs weak pair. We also have Trend and previous bar filter that confirm the trade direction. FiB/PiV/Supply and Demand levels are ok, so we have ALL the signals to take this trade... And almost forgot no news during that time So everything match good.... What I did wrong? How can we avoid this ? {image}


@project13et as we all know, a winning trade is never guaranteed! This level was tested 3 times already. Hence, it could break or bounce. Unfortunately, it bounced. On the other hand, the order was not placed very clever directly on the low.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,157
  • Feb 4, 2016 5:06am Feb 4, 2016 5:06am
Sometimes it takes a little bit longer. It also could bounce. Hence, lucky trade and happy for +21.5 Pip!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.04_18h47m45s_028_EURUSD-M30.png Size: 57 KB

Order Details: Main Trend UP, BR: 1.00 (+/- 0.76), RS: 8.99 (+/- 7.07), BS: 6.98 (+/- 2.39), BS GAP: 1.90 (+/- 1.18)
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,158
  • Feb 4, 2016 9:43am Feb 4, 2016 9:43am
Quoting JibalaPasan
Sometimes it takes a little bit longer. It also could bounce. Hence, lucky trade and happy for +21.5 Pip! {image} Order Details: Main Trend UP, BR: 1.00 (+/- 0.76), RS: 8.99 (+/- 7.07), BS: 6.98 (+/- 2.39), BS GAP: 1.90 (+/- 1.18)
Hi Jibala,

Kindly I would like to know why you did not take this trade before this time, it happened several times (between 9:30AM to 11:00AM your broker time) that the BR reach .76 and the GAP for EUR was > 1.18.

May I know if ant reason for that ?

Best regards
  • #1,159
  • Feb 4, 2016 10:00am Feb 4, 2016 10:00am
Quoting htawfik
{quote} Hi Jibala, Kindly I would like to know why you did not take this trade before this time, it happened several times (between 9:30AM to 11:00AM your broker time) that the BR reach .76 and the GAP for EUR was > 1.18. May I know if ant reason for that ? Best regards
Because there are some more filters than BR and GAP only! If you have a closer look exactly on that chart you can clearly see a typical breakout above the Daily High line. And exactly at that point of time, a signal was given. That was automated trading, without intervention!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,160
  • Feb 4, 2016 10:07am Feb 4, 2016 10:07am
Sometimes I'd like to kick out the TS, it just drives me crazy!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.04_21h46m23s_034_GBPCAD-M30.png Size: 60 KB

Without TS:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.04_21h57m40s_036_EURJPY-M30.png Size: 60 KB

Best trade today on GER30 with +171.5 Pip:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.04_21h51m07s_035_.png Size: 73 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.02.04_23h48m38s_037_.png Size: 78 KB

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