MT4 Trading the GAP With Excel | Page 70 | 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,381
  • Mar 31, 2016 1:39am Mar 31, 2016 1:39am
Quoting draugas2
{quote} Read carefully the theme!!! Post 32 Post 71 Post 61 Post 10,918
Many thanks my friend
  • #1,382
  • Mar 31, 2016 1:32pm Mar 31, 2016 1:32pm
Since @JibalaPasan is not so present this days, I will posting few trades from one of my signal of today. This is a similar to what @nasap had in the begin of time

For some this could be very primitive and simple , but it's also very efficient. For peoples that are arguing about this trading style should read more JibalaPasan and Nasap posts, like I said many times is one of the hardest thread because you don't just take an indicator and put it on a chart and give a sell or buy based on it.

Imagine how many formula's are in the back of the excel, how many data imported and how many ways to calculate that data There are a lot of approaches for 1 trading style, and they have more then 1 with different settings

Everything work automatic , the chart indicators are just representative.

And if anyone look at the begin of the thread I was one of the biggest objector to there trading style, but you know why? Because I didn't do my homework's in the begin

Project Leet.
Attached Images
By failing to prepare, you are preparing to fail.
  • #1,383
  • Apr 1, 2016 11:22am Apr 1, 2016 11:22am
Quoting project13et
Imagine how many formula's are in the back of the excel, how many data imported and how many ways to calculate that data There are a lot of approaches for 1 trading style, and they have more then 1 with different settings Everything work automatic ,
If you can be so kind, you seem to be doing more than imagine the many formulas. can you enumerate which ones you used in the examples and why. We have many talented coders here who are striving to "make everything work automatic" It is very difficult to code "imagine"

Thank you,
dlouw
  • #1,384
  • Apr 2, 2016 7:02am Apr 2, 2016 7:02am
Quoting project13et
Since @JibalaPasan is not so present this days,
Excellent trading, Project. Not worse than Jibala's one.
Can you explain why ADR=199.6, Today=94.2 is the same on all your charts? Doesn't it depend on currency pair choice?
BR, alex
  • #1,385
  • Apr 2, 2016 10:13am Apr 2, 2016 10:13am
Quoting sevan62
{quote} Excellent trading, Project. Not worse than Jibala's one. Can you explain why ADR=199.6, Today=94.2 is the same on all your charts? Doesn't it depend on currency pair choice?
The chart's are just to illustrate the trading style. The ADR somehow was not proper attached and that's why the value remain fix. I check for ADR inside excel , individual in every single trade.


Quoting dlouw
{quote} If you can be so kind, you seem to be doing more than imagine the many formulas. can you enumerate which ones you used in the examples and why. We have many talented coders here who are striving to "make everything work automatic" It is very difficult to code "imagine" Thank you, dlouw
Everything I use is public and have been posted by @JibalaPasan or @nasap, when I am trying to trade there trading style I "forget" everything I know about forex or read in other parts, and I focus to replicate exact what they did and understand there system. So thins that I got access everyone has access, I didn't get any privilege. I already said the big amount of time has been spend , and my to do list don't looks like will be end soon.

I wish good look to all the talented coders.
By failing to prepare, you are preparing to fail.
  • #1,386
  • Apr 2, 2016 1:26pm Apr 2, 2016 1:26pm
Quoting project13et
{quote} The chart's are just to illustrate the trading style. The ADR somehow was not proper attached and that's why the value remain fix. I check for ADR inside excel , individual in every single trade. {quote} Everything I use is public and have been posted by @JibalaPasan or @nasap, when I am trying to trade there trading style I "forget" everything I know about forex or read in other parts, and I focus to replicate exact what they did and understand there system. So thins that I got access everyone has access, I didn't get any privilege. I already...

Thank you Project13et for sharing your trades, can you explain more about your TP and SL, are you using a trade manager and which one is working better with this method?
are you using 5 TP and 35 SL or something else?

Best regards
  • #1,387
  • Apr 2, 2016 2:25pm Apr 2, 2016 2:25pm
Quoting htawfik
{quote} Thank you Project13et for sharing your trades, can you explain more about your TP and SL, are you using a trade manager and which one is working better with this method? are you using 5 TP and 35 SL or something else? Best regards
I am using trailing stop, staring around 5 pips with a very tight steep , less then 1 pip , not all brokers will allow that , SL is very dynamic based on market behavior , including a automatic market level's detect that can turn over direction. The SL will always respect the account balance and even if get higher, the lots get automatic adjusted so the risk remain constant.

I constant study all my trades from, all I could reach in the next X minutes after trade was close and maxim drop down's of winning trades , in the feature I will probably go to a dynamic TP since @JibalaPasan also use a TP this days.

Project Leet
By failing to prepare, you are preparing to fail.
  • #1,388
  • Apr 3, 2016 2:19pm Apr 3, 2016 2:19pm
Quoting project13et
{quote} I am using trailing stop, staring around 5 pips with a very tight steep , less then 1 pip , not all brokers will allow that , SL is very dynamic based on market behavior , including a automatic market level's detect that can turn over direction. The SL will always respect the account balance and even if get higher, the lots get automatic adjusted so the risk remain constant. I constant study all my trades from, all I could reach in the next X minutes after trade was close and maxim drop down's of winning trades , in the feature I will probably...
Thanks a lot
  • #1,389
  • Apr 5, 2016 10:58pm Apr 5, 2016 10:58pm
Quoting project13et
{quote} The chart's are just to illustrate the trading style. The ADR somehow was not proper attached and that's why the value remain fix. I check for ADR inside excel , individual in every single trade. {quote} Everything I use is public and have been posted by @JibalaPasan or @nasap, when I am trying to trade there trading style I "forget" everything I know about forex or read in other parts, and I focus to replicate exact what they did and understand there system. So thins that I got access everyone has access, I didn't get any privilege. I already...
This thread was established to "discuss the tools" There has been a of of information from JibalaPasan and Nasap given in this and other threads. Some of it relevant, some not. Some gets lost in translation. We are all striving to accumulate and digest this information into a usable format in excel. Many have shared their thoughts and coding efforts. Myself included. It appears you are showing that you understand some aspects of trading the gap with excel that many have missed. If you have understood this information in a way that enables you to use excel more effectively by information and formulas freely offered in this thread why would you not want to share this as others have with you?

Respectfuly,
dlouw
  • #1,390
  • Apr 6, 2016 2:47am Apr 6, 2016 2:47am
Quoting dlouw
{quote} This thread was established to "discuss the tools" There has been a of of information from JibalaPasan and Nasap given in this and other threads. Some of it relevant, some not. Some gets lost in translation. We are all striving to accumulate and digest this information into a usable format in excel. Many have shared their thoughts and coding efforts. Myself included. It appears you are showing that you understand some aspects of trading the gap with excel that many have missed. If you have understood this information in a way that enables...

All the information I use are public , anyone has access to it. Information is not the same with tools . I am sure anyone can understand this trading style if the proper amount of time is invested. I suggest multiple times here to many "talented coders" that they miss important puzzle parts, like CTB correlation .... just a remainder this start long time ago even before 00 Level thread , is could be a good start .....
By failing to prepare, you are preparing to fail.
  • #1,391
  • Apr 6, 2016 3:11am Apr 6, 2016 3:11am
Quoting project13et
{quote} All the information I use are public , anyone has access to it. Information is not the same with tools . I am sure anyone can understand this trading style if the proper amount of time is invested. I suggest multiple times here to many "talented coders" that they miss important puzzle parts, like CTB correlation .... just a remainder this start long time ago even before 00 Level thread , is could be a good start .....

Hello project13et

I've sent you a PM,some days ago,don't know if u have noticed.

I've been studying this thread and all Jibala\Udine\Nasap posts and there are a lot of goods tips shared in their posts

I'm working and testing my own variation of Excel ,starting from some Files generously shared in this thread.
I've been studying and reviewing my own settings since 3 months.

Currently I'm updating my Excel each 30 minutes,and trading the Gap accordingly.
And I'm working on a Market Volatility filter,to avoid ranging trades

I'm still missing some pieces of the puzzle:

what is your update interval?
Have you included Pivots and Fibos into your Excel?
Do you trade directly from Excel?

btw
cngrts for your job

I KNOW it is not an easy task to build this trading system
DO UT DES
  • #1,392
  • Apr 6, 2016 3:31am Apr 6, 2016 3:31am
Quoting the bourne
{quote} Hello project13et I've sent you a PM,some days ago,don't know if u have noticed. I've been studying this thread and all Jibala\Udine\Nasap posts and there are a lot of goods tips shared in their posts I'm working and testing my own variation of Excel ,starting from some Files generously shared in this thread. I've been studying and reviewing my own settings since 3 months. Currently I'm updating my Excel each 30 minutes,and trading the Gap accordingly. And I'm working on a Market Volatility filter,to avoid ranging trades I'm still missing...

All my trades are automatic launched, I don't use any update interval or VBA timer , everything is processed tick by tick, if a pair get 10 ticks in 1 seconds, I get all 10 without any downgrade on speed or performance. This can be achieve with API or a custom build DDE(not mt4 one).

Copy/Paste values in excel with VBA timmer is not the best solution, do you know it remains in clipboard memory all the copy values ? Try to run excel for 1 week with lot of macro's to see what happen no meter how good is you're pc and how many resources it has.

You want to go to insert data instead of copy ... ok but what you do with the calling timers? If you keep calling them excel will always count as a unique one, how many timers you have after 1 week?

Of course this thinks could be also fixed in VBA but still not the most elegant solution.


Project leet
By failing to prepare, you are preparing to fail.
  • #1,393
  • Apr 6, 2016 5:22am Apr 6, 2016 5:22am
Quoting project13et
{quote} All my trades are automatic launched, I don't use any update interval or VBA timer , everything is processed tick by tick, if a pair get 10 ticks in 1 seconds, I get all 10 without any downgrade on speed or performance. This can be achieve with API or a custom build DDE(not mt4 one). Copy/Paste values in excel with VBA timmer is not the best solution, do you know it remains in clipboard memory all the copy values ? Try to run excel for 1 week with lot of macro's to see what happen no meter how good is you're pc and how many resources it...
Hi
thx for your reply and the hint about data import

what is your update interval?

the GAP need a reference point to be measured
so you are saying that your GAP is continously updated,sec by sec,tick by tick,ok.
But how many minutes in the past you watch for the reference Gap?
15 minutes? 30minutes? 8 minutes? There must be a starting point to obtain a difference calculation.


Have you included Pivots and Fibos into your Excel?
?

Do you trade directly from Excel?
I guess so,from your reply I can see you are an advanced excel user

thank you
DO UT DES
  • #1,394
  • Apr 6, 2016 12:06pm Apr 6, 2016 12:06pm
1 scenario , 2 pairs to TP.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: gbpjpy.png Size: 80 KB
Click to Enlarge Name: gbpusd.png Size: 73 KB
By failing to prepare, you are preparing to fail.
  • #1,395
  • Apr 6, 2016 3:19pm Apr 6, 2016 3:19pm
USD Strong,1 pair to TP,USDCAD Long;LO
Attached Image (click to enlarge)
Click to Enlarge Name: 256ecgj.gif Size: 53 KB
DO UT DES
  • #1,396
  • Apr 6, 2016 6:11pm Apr 6, 2016 6:11pm
Quoting project13et
{quote} All the information I use are public , anyone has access to it. Information is not the same with tools . I am sure anyone can understand this trading style if the proper amount of time is invested. I suggest multiple times here to many "talented coders" that they miss important puzzle parts, like CTB correlation .... just a remainder this start long time ago even before 00 Level thread , is could be a good start .....
Thank you, Custom API! Well done. Can I ask which you used? CBT correlation. You are referring to Chicago Board of Trade currency futures correct. I do not recall Jibala mentioning this before and I have read everything from 00 forward. Good to know. I too would to like to know what time frame you use to measure the momentum of the gap. My excel study has been to look at this based on the last 0 to 5 minutes, 5 to 15 and 15 to 1 hour. It is an interesting way to see momentum ebbing and flowing but I have not refined it to a consistent state. The last 5 seems to be the most relevant. Have an API trading interface would be a dream for testing and trading, the csv file method is full of delays and pitfalls. PM me if you can share relevant details.

Best Regards,
dlouw
  • #1,397
  • Apr 7, 2016 3:25am Apr 7, 2016 3:25am
Quoting dlouw
{quote} Thank you, Custom API! Well done. Can I ask which you used? CBT correlation. You are referring to Chicago Board of Trade currency futures correct. I do not recall Jibala mentioning this before and I have read everything from 00 forward. Good to know. I too would to like to know what time frame you use to measure the momentum of the gap. My excel study has been to look at this based on the last 0 to 5 minutes, 5 to 15 and 15 to 1 hour. It is an interesting way to see momentum ebbing and flowing but I have not refined it to a consistent state....
CTB not CBT, ex "STB"

Quoting project13et
{quote} I totally agree with what you say. But 15/30/60/240 for MTF GAP work well most of time .....

JibalaPasan answer

1. We've tested many of the smaller TF's but nothing seems to work. This combination works pretty well so far, maybe needs adjustment after some time. We're already thinking about a time-based self-adjustment but need more data to analyze.


Serious I expect peoples to focus more and pay attention to every details, This is one of the main reasons JibalaPasan is not answering to questions that have been answered already. All the information are public just do the homeworks.

I am not the one that is sharing information here, because I didn't build anything to share, I am just trying to do a similar system of JibalaPasan and nasap. I already said I try to "forget" everything I know about Forex and to focus just on there styles. This to be constructive, everyone need to look at there trading styles, not mine.
Attached Image (click to enlarge)
Click to Enlarge Name: CTB.png Size: 47 KB
By failing to prepare, you are preparing to fail.
  • #1,398
  • Apr 7, 2016 6:51am Apr 7, 2016 6:51am
Quoting project13et
{quote} CTB not CBT, ex "STB" Quoting project13et {quote} I totally agree with what you say. But 15/30/60/240 for MTF GAP work well most of time ..... JibalaPasan answer 1. We've tested many of the smaller TF's but nothing seems to work. This combination works pretty well so far, maybe needs adjustment after some time. We're already thinking about a time-based self-adjustment but need more data to analyze. Serious I expect peoples to focus more and pay attention to every...
my Excel data feeds still come from DDE Metatrader built-in program

one of my trades today
I still have to take my trades manually
I extract my signals from my own customized Excel-->check some price action indicators on Metatrader--> click the button

if I could only automatize this process...
Attached Image (click to enlarge)
Click to Enlarge Name: 108ctbd.gif Size: 56 KB
DO UT DES
  • #1,399
  • Apr 12, 2016 6:03am Apr 12, 2016 6:03am
One trading method , multiple trades. Of course thanks to @JibalaPasan and @nasap we have multiple trading styles and settings and that can be adjusted and choose based on market behavior.

Since I am far away to finish this , and still I need to learn from this girls, I hope they don't mind about my posts and they will keep posting , like I said multiple times I am here to learn from them.

Project Leet
Attached Image(s) (click to enlarge)
Click to Enlarge Name: AUDCHF.png Size: 65 KB
Click to Enlarge Name: AUDJPY.png Size: 73 KB
Click to Enlarge Name: CADJPY.png Size: 66 KB
Click to Enlarge Name: GBPJPY.png Size: 78 KB
Click to Enlarge Name: GBPUSD.png Size: 68 KB
Click to Enlarge Name: NZDJPY-1.png Size: 66 KB
By failing to prepare, you are preparing to fail.
  • #1,400
  • Apr 12, 2016 6:26am Apr 12, 2016 6:26am
Quoting project13et
One trading method , multiple trades. Of course thanks to @JibalaPasan and @nasap we have multiple trading styles and settings and that can be adjusted and choose based on market behavior. Since I am far away to finish this , and still I need to learn from this girls, I hope they don't mind about my posts and they will keep posting , like I said multiple times I am here to learn from them. Project Leet {image} {image} {image} {image} {image} {image}
Nice Leet,

First thing that comes to my mind seeing the trades (that JibalaPasan's dash would not take in automode) is a long trade after a bearish M30 candle and viceversa.
i suppose you are aware, but I thought I would mention it nevertheless.

All the best and green pips.

Luxing
Wisdom begins in wonder
6 traders viewing now