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

  • #161
  • Oct 14, 2015 4:15am Oct 14, 2015 4:15am
Quoting dariuske
{quote} This is trading with Excel right? So why put the Dash in here? I'm a bit confused. My first trade by using the excel (my own way): +26 pips. {image}
According to Jibala the dashboard already has the last bar algo in it excel doesn't. The dash tracks your trades and has rudimentary TM excel doesn't. The gap on dash is adjustable excel right now isn't. The dash basically has almost everything in it now except the update interval is 15 min and it doesn't have the buy/sell/wait or market strength. The excel sheet is really just an extra tool. That's why if the dash was modified we wouldn't even need the excel sheet.
  • #162
  • Oct 14, 2015 4:19am Oct 14, 2015 4:19am
Quoting dariuske
{quote} This is trading with Excel right? So why put the Dash in here? I'm a bit confused. My first trade by using the excel (my own way): +26 pips. {image}
To be exact "Trading the GAP with Excel"!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #163
  • Oct 14, 2015 4:22am Oct 14, 2015 4:22am
Quoting JibalaPasan
{quote} To be exact "Trading the GAP with Excel"!
Yes I know and you can do as you want I prefer the GVC dash because it does most of the heavy lifting but it not necessary.
  • #164
  • Edited 4:44am Oct 14, 2015 4:26am | Edited 4:44am
Quoting PipFlak
{quote} Yes I know and you can do as you want I prefer the GVC dash because it does most of the heavy lifting but it not necessary.
If you want the excel spreadsheet to be like Jibala's dash then you are going to have to add a lot of things. If not then I am confused-what does it do that the dash doesn't?
  • #165
  • Oct 14, 2015 4:53am Oct 14, 2015 4:53am
I just put a new line here and made it bigger for my eyes.
Can you check if its correct. I am not very used to this excel version.
Attached Image (click to enlarge)
Click to Enlarge Name: 96G5hgV.png Size: 27 KB
Attached File(s)
File Type: zip Speedometer_v3 02.zip   509 KB | 1,015 downloads
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #166
  • Oct 14, 2015 5:13am Oct 14, 2015 5:13am
Jibala
There is one major advantage to the excel spreadsheet that suddenly dawned on me - it is a perfect visual teaching tool for your classroom. That in itself is priceless!
I didn't even think about that sorry
  • #167
  • Oct 14, 2015 5:13am Oct 14, 2015 5:13am
Quoting Bernhard
I just put a new line here and made it bigger for my eyes. Can you check if its correct. I am not very used to this excel version. {file} {image}
I don't know what you are calculating hence don't know what to check and to compare!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #168
  • Oct 14, 2015 6:32am Oct 14, 2015 6:32am
Good luck with your training everyone it is worth it! Jibala is the absolute best forex teacher you could have.
Thanks for subscribing. I am out of here. Except when I need some more training.
See ya!
  • #169
  • Oct 14, 2015 6:45am Oct 14, 2015 6:45am
Quoting JibalaPasan
{quote} I don't know what you are calculating hence don't know what to check and to compare!
I just linked the GAP numbers from speedometer2-tab (G2...) were is the gap arrow
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #170
  • Oct 14, 2015 7:06am Oct 14, 2015 7:06am
Quoting JibalaPasan
{quote} To be exact "Trading the GAP with Excel"!
Indeed, but the GAP can be used for a lot more then only reversal trades.
  • #171
  • Oct 14, 2015 7:24am Oct 14, 2015 7:24am
Quoting PipFlak
{quote} If you want the excel spreadsheet to be like Jibala's dash then you are going to have to add a lot of things. If not then I am confused-what does it do that the dash doesn't?


To me, the excel contains a lot more (workable) info than the dash. Just study it. Put the puzzle pieces together and analyse it. But that is just my opinion of course.
For me it doesn't have to look like Jibala's sheet. She has already given almost all information you need to be able to make the excel exactly like her's.
But thanks anyway for your reply at least now I know why you've posted the dash here.
  • #172
  • Oct 14, 2015 7:24am Oct 14, 2015 7:24am
Quoting dariuske
{quote} Indeed, but the GAP can be used for a lot more then only reversal trades.
Only for reversal, something I never said!

http://www.forexfactory.com/showthre...92#post8537192
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #173
  • Oct 14, 2015 7:27am Oct 14, 2015 7:27am
Quoting JibalaPasan
{quote} Only for reversal, something I never said! http://www.forexfactory.com/showthre...92#post8537192
I know you know but I don't think a lot of others understand this! That is why I wanted to repeat it.
  • #174
  • Oct 14, 2015 7:43am Oct 14, 2015 7:43am
Quoting Bernhard
{quote} I just linked the GAP numbers from speedometer2-tab (G2...) were is the gap arrow
I am wondering whats the base for the GAP calculation because of the big numbers.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #175
  • Oct 14, 2015 7:43am Oct 14, 2015 7:43am
please help me out how to use such gap system
  • #176
  • Oct 14, 2015 7:57am Oct 14, 2015 7:57am
Quoting PipFlak
{quote} According to Jibala the dashboard already has the last bar algo in it excel doesn't. The dash tracks your trades and has rudimentary TM excel doesn't. The gap on dash is adjustable excel right now isn't. The dash basically has almost everything in it now except the update interval is 15 min and it doesn't have the buy/sell/wait or market strength. The excel sheet is really just an extra tool. That's why if the dash was modified we wouldn't even need the excel sheet.
I love those dashboards too but that thread has become so full of rubbish that it isn't fun or educational to read anymore. I have found more valuable information in the previous 3 pages of this thread than in the last couple of hundred pages in the other thread. I think HP and GVC are the best and hope they earn a lot of (green) pips.
  • #177
  • Oct 14, 2015 8:02am Oct 14, 2015 8:02am
Quoting JibalaPasan
{quote} I am wondering whats the base for the GAP calculation because of the big numbers.
He probably neither did auto nor manual update. That's likely why the numbers are so big.
  • #178
  • Oct 14, 2015 8:27am Oct 14, 2015 8:27am
Quoting dariuske
{quote} He probably neither did auto nor manual update. That's likely why the numbers are so big.
no, please explane how to use this, is it a macro?
surprise.
after click manual update all was set to null. how is now a gap of 30 minutes?
what does autoupdate do?

but you did not answer my question here
now I see this numbers are reset.
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #179
  • Edited 9:19am Oct 14, 2015 8:52am | Edited 9:19am
Quoting Bernhard
{quote} no, please explane how to use this, is it a macro? surprise. after click manual update all was set to null. how is now a gap of 30 minutes? what does autoupdate do? but you did not answer my question here now I see this numbers are reset.

I also find that a strange way to do it but it is what the original creator of the excel (dtlase) did. (I did not make it that way but I don't know if I can do it differently either.) But since the VB is password protected I cannot have a look at it.
And NO, I did not answer your question because the answer is already in this thread and even on the excel sheet it self.
Edit: So the second one is fixed and only updated every 30 minutes or everytime you press manual update.
Attached Image
  • #180
  • Oct 14, 2015 8:53am Oct 14, 2015 8:53am
Hi,
All GAP trade signal every 30 minutes for 2 hours from "GAP_SYNC" tab(Speedometer) were winner(TP=8pips) in Tokio open, I can`t test LO or NYO because sleeping and job. Thank you dtlase for the file, also thank you for Jibala, PipFlak and all contributors.
Regards
2 traders viewing now