MT4 Trading the GAP With Excel | Page 90 | 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,781
  • Jun 13, 2016 3:55am Jun 13, 2016 3:55am
Now the GBP worked, full automatic, Almost 50 pips in 4 trades. Too bad the other GBP ruined a good Monday.

In the right of the photo can be seen how much would move in profit on the next 2 time frames after I hit TP. So for the GBP I could earn 100 pips more if I could just wait a little longer, but that is just for feature investigation of my trades for my TP dynamic formula's.
Attached Image (click to enlarge)
Click to Enlarge Name: GBP.png Size: 20 KB
By failing to prepare, you are preparing to fail.
  • #1,782
  • Jun 13, 2016 4:26am Jun 13, 2016 4:26am
Hi.

Trying forex gap on google, I find you. But I don’t understood anything.

Among these 89 forum pages (help me! don’t make me read all!), can I find a post where has been explained all this theory on forex gap?

I don’t speak English (I use Google translator), so to understand I must read some example.
  • #1,783
  • Jun 13, 2016 5:29am Jun 13, 2016 5:29am
Quoting project13et
Now the GBP worked, full automatic, Almost 50 pips in 4 trades. Too bad the other GBP ruined a good Monday. In the right of the photo can be seen how much would move in profit on the next 2 time frames after I hit TP. So for the GBP I could earn 100 pips more if I could just wait a little longer, but that is just for feature investigation of my trades for my TP dynamic formula's. {image}
It didn't work for me too!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_10h07m25s_023_.png Size: 192 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_12h02m28s_036_.png Size: 90 KB

But some minutes later I could fight back.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h26m37s_028_.png Size: 200 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_12h11m08s_037_.png Size: 26 KB

Like what I wrote a while ago, GBP is a bit difficult at the moment. Better to trade single orders and to play it like Beckham!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h32m35s_030_.png Size: 80 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h32m59s_031_.png Size: 75 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h54m38s_033_.png Size: 81 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h55m21s_034_.png Size: 14 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_11h57m51s_035_.png Size: 84 KB

Have a nice day all together!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,784
  • Jun 13, 2016 5:44am Jun 13, 2016 5:44am
Quoting cinisciu
Hi. Trying forex gap on google, I find you. But I dont understood anything. Among these 89 forum pages (help me! dont make me read all!), can I find a post where has been explained all this theory on forex gap? I dont speak English (I use Google translator), so to understand I must read some example.
You are the lucky one because only 90 pages (plus some referrals) to read! Hence, continue reading, try to understand and learn from what you've read.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,785
  • Jun 13, 2016 5:51am Jun 13, 2016 5:51am
Quoting cinisciu
Hi. Trying forex gap on google, I find you. But I dont understood anything. Among these 89 forum pages (help me! dont make me read all!), can I find a post where has been explained all this theory on forex gap? I dont speak English (I use Google translator), so to understand I must read some example.
Not to much time ago I was exact in you're situation, patience and perseverance is the key of success

Quoting JibalaPasan
{quote} It didn't work for me too! {image} {image} But some minutes later I could fight back. {image} {image} Like what I wrote a while ago, GBP is a bit difficult at the moment. Better to trade single orders and to play it like Beckham! {image} {image} {image} {image} {image} Have a nice day all together! Jibala
I am a big fan of M2 / M3 custom time frames, I use them already for different formula's why did you change you're M5 spaghetti lines ? Should I try M2 ? Because sometimes if retracement happen before bar close, on historical graph I can't see that move, or should I always record the highest , lowest value touched even if the bar didn't close on that level?

Thanks,
By failing to prepare, you are preparing to fail.
  • #1,786
  • Jun 13, 2016 8:35am Jun 13, 2016 8:35am
Quoting project13et
{quote} Not to much time ago I was exact in you're situation, patience and perseverance is the key of success {quote} I am a big fan of M2 / M3 custom time frames, I use them already for different formula's why did you change you're M5 spaghetti lines ? Should I try M2 ? Because sometimes if retracement happen before bar close, on historical graph I can't see that move, or should I always record the highest , lowest value touched even if the bar didn't close on that level? Thanks,
I didn't change it but the analyses states that there is much more potential in smaller TFs hence, our decision was to step down. Now it's pure manual scalping and it's just fun and amazing how good it works.

My choice USDCAD & USDCHF long:

USDCAD, OP_BUY Order Details: Main Trend UP, BR: 0.93 (+/- 0.77), RS: 7.79 (+/- 7.15), BS: 3.25 (+/- 3.24), BS GAP: 1.34 (+/- 0.45), APS: 2.43, AMS: 3.02

USDCHF, OP_BUY Order Details: Main Trend UP, BR: 0.97 (+/- 0.77), RS: 8.90 (+/- 7.17), BS: 3.62 (+/- 3.26), BS GAP: 0.34 (+/- 0.45), APS: 2.80, AMS: 2.99
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h05m42s_047_.png Size: 186 KB

USDCAD was running better
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h09m38s_048_.png Size: 182 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h10m19s_049_.png Size: 77 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h10m52s_050_.png Size: 74 KB

EURUSD short:

EURUSD, OP_SELL Order Details: Main Trend FLAT, BR: 0.28 (+/- 0.77), RS: -2.57 (+/- 7.13), BS: -1.06 (+/- 3.19), BS GAP: -0.96 (+/- 0.45), APS: -1.23, AMS: 3.12
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h12m18s_051_.png Size: 183 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h22m49s_052_.png Size: 74 KB

What a perfect timing and calculation of TP, it couldn't be any better even!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h33m44s_053_.png Size: 75 KB

I have much more trades for today, showing some of them only because this trading style needs my attention hence, don't have much time for taking screens.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,787
  • Jun 13, 2016 8:47am Jun 13, 2016 8:47am
Quoting JibalaPasan
{quote} I didn't change it but the analyses states that there is much more potential in smaller TFs hence, our decision was to step down. Now it's pure manual scalping and it's just fun and amazing how good it works. My choice USDCAD & USDCHF long: USDCAD, OP_BUY Order Details: Main Trend UP, BR: 0.93 (+/- 0.77), RS: 7.79 (+/- 7.15), BS: 3.25 (+/- 3.24), BS GAP: 1.34 (+/- 0.45), APS: 2.43, AMS: 3.02 USDCHF, OP_BUY Order Details: Main Trend UP, BR: 0.97 (+/- 0.77), RS: 8.90 (+/- 7.17), BS: 3.62 (+/- 3.26), BS GAP: 0.34 (+/- 0.45), APS: 2.80, AMS:...
Congratulation amazing TP on EURUSD. I am working for sometime already to implement a tick based OHLC, so non standard time frames, just pure ticks. Higher volatility pairs get more ticks less volatility pairs less ticks, is that wrong? I will focus my time more on that then trading in the next period to finish it faster.
By failing to prepare, you are preparing to fail.
  • #1,788
  • Jun 13, 2016 9:20am Jun 13, 2016 9:20am
Quoting project13et
{quote} Congratulation amazing TP on EURUSD. I am working for sometime already to implement a tick based OHLC, so non standard time frames, just pure ticks. Higher volatility pairs get more ticks less volatility pairs less ticks, is that wrong? I will focus my time more on that then trading in the next period to finish it faster.
Just watch the spaghetti how it is moving and you easily can find out what pairs you have to choose!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_15h50m32s_054_.png Size: 194 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_16h00m12s_055_.png Size: 77 KB

Almost like EURUSD in my prior post.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_16h00m33s_056_.png Size: 75 KB

EURUSD up and down it doesn't matter where it goes!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_16h01m00s_057_.png Size: 89 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_16h04m20s_059_.png Size: 83 KB



However, waiting on your presentation of the tick by tick OHLC and if there will be any improvement!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,789
  • Jun 13, 2016 9:53am Jun 13, 2016 9:53am
Took some counter trades today with the following RULES..

BUY currency that has +Ve Strength GAP in a DOWNTREND.
SELL currency that has -Ve Strength GAP in an UPTREND.
The STRONGER currency should have -Ve Strength GAP while the WEAKER currency should have +Ve Strength GAP.
The pair should have a -Ve BS GAP equal or below BS GAP filter for a SELL in an UPTREND.
The pair should have a +Ve BS GAP equal or above BS GAP filter for a BUY in a DOWNTREND.
Lastly, Fibo & Pivot should advice a BUY TRADE for a COUNTER downtrend trade (i.e price should be hitting a Support) and vice versa for a SELL TRADE (Resistance)

AGAINST TREND...
Attached Image (click to enlarge)
Click to Enlarge Name: AUDCHF.PNG Size: 75 KB

Attached Image (click to enlarge)
Click to Enlarge Name: GBPAUD.PNG Size: 63 KB

Attached Image (click to enlarge)
Click to Enlarge Name: GBPNZD.PNG Size: 62 KB


WITH TREND...
Attached Image (click to enlarge)
Click to Enlarge Name: CHFJPY.PNG Size: 70 KB

Attached Image (click to enlarge)
Click to Enlarge Name: USDCAD.PNG Size: 49 KB

Attached Image (click to enlarge)
Click to Enlarge Name: NZDCHF Fib_Pivot set TP.PNG Size: 72 KB


Lastly, A Lesson....Have rules and stick to them. Took this BUY TRADE in a DOWNTREND but closed it Only checking the Currency Strength GAP of the two currencies without checking if the BS GAP of the pair was still +Ve (Still learning)
Attached Image (click to enlarge)
Click to Enlarge Name: GBPJPY CLOSED Trade(WRONG).PNG Size: 63 KB


But the most important thing is that you remain in profit....
Attached Image


Attached Image (click to enlarge)
Click to Enlarge Name: FTB_update.PNG Size: 277 KB


Attached Image (click to enlarge)
Click to Enlarge Name: Account History.PNG Size: 44 KB
  • #1,790
  • Jun 13, 2016 10:19am Jun 13, 2016 10:19am
Quoting BlacMoni
Took some counter trades today with the following RULES.. BUY currency that has +Ve Strength GAP in a DOWNTREND. SELL currency that has -Ve Strength GAP in an UPTREND. The STRONGER currency should have -Ve Strength GAP while the WEAKER currency should have +Ve Strength GAP. The pair should have a -Ve BS GAP equal or below BS GAP filter for a SELL in an UPTREND. The pair should have a +Ve BS GAP equal or above BS GAP filter for a BUY in a DOWNTREND. Lastly, Fibo & Pivot should advice a BUY TRADE for a COUNTER downtrend trade (i.e price should be...
I hope to see more in the future! Great result! Keep up the good work. Excellent!

Btw allow me one question! How long did it take to develop your dashboard?
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,791
  • Jun 13, 2016 10:58am Jun 13, 2016 10:58am
What I wrote already, this trading style needs a lot of attention otherwise I will miss the good signals.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_16h02m20s_058_.png Size: 203 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_17h39m59s_065_.png Size: 28 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.13_17h42m19s_067_.png Size: 86 KB

+204 Pip! No matter where it goes or wanna go, I will fetch it. It works like a charm!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,792
  • Jun 13, 2016 4:50pm Jun 13, 2016 4:50pm
Quoting cinisciu
Hi. Trying forex gap on google, I find you. But I dont understood anything. Among these 89 forum pages (help me! dont make me read all!), can I find a post where has been explained all this theory on forex gap? I dont speak English (I use Google translator), so to understand I must read some example.

@cinisciu
I know it could be hard at the beginning
you could start from this post and this one about the original GAP theory
take it slowly,read all the thread carefully and do not be afraid to ask your questions
the only problem could be your English,I wish you could understand everything
DO UT DES
  • #1,793
  • Jun 13, 2016 8:04pm Jun 13, 2016 8:04pm
My early bird for today on JPY:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.14_02h13m03s_076_.png Size: 214 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.06.14_02h47m39s_084_.png Size: 25 KB

Good night all together!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,794
  • Jun 14, 2016 3:43am Jun 14, 2016 3:43am
Quoting the bourne
{quote} @cinisciu I know it could be hard at the beginning you could start from this post and this one about the original GAP theory take it slowly,read all the thread carefully and do not be afraid to ask your questions the only problem could be your English,I wish you could understand everything
Hi The Bourne!

I think it's very difficult for me, because in addition to being written in a language different from mine, relevant information is scattered in hundreds of web pages.
I opened a link that you reported to me and I found a thread with more than 900 pages . Help!

So ... I think I must give up.

But thanks anyway for the info!
  • #1,795
  • Jun 14, 2016 3:57am Jun 14, 2016 3:57am
Quoting JibalaPasan
{quote} I hope to see more in the future! Great result! Keep up the good work. Excellent! Btw allow me one question! How long did it take to develop your dashboard?
Thanks, took me about 2 weeks but with much work hours
  • #1,796
  • Jun 14, 2016 5:05am Jun 14, 2016 5:05am
Quoting BlacMoni
{quote} Thanks, took me about 2 weeks but with much work hours
Congrats sister, it is / was worth it!

Some more questions to answer, maybe also of interest for all our fellow traders. How would you describe your knowledge in M$ Excel, vba programming and what was your motivation to develop such a dashboard?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,797
  • Jun 14, 2016 8:42am Jun 14, 2016 8:42am
Quoting project13et
Why everyone is looking for tools made with others ideas, that they don't even understand how it work's. They change tools and strategies every day and they ask them self why the results are not good, and there is no profit. Just try to understand trading style! Like that you have a solid strategy and you can build you're own tools with you're market vision and understanding. Traders exist because of there market behavior understanding not because of there tools, tools are just an additional to make trades life more easy.
Hi,


i agree with you....

regards

Attached Image (click to enlarge)
Click to Enlarge Name: ls.png Size: 106 KB


Attached Image (click to enlarge)
Click to Enlarge Name: ls1.png Size: 78 KB
if you're doing we all have results with all
  • #1,798
  • Jun 14, 2016 10:10am Jun 14, 2016 10:10am
Quoting JibalaPasan
{quote} Congrats sister, it is / was worth it! Some more questions to answer, maybe also of interest for all our fellow traders. How would you describe your knowledge in M$ Excel, vba programming and what was your motivation to develop such a dashboard? Jibala
Just had basic knowledge of excel, didn't even know how to use excel formulas let alone conditional formatting though I have a basic background on programming but nothing that serious. I'm kinda conversant with them IF, ELSE, AND, OR statements as per decision making...outside that I had to do a lot of reading from PDFs to websites to acquire knowledge on vba to work in excel. Imho...I believe everyone can accomplish same if they put some interest into it.

I was motivated by your posts on the thread, showing your trades...so I downloaded dtlase's speedometer_V4c. Started studying it and testing out some trade signals, saw how potent they were and decided to have mine. I'm not done yet, testing, debugging and tweaking seeing i'm not entirely sure of your triggers and calculation formulas. I intend to work on my spaghetti when my dash is perfect.
  • #1,799
  • Jun 14, 2016 10:16am Jun 14, 2016 10:16am
One based highest value touched / lowest value touched other just normal data, I am not satisfied by any of them still looking for better solution. If I am not at pc for few minutes and I come back I want to see if the that level was been touched or not , shouldn't be sell the highest , buy the lowest? So far the counter trades results are very but can't beat "WSD" !
Attached Image (click to enlarge)
Click to Enlarge Name: data.png Size: 134 KB
By failing to prepare, you are preparing to fail.
  • #1,800
  • Jun 14, 2016 11:05am Jun 14, 2016 11:05am
have a nice weekend all...

Attached Image (click to enlarge)
Click to Enlarge Name: ls5.png Size: 74 KB
if you're doing we all have results with all
2 traders viewing now