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

  • #3,361
  • Mar 11, 2017 8:02pm Mar 11, 2017 8:02pm
Quoting VictorFaria
After Few Months Reading, Reading, Reading i developed my own system based on this one..the results Below, let's see for long term. Thanks @Jibalapasan for all your efforts posting your results and keeping the thread alive. {image}
Sorry to ask but you are not affiliated with Ghostbiker are you? I ask because your comment sounds like an invite for PMs for more information and selling. Why else would you post just your winrate? He made the same claim of 90% winrate.. So what happens next? There are other more important stats than Winrate when it comes to trading.. How about a MyFXbook validated report of your live trades?
If it backtests good run it live!
  • #3,362
  • Mar 12, 2017 4:23am Mar 12, 2017 4:23am
Quoting VictorFaria
After Few Months Reading, Reading, Reading i developed my own system based on this one..the results Below, let's see for long term. Thanks @Jibalapasan for all your efforts posting your results and keeping the thread alive. {image}
VictorFaria, would you please explain the most important parts in developing your system, which lead you to results like Jibala/Nasap? What were your key moments to find out how you can avoid enough fake outs (at tops and bottoms) to achive over 90% hit rate. And which momentum measurement, which is still an open question in this thread, lead you to success.

Many thanks in advance for all those how still struggling, like myself.
  • #3,363
  • Mar 12, 2017 4:45am Mar 12, 2017 4:45am
Quoting Telestes
{quote} VictorFaria, would you please explain the most important parts in developing your system, which lead you to results like Jibala/Nasap? What were your key moments to find out how you can avoid enough fake outs (at tops and bottoms) to achive over 90% hit rate. And which momentum measurement, which is still an open question in this thread, lead you to success. Many thanks in advance for all those how still struggling, like myself.
Did I describe anything other in my postings from above? On the right side you clearly see the "accelerator" don't you?

Quote
What is 'Momentum'
Momentum is the rate of acceleration of a security's price or volume. In technical analysis, momentum is considered an oscillator and is used to help identify trend lines. In general, momentum refers to the force or speed of movement; it is usually defined as a rate. In the world of investments, momentum refers to the rate...

Read more: Momentum Definition | Investopedia http://www.investopedia.com/terms/m/...#ixzz4b6QgWXWS

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,364
  • Mar 12, 2017 5:45am Mar 12, 2017 5:45am
@fxspeedster
Sorry if my post finds you on wrong way... my objective is to prove that with a lot of Hard work, day/nights months studying, reading you can get there.. so a little advise, stop to think like this, you will not earn and learn nothing... you will only attract negative things, with your excuse, please read 10x times every single post in this Thread and i assure you that you will find the way..

@telestes
Please read all thread first.. you will find the way, the definition is more simple that you think

With all respect,
Victor Faria
  • #3,365
  • Mar 12, 2017 6:39am Mar 12, 2017 6:39am
Quoting JibalaPasan
{quote} I'll try to explain from our point of view. If CS is described as momentum then we still could see a rally of the EUR because it's still on the top of all other currencies. Maybe it's still a valid argument if someone takes long-term investments. But what about us? How to determine momentum that it can be used as an advantage in our trading decision? A picture is worth a thousand words, as always: See the CSM of GVC (many thanks for your great art of work) with EUR on the top while USD is at the bottom. {image} But is it for real what we...

Thanks, your post is clear to me, I just don't have anything to add. Only continues working to find that secret formula, since I found many secret formulas until now I am confident that maybe I could find this one too, the only way to find out is working on it continues
By failing to prepare, you are preparing to fail.
  • #3,366
  • Mar 12, 2017 7:09am Mar 12, 2017 7:09am
Quoting project13et
{quote} Thanks, your post is clear to me, I just don't have anything to add. Only continues working to find that secret formula, since I found many secret formulas until now I am confident that maybe I could find this one too, the only way to find out is working on it continues
That's good to hear but maybe I also have to explain further.

If you have a look on our accelerator you can see EUR still the strongest currency against all others. That's only because the screen is static. In reality everything, gain or loss, mixed with the algorithm will finally end up in the decision of a buy/sell signal. EUR is falling while USD is rising for many minutes already what you can see on the M5 chart. And once again, I've explained the deviation indicator already, the deviation is not meant to show what we see on CSM already, otherwise there's no need for it. Like the arrows from GVC's CSM we like to see what direction it possibly will move. And we want to see it on time, not when the momentum has gone already again!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,367
  • Mar 12, 2017 11:25am Mar 12, 2017 11:25am
Quoting Forexpinbar
{quote} Great job PayItForward..The pdf makes a lot of sense..It would be great if we can get a pop up alert from the strength indicator u posted if criteria is met..
if you meet it, please let's me know.
thx.
  • #3,368
  • Mar 12, 2017 1:45pm Mar 12, 2017 1:45pm
Quoting JibalaPasan
{quote} That's good to hear but maybe I also have to explain further. If you have a look on our accelerator you can see EUR still the strongest currency against all others. That's only because the screen is static. In reality everything, gain or loss, mixed with the algorithm will finally end up in the decision of a buy/sell signal. EUR is falling while USD is rising for many minutes already what you can see on the M5 chart. And once again, I've explained the deviation indicator already, the deviation is not meant to show what we see on CSM already,...
A stupid question, can Ron share how to make this gray square inside arrows for Fib/Piv/Direct ?
Thanks,
Attached Image
By failing to prepare, you are preparing to fail.
  • #3,369
  • Mar 12, 2017 11:11pm Mar 12, 2017 11:11pm
Quoting dariuske
Here is the latest excel. The previous version still had a calculation error in it for JPY. It treated JPY as main currency but JPY is always secondary currency so changed JPY calculation. Plus added Market Strength as explained by Jibala! Edit: the signal of JPY is still wrong it has -5 now and says buy so seems I overlooked something. Will have a look later. Edit2: this post now contains the correct file - adjusted the signal which was reversed by dtlase instead of changing the calculations so now everything is as it should be! please re-download...
i have problem in excel not responding. so how to solve this.?
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 240 KB
  • #3,370
  • Mar 13, 2017 12:17am Mar 13, 2017 12: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...
In excel where change this path pls. help me
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 225 KB
  • #3,371
  • Mar 13, 2017 1:57am Mar 13, 2017 1:57am
Quoting JibalaPasan
{quote} Prior to the debugging mode there is a dialogue box displayed on the screen. What does it show? Jibala
Hi Jibala, this is what it shows?
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 45 KB
  • #3,372
  • Mar 13, 2017 4:59am Mar 13, 2017 4:59am
Quoting skpat
{quote} In excel where change this path pls. help me{image}
That is not the latest version, go here.
Download and put in your Files folder of MT4, create a shortcut and copy that to your desktop for later use.
Then open the workbook using the shortcut, open the "getValues" sheet, look at the top of the page for a path similar to:
C:\Users\xxxxxxx\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9
Replace that path with your MT4 terminal path.
There is some missing data in the some of the cells of this workbook but don't worry about it, this will get you started.
Save your workbook.
Make sure you have DDE ticked in your MT4 > Tools > Options to allow for the data stream.
Then re-open the workbook and allow the Update.
The workbook should then allow the data.
When you are successful perhaps give a thought to others ... Kiva dot org
  • #3,373
  • Mar 13, 2017 6:41am Mar 13, 2017 6:41am
-1 LO open ower -300 pips GBP and CHF

don't make same mistake like me,to open bevor LO
Attached Image (click to enlarge)
Click to Enlarge Name: fg345.png Size: 135 KB
  • #3,374
  • Mar 13, 2017 6:45am Mar 13, 2017 6:45am
Quoting Forexpinbar
EUR group buy signal and 22 minutes later collected 234pips..God bless Excel dashboard trading. {image} {image} {image}
hey Forexpinbar, let me first congratulate you on your journey within this thread, you seem to be accomplishing amazing results with Excel gap trading.
I'm new to this thread, only started reading through last week and while i still have quite a few pages to go I really like the simplicity of your approach and the possibility of staying in the market for longer rather than scalping (can be very effective as we see here in the thread but takes a lot more time to master as well). Your strategy seem to be a great starting point for new comers in the thread before they can master the scalping if they so wish. That said, i have a few questions that i hope you can help me with.

1- you mentioned that you were testing 2 approaches... Buy/Sell signal in combination with CS Meter and Modoki AND later you started testing a different approach using only the excel (Buy/Sell signal + gap confirmation and non-repainting for 1 hr).
Have you replaced the first approach with the second or you still use/test both? how do they compare in your experience?

2- when talking about SL and TP you said you had not determined the best ones yet and usually left your basket running till NY Close? Is that still your approach or you use some type of basket % SL TP? and if you still let it running, how often do you get caught by midsession reversals on a basket?

i am not looking to be spoon fed in anyway, i do believe in the grinding and a lot of testing. You have given more tips then one can hope for to be honest, the above would just help me focus on the right starting point for my tests and i would be happy to report back on my results so we can all discuss and improve our trading.
thanks in advance
  • #3,375
  • Mar 13, 2017 6:54am Mar 13, 2017 6:54am
Quoting papamax
{quote} hey Forexpinbar, let me first congratulate you on your journey within this thread, you seem to be accomplishing amazing results with Excel gap trading. I'm new to this thread, only started reading through last week and while i still have quite a few pages to go I really like the simplicity of your approach and the possibility of staying in the market for longer rather than scalping (can be very effective as we see here in the thread but takes a lot more time to master as well). Your strategy seem to be a great starting point for new comers...
Welcome on board papamax..Yes I replaced the first approach with the gap indicator strategy..Why?Because I have been getting false signals in the past couple of weeks..So its on hold for now..Currently trying to figure out how to avoid those false signals.As far as the new approach is concerned , I am currently testing BASKET SL=100PIPS and BASKET TP=200PIPS and BASKET SL=200PIPS and BASKET TP=200PIPS...Wish you green pips.
Goal of a successful trader is to make the best trades. Money is secondary
  • #3,376
  • Mar 13, 2017 8:24am Mar 13, 2017 8:24am
Quoting eurjpower
-1 LO open ower -300 pips GBP and CHF don't make same mistake like me,to open bevor LO {image}
Did you enter too early or you were late? Reason I am asking is because I see GBP and CHF rallied a bit...
Thanks
  • #3,377
  • Mar 13, 2017 9:05am Mar 13, 2017 9:05am
Quoting Fatso
{quote} Did you enter too early or you were late? Reason I am asking is because I see GBP and CHF rallied a bit... Thanks

Too early ,after LO open the direction changet to 100%
  • #3,378
  • Mar 13, 2017 9:08am Mar 13, 2017 9:08am
Quoting eurjpower
{quote} Too early ,after LO open the direction changet to 100%
You should look at momentum, and what sister JibalaPasan describe.
By failing to prepare, you are preparing to fail.
  • #3,379
  • Mar 13, 2017 11:54am Mar 13, 2017 11:54am
Quoting JibalaPasan
{quote} No problem, I can show some if that will make your day! {image} {image} {image} {image} {image} {image} {image} {image} {image} {image} To be continued on next post...
JiblaPasan, Can you share indicators on your chart. I'm interested.

Thank you.
  • #3,380
  • Mar 13, 2017 1:25pm Mar 13, 2017 1:25pm
Quoting project13et
{quote} A stupid question, can Ron share how to make this gray square inside arrows for Fib/Piv/Direct ? Thanks, {image}
Brother, there are no stupid questions but answers (maybe a bit boring sometimes)! What you see is the effect of formatting, because of the silver shadow in the middle, nothing special.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.13_19h24m16s_017_Zellen formatieren.png Size: 29 KB


Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
1 trader viewing now