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

  • #3,201
  • Feb 28, 2017 8:42am Feb 28, 2017 8:42am
Quoting JibalaPasan
{quote} Any, it doesn't matter. The main thing the market moves and we can grab our pips. Jibala
From the SL series, the episode continue .... I need to call the cavalry, sister bring the big guns since you're help is needed on the battle front.

3:37 AUDCAD Order Details: Main Trend UP, BR: 1.00 (+/- 0.72), RS: 9.00 (+/- 6.80), BS: 6.55 (+/- 3.40), BS GAP: 0.78 (+/- 0.45), APS: 3.92, AMS: 2.74, BSR: 60.71% / 39.29% (67%), Bs&Bs: 0.20 / 0.20 (+/- 0.61), AUDCAD 4.29 / -2.25

M30 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: AUDCAD M30.gif Size: 42 KB


M1 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: AUDCAD M1.gif Size: 19 KB


Spaghetti
Attached Image


6:00 ADUJPY Order Details: Main Trend UP, BR: 0.97 (+/- 0.71), RS: 9.00 (+/- 6.77), BS: 5.11 (+/- 3.36), BS GAP: 1.25 (+/- 0.45), APS: 3.15, AMS: 2.81, BSR: 71.43% / 28.57% (67%), Bs&Bs: 0.20 / 0.00 (+/- 0.63), AUDJPY 2.99 / -2.12

M30 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: AUDJPY M30.gif Size: 66 KB


M1 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: AUDJPY M1.gif Size: 19 KB


Spaghetti
Attached Image


4:45 EURNZD Order Details: Main Trend UP, BR: 0.95 (+/- 0.69), RS: 8.50 (+/- 6.65), BS: 4.25 (+/- 3.14), BS GAP: 0.65 (+/- 0.45), APS: 3.24, AMS: 3.21, BSR: 53.57% / 46.43% (65%), Bs&Bs: 0.20 / 0.20 (+/- 0.71), EURNZD 1.65 / -2.60

M30 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: EURNZD M30.gif Size: 47 KB


M1 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: EURNZD M1.gif Size: 22 KB


Spaghetti
Attached Image
By failing to prepare, you are preparing to fail.
  • #3,202
  • Feb 28, 2017 8:42am Feb 28, 2017 8:42am
2:02 GBPCAD Order Details: Main Trend UP, BR: 0.99 (+/- 0.74), RS: 9.00 (+/- 6.92), BS: 5.79 (+/- 3.62), BS GAP: 1.35 (+/- 0.45), APS: 4.07, AMS: 2.34, BSR: 67.86% / 32.14% (69%), Bs&Bs: 1.70 / 0.20 (+/- 0.52), GBPCAD 3.17 / -2.61

M30 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: GBPCAD M30.gif Size: 47 KB


M1 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: GBPCAD M1.gif Size: 26 KB


Spaghetti
Attached Image


GAP
Attached Image


2:03 GBPJPY Order Details: Main Trend UP, BR: 0.89 (+/- 0.73), RS: 6.90 (+/- 6.89), BS: 5.66 (+/- 3.56), BS GAP: 2.68 (+/- 0.45), APS: 3.46, AMS: 2.45, BSR: 67.86% / 32.14% (68%), Bs&Bs: 1.00 / 0.20 (+/- 0.54), GBPJPY 3.46 / -2.19

M30 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: GBPJPY M30.gif Size: 37 KB


M1 Chart
Attached Image (click to enlarge)
Click to Enlarge Name: GBPJPY M1.gif Size: 23 KB


Spaghetti
Attached Image


MTF
Attached Image
By failing to prepare, you are preparing to fail.
  • #3,203
  • Edited 11:36am Feb 28, 2017 10:58am | Edited 11:36am
OMG...brother project13et, what happened?

First, I couldn't login to FF for hours. The login site always came up with a bad request upon login. Ok, solved and I am back again. 2nd the robot was under maintenance, some bugs have been fixed. But at the time what you show there was no signal for most of your pairs except GBPJPY which was later even.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_18h41m27s_049_.png Size: 79 KB

However, GBPJPY was solved the very best and it seems the robot wants to grab the very last possibly pip of the range.

Some trades of our today's journey:

After the bugs were fixed the bot came up with a nice firework which was looking very promising for what will happen within the next few hours.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_14h59m21s_035_.png Size: 365 KB

All orders opened within 20 minutes and closed at exactly the same time!

The loser caught by the spread what you clearly can see in the upper left corner on execution.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_15h29m08s_038_.png Size: 90 KB


Some more really fantastic trades:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_15h50m29s_041_.png Size: 73 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_17h51m11s_045_.png Size: 81 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_18h17m52s_046_.png Size: 75 KB


And the winner of today is:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_19h00m09s_052_.png Size: 135 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_19h02m18s_053_.png Size: 10 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_16h59m57s_044_.png Size: 77 KB

Edit: I forgot to upload the chart. TP couldn't be calculated any better!

The total for today so far but still counting into account:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_19h11m50s_055_.png Size: 47 KB


I want to thank all who participates and contributes in the thread and the forum. Special thanks to brother FerruFx. It's great to see you always around here. Your comments are welcome and highly appreciated.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,204
  • Feb 28, 2017 11:02am Feb 28, 2017 11:02am
Quoting dlouw
{quote} Thank you very much! I am working with the correct data then. No resets! So you do not record tick data, just use the DDE feed for the current price, correct?
Yes, that's correct. Data coming via DDE from mt4.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,205
  • Feb 28, 2017 11:08am Feb 28, 2017 11:08am
Quoting bubincka
{quote} Hi FerruFx, project13et, there is no reason to raise the tone and get harsh for so little. I know well dtlase excel and its main data source. Currently I'm looking inside of it to discover formulas and how all the values are calculated (Btw I'm arrived at pag. 55). Nevertheless this was when all started, after then there have been many evolutions and now master Jibala presents here concepts like Gap Heatmap! So I don't see anything wrong in trying to thoroughly understand the hows, the whys and the details in...
That's why we come together here and talk/write about what we think, what we do not understand, our suggestions, some imaginations, sometimes our desires and so on.

Everything is welcome as long as we do respect each other.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,206
  • Feb 28, 2017 11:21am Feb 28, 2017 11:21am
Quoting bubincka
{quote} The only meaning I can think of is that being this never-ending rolling period, high and low values are calculated like the following: x_per_high = iHigh(CP, PERIOD_M1, iHighest(CP, PERIOD_M1, MODE_HIGH, xPer - 1, 0)); x_per_low = iLow(CP, PERIOD_M1, iLowest(CP, PERIOD_M1, MODE_LOW, xPer - 1, 0)); instead of: x_per_high = iHigh(CP, xPer, 0); x_per_low = iLow(CP, xPer, 0); with xPer = 1440. If it's in this way then different timeframes H4, H1, M15, M5 are only used on the strengths calculated above only to reset GAP for...
To be accurate all pairs must be calculate on the same time frame. I believe it is wise to account for missing bars by counting bars to a fixed time. Of course then we must account for market closures to calculate the correct time.....

dlouw
  • #3,207
  • Feb 28, 2017 11:30am Feb 28, 2017 11:30am
Quoting JibalaPasan
OMG...brother project13et, what happened? First, I couldn't login to FF for hours. The login site always came up with a bad request upon login. Ok, solved and I am back again. 2nd the robot was under maintenance, some bugs have been fixed. But at the time what you show there was no signal for most of your pairs except GBPJPY which was later even. {image} However, GBPJPY was solved the very best and it seems the robot wants to grab the very last possibly pip of the range. Some trades of our today's journey: After the bugs were fixed the bot came...
Same problem here with the login all day ... I don't need to point that correlation , GC / GD / time table etc etc , trillions of all the other filters where present and there was no BUG

I'm speechless maybe you can add something to that SL's ... or at least give me a call when I should add mine M$ in maintenance, that would help a lot
By failing to prepare, you are preparing to fail.
  • #3,208
  • Edited 12:57pm Feb 28, 2017 11:47am | Edited 12:57pm
Quoting JibalaPasan
OMG...brother project13et, what happened? First, I couldn't login to FF for hours. The login site always came up with a bad request upon login. Ok, solved and I am back again. 2nd the robot was under maintenance, some bugs have been fixed. But at the time what you show there was no signal for most of your pairs except GBPJPY which was later even. {image} However, GBPJPY was solved the very best and it seems the robot wants to grab the very last possibly pip of the range. Some trades of our today's journey: After the bugs were fixed the bot came...
It seem you did not use momentum from m240.
  • #3,209
  • Feb 28, 2017 1:17pm Feb 28, 2017 1:17pm
Quoting project13et
{quote} Same problem here with the login all day ... I don't need to point that correlation , GC / GD / time table etc etc , trillions of all the other filters where present and there was no BUG I'm speechless maybe you can add something to that SL's ... or at least give me a call when I should add mine M$ in maintenance, that would help a lot
Maybe that's the bug!
Attached Image


Btw do you have any signals right now?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,210
  • Feb 28, 2017 1:28pm Feb 28, 2017 1:28pm
Quoting JibalaPasan
{quote} Maybe that's the bug! {image} Btw do you have any signals right now? Jibala
Time table doesnt allow trades at this hour, but usd and jpy seams to play in the market
By failing to prepare, you are preparing to fail.
  • #3,211
  • Feb 28, 2017 1:44pm Feb 28, 2017 1:44pm
My bot is like a girl... spending more then I can make... my today respond to the bot ! And YES I didn't joke the whole signal is deleted !!!
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_NZDJPY_M30_11-02-52.gif Size: 15 KB
By failing to prepare, you are preparing to fail.
  • #3,212
  • Feb 28, 2017 1:47pm Feb 28, 2017 1:47pm
Quoting project13et
{quote} Time table doesnt allow trades at this hour, but usd and jpy seams to play in the market
Pretty good even!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.28_22h44m47s_062_.png Size: 177 KB


Isn't it a bit early to prevent the bot from taking trades?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,213
  • Feb 28, 2017 1:50pm Feb 28, 2017 1:50pm
Quoting JibalaPasan
{quote} Pretty good even! {image} Isn't it a bit early to prevent the bot from taking trades? Jibala
No more bot sister, I am very upset on him for what he did today. I didn't catch that move, when I answer you I was doing it from the phone, driving home.
By failing to prepare, you are preparing to fail.
  • #3,214
  • Feb 28, 2017 2:18pm Feb 28, 2017 2:18pm
Quoting project13et
{quote} No more bot sister, I am very upset on him for what he did today. I didn't catch that move, when I answer you I was doing it from the phone, driving home.
Who's fault? The bot is doing only what you taught it!

The picture above you showing +158 Pips and no loss! What's that other than enough? What else do you want?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,215
  • Feb 28, 2017 2:35pm Feb 28, 2017 2:35pm
C'mon Leet,the same happened here

16 trades,6 losers!!!!!

The Market today has been gallant only towards the ladies(=Nathalia & Jibala), not with the guys(You and Me),
but you recovered some losses with your smart manual trading.
I'd love to do the same,but I was at work!
DO UT DES
  • #3,216
  • Feb 28, 2017 2:49pm Feb 28, 2017 2:49pm
Quoting JibalaPasan
{quote} The picture above you showing +158 Pips and no loss! What's that other than enough? What else do you want? Jibala
Count the SL's for automatic trading , and the result of me trading manual. At this moment they don't even break even.

Both of trading using the same excel, difference between automatic and me ? I am subjective and I am the last factor of decision, I see 6 out of 8 filters, and based on my judgement I can give an early go, or vice versa the visual signal could come faster then my analyze in the market, but in the end I am getting the decision to launch or not the trade.

What would happen if I was trading last night? I have no idea because was not me trading, and was an automatic signal !

The difference between my expression and you're ... when I say "bot" I am not referring to a person, but to an automatic trading signal ! with EXACT rules
For example same of you're today trades, and others are executed manual, so in the end you're personal decision made you not to trade last night, and keep you away from the SL and bad market condition ?

This is going to the same category of question "What would happen if I was trading last night?" , we will never know the answer

And again don't understand me wrong, since you know I am not in the lazy category, my aiming with automatic trading is not to go at disco while the signal make money, but mainly is to gather information, and to learn from that, but is quite hard to learn when EXACT all the rules presented bring that kind of result.

With all my respect and love, even if sometimes we have divergent opinions but is between brothers, so don't get mad on me.

I'll always be grateful to you !
By failing to prepare, you are preparing to fail.
  • #3,217
  • Feb 28, 2017 4:58pm Feb 28, 2017 4:58pm
This bot is on fire......
Attached Image


Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,218
  • Feb 28, 2017 5:18pm Feb 28, 2017 5:18pm
Quoting JibalaPasan
This bot is on fire...... {image} Jibala
Hello Jibala

Could you sent the trade time for those posted above ?

Any good coder here can made one indicator for bid ratio current time frame with option to read historic value and current bar ? More important for me if are output the values in buffers. Not good in excel and only know a little coding with Molanis reading buffer values

Thanks

Jose
  • #3,219
  • Mar 1, 2017 4:45am Mar 1, 2017 4:45am
This is what market offer me so far, not too much activity, all the money have been gone while I was sleeping, and I lose momentum on GBP move.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_USDJPY_M30_14-11-18.gif Size: 9 KB
By failing to prepare, you are preparing to fail.
  • #3,220
  • Mar 1, 2017 9:57am Mar 1, 2017 9:57am
Closing the day, it seams I am trading better when I start with few loses

Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_USDJPY_M30_19-50-26.gif Size: 9 KB


Thanks for the all the messages regarding the group. I didn't take yet a decision, I will let everyone know when I will take it.
By failing to prepare, you are preparing to fail.
1 trader viewing now