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

  • #241
  • Oct 16, 2015 4:45am Oct 16, 2015 4:45am
Quoting dariuske
{quote} Well, that is a bit what's been bothering me since the beginning about the excel. Normally the GAP (if I understand Maria correctly) is only shown every 30 minutes (every ??:00 and ??:30 hours) and based on that you only search for trades in the direction of the GAP. So how the excel works now, is not the way Maria intended it. But I don't think it is the way Jibala uses it and that they maybe use a rolling 30 minute window or something. So the excel should Always have a number as GAP and not be reset to zero. That's just my...
I am wondering how you wanna calculate the GAP without an interval?
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #242
  • Oct 16, 2015 5:01am Oct 16, 2015 5:01am
Quoting jarfx05
{quote} Hi, great job, thank you...
Hope to see you around for your contribution toward this development.
  • #243
  • Oct 16, 2015 5:16am Oct 16, 2015 5:16am
I don't know what am doing. But it is getting interesting. Done for the day, here is my trade so far and the ones that are yet to reach TP.
Hope they all get to their destination. Some trade can turn bad because of brokers spread. I am trading all pair because it is demo.
My advice to all if you want to scalp (fifo) is to trade pairs with small spread. Hope you guys have a lovely weekend.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: R1.PNG Size: 110 KB
Click to Enlarge Name: R2.PNG Size: 100 KB
Click to Enlarge Name: R3.PNG Size: 37 KB
Click to Enlarge Name: R4.PNG Size: 118 KB
  • #244
  • Oct 16, 2015 6:57am Oct 16, 2015 6:57am
Quoting JibalaPasan
{quote} I am wondering how you wanna calculate the GAP without an interval?
thank you very much jibala for extending the gap theory to its true sesnse. it seems that i have to read too much before commenting anything technical. Jibala, would you like to share your excel developed based on thoughts in this thread?

Again i would extend thanks.
  • #245
  • Oct 16, 2015 7:05am Oct 16, 2015 7:05am
Quoting JibalaPasan
{quote} I am wondering how you wanna calculate the GAP without an interval?
I don't mean without an interval because the interval should be set to 30 minutes (or 4H) as said by Maria. It is just that now every 30 minutes the gap is being reset without using that gap to compare it with the previous gap.
So what the excel is doing is saving the previous 30m BSR and building the new one (which is only being formed and not completed yet) and comparing those two. But it should save the gap that was formed during the last 30 minutes and compare it with the gap that was formed 30 minutes before that, not the gap that is being formed by the difference with the last gap. So..
The current build gap is just being used to compare with the previous gap, but to me that is not what I understood Maria was saying. The gap that is build at 14:00 shoud be compared with the gap that was build at 13:30. But now (in the excel) the gap that is still building at 13:50 is being compared with the gap that was build at 13:30. And at 14:01 the gap that is forming will be used to compare with the gap that was formed at 14:00 instead of comparing the one from 14:00 with the one from 13:30 and that is (to me) not how Maria explained it.

I hope this all makes sence.
  • #246
  • Oct 16, 2015 7:31am Oct 16, 2015 7:31am
Quoting Marialuiza
{quote} thank you very much jibala for extending the gap theory to its true sesnse. it seems that i have to read too much before commenting anything technical. Jibala, would you like to share your excel developed based on thoughts in this thread? Again i would extend thanks.
Hey lady, where have you been? Hope you are good. Welcome to the party.
This request may be difficult for Jibala, but she can point us to the right direction for calculating the filters.
Thank you both for your contribution so far.
  • #247
  • Oct 16, 2015 7:37am Oct 16, 2015 7:37am
Quoting dtlase
{quote} Hey lady, where have you been? Hope you are good. Welcome to the party. This request may be difficult for Jibala, but she can point us to the right direction for calculating the filters. Thank you both for your contribution so far.
Due to having some vision problems, unable to focus on viewing the screen continuously. Sorry for the absence. Let us proceed.
  • #248
  • Oct 16, 2015 7:43am Oct 16, 2015 7:43am
Quoting Marialuiza
{quote} thank you very much jibala for extending the gap theory to its true sesnse. it seems that i have to read too much before commenting anything technical. Jibala, would you like to share your excel developed based on thoughts in this thread? Again i would extend thanks.
Welcome!
  • #249
  • Oct 16, 2015 7:46am Oct 16, 2015 7:46am
Quoting dtlase
I don't know what am doing. But it is getting interesting. Done for the day, here is my trade so far and the ones that are yet to reach TP. Hope they all get to their destination. Some trade can turn bad because of brokers spread. I am trading all pair because it is demo. My advice to all if you want to scalp (fifo) is to trade pairs with small spread. Hope you guys have a lovely weekend. {image} {image} {image} {image}
Maybe we should open a new thread: "Just to improve our trading; with or without excel, with or without dashboards, with or without gap."
  • #250
  • Oct 16, 2015 9:48am Oct 16, 2015 9:48am
Hi everybody.

Do you know if it is possible to export INDICATOR values to Excel?

Thanks for your answer!

G
  • #251
  • Oct 16, 2015 9:52am Oct 16, 2015 9:52am
Quoting dariuske
{quote} I don't mean without an interval because the interval should be set to 30 minutes (or 4H) as said by Maria. It is just that now every 30 minutes the gap is being reset without using that gap to compare it with the previous gap. So what the excel is doing is saving the previous 30m BSR and building the new one (which is only being formed and not completed yet) and comparing those two. But it should save the gap that was formed during the last 30 minutes and compare it with the gap that was formed 30 minutes before that, not the gap that is...
So in essence, you are thinking that the current Gap at 14:10 should be compared to the previous Gap calculated at `13:40, assuming a 30 minute Gap Calculation and not the Gap calculated at 13:30. Jibabala, MariLuisa, PipFlak and all others, can we establish a common consistent definition as it is needed to correctly modify the PowerMeterV3 to insure has the proper calculation? This should allso include the time period definitions as we have talked about Daily and H4 period Gaps, is there any need to go below the H4 time period toH1 or below? And what about the Gap interval, 60 minutes, 30 minutes and anything else?
  • #252
  • Oct 16, 2015 9:59am Oct 16, 2015 9:59am
Quoting guibernaua
Hi everybody. Do you know if it is possible to export INDICATOR values to Excel? Thanks for your answer! G
Not without a lot of very technical programming to obtain current indicator values from MetaTrader into Excel. DDE only from Metatrader to Excel for input of current quotes only. Same issues apply for exporting Excel values directly into MetaTrader. The only easy intermediate option is to create a Comma Separated Values file that can be created and exported on a button press to go from Excel into MetaTrader or from MetaTrader into Excel
  • #253
  • Oct 16, 2015 10:10am Oct 16, 2015 10:10am
Quoting CapeCoddah
{quote} Not without a lot of very technical programming to obtain current indicator values from MetaTrader into Excel. DDE only from Metatrader to Excel for input of current quotes only. Same issues apply for exporting Excel values directly into MetaTrader. The only easy intermediate option is to create a Comma Separated Values file that can be created and exported on a button press to go from Excel into MetaTrader or from MetaTrader into Excel
Thanks for your answer!
  • #254
  • Oct 16, 2015 10:30am Oct 16, 2015 10:30am
Quoting guibernaua
Hi everybody. Do you know if it is possible to export INDICATOR values to Excel? Thanks for your answer! G
Just to give an idea on how to!

https://www.mql5.com/en/code/7716
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #255
  • Oct 16, 2015 11:31am Oct 16, 2015 11:31am
Quoting Marialuiza
{quote} thank you very much jibala for extending the gap theory to its true sesnse. it seems that i have to read too much before commenting anything technical. Jibala, would you like to share your excel developed based on thoughts in this thread? Again i would extend thanks.
The idea was introduced by you first. We started with deeper analyses and further development of your theory and came to the conclusion, it has lots of potential and can improve our system. The interpretation of the origin may differ, but what counts is the proof of hundreds of successful trades ever since implementation. I have shown many of our trades, all have the same structure. Buy positive GAP in an uptrend and opposite, sell negative GAP in an uptrend and opposite!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.16_20h34m57s_002_.png Size: 56 KB

Some minutes later the next two (2) signals:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.16_20h39m23s_003_.png Size: 55 KB

Result:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.16_22h29m31s_004_.png Size: 16 KB

More details:

NZDCHF, OP_BUY Order Details: Main Trend DOWN, BR: 0.21, RS: -3.50, BS: -3.01, BS GAP: 1.12
AUDJPY, OP_BUY Order Details: Main Trend DOWN, BR: 0.22, RS: -3.41, BS: -1.99, BS GAP: 1.50
NZDJPY, OP_BUY Order Details: Main Trend DOWN, BR: 0.21, RS: -3.54, BS: -2.01, BS GAP: 2.02

Two trades enough to survive, one more is a big plus (bad times may come)!

Wish you all a peaceful weekend.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #256
  • Oct 16, 2015 11:43am Oct 16, 2015 11:43am
Quoting JibalaPasan
{quote} The idea was introduced by you first. We started with deeper analyses and further development of your theory and came to the conclusion, it has lots of potential and can improve our system. The interpretation of the origin may differ, but what counts is the proof of hundreds of successful trades ever since implementation. I have shown many of our trades, all have the same structure. Buy positive GAP in an uptrend and opposite, sell negative GAP in an uptrend and opposite! {image} Some minutes later the next two (2) signals: {image} Result:...
your gap is not a flexi gap it's a time intervall based gap right?
  • #257
  • Edited 2:25pm Oct 16, 2015 1:57pm | Edited 2:25pm
Quoting guibernaua
Hi everybody. Do you know if it is possible to export INDICATOR values to Excel? Thanks for your answer! G

This will do the magic. You need to do some tweaking to export value of your indicator. Use the iCustom function to call your indicator and supply all the necessary inputs. This will loop through and export value for all 28 currency pair.


-----iCustom(NULL, 0, "Indi-Name",5, 10, "Arial", 85 , 25, 0 , 0, 0);


This is a must have script for anyone that want to export to excel. Bless you all.
The script exports values for......

"Symb,DOpen,WOpen,MOpen,PrevD,PrevW,PrevM,dEMA8,dEMA21,wEMA8,wEMA21,mEMA8,mEMA21,m30RSI2,dRSI2,wRSI2,mRSI2"

you can add to the list or reduce as you wish.
Attached File(s)
File Type: mq4 ExportDataToExcel.mq4   5 KB | 843 downloads
  • #258
  • Oct 16, 2015 2:28pm Oct 16, 2015 2:28pm
Quoting JibalaPasan
{quote} The idea was introduced by you first. We started with deeper analyses and further development of your theory and came to the conclusion, it has lots of potential and can improve our system. The interpretation of the origin may differ, but what counts is the proof of hundreds of successful trades ever since implementation. I have shown many of our trades, all have the same structure. Buy positive GAP in an uptrend and opposite, sell negative GAP in an uptrend and opposite! {image} Some minutes later the next two (2) signals: {image} Result:...
  • #259
  • Oct 16, 2015 3:01pm Oct 16, 2015 3:01pm
Quoting JibalaPasan
{quote} Just to give an idea on how to! https://www.mql5.com/en/code/7716
Been there and done that. (With paid help.) MT4 can write to a CSV/ text file easily. The excel must then use PHP to open and read the file into your excel sheet. All great until they try to open or use the same file at the same time which is inevitable. So now you must create duplicates of these files and have these programs search for the unused file. Not so easy! Good luck. Staying in MT4 is much easier.

dlouw
  • #260
  • Oct 16, 2015 3:14pm Oct 16, 2015 3:14pm
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
2 traders viewing now