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

  • #201
  • Edited 2:26am Oct 15, 2015 1:46am | Edited 2:26am
CapeCoddah and GVC have graciously offered to implement 3 or 4 excel features onto powermeter 3.

This is what I think it needs but need your input. Keep in mind we can't ask too much these guys are busy.

1. 15 min gap update changed to 30 min Maybe everything updates at 30 min have to ask Jibala how she does hers. Massofras flexi filter added.
2. Replace GVC Currency meter with one like HP has on his dash same as excel with CRS, bias, synch, direction, etc Move meter down where HP has his.
3. Buy, Sell, Wait alerts down on left hand side where existing group currencies buttons are next to currency meter. Move trade info to left to meet up with close row.
4.Speedometers to right of trade info row. Might have to be mini speedometers in order to get them all in there.
5. Market strength added.

I know technically this is 6 requests but maybe they will do it.

For instance if you get a buy alert for AUD and a sell for USD ( if that is how that works) you would take the highlighted AUD/USD on existing dash if it meets Maria's BR rules(not over 90% or under 10%)

Would one of you with photoshop be able to come up with a layout that we could give them. Don't change too much it cuts down on their work.

**We have to thoroughly test everything first in excel so that we don't waste their time.

**If possible add the 30 min 4hr gap synch idea later if it works and looks like it is worth doing has to be tested first in excel.
***Maybe later the trade manager can be improved and a stealth feauture added to fight those lousy bastard gangster Brokers as Jibala puts it (boy don't make her mad she's liable to decapitate you with a machete)
**** Last and know you are going to ask- make it autotrade-this may require too much coding to get it to work right.
  • #202
  • Edited 2:44am Oct 15, 2015 2:33am | Edited 2:44am
The euro just took a nosedive.
Something is wrong the euro is down but I am getting a Euro buy signal on the gap synch.
Dtlase is going to have to explain how to use this I am confused. Looks great though.
Help Jibala!
No way this is a reversal signal.
I just missed several trades on dash with no corresponding signals from excel.
  • #203
  • Edited 2:58am Oct 15, 2015 2:44am | Edited 2:58am
Quoting Adhipfx
{quote} Hi dariuske Please give me advice if i want 4 hour gap so i have to push "manual update bottom" early 4 hour before my trading start,am I right? I am so confused,How can i know 30 min. gap+4 hour gap at the same time?
Yes, As long as dtlase does not unlock the VB or adjust it so you can choose what timeframe you want the gap to display, you have to manually press updat every 4 hours. If you want 30 min and 4H GAP both, just use two excel sheets at once. (Copy one and rename it 4H and start Original plus 4H one.)

Edit: of course you can also just copy the content on specific moments and paste it in the columns you want.
  • #204
  • Oct 15, 2015 2:57am Oct 15, 2015 2:57am
Quoting PipFlak
The euro just took a nosedive. Something is wrong the euro is down but I am getting a Euro buy signal on the gap synch. Dtlase is going to have to explain how to use this I am confused. Looks great though. Help Jibala! No way this is a reversal signal. I just missed several trades on dash with no corresponding signals from excel.

Look at Jibala's comment:

Quoting JibalaPasan
{quote} Remember? http://www.forexfactory.com/showthre...12#post8539212 This is what we got from a "dead" market: {image} Have a green day all together.
LO is not a dead market.
  • #205
  • Oct 15, 2015 2:57am Oct 15, 2015 2:57am
Quoting dariuske
{quote} Yes, As long as dtlase does not unlock the VB or adjust it so you can choose what timeframe you want the gap to display, you have to manually press updat every 4 hours. If you want 30 min and 4H GAP both, just use two excel sheets at once. (Copy one and rename it 4H and start Original plus 4H one.)
dariuske

You got any idea how to use the gap synch?

dtlase is going have to give you the keys to the house cause this is going to take a lot of adjustment I think.

Maybe you can sign a non disclosure agreement
  • #206
  • Oct 15, 2015 3:05am Oct 15, 2015 3:05am
Quoting dtlase
Hello friends, I have been away due to work.... Thanks to everyone that has contributed to the progress of this course. I have manage to add some flexi filter from our friend masofras. I am not saying this is perfect or the same with Jiba's filter. Again let me remind us that this is a tool, and it should be use with our other strategy. I hope Jibala can go through this masofras filter for us. Thanks for your effort. I also include the CRS filter. The best signal is when you have The BASE & QUOTE with different colour, that means one is +- . I will...

Good job of integrating masofras excel!
  • #207
  • Oct 15, 2015 3:28am Oct 15, 2015 3:28am
Quoting PipFlak
{quote} dariuske You got any idea how to use the gap synch? dtlase is going have to give you the keys to the house cause this is going to take a lot of adjustment I think. Maybe you can sign a non disclosure agreement




How to use it in 'dead' market = Order Details: Main Trend UP, BR: 0.75, RS: 4.97, BS: 1.92, BS GAP: -1.78

How I am starting to implement it in a 'live' market is by using it as a confirmation with my own way of trading. (+17 pips)
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 3 KB
  • #208
  • Oct 15, 2015 3:34am Oct 15, 2015 3:34am
Quoting dariuske
{quote} Yes, As long as dtlase does not unlock the VB or adjust it so you can choose what timeframe you want the gap to display, you have to manually press updat every 4 hours. If you want 30 min and 4H GAP both, just use two excel sheets at once. (Copy one and rename it 4H and start Original plus 4H one.) Edit: of course you can also just copy the content on specific moments and paste it in the columns you want.
Thank you dariuske
  • #209
  • Oct 15, 2015 3:39am Oct 15, 2015 3:39am
Quoting JibalaPasan
{quote} What I can see from picture looks good and very similar!
  • #210
  • Oct 15, 2015 3:49am Oct 15, 2015 3:49am
Quoting dariuske
{quote} Look at Jibala's comment: {quote} LO is not a dead market.
At the time of my post London was still sleeping (2nd hour of Tokyo). Until now profit almost doubled (11 / 49), enough for today! I am out of office for some hours.

cul8er
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #211
  • Oct 15, 2015 3:52am Oct 15, 2015 3:52am
Quoting PipFlak
The euro just took a nosedive. Something is wrong the euro is down but I am getting a Euro buy signal on the gap synch. Dtlase is going to have to explain how to use this I am confused. Looks great though. Help Jibala! No way this is a reversal signal. I just missed several trades on dash with no corresponding signals from excel.
Well... in retrospect it seems those reversal signals were right. Seems you did not look at all the info on your screen then, maybe? Did you look at market strength?
That is why having historical data is so important. Then you can look back and analyse what you did not see at that moment! Just start to take printscreens at such moments.
  • #212
  • Edited 4:11am Oct 15, 2015 3:56am | Edited 4:11am
Quoting dariuske
{quote} Well... in retrospect it seems those reversal signals were right. Seems you did not look at all the info on your screen then, maybe? Did you look at market strength? That is why having historical data is so important. Then you can look back and analyse what you did not see at that moment! Just start to take printscreens at such moments.
A reversal signal after a big candle with a freakin doji next to it? What does it do engulfing candles too? I got a buy signal right after the first big candle. If it can tell that the market is pulling back from that it is amazing.
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 101 KB
  • #213
  • Oct 15, 2015 3:58am Oct 15, 2015 3:58am
Quoting dariuske
{quote} How to use it in 'dead' market = Order Details: Main Trend UP, BR: 0.75, RS: 4.97, BS: 1.92, BS GAP: -1.78 How I am starting to implement it in a 'live' market is by using it as a confirmation with my own way of trading. (+17 pips) {image}

sent you pm
  • #214
  • Oct 15, 2015 4:05am Oct 15, 2015 4:05am
Quoting PipFlak
{quote} A reversal signal after a big candle with a freakin doji next to it? What does it do engulfing candles too?
Wouldn't that be great? Maybe we could call it 'the crystal ball'?
  • #215
  • Oct 15, 2015 4:14am Oct 15, 2015 4:14am
Quoting JibalaPasan
{quote} What I can see from picture looks good and very similar!
Thank you Jibala. I believe with more of your input from your success, guys can come up with excel tool that will help greatly with trading. Thank you all.
  • #216
  • Oct 15, 2015 4:30am Oct 15, 2015 4:30am
Quoting dtlase
{quote} Thank you Jibala. I believe with more of your input from your success, guys can come up with excel tool that will help greatly with trading. Thank you all.
Thanks dtlase I love this thing it smells like progress!
  • #217
  • Oct 15, 2015 4:39am Oct 15, 2015 4:39am
I downloaded an auto screenshot prog from soundforge just have to figure out how to do this wish it wouldn't default back to another screen every 30 minutes.
  • #218
  • Oct 15, 2015 5:53am Oct 15, 2015 5:53am
Quoting dtlase
Hello friends, I have been away due to work.... Thanks to everyone that has contributed to the progress of this course. I have manage to add some flexi filter from our friend masofras. I am not saying this is perfect or the same with Jiba's filter. Again let me remind us that this is a tool, and it should be use with our other strategy. I hope Jibala can go through this masofras filter for us. Thanks for your effort. I also include the CRS filter. The best signal is when you have The BASE & QUOTE with different colour, that means one is +- . I will...
Hello guys

First, I have to say, Im glad that you started this thread and trading with excel becoming more popular. Since I learnt something in this thread I have to share my experience too. I cant share everything I have tied hands from my team, not everyone agree with sharing all details here. Im not saying that Im on Jibala level but I think Im very close


Okey, lets focus on technical things. At first, my old flexi filters are bad but rough idea was good. The biggest problem of these flexi filters(old) is When market is weaking/weak it opens trade with no pressure/flow and this is bad. As Jibala mentioned we need adjust our flexi filters depending on market strength. IF market is strong our filters should be lower as usual and same for opposite IF market is weak values should be higher. Where is my point here? Dont waste time with my formula it needs adjustment but idea is there.


Next thing What I tested and my opinion.
Do not divide strength of bull/bears from 28 pairs. In Excel file buy sell values are different and they should be equal. If you are calculating bull strength use function in Excel ABS() of 28 pairs and for bear strength use just BULL STRENGTH*(-1) . Im not 100% sure about it but I have better feeling to calculate strength with function ABS().

Keep doing good job

Hope it will helps


have a nice day



masofras
  • #219
  • Oct 15, 2015 8:00am Oct 15, 2015 8:00am
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 see.
So please TEST IT first and let us know your findings!!!!!
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 91 KB
Attached File(s)
File Type: zip Speedometer_v4_1.zip   524 KB | 1,259 downloads
  • #220
  • Oct 15, 2015 8:23am Oct 15, 2015 8:23am
Quoting Bernhard
{quote} agreed, and some word to caution here. macros and links with excel are dangerous source of hacks and virus. DO NOT USE FILES FROM UNKNOWN PEOPLE! So now some other question. We use mt4 DDE for high low ask bid, how it takes the right TF. Do I need have the right TF charts open? Or how it is linked to a TF. I was told the pairs need only to be listed in market overview.
Tick by tick processing = no timeframes!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
2 traders viewing now