Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 603 replies

MT4 Trading without GAP and without Excel 669 replies

Trading using Excel and MT4? 28 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Gap Up and Gap Down terminology 8 replies

Attachments: MT4 Trading the GAP With Excel
Exit Attachments

MT4 Trading the GAP With Excel

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
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...
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)
Quoting FerruFx
{quote} Transition
You're right. The whole sentence is Copy Paste from MT4 help menu.
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.
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
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
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?
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
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.
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.
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
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,064 downloads
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)
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!
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.
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!
Hi Jibala
Hi PipFlak
Anybody does not want. Answer the questions give me . post 89
Thanks
Hi,
One file from xard777, http://www.forexfactory.com/showthre...76#post8493776
Regards
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!!
1 trader viewing now