MT4 Trading the GAP With Excel | Page 115 | 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,281
  • Aug 16, 2016 1:34am Aug 16, 2016 1:34am
Quoting cinisciu
{quote} Ehmmm... I downloaded the two files that you told me, but I don't understand how to make them work. Could you tell me if there is a post where it explains what I should do with these files?
You're not the first asking this questions, all the answer could be found in this thread.
By failing to prepare, you are preparing to fail.
  • #2,282
  • Aug 16, 2016 3:07am Aug 16, 2016 3:07am
Quoting project13et
{quote} In the right Currency Strength, in the left Modoki heat map {file}
Thanks so much!

Olufemi
I am more afraid of 100 sheep led by a lion than 100 lions led by a sheep!
  • #2,283
  • Aug 16, 2016 3:13am Aug 16, 2016 3:13am
Quoting Opemipo
{quote} Derived from your posts and project13et are these:{image}{image} I m really learning from you guys. Thanks!
Approaching the heat map with basket sense, GBP(D-MN) has been weak since yesterday so I placed a sell trade.
Attached Image (click to enlarge)
Click to Enlarge Name: Basket.PNG Size: 22 KB

This result has been good so far.
Attached Image (click to enlarge)
Click to Enlarge Name: basket 2.PNG Size: 23 KB

Olufemi
I am more afraid of 100 sheep led by a lion than 100 lions led by a sheep!
  • #2,284
  • Aug 16, 2016 3:51am Aug 16, 2016 3:51am
Quoting project13et
{quote} You're not the first asking this questions, all the answer could be found in this thread.
Yes. You have certainly right. You have probably already answered this question so many times.

But for me it's hard to find the answers I'm looking for, in a forum where they speak a language I don't know, and in a thread with 115 pages.

But it's fine! As soon as I have free time, I try to go in search of this information.

Thanks anyway for your support!
  • #2,285
  • Aug 16, 2016 5:41am Aug 16, 2016 5:41am
Quoting Opemipo
{quote} Approaching the heat map with basket sense, GBP(D-MN) has been weak since yesterday so I placed a sell trade. {image} This result has been good so far.{image} Olufemi

Modoki is using a rolling period, from my experience that's much slower then the reset timer gap, that's the whole idea with 1hour reset timer for example. But you can use M5 Modoki for example like @JibalaPasan showed as a confirmation of the momentum.

By combining both of them... short term rolling and reset gap timer I think you can increase the quality of trades by entering with a lower drop down.
By failing to prepare, you are preparing to fail.
  • #2,286
  • Aug 16, 2016 7:05am Aug 16, 2016 7:05am
Where is the DWM.cvs file ?
In my folder named files don't exist this file.

somebody help me please
  • #2,287
  • Aug 16, 2016 7:52am Aug 16, 2016 7:52am
Quoting project13et
{quote} Modoki is using a rolling period, from my experience that's much slower then the reset timer gap, that's the whole idea with 1hour reset timer for example. But you can use M5 Modoki for example like @JibalaPasan showed as a confirmation of the momentum. By combining both of them... short term rolling and reset gap timer I think you can increase the quality of trades by entering with a lower drop down.
Thanks!

Olufemi
I am more afraid of 100 sheep led by a lion than 100 lions led by a sheep!
  • #2,288
  • Aug 16, 2016 7:55am Aug 16, 2016 7:55am
Quoting project13et
{quote} All of them used in Spaghetti trading ?
Currently only the spaghetti module is active hence, all formula is used for it.

Result from the night session:
Attached Image

Result until now:
Attached Image

Again one losing trade but pretty good result so far.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,289
  • Aug 16, 2016 7:59am Aug 16, 2016 7:59am
Quoting JibalaPasan
{quote} Currently only the spaghetti module is active hence, all formula is used for it. Result from the night session: {image} Result until now: {image} Again one losing trade but pretty good result so far.
Beside the great results we know you have , can charts or excel photos be showed ? Since is impossible to learn only from total orders showed in iHistory .
By failing to prepare, you are preparing to fail.
  • #2,290
  • Aug 16, 2016 9:03am Aug 16, 2016 9:03am
Quoting project13et
{quote} Beside the great results we know you have , can charts or excel photos be showed ? Since is impossible to learn only from total orders showed in iHistory .
I know brother project13et, but this is what I see at the moment, only the past. Once in a while I have a look for the system if still everything works fine. I only have to report the losing trades for the analyse and that's it.

Once we had a module included taking a screenshot from the excel sheet on order entry but it did not work properly and was a bit slow. That's why we are using the mail system. We have all data at hand for the analyse.

Brother, if for any case I'm at the desk when an order is executed I'll try to take a snapshot.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,291
  • Aug 16, 2016 9:09am Aug 16, 2016 9:09am
Quoting JibalaPasan
{quote} I know brother project13et, but this is what I see at the moment, only the past. Once in a while I have a look for the system if still everything works fine. I only have to report the losing trades for the analyse and that's it. Once we had a module included taking a screenshot from the excel sheet on order entry but it did not work properly and was a bit slow. That's why we are using the mail system. We have all data at hand for the analyse. Brother, if for any case I'm at the desk when an order is executed I'll try to take a snapshot.

Thank you so much, I had the same problem with the snapshot during trade execute, because the photo was taken before the trade was executed, and slow down the trade with less then 1 second, but still....

My solution to that is to build a buffer, similar to the one that save trade information and to take the snapshot photo when trading signal equal 0 (no trade to execute) and buffer equal 1 , for example. After the JPG is taken just clear the buffer.

Also you can include in the snapshot photo the name of each pair trade and time of the trade to be more easy to recognize.
Thanks,
By failing to prepare, you are preparing to fail.
  • #2,292
  • Aug 16, 2016 9:17am Aug 16, 2016 9:17am
Quoting dtlase
I have decided to make this excel open source due to request from friends and also for others to add their input. Also attached is the indicator that create and populate DWM.csv file. The indicator will constantly update the file based on the time frame you have placed it on. On the Speedometer excel I have delayed the update by 5 sec so that the import process should be without error. You need to set-up the path to DWM.csv. 1. C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9\MQL4\Files 2. C:\Users\xxxxxxx\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9\MQL4\Files\DWM.csv...
Hi dtlase !!
I followed your steps and create populate DWM.csv opening a chart with script TradeFromExcel2MT4 working and open too the Speedometer excel file but don't work correctly because don't show all value in all currency.
See screenshot
[attach]1996469

What is wrong now ?
Can i change something now ?
thank you
Attached Image (click to enlarge)
Click to Enlarge Name: Area.jpg Size: 177 KB
  • #2,293
  • Aug 16, 2016 12:09pm Aug 16, 2016 12:09pm
Quoting project13et
{quote} Thank you so much, I had the same problem with the snapshot during trade execute, because the photo was taken before the trade was executed, and slow down the trade with less then 1 second, but still.... My solution to that is to build a buffer, similar to the one that save trade information and to take the snapshot photo when trading signal equal 0 (no trade to execute) and buffer equal 1 , for example. After the JPG is taken just clear the buffer. Also you can include in the snapshot photo the name of each pair trade and time of the trade...
Here we go!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_16h12m41s_029_.png Size: 268 KB

GBPAUD, OP_BUY Order Details: Main Trend UP, BR: 0.92 (+/- 0.70), RS: 7.45 (+/- 6.67), BS: 4.86 (+/- 1.58), BS GAP: 0.46 (+/- 0.45), APS: 3.45, AMS: 3.17, BSR: 50.00% / 50.00% (65.63%), Bs&Bs: 0.17 / -0.17 (+/- 0.71), GBPAUD 2.38 / -2.48
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_16h19m48s_030_.png Size: 64 KB

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

Attached Image

Almost same result like yesterday.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,294
  • Aug 16, 2016 1:57pm Aug 16, 2016 1:57pm
Quoting JibalaPasan
{quote} If I'm not totally mistaken Nathalia is using at least 4 correlation modules.
You have repeatedly talked about correlation both on this thread and other threads...is the spaghetti also using tick strength based on a correlation table and nasap's special algorithm(respect to @ nasap)? If true do you ever reset the tick strength say at every 1 hour Bar End or just continuous calculation from DO every new trading day? You have also mentioned severally that WSD uses tick data via DDE...are the tick collected on every tick and processed within WSD based on selected trading tf say every 15 mins if trading the m15 GAP?
  • #2,295
  • Aug 16, 2016 3:46pm Aug 16, 2016 3:46pm
Quoting JibalaPasan
{quote} Here we go! {image} GBPAUD, OP_BUY Order Details: Main Trend UP, BR: 0.92 (+/- 0.70), RS: 7.45 (+/- 6.67), BS: 4.86 (+/- 1.58), BS GAP: 0.46 (+/- 0.45), APS: 3.45, AMS: 3.17, BSR: 50.00% / 50.00% (65.63%), Bs&Bs: 0.17 / -0.17 (+/- 0.71), GBPAUD 2.38 / -2.48 {image} {image} {image} Almost same result like yesterday.
Thank you, this kind of pictures helps a lot including the bonus data's from email.
By failing to prepare, you are preparing to fail.
  • #2,296
  • Aug 16, 2016 5:11pm Aug 16, 2016 5:11pm
I have a micro account. Can you tell me if these files also work with this type of account?
  • #2,297
  • Aug 16, 2016 6:33pm Aug 16, 2016 6:33pm
Hi

as I said before,I'm workin' hard for a better quality trading

Today trades
TOTAL TRADES 5
WINNING TRADES 5
HIT RATIO 100%

As I can see in this thread,not all the Traders are using the same style

@Jibala : about you and your Team,are you still running normal WSD trend trades beside Spaghetti trades???I'm just curious about that

personally,I still go with the Trend and planning to add STB trades to my automated system in the next weeks
CTT can wait
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 2vhu8w0.png Size: 50 KB
Click to Enlarge Name: 2cncspg.png Size: 54 KB
Click to Enlarge Name: 9u83v9.png Size: 61 KB
Click to Enlarge Name: 2d0bf4k.png Size: 60 KB
Click to Enlarge Name: t9a4qt.png Size: 63 KB
Click to Enlarge Name: 2mm6d5e.png Size: 62 KB
DO UT DES
  • #2,298
  • Aug 17, 2016 12:59am Aug 17, 2016 12:59am
Quoting the bourne
Hi as I said before,I'm workin' hard for a better quality trading Today trades TOTAL TRADES 5 WINNING TRADES 5 HIT RATIO 100% As I can see in this thread,not all the Traders are using the same style @Jibala : about you and your Team,are you still running normal WSD trend trades beside Spaghetti trades???I'm just curious about that personally,I still go with the Trend and planning to add STB trades to my automated system in the next weeks CTT can wait {image} {image} {image} {image} {image} {image}

STB was never an automatic trading signal.
By failing to prepare, you are preparing to fail.
  • #2,299
  • Aug 17, 2016 7:41am Aug 17, 2016 7:41am
Quoting BlacMoni
{quote} You have repeatedly talked about correlation both on this thread and other threads...is the spaghetti also using tick strength based on a correlation table and nasap's special algorithm(respect to @ nasap)? If true do you ever reset the tick strength say at every 1 hour Bar End or just continuous calculation from DO every new trading day? You have also mentioned severally that WSD uses tick data via DDE...are the tick collected on every tick and processed within WSD based on selected trading tf say every 15 mins if trading...
1. no
2. yes
3. we do not trade a M15 GAP but MTF GAP

I have mentioned many times and also explained about the 4 TF's and the correlation. It can't be used as a stand alone signal but as confirmation and a filter!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_23h20m16s_041_.png Size: 271 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_23h20m44s_042_.png Size: 48 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_23h29m08s_043_.png Size: 46 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.08.16_23h29m35s_044_.png Size: 288 KB

A small video of the MTF GAP.
Attached File(s)
File Type: zip mtf_correl.zip   1.1 MB | 1,138 downloads
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,300
  • Aug 17, 2016 7:45am Aug 17, 2016 7:45am
Quoting the bourne
Hi as I said before,I'm workin' hard for a better quality trading Today trades TOTAL TRADES 5 WINNING TRADES 5 HIT RATIO 100% As I can see in this thread,not all the Traders are using the same style @Jibala : about you and your Team,are you still running normal WSD trend trades beside Spaghetti trades???I'm just curious about that personally,I still go with the Trend and planning to add STB trades to my automated system in the next weeks CTT can wait {image} {image} {image} {image} {image} {image}
No, only the spaghetti module is activated. Your result is pretty good and needs to be continued.

It seems each day needs it's loser! Today's result so far:
Attached Image
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
1 trader viewing now