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

  • #221
  • Oct 15, 2015 9:07am Oct 15, 2015 9:07am
Congratulations again to Jibala Pasan and Dtlase. Great work and Thanks for some fresh ideas.
BIAS and CRS is now part of my private xls dashboard

Bravely go forward!

Attached Image (click to enlarge)
Click to Enlarge Name: DashBoard.jpg Size: 985 KB
  • #222
  • Oct 15, 2015 9:42am Oct 15, 2015 9:42am
Quoting dariuske
Well, I added an extra section to the excel which should help you to trade the GAP in a 'dead' market as explained by JB. This does not mean that when the sheet says 'GO' that you should just trade without using your brain. For example, the sheet will probably say 'GO' close to news coming out because trading is very low then, but you should know it is NOT good to do so (at least) half an hour before the news! And since masofras just told us his old concept of the flexi filters is not good, I doubt if the section I added will truly work but we will...
Many Thanks dariuske

I have a question,signals are against bidratio and RS ?
  • #223
  • Oct 15, 2015 11:59am Oct 15, 2015 11:59am
Hi,
These were the signals today with SpeedometerV3(GAP_SYNC tab) at TO: GBPCAD, CADJPY and USDCAD. And TO+1: AUDJPY, EURAUD.
I canīt check LO neither NYO, please, could you share the signals from LO and NYO to see if they are reliable.
Regards
Attached Image(s) (click to enlarge)
Click to Enlarge Name: fxcm-ff-TO-15Oct.jpg Size: 30 KB
Click to Enlarge Name: Pepper-ff-TO-15Oct.jpg Size: 10 KB
Click to Enlarge Name: Tickmill-ff-TO-15Oct.jpg Size: 10 KB
  • #224
  • Oct 15, 2015 12:45pm Oct 15, 2015 12:45pm
Quoting dariuske
Well, I added an extra section to the excel which should help you to trade the GAP in a 'dead' market as explained by JB. This does not mean that when the sheet says 'GO' that you should just trade without using your brain. For example, the sheet will probably say 'GO' close to news coming out because trading is very low then, but you should know it is NOT good to do so (at least) half an hour before the news! And since masofras just told us his old concept of the flexi filters is not good, I doubt if the section I added will truly work but we will...
Thanks dariuske
  • #225
  • Oct 15, 2015 1:49pm Oct 15, 2015 1:49pm
Quoting PipFlak
{quote} I know what that is it's the weapons console from a Klingon Bird of Prey! Does the Federation know you have this? All you need is a cloaking device and the brokers will never see you coming!
Cloaking device?
I need this because i am looking for hidden "Cloaking" take profit Ea without success. I tested many different no one works as I would have liked. But my problem does not belong to this thread.

Trading is like surfing on the waves. Ride the lowest and surf down from the highest!

Best regards
  • #226
  • Oct 15, 2015 2:10pm Oct 15, 2015 2:10pm
Quoting PipFlak
{quote} Sure looks hi tech to me you should be working for the CIA!
THX
Hi tech analysis without a good trading style does not always work

Let force be with you.
  • #227
  • Oct 15, 2015 3:14pm Oct 15, 2015 3:14pm
Hello friends,
There are a lot of potential in what we are doing here. I know people can contribute more to this cause. Like how do we get correct calculation for flexi filters?
By the way, I thought of adding RSI to the excel but we need to continue to export data from mt4 and import data for every timeframe we decide. It is working
but its unnecessary. WHY RE-INVENT the wheel????? This is what I came up with, I added RSI to GVC Power Meter V3 and put my excel side by side. Thanks to GVC.
This is the result I was able to achieve in the past 2hrs (Manual trade). Let us be dynamic and think of how we can improve the excel tool. Thanks.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: SYncBias_CRS_RSI1.PNG Size: 164 KB
Click to Enlarge Name: SYncBias_CRS_RSI2.PNG Size: 162 KB
Click to Enlarge Name: SYncBias_CRS_RSI3.PNG Size: 93 KB
Click to Enlarge Name: SYncBias_CRS_RSI4.PNG Size: 125 KB
Click to Enlarge Name: SYncBias_CRS_RSI5.PNG Size: 85 KB
  • #228
  • Oct 15, 2015 4:33pm Oct 15, 2015 4:33pm
Quoting PipFlak
{quote} Thank for all your effort I know you are super busy with work and thanks to GVC! Can I get a copy of the dash? Looks good. Sorry had to ask Good idea putting the RSI values.
Here you go. Many pip to you all.


Hope guys don't mind posting a dash here. We know this thread is for excel tools.
Attached File(s)
File Type: ex4 Power MeterV3+RSI2.ex4   228 KB | 1,720 downloads
  • #229
  • Oct 15, 2015 4:39pm Oct 15, 2015 4:39pm
What is all about this thread "GAP" ?

What is your strategy guys? I dont understand...
  • #230
  • Oct 15, 2015 6:17pm Oct 15, 2015 6:17pm
Quoting dtlase
Hello friends, . {image} {image} {image} {image} {image}
Hi,

great job, thank you...
if you're doing we all have results with all
  • #231
  • Oct 16, 2015 12:48am Oct 16, 2015 12:48am
When you guys mentioned 30m Gap is that mean once the excel refresh, the gap will start from 0. Whichever pair that reach the +/- 1.75 or more consider as having a gap? Can somebody also tell me what is "BS ratio"? How do we calculate this?

Alpe
  • #232
  • Oct 16, 2015 1:25am Oct 16, 2015 1:25am
Quoting proctor
could you please explain us how you came to the decisions compare to the showed pictures?why for example only chfjpy?
Attached Image

I guess there was more than one (1) signal only but I do not track everything everywhere especially when I go to the grocery!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #233
  • Oct 16, 2015 2:04am Oct 16, 2015 2:04am
Quoting Alpe
When you guys mentioned 30m Gap is that mean once the excel refresh, the gap will start from 0. Whichever pair that reach the +/- 1.75 or more consider as having a gap? Can somebody also tell me what is "BS ratio"? How do we calculate this? Alpe
Since most members of this thread coming from another one, some of the key terms should be described / explained on first site. On the other hand there is always a search function available. Maybe more useful to explain the "how to" of this first!

Btw BS Ratio or BSR stands for buy / sell ratio which is calculated from strength of base & quote currency.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #234
  • Oct 16, 2015 2:45am Oct 16, 2015 2:45am
Quoting Alpe
When you guys mentioned 30m Gap is that mean once the excel refresh, the gap will start from 0. Whichever pair that reach the +/- 1.75 or more consider as having a gap? Can somebody also tell me what is "BS ratio"? How do we calculate this? Alpe
Well, that is a bit what's been bothering me since the beginning about the excel.
Normally the GAP (if I understand Maria correctly) is only shown every 30 minutes (every ??:00 and ??:30 hours) and based on that you only search for trades in the direction of the GAP. So how the excel works now, is not the way Maria intended it. But I don't think it is the way Jibala uses it and that they maybe use a rolling 30 minute window or something.
So the excel should Always have a number as GAP and not be reset to zero. That's just my 2 cents.
  • #235
  • Oct 16, 2015 2:47am Oct 16, 2015 2:47am
Quoting dtlase
Hello friends, There are a lot of potential in what we are doing here. I know people can contribute more to this cause. Like how do we get correct calculation for flexi filters? By the way, I thought of adding RSI to the excel but we need to continue to export data from mt4 and import data for every timeframe we decide. It is working but its unnecessary. WHY RE-INVENT the wheel????? This is what I came up with, I added RSI to GVC Power Meter V3 and put my excel side by side. Thanks to GVC. This is the result I was able to achieve in the past 2hrs...
  • #236
  • Oct 16, 2015 2:52am Oct 16, 2015 2:52am
Quoting PipFlak
{quote} Jibala If I make a basic trading guide tlhis weekend would you mind proof reading it before I export it to pdf? I will include a definition page/s
That would be awesome!
MT4/MT5 EAs/Indicators/Alerts coder
  • #237
  • Oct 16, 2015 3:06am Oct 16, 2015 3:06am
Quoting PipFlak
{quote} The original way Maria figured the gap was by taking screenshots every 30 min and comparing the values to measure how much the absolute strength had changed. Later she suggested using the BS ratios instead. There is no rolling value with 30 min screenshots. I don't know how that came about. Read back from the beginning of the Maria posts. I would prefer it if that is the way it worked now. http://www.forexfactory.com/showthre...79#post8534079


MAYBE you should read what people write instead of lecturing them.
I said: But I don't think it is the way Jibala uses it and that they maybe use a rolling 30 minute window or something.
Then you could ask: "Oh, why do you think so?" And then a conversation can start, which by the way can be very constructive instead of telling people what to do after having drawn the wrong conclusions about what they wrote!
  • #238
  • Oct 16, 2015 3:25am Oct 16, 2015 3:25am
Quoting PipFlak
{quote} Sorry didn't mean to lecture forgive me I just woke up. But the way the gap works confuses the heck out me too. It wasn't directed at you by the way I already know you know what is going on. I am in the middle of trying to put together a guide so the same question don't have to be answered over and over.
No problem!
  • #239
  • Oct 16, 2015 3:37am Oct 16, 2015 3:37am
Quoting PipFlak
{quote} If people would just read from the beginning of the thread it would answer almost all their questions! The dang thread is only a week old for Pete's sake!
Completely agree! But it seems very hard for most people to put in a bit of effort.
  • #240
  • Oct 16, 2015 3:57am Oct 16, 2015 3:57am
Quoting PipFlak
{quote} Sorry didn't mean to lecture forgive me I just woke up. But the way the gap works confuses the heck out me too. It wasn't directed at you by the way I already know you know what is going on. I am in the middle of trying to put together a guide so the same question don't have to be answered over and over. If people would just read from the beginning of the thread it would answer almost all their questions! The dang thread is only a week old for Pete's sake! Sorry I am done ranting now.
Read it again!

http://www.forexfactory.com/showthre...92#post8537192

You (not you in person) haven't put the basics together even, hence what you're going to trade with?
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
3 traders viewing now