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

  • #21
  • Oct 9, 2015 3:12am Oct 9, 2015 3:12am
Quoting dtlase
{quote} @dariuske I will check the calculation again. It should be a SELL, since the GAP for EU,GU,AU,NU are +1. it shows that you BUY the base and SELL the quote USD. and UC,UJ are -1. All the calculation are on the work sheet. It is just the timer and update that is protected. when you click on the Cell where you have 4, the calculation is there.
If I want to adjust the calculations I get a message saying I can't because it is password protected!
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 94 KB
  • #22
  • Edited 3:23am Oct 9, 2015 3:12am | Edited 3:23am
Today we have a trending market, no reversals hence no tradeable "GAPs" until now. But good for trading strength!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #23
  • Oct 9, 2015 3:26am Oct 9, 2015 3:26am
Quoting JibalaPasan
{quote} Exactly what I noticed too that's why I wrote above "should be explained by the creator". Only then we will know how it works.

My interpretation might be wrong because of lack of info and little knowledge of the pics. Just trying to follow what I see in the pictures.
Though not perfect but it can be with the help of friends.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015_09_28_08h59m24s_004_.png Size: 83 KB
Click to Enlarge Name: Ashampoo_Snap_2015_09_28_15h56m24s_009_.png Size: 90 KB
Click to Enlarge Name: Ashampoo_Snap_2015_09_28_18h13m52s_012_.png Size: 90 KB
Click to Enlarge Name: Ashampoo_Snap_2015_09_29_22h59m29s_028_.png Size: 96 KB
Click to Enlarge Name: Ashampoo_Snap_2015_09_30_09h35m50s_032_.png Size: 94 KB
  • #24
  • Oct 9, 2015 3:29am Oct 9, 2015 3:29am
Quoting dariuske
{quote} If I want to adjust the calculations I get a message saying I can't because it is password protected! {image}
I will check it.
  • #25
  • Oct 9, 2015 3:33am Oct 9, 2015 3:33am
Is this GBP correct. The GAP for EG is -1.71 but the signal is UP.
Attached Image
  • #26
  • Oct 9, 2015 3:39am Oct 9, 2015 3:39am
Quoting JibalaPasan
Today we have a trending market, no reversals hence no tradeable "GAPs" until now. But good for trading strength!
Can you explain to me what you base this on? I'm just trying to understand how others (like you ) think, because I sometimes see people writing things that totaly contradict what I understand it to be. (But that doesn't mean I am right and you are wrong of course.)
For example: you now say it is a trending market and there are no reversals. If I look at the EurAud I see a reversal at LO open that was very tradeable (to me) so what do you mean exactly with what you said? Can you try to explain it more detailed please? On what is your deduction based?

Thanx, Dariuske.
  • #27
  • Oct 9, 2015 3:42am Oct 9, 2015 3:42am
Quoting dtlase
Is this GBP correct. The GAP for EG is -1.71 but the signal is UP. {image}
Yes, that calculation is correct now. The signal is not 'up' the 'base currency' GBP is up so it has to have (indeed) +7 and not +6 and -1!
So, yes, the (group) calculation is correct that way!

If you would do the same for EURAUD and GBPAUD then that (group) calculation would be correct too! And then do it for all others too! If it wasn't password protected I would do it myself.
  • #28
  • Oct 9, 2015 3:54am Oct 9, 2015 3:54am
The GAP_SNYC get its feed from GAP_test.

GAP_test have the BR, RS, BS Ratio, Previous and Diff <>.
Diff = BS - Previous.

The GAP_SYNC is the grouping into Currencies.
We have BS, LBS=Previous, Diff<>


The GAP calculation is based on BS Ratio, M30 interval.

That is all to the excel apart from the Speedometer which also shows M30 interval of the currencies
Attached Images
  • #29
  • Oct 9, 2015 4:23am Oct 9, 2015 4:23am
Here is the updated version with no password.
Thank you dariuske for pointing this out.
Attached File(s)
File Type: zip Speedometer_v2.zip   523 KB | 2,342 downloads
  • #30
  • Oct 9, 2015 4:31am Oct 9, 2015 4:31am
Quoting dariuske
{quote} Can you explain to me what you base this on? I'm just trying to understand how others (like you ) think, because I sometimes see people writing things that totaly contradict what I understand it to be. (But that doesn't mean I am right and you are wrong of course.) For example: you now say it is a trending market and there are no reversals. If I look at the EurAud I see a reversal at LO open that was very tradeable (to me) so what do you mean exactly with what you said? Can you try to explain it more detailed please? On what...
If you measure and respect the GAP only, then you are right. But I have mentioned many times that the filters of our system are based on more than one (1) algorithm for the entry rules. I showed a video even with the "flexi" filters. You soon will find out that <> 1.00 (ours 2.11 at present) is not enough as an entry criterium.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #31
  • Oct 9, 2015 4:45am Oct 9, 2015 4:45am
how to do it properly
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot_5.png Size: 30 KB
  • #32
  • Edited 5:12am Oct 9, 2015 4:52am | Edited 5:12am
Quoting Tobib80
how to do it properly {image}
Gehe auf "Weiter", dann funktioniert das Speedometer.

Attached Image (click to enlarge)
Click to Enlarge Name: Excel 1.png Size: 75 KB


Attached Image (click to enlarge)
Click to Enlarge Name: Excel 2.png Size: 67 KB


Attached Image (click to enlarge)
Click to Enlarge Name: Excel 3.png Size: 30 KB


Attached Image (click to enlarge)
Click to Enlarge Name: Excel 4.png Size: 50 KB
  • #33
  • Edited 5:05am Oct 9, 2015 4:52am | Edited 5:05am
Was mache ich falsch??
bitte helfen
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Screenshot_6.png Size: 57 KB
Click to Enlarge Name: Screenshot_7.png Size: 64 KB
  • #34
  • Oct 9, 2015 5:08am Oct 9, 2015 5:08am
Quoting JibalaPasan
{quote} If you measure and respect the GAP only, then you are right. But I have mentioned many times that the filters of our system are based on more than one (1) algorithm for the entry rules. I showed a video even with the "flexi" filters. You soon will find out that <> 1.00 (ours 2.11 at present) is not enough as an entry criterium.

@JibalaPasan
We know you have been talking about filters and I see a lot of figures on your sheets, but I don't get the calculations.
Can you tell us more? We know you can not share your system, but if you can give us hint on how to calculate or get for example average market 2.11
Gradually we can build in the most important filters. Thanks.
  • #35
  • Oct 9, 2015 5:27am Oct 9, 2015 5:27am
Quoting JibalaPasan
{quote} If you measure and respect the GAP only, then you are right. But I have mentioned many times that the filters of our system are based on more than one (1) algorithm for the entry rules. I showed a video even with the "flexi" filters. You soon will find out that <> 1.00 (ours 2.11 at present) is not enough as an entry criterium.
Jibala,
We all appreciate you. This is a new thread. we will appreciate that you release the entry rules and not the bit by bit release by you

Please do this in writing by fully explaining and (itemising) all the criteria that have to be met for entry.

This will make things easier for the coders and those working on the excel and not they trying to figure out your thinking.

if you look at Udine thread (http://www.forexfactory.com/showthread.php?t=487923) , his trading rules for the H1 strategy/system was fully stated in his first post as per below:
SUMMARY TRADING RULES:

1. D1 & 1H candle color MUST be both red or both green
2. Entry ONLY the FIRST 00 level
3. Frankfurt open only .400/.500/.600 levels
4. London open all levels
5. No short @ .100 level
6. No long @ .900 level
7. No trading 1 hour before RED NEWS on the pair
8. No trading less than 30 minutes after RED NEWS in the pair
9. After 4 losses stop trading for the day
10. Higher probability at market opens (new money into the market
11. Check ADR
12. Distance to BRN > 10 pips (see 5 & 6)
13. Stop trading after reaching daily target
14. Stop Loss 10 pips
15. Take profit 5 pips
16. Trailstop 3.5 pips & Stoploss to BE @ 3.5 pips
17. Only pending orders
18. Trade higher ADR pairs only
19. My pairs EJ and GJ
20. only 1 trade per hour per pair
21. a mistake is 10 burpees

Please do the same
  • #36
  • Oct 9, 2015 5:38am Oct 9, 2015 5:38am
Why are you password protecting it ?

Quoting dtlase
{quote} I will check it.
  • #37
  • Oct 9, 2015 5:41am Oct 9, 2015 5:41am
Quoting toddanderson
Why are you password protecting it ? {quote}
Look here.
  • #38
  • Oct 9, 2015 5:46am Oct 9, 2015 5:46am
Quoting toddanderson
Why are you password protecting it ? {quote}
I have removed the password on the sheets. But in case yours is still having password, here is the pass: 0987654321.
The vba remain protected.
  • #39
  • Oct 9, 2015 5:58am Oct 9, 2015 5:58am
Please friends don't make us dependent of a company like Microsoft. trial 30 days? and then? do i need buy such expensive programs? please try alternative tables with free program open office. (i do not need funny graphics, just the basic alerts)
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #40
  • Oct 9, 2015 6:33am Oct 9, 2015 6:33am
Quoting Bernhard
Please friends don't make us dependent of a company like Microsoft. trial 30 days? and then? do i need buy such expensive programs? please try alternative tables with free program open office. (i do not need funny graphics, just the basic alerts)
You can't do that by yourself? OMG I think I am wrong here!

http://www.forexfactory.com/showthre...82#post8531582
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
1 trader viewing now