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

  • #81
  • Oct 10, 2015 2:50am Oct 10, 2015 2:50am
Quoting dariuske
{quote} Do you think I made this comment for you on the dashboard thread just for fun? {quote}
I changed it and had after same problems, then i did all back on windows. It was not the setting on windows.
Table was working when I changed language setting on OO but not the hook on comma/point.
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #82
  • Oct 10, 2015 4:47am Oct 10, 2015 4:47am
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)
Another alternative is LibreOffice http://www.libreoffice.org/ depending upon which comparison review you trust...
  • #83
  • Oct 10, 2015 5:25am Oct 10, 2015 5:25am
Quoting PipFlak
One topic that needs discussion as we move on down the road is trade management. What is the best strategy to use for the GAP. Is it better to only go for 8 pips while risking 35 pips or to go for say 15-20 pips using a BE and trail or maybe 30 pips pulling partial profits off as you go. What are your thoughts and how can they be implemented ? Lots of smart and talented people here thanks for the input so far! Here is an interesting video sent to me by Vladimir Ribakov showing his interpretation of what a professional trader's performance graphs...
About the TP strategy you should know that a GAP calculated on a short time frame can be a turning point but mostly it will be a short correction only. The higher you set your TP the more risk you take. This is a pure scalper strategy, hence only "fifo" (fast in fast out) counts. If you want more or looking for long term strategy you should also change the update interval for the GAP calculation to eg. H4.

You also can use a trade manager with a min. TP of eg. 10 Pip and then trail it. On a strong reversal your profit will increase. Just find out what fits you the best!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #84
  • Oct 10, 2015 5:59am Oct 10, 2015 5:59am
Quoting FerruFx
{quote} Transition
You're right. The whole sentence is Copy Paste from MT4 help menu.
  • #85
  • Oct 10, 2015 8:46am Oct 10, 2015 8:46am
Quoting JibalaPasan
{quote} About the TP strategy you should know that a GAP calculated on a short time frame can be a turning point but mostly it will be a short correction only. The higher you set your TP the more risk you take. This is a pure scalper strategy, hence only "fifo" (fast in fast out) counts. If you want more or looking for long term strategy you should also change the update interval for the GAP calculation to eg. H4. You also can use a trade manager with a min. TP of eg. 10 Pip and then trail it. On a strong reversal your profit will increase. Just...
Thanks Jibala I am sure this will help a lot of traders on this thread.
  • #86
  • Oct 10, 2015 9:10am Oct 10, 2015 9:10am
Quoting draugas2
{quote} Post 61 {image}
Thx alot for the detailed explaination. It helped alot. There are unfortunately still some problems.

look at the attached ss

I know that Bernhard showed a solution for the problem at the first ss but I have no Open Office.

The problems with this missing values (=Wert in german) are maybe based on the fact that the data feed is offline?
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 1.png Size: 114 KB
Click to Enlarge Name: 2.png Size: 119 KB
Click to Enlarge Name: 3.png Size: 63 KB
Click to Enlarge Name: 4.png Size: 47 KB
  • #87
  • Oct 10, 2015 10:22am Oct 10, 2015 10:22am
Quoting Sanyo
{quote} Thx alot for the detailed explaination. It helped alot. There are unfortunately still some problems. look at the attached ss I know that Bernhard showed a solution for the problem at the first ss but I have no Open Office. The problems with this missing values (=Wert in german) are maybe based on the fact that the data feed is offline? {image} {image} {image} {image}
Check the DDE server
Attached Image (click to enlarge)
Click to Enlarge Name: 106_.png Size: 44 KB
  • #88
  • Oct 10, 2015 10:46am Oct 10, 2015 10:46am
Quoting draugas2
{quote} Check the DDE server {image}
Thx again for the answer but I have checked it before. I have 5 MT4s for different reason but how does the file know which one to rely on?
  • #89
  • Oct 10, 2015 10:56am Oct 10, 2015 10:56am
Can somebody explain about this system. We have several Excel sheet . Where is the final output. Everyone should have his own conclusions. Or there is the final output. thanks
  • #90
  • Oct 10, 2015 12:18pm Oct 10, 2015 12:18pm
Quoting Sanyo
{quote} Thx alot for the detailed explaination. It helped alot. There are unfortunately still some problems. look at the attached ss I know that Bernhard showed a solution for the problem at the first ss but I have no Open Office. The problems with this missing values (=Wert in german) are maybe based on the fact that the data feed is offline? {image} {image} {image} {image}
You are either missing some pairs or your broker has a prefix or suffix. I use forex.com as my broker and I need to add "pro" at the end of each formula in order for the excel worksheet to work properly. having adjusted each cell formula the worksheet works without any problems.
  • #91
  • Oct 10, 2015 1:59pm Oct 10, 2015 1:59pm
Quoting dariuske
{quote}

Dariuske and dtlase

I am going to go back through all the Maria/Jibala GAP posts and see if there are clues as to what Jibala is using for flexi filters. There might be some made from Udine's rules stated on an earlier post on this thread. One filter needed for sure is the last two bars. http://www.forexfactory.com/showthre...70#post8533870
I know this is a pain in the butt but if it makes us all rich some day I would say it's worth it. At least it's a learning experience.
  • #92
  • Oct 10, 2015 2:15pm Oct 10, 2015 2:15pm
Hy
Maybe this will help with missing currency name
For displaying all currencies activate currencies in Market Watch. View / Market Watch / (Right mouse click) Show all.

Attached Image (click to enlarge)
Click to Enlarge Name: Market Watch.jpg Size: 371 KB
  • #93
  • Oct 10, 2015 4:19pm Oct 10, 2015 4:19pm
Quoting PipFlak
{quote} Dariuske and dtlase I am going to go back through all the Maria/Jibala GAP posts and see if there are clues as to what Jibala is using for flexi filters. There might be some made from Udine's rules stated on an earlier post on this thread. One filter needed for sure is the last two bars. http://www.forexfactory.com/showthre...70#post8533870 I know this is a pain in the butt but if it makes us all rich some day I would say it's worth it. At least it's a learning experience.
Here is the most pertinent Maria Posts that I could find.
Attached File(s)
File Type: docx Maria Posts.docx   12 KB | 1,295 downloads
  • #94
  • Oct 10, 2015 10:31pm Oct 10, 2015 10:31pm
Quoting PipFlak
{quote} Dariuske and dtlase I am going to go back through all the Maria/Jibala GAP posts and see if there are clues as to what Jibala is using for flexi filters. There might be some made from Udine's rules stated on an earlier post on this thread. One filter needed for sure is the last two bars. http://www.forexfactory.com/showthre...70#post8533870 I know this is a pain in the butt but if it makes us all rich some day I would say it's worth it. At least it's a learning experience.
You have to divide in what you are going to trade! With the trend = use LBAR as additional confirmation (do not trade up/down/up/down formations!) If you wanna trade the GAP = use LBAR confirmation in opposite direction.

Furthermore you should use LBAR as a "strength filter". If LBAR is stronger / longer than a certain level, do not enter trade, it might reverse again.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #95
  • Oct 11, 2015 3:42am Oct 11, 2015 3:42am
Quoting JibalaPasan
{quote} You have to divide in what you are going to trade! With the trend = use LBAR as additional confirmation (do not trade up/down/up/down formations!) If you wanna trade the GAP = use LBAR confirmation in opposite direction. Furthermore you should use LBAR as a "strength filter". If LBAR is stronger / longer than a certain level, do not enter trade, it might reverse again.
Thanks Jibala!
  • #96
  • Oct 11, 2015 4:18am Oct 11, 2015 4:18am
I am going to start putting together a Trend/GAP set of rules and throw it out to the members of this thread for discussion and correction. While that is being done I am going to start digging through all the Nasap posts and arrange them in categorical order to use as a sort of reference manual. Nasap and Udine are the masterminds. If we can blend the oo level and Maria GAP together I believe it will be unbeatable. I am not that familiar with the 00 level thread so that may take me some time.
  • #97
  • Oct 11, 2015 10:02am Oct 11, 2015 10:02am
Quoting PipFlak
{quote} Dariuske and dtlase I am going to go back through all the Maria/Jibala GAP posts and see if there are clues as to what Jibala is using for flexi filters. There might be some made from Udine's rules stated on an earlier post on this thread. One filter needed for sure is the last two bars. http://www.forexfactory.com/showthre...70#post8533870 I know this is a pain in the butt but if it makes us all rich some day I would say it's worth it. At least it's a learning experience.
No pain, no gain!
  • #98
  • Oct 11, 2015 10:15am Oct 11, 2015 10:15am
Hi Jibala
Hi PipFlak
Anybody does not want. Answer the questions give me . post 89
Thanks
  • #99
  • Oct 11, 2015 11:11am Oct 11, 2015 11:11am
Hi,
One file from xard777, http://www.forexfactory.com/showthre...76#post8493776
Regards
  • #100
  • Oct 11, 2015 12:51pm Oct 11, 2015 12:51pm
Hello,
I would be very happy to get some help, I managed to get my excel file to be updated and it is working well but I can’t get it to show on the software. Where should I paste the formulas? what am I doing wrong? what file should I open? Because when I am pasting the formula, I see the text but not the tables as it should.
Thanks for your help!!
3 traders viewing now