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

  • #2,441
  • Oct 23, 2016 8:24am Oct 23, 2016 8:24am
Quoting JibalaPasan
{quote} Your analysis are very good also the results. Our system you've copied perfectly. Yet another hint to reduce false signals. See how the values of AUDUSD look like: AUDUSD, Order Details: Main Trend DOWN, BR: 0.05 (+/- 0.69), RS: -6.38 (+/- 6.62), BS: -4.25 (+/- 1.54), BS GAP: 0.18 (+/- 0.45), APS: -2.72, AMS: 3.32, BSR: 50.00% / 50.00% (65.06%), Bs&Bs: 0.33 / 0.00 (+/- 0.74), AUDUSD -1.99 / 2.26 Would you buy AUDUSD? Not really, right? Because the values are speaking against a buy order. How many times I was talking about the power of correlation...
Thank you very much sister, any information coming from you is very valued and without your teaching I wouldn't get so far.

This post made me even more happy because even if I didn't use the filters like you do, I was having a similar vision and this come in a confirmation for me that I am on the good road. I all this period of course I had problem with my system and thinks didn't alight from the start but if you have hope and you hard work the results will always come and steep by steep you will gone see the big picture.
By failing to prepare, you are preparing to fail.
  • #2,442
  • Oct 25, 2016 1:51am Oct 25, 2016 1:51am
Ok Im frustrated........ sorry

is 2:43am, in 1 hour i have to go to work, i live in NY, I spent the night trying to set up this system..... please, dont get me wrong , I have read the post # 1, even the pdf, several times, believe me..... but....

I need help......
Attached Image (click to enlarge)
Click to Enlarge Name: quit.png Size: 271 KB
I have a Dream....
  • #2,443
  • Oct 25, 2016 3:14am Oct 25, 2016 3:14am
Quoting Yanky2016
Ok Im frustrated........ sorry is 2:43am, in 1 hour i have to go to work, i live in NY, I spent the night trying to set up this system..... please, dont get me wrong , I have read the post # 1, even the pdf, several times, believe me..... but.... I need help...... {image}



First of all make sure in MT4 you have enable DDE and Expert Advisors, Second enable macros inside Excel. Does you're broker use any suffix or prefix ?

If all this is set then you should see the live data in excel , strength, and any formulas that use the live data.

Export to excel indicator help you export historical data from MT4 broker to you're excel
TradefromCSV help you do build an automatic trading system, or manual buttons to trade direct from excel.
By failing to prepare, you are preparing to fail.
  • #2,444
  • Oct 25, 2016 8:42am Oct 25, 2016 8:42am
Quoting Yanky2016
Ok Im frustrated........ sorry is 2:43am, in 1 hour i have to go to work, i live in NY, I spent the night trying to set up this system..... please, dont get me wrong , I have read the post # 1, even the pdf, several times, believe me..... but.... I need help......
in case you live in Europe pay attention to decimal separator it should be dot (.) not comma (,):
through excel 2007 <
file - option - advanced : (chkbox) - Use system separator - uncheck - Decimal separator below enter value "."
Forex can only be understood backwards, but it must be traded forwards.
  • #2,445
  • Oct 25, 2016 8:50am Oct 25, 2016 8:50am
I brought my laptop to work, delete all indicators and ea, then uninstall MT4, reinstall again, now everything works fine...!!

Project13et, Prozor7, Thank You, you are the best.

all of you have done an excellent job here.
Congratulations..!
Attached Image (click to enlarge)
Click to Enlarge Name: is live.png Size: 601 KB



By the way, Im using this one in MT4
Attached Image (click to enlarge)
Click to Enlarge Name: dash.png Size: 441 KB
I have a Dream....
  • #2,446
  • Oct 26, 2016 3:08am Oct 26, 2016 3:08am
Quoting project13et
Dream scalping today, Tokyo session started with high volatility and it keep that way all day long. GBP this days it move side ways so I prefer more the counter trade technique. {image} Like you can see I still have SL's and few trades are closed early by the system because TP was not reach in right momentum and they are at a high risk of reversal. {image} {image} Enough for today , time to sleep ! {image} Market is already sleeping {image} Where did @the_bourne and @blacmoni go ? I would like to see other results for at least 200-300 consecutive...
Hi
I can't see no meaning of showing my muscles\trading results here
I've tried in my last post to explain how I got these results,and I still have got a lot to learn
any precious hint -as always- is much appreciated,especially if coming from you or Jibala
about my trading results,trades are going fair well,my hit ratio is similar to your,I'm still using my algorithms

but,as they said,you are never too old to learn..
I'm currently studying Muti timeframes Gap for M15-M30-H1 Correlation = I'm saving each xx ticks the single Currency strenght,for each TimeFrame,then I subtract the actual (the more recent )strenght from the first of the column,obtaining each time an updated Gap . I put all this Gaps in another excel tab,the 2 tabs are side by side[see pic 1 ] and calculate correlations from there.Obtained correlation % values are shown in the main trading window,for visual testing purposes [see pic 2].I do this for each timeframes,calculating the strenght for each new Candle,M15,M30,H1. Obviously,the M15 strenght TAB refreshes at each new M15 candle,the M30 strenght TAB refreshes at each new M30 candle and so on.

see the pics,thx
Attached Image (click to enlarge)
Click to Enlarge Name: pic1.png Size: 46 KB
Attached Image
DO UT DES
  • #2,447
  • Oct 26, 2016 9:57am Oct 26, 2016 9:57am
Hello fellow traders,
I have set up Speedometer according to instructions and it's getting signals from my MT4. I have also opened a chart and placed the trade from csv file indi.
However I get the " run time error 76" path not found" message on excel that directs me to debug...
Could someone please advise how to get around that.
Thank you
PS:I would like to take the opportunity to congratulate all the pioneers contributing to this thread.
  • #2,448
  • Oct 26, 2016 1:56pm Oct 26, 2016 1:56pm
Quoting the bourne
{quote} Hi I can't see no meaning of showing my muscles\trading results here I've tried in my last post to explain how I got these results,and I still have got a lot to learn any precious hint -as always- is much appreciated,especially if coming from you or Jibala about my trading results,trades are going fair well,my hit ratio is similar to your,I'm still using my algorithms but,as they said,you are never too old to learn.. I'm currently studying Muti timeframes Gap for M15-M30-H1 Correlation = I'm saving each xx ticks the single Currency strenght,for...
Musles has nothing to do, since there are lot of haters around I would like to see more positive & constructive posts, what else like argue then positive results if they are any of course ... in the end we all own something to this thread and to the person that keep it alive JibalaPasan. But is sad you're comment got deleted in first place and it come just after she come online.
By failing to prepare, you are preparing to fail.
  • #2,449
  • Oct 26, 2016 2:01pm Oct 26, 2016 2:01pm
Quoting JibalaPasan
{quote} Your analysis are very good also the results. Our system you've copied perfectly. Yet another hint to reduce false signals. See how the values of AUDUSD look like: AUDUSD, Order Details: Main Trend DOWN, BR: 0.05 (+/- 0.69), RS: -6.38 (+/- 6.62), BS: -4.25 (+/- 1.54), BS GAP: 0.18 (+/- 0.45), APS: -2.72, AMS: 3.32, BSR: 50.00% / 50.00% (65.06%), Bs&Bs: 0.33 / 0.00 (+/- 0.74), AUDUSD -1.99 / 2.26 Would you buy AUDUSD? Not really, right? Because the values are speaking against a buy order. How many times I was talking about the power of correlation...
You're time is again wrong I don't have a problem with it but if you want to fix it...

This is what it help me, if you google nettime , the first result would be Network Time Synchronization tool , I just set-up it with 4 different time pools to automatic update time every 1 hour, since then my time is working perfect.

The difference from Time.is was -0.039 seconds (±0.013 seconds).
By failing to prepare, you are preparing to fail.
  • #2,450
  • Oct 29, 2016 2:04pm Oct 29, 2016 2:04pm
Quoting Catalin68
{quote} And yet it can be done and auto, with the excel sheet and dash EAX, without a software special ... {image}
Hi bro,
Could you please share or advise us on this set up. Thank you
  • #2,451
  • Edited 3:20pm Nov 3, 2016 1:48pm | Edited 3:20pm
Quoting Chrous
{quote} Hi bro, Could you please share or advise us on this set up. Thank you
I hope I have helped you (it is true, a little late!)
Attached File(s)
File Type: rar EAX-Xard.rar   99 KB | 985 downloads

Attached Image (click to enlarge)
Click to Enlarge Name: Fără titlu.png Size: 159 KB
The road to success is always under construction !
  • #2,452
  • Nov 6, 2016 1:46pm Nov 6, 2016 1:46pm
This is an example of the correlation filter that JibalaPasan describe. Of course the filter was just provided and is still testing it, the number of trades is very little so far. I will post at the end of the month the final result .
Attached Image
By failing to prepare, you are preparing to fail.
  • #2,453
  • Nov 6, 2016 3:05pm Nov 6, 2016 3:05pm
Quoting Catalin68
{quote} I hope I have helped you (it is true, a little late!) {file} {image}
Thank you Catalin68, will try, I was late in thanking you too....
  • #2,454
  • Nov 7, 2016 2:18pm Nov 7, 2016 2:18pm
Hey Catalin

many thanks for the upload.... can you confirm this can be run full auto with no manual intervention?

thanks, blam

Quoting Catalin68
{quote} I hope I have helped you (it is true, a little late!) {file} {image}
  • #2,455
  • Nov 8, 2016 7:26am Nov 8, 2016 7:26am
Quoting blamshakk
Hey Catalin many thanks for the upload.... can you confirm this can be run full auto with no manual intervention? thanks, blam {quote}
The EAX setting you lock a basket (you can modify it as you want, or apply another method of closing) ... you do not need manual intervention.
The road to success is always under construction !
  • #2,456
  • Nov 8, 2016 9:25am Nov 8, 2016 9:25am
A Trump win could offer nice trading opportunities. Good luck to candidates and green pips to all
Attached Image
By failing to prepare, you are preparing to fail.
  • #2,457
  • Nov 8, 2016 12:42pm Nov 8, 2016 12:42pm
Quoting project13et
A Trump win could offer nice trading opportunities. Good luck to candidates and green pips to all {image}
Nice panel ... what information incorporates?!
The road to success is always under construction !
  • #2,458
  • Nov 9, 2016 6:22pm Nov 9, 2016 6:22pm
Quoting jarfx05
Hi all, i tested today set file for PM3 . only manually. The signals must be compatible with Excel . If you would like Always test and write what can be improved . Regards {file} {image}
Hi,

How to open it?

Thanks
  • #2,459
  • Nov 10, 2016 3:19am Nov 10, 2016 3:19am
Quoting Catalin68
{quote} Nice panel ... what information incorporates?!

Same information that JibalaPasan offer in her Speedometer, Average Market strength, Bulls & Bears and some market bias. And of course economic calendar, of upcoming and pasted events.
By failing to prepare, you are preparing to fail.
  • #2,460
  • Nov 11, 2016 1:24am Nov 11, 2016 1:24am
Quoting project13et
{quote} Same information that JibalaPasan offer in her Speedometer, Average Market strength, Bulls & Bears and some market bias. And of course economic calendar, of upcoming and pasted events.
Thank you man !
The road to success is always under construction !
10 traders viewing now