• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 3:50pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 3:50pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

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

Integration between excel and MT4 prices 3 replies

  • Trading Discussion
  • /
  • Reply to Thread
  • Subscribe
  • 3,210
Attachments: MT4 Trading the GAP With Excel
Exit Attachments
Tags: MT4 Trading the GAP With Excel
Cancel

MT4 Trading the GAP With Excel

  • Last Post
  •  
  • Page 1 23456 182
  • Page 1 2 182
  •  
  • Post #1
  • Quote
  • First Post: Edited Mar 7, 2017 4:46pm Oct 8, 2015 11:00pm | Edited Mar 7, 2017 4:46pm
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Hello and Welcome.

This is for discussion of the Excel GAP trading spreadsheet developed by JibalaPasan and coded by dtlase based on GAP theory by MARIALUIZA (thanks Maria!) and any other tools developed by this talented international community.


NOTICE!!!
Please do not post pirated copies of software on this thread. I know for sure some of the stuff I see posted on other threads are from a certain Russian site and may contain viruses and or infringe upon US copyright laws. If you are not sure then don't post! You may be reported if you are found to be in violation.
Please be careful!


The latest dtlase spreadsheet is found here:
http://www.forexfactory.com/showthre...91#post8564491 updated 10/28/2015

CapeCoddah's Powermeter Dashboard Modification is found here http://www.forexfactory.com/showthre...21#post8551521 updated 10/21/2015

dtlase Powermeter V5c here http://www.forexfactory.com/showthre...65#post8593665 updated 11/16/2015 (A must have!)

dtlase Powermeter V5p here http://www.forexfactory.com/showthre...33#post8615433 updated 12/01/2015


Jibala Trade Management here http://www.forexfactory.com/showthre...97#post8533797 and here http://www.forexfactory.com/showthre...71#post8545471 updated 10/21/2015



Helpful Tools

CJA MTF Multi Pair RSI dashboard http://www.forexfactory.com/showthre...79#post8549779
jamesT. modified speedometer excel file here http://www.forexfactory.com/showthre...97#post8550997 updated 10/21/2015
jamesT. arrows http://www.forexfactory.com/showthre...21#post8551521 updated 10/21/2015
Average Bar Range (last candle too long/strong) here lhttp://www.forexfactory.com/showthre...28#post8552628


BASIC INSTALLATION Guide by PayItForward
(Removed by request of author.)



Many Green Pips To All!





Please Read *Very Good Idea * Thanks to DLOUW!

I believe some of the challenges being faced as a group is that terms are being used interchangeably. If we can create a standard set of definitions it will be much easier to work together. Here is my take on them as a start. Can we discuss this and create a durable standard to move forward with?

Here on some thoughts about the dash information and layout for strength indicators for clarity and discussion. We have Bid Ratio, Relative Strength, Currency Strength, Absolute Strength, Gap and Sync.

Bid Ratio is based on the current price as a percentage of the Day Range. This range can be based on the Day Bar (the time elapsed since the brokers open time) or Rolling (the last 24 hours).

Relative Strength is the Bid Ratio of a pair expressed in a range of -9 to 9.

Currency Strength (Strength) represents the average of Relative Strengths of a single currency across all currency pairs expressed in a range of 0 to 9.

Absolute Strength represents the difference of the Currency Strength of the base and counter currencies of a pair expressed in a range of -9 to 9. (This has been also described as Gap.)

Gap is a measure of the difference (movement) of an indicator across a fixed time frame. (Currently 30 minutes). This would indicate Momentum.

Sync is a count of how many pairs fit a set of criteria for a given currency. This is currently defined by all the selected filters. Sync is expressed in a range of 0 to 7.

If we can all build on or correct this to create a standard I think this help us moving forward. I will be happy to record progress and post the final "dictionary"

All the Best,
dlouw
  • Post #2
  • Quote
  • Oct 8, 2015 11:22pm Oct 8, 2015 11:22pm
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Ok well I have a question. When pressing auto update does it start automatically updating every 30 minutes using the server clock?
 
 
  • Post #3
  • Quote
  • Oct 8, 2015 11:30pm Oct 8, 2015 11:30pm
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,498 Posts
Many thanks for creating this new thread. I hope many people with great ideas will join and inspire. Let's have a nice time together and most of all respect each other's.

M$ Excel is a great tool not only as a trade analyzer but (automated) trading as well. Hence let's see if and how the new thread will grow.

Btw the idea for the "GAP" was introduced by Marialuiza. We put it into practice with some further development.

Regards Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
 
 
  • Post #4
  • Quote
  • Oct 9, 2015 12:01am Oct 9, 2015 12:01am
  •  imgarjana
  • | Joined Apr 2011 | Status: Member | 14 Posts
Join, curious how the gap analysis.
Hope we can all enlightenment more detial how to exploit a gap analysis to achieve profits
 
 
  • Post #5
  • Quote
  • Oct 9, 2015 12:06am Oct 9, 2015 12:06am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,498 Posts
Quoting PipFlak
Disliked
Ok well I have a question. When pressing auto update does it start automatically updating every 30 minutes using the server clock?
Ignored
If I am not totally mistaken the macro is using the internal "Application.OnTime" function, hence if the "auto update" button is pressed it should update every 30 minutes in accordance to a M30 chart.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
 
 
  • Post #6
  • Quote
  • Oct 9, 2015 1:02am Oct 9, 2015 1:02am
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
I think the first thing we need to do is create a 'GAP Trading for Dummies' pdf. I am one of the dummies who don't really know how to use this spreadsheet yet. If we could start with the basic setup in excel and how to test if it is working correctly that would be nice.
 
 
  • Post #7
  • Quote
  • Oct 9, 2015 1:22am Oct 9, 2015 1:22am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,498 Posts
Quoting PipFlak
Disliked
I think the first thing we need to do is create a 'GAP Trading for Dummies' pdf. I am one of the dummies who don't really know how to use this spreadsheet yet. If we could start with the basic setup in excel and how to test if it is working correctly that would be nice.
Ignored
Should be done by the creator (dtlase) of the spreadsheet. Only then it will become more clear how he interprets and understands Marialuiza's "GAP" definition.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
 
 
  • Post #8
  • Quote
  • Oct 9, 2015 1:50am Oct 9, 2015 1:50am
  •  brucech
  • | Joined Sep 2006 | Status: Member | 594 Posts
Quoting PipFlak
Disliked
I think the first thing we need to do is create a 'GAP Trading for Dummies' pdf. I am one of the dummies who don't really know how to use this spreadsheet yet. If we could start with the basic setup in excel and how to test if it is working correctly that would be nice.
Ignored
Thanks PipFlak for opening this thread to explore Gap Trading for Dummies (like me) using Excel (which I am a dummie in also). And thank you JibalaPasan for your continued inspiration.
I am definitely subscribed to this thread.

Bruce
 
 
  • Post #9
  • Quote
  • Oct 9, 2015 1:52am Oct 9, 2015 1:52am
  •  bubola
  • | Joined Jan 2010 | Status: ad maiora | 649 Posts
thanks for starting the thread, pipflak, i am very interested in gap trading and sharing ideas. and thanks to jibala for her teachings
 
 
  • Post #10
  • Quote
  • Edited 2:09am Oct 9, 2015 1:54am | Edited 2:09am
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Anyone who doesn't have a copy of Microsoft Office don't worry go here http://www.microsoft.com/en-us/evalc...onal-plus-2013.
This is by no means an endorsement of Microsoft products. They don't need my help.
 
 
  • Post #11
  • Quote
  • Oct 9, 2015 3:08am Oct 9, 2015 3:08am
  •  idiamond
  • Joined Dec 2011 | Status: Member | 62 Posts
Quoting JibalaPasan
Disliked
Many thanks for creating this new thread. I hope many people with great ideas will join and inspire. Let's have a nice time together and most of all respect each other's. M$ Excel is a great tool not only as a trade analyzer but (automated) trading as well. Hence let's see if and how the new thread will grow. Btw the idea for the "GAP" was introduced by Marialuiza. We put it into practice with some further development. Regards Jibala
Ignored
Where is "GAP" defined? While searching there are many references. Which reference(s) best define the "GAP".
 
 
  • Post #12
  • Quote
  • Oct 9, 2015 3:13am Oct 9, 2015 3:13am
  •  dariuske
  • | Joined Oct 2005 | Status: Just a member | 237 Posts
Calculation of groups are wrong!!!

Look at screenshot. It should not be 4. It should be -6!!!! When EURUSD is getting stronger, Euro is getting stronger but USD is getting WEAKER!
USD should now be SELL!
Since the excel is password protected, I cannot alter it the way it should be. So please notify dtlase.
Attached Image
 
 
  • Post #13
  • Quote
  • Oct 9, 2015 3:17am Oct 9, 2015 3:17am
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Quoting idiamond
Disliked
{quote} Where is "GAP" defined? While searching there are many references. Which reference(s) best define the "GAP".
Ignored
This is MariaLuiza's original ideas.
Attached File(s)
File Type: pdf Maria Gap Theory.pdf   114 KB | 7,599 downloads
 
1
  • Post #14
  • Quote
  • Oct 9, 2015 3:21am Oct 9, 2015 3:21am
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Quoting dariuske
Disliked
Calculation of groups are wrong!!! Look at screenshot. It should not be 4. It should be -6!!!! When EURUSD is getting stronger, Euro is getting stronger but USD is getting WEAKER! USD should now be SELL! Since the excel is password protected, I cannot alter it the way it should be. So please notify dtlase. {image}
Ignored
One thing I noticed unless I am wrong but it looks like he is calculating the difference of the bs ratio instead of absolute strength each 30 minutes for LO. At least I think that's what Maria said originally.
 
 
  • Post #15
  • Quote
  • Oct 9, 2015 3:28am Oct 9, 2015 3:28am
  •  dariuske
  • | Joined Oct 2005 | Status: Just a member | 237 Posts
Quoting PipFlak
Disliked
{quote} One thing I noticed unless I am wrong but it looks like he is calculating the difference of the bs ratio instead of absolute strength each 30 minutes for LO. At least I think that's what Maria said originally.
Ignored

Also correct PipFlak. Original Gap was based on Absolute strength and not on BSratio!
I don't know if that will be a big difference but we can see by building both. But the group calculation now is completely wrong and will not give correct signals so do not use it!
 
 
  • Post #16
  • Quote
  • Oct 9, 2015 3:49am Oct 9, 2015 3:49am
  •  dtlase
  • | Joined Nov 2014 | Status: Member | 114 Posts
Hello friends,
Thank you PipFlak for creating this thread. I want to thank Maria and JibalaPasan also.
The excel tool is just created from the little knowledge I got from Jibala pictures. I am not claiming it is perfect but I believe together we can make it.
 
 
  • Post #17
  • Quote
  • Oct 9, 2015 3:51am Oct 9, 2015 3:51am
  •  PipFlak
  • Joined May 2015 | Status: Member | 1,438 Posts
Quoting dtlase
Disliked
Hello friends, Thank you PipFlak for creating this thread. I want to thank Maria and JibalaPasan also. The excel tool is just created from the little knowledge I got from Jibala pictures. I am not claiming it is perfect but I believe together we can make it.
Ignored
Thank you and Jibala for giving us this sandbox to play in!
 
 
  • Post #18
  • Quote
  • Oct 9, 2015 3:55am Oct 9, 2015 3:55am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,498 Posts
Quoting dariuske
Disliked
{quote} Also correct PipFlak. Original Gap was based on Absolute strength and not on BSratio! I don't know if that will be a big difference but we can see by building both. But the group calculation now is completely wrong and will not give correct signals so do not use it!
Ignored
Exactly what I noticed too that's why I wrote above "should be explained by the creator". Only then we will know how it works.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
 
 
  • Post #19
  • Quote
  • Oct 9, 2015 4:03am Oct 9, 2015 4:03am
  •  dariuske
  • | Joined Oct 2005 | Status: Just a member | 237 Posts
Quoting dtlase
Disliked
Hello friends, Thank you PipFlak for creating this thread. I want to thank Maria and JibalaPasan also. The excel tool is just created from the little knowledge I got from Jibala pictures. I am not claiming it is perfect but I believe together we can make it.
Ignored
I agree! And I am just trying to help by giving constructive remarks.

If a base currency is second you need to reverse the outcome. Look at my screenshot.
Attached Image
 
 
  • Post #20
  • Quote
  • Oct 9, 2015 4:07am Oct 9, 2015 4:07am
  •  dtlase
  • | Joined Nov 2014 | Status: Member | 114 Posts
Quoting dariuske
Disliked
Calculation of groups are wrong!!! Look at screenshot. It should not be 4. It should be -6!!!! When EURUSD is getting stronger, Euro is getting stronger but USD is getting WEAKER! USD should now be SELL! Since the excel is password protected, I cannot alter it the way it should be. So please notify dtlase. {image}
Ignored

@dariuske
I will check the calculation again. It should be a SELL, since the GAP for EU,GU,AU,NU are +1. it shows that you BUY the base and SELL the quote USD.
and UC,UJ are -1.



All the calculation are on the work sheet. It is just the timer and update that is protected.
when you click on the Cell where you have 4, the calculation is there.
 
 
  • Trading Discussion
  • /
  • MT4 Trading the GAP With Excel
  • Reply to Thread
    • Page 1 23456 182
    • Page 1 2 182
0 traders viewing now
  • More
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2023