Menu

Options

Bookmark Thread

First Page First Unread Last Page Last Post

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

  • #261
  • Quote
  • Oct 16, 2015 9:21pm Oct 16, 2015 9:21pm
Quoting dtlase
{quote} Hope to see you around for your contribution toward this development.
Hi dtlase,

Do you think that the addition of divergence can improve the results?
Attached Image (click to enlarge)
Click to Enlarge Name: SYncBias_CRS_RSI3.PNG Size: 100 KB


regard
if you're doing we all have results with all
  • #262
  • Quote
  • Oct 16, 2015 10:16pm Oct 16, 2015 10:16pm
Quoting dlouw
{quote} 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
M$ Excel doesn't need any php support to open / import csv / txt file! It uses its internal function and can repeat it in specified interval from 1 - n minutes. This works pretty good if you do not have access from different sheets the same csv / txt. If for any case you should need such a function, then write a macro which will check first if csv / txt is open / in use already and will try it again after it is released again.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #263
  • Quote
  • Oct 16, 2015 10:37pm Oct 16, 2015 10:37pm
Quoting Sanyo
{quote} your gap is not a flexi gap it's a time intervall based gap right?
Depends on your "flexi" definition. I've stated many times already that we use an interval to update / reset the GAP and that the entry level of the GAP is based on a "flexi" filter.

To reset the GAP has the big advantage to keep you away from entries in a "weak" market. Why? One will see very slow increase / decrease of the GAP and it will not reach entry level until next update. As soon as market is awake and price action comes up, this will happen much faster and together with other entry criteria there are signals. You will much more understand if once you have your GAP sheet running beside a currency strength meter and some of your charts. Study it until you are familiar with it. This will not only take hours but days or weeks even!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #264
  • Quote
  • Oct 16, 2015 10:57pm Oct 16, 2015 10:57pm
Quoting jarfx05
{quote} Hi dtlase, Do you think that the addition of divergence can improve the results? {image} regard
The GAP is (almost) like divergence!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.17_10h45m05s_001_NZDCHF-M30.png Size: 56 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.17_10h48m56s_002_NZDJPY-M30.png Size: 56 KB

Not all charts always showing much clear divergence, hence we measure it and together with some of our other rules we have a signal.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #265
  • Quote
  • Oct 16, 2015 11:06pm Oct 16, 2015 11:06pm
Quoting 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...


And now in big letters transferred to the start page #1
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #266
  • Quote
  • Oct 16, 2015 11:47pm Oct 16, 2015 11:47pm
Quoting JibalaPasan
{quote} To reset the GAP has the big advantage to keep you away from entries in a "weak" market. Why? One will see very slow increase / decrease of the GAP and it will not reach entry level until next update. As soon as market is awake and price action comes up, this will happen much faster and together with other entry criteria there are signals.
That makes perfect sense ...
MT4/MT5 EAs/Indicators/Alerts coder
  • #267
  • Quote
  • Oct 17, 2015 4:01am Oct 17, 2015 4:01am
Quoting JibalaPasan
{quote} Depends on your "flexi" definition. I've stated many times already that we use an interval to update / reset the GAP and that the entry level of the GAP is based on a "flexi" filter. To reset the GAP has the big advantage to keep you away from entries in a "weak" market. Why? One will see very slow increase / decrease of the GAP and it will not reach entry level until next update. As soon as market is awake and price action comes up, this will happen much faster and together with other entry criteria there are signals. You will much more...
Okay, thx for the detailed explaination
  • #268
  • Quote
  • Oct 17, 2015 5:42am Oct 17, 2015 5:42am
Quoting dlouw
IHere 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...
This is a great succinct definition of our terms and belongs on page 1 where Jibala placed it.

I have a thought to add:

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).

I thought Bid Ratio for the current value uses the Bid value, not the current close. However, as the Bid values are not available for previous time frames, the close value is used. This leads to an inconsistency when comparing historical results by using two values that are calculated differently. It is much better to use dlouw'is definition as our standard as it provides higher consistency between the current values and historical ones. What is your consensus?
  • #269
  • Quote
  • Oct 17, 2015 5:46am Oct 17, 2015 5:46am
Quoting JibalaPasan
{quote} Depends on your "flexi" definition. I've stated many times already that we use an interval to update / reset the GAP and that the entry level of the GAP is based on a "flexi" filter. To reset the GAP has the big advantage to keep you away from entries in a "weak" market. Why? One will see very slow increase / decrease of the GAP and it will not reach entry level until next update. As soon as market is awake and price action comes up, this will happen much faster and together with other entry criteria there are signals. You will much more...
thanks jibala for your nice explanation. From where i can get this gap sheet?
  • #270
  • Quote
  • Oct 17, 2015 6:02am Oct 17, 2015 6:02am
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:...
thanks Jibala
I see you don't use anymore 8 pip target but use a trail stop?
Can you tell what trail, pip, candle or atr? What works best.
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #271
  • Quote
  • Edited Oct 18, 2015 1:00am Oct 17, 2015 9:04am | Edited Oct 18, 2015 1:00am
Quoting Bernhard
{quote} thanks Jibala I see you don't use anymore 8 pip target but use a trail stop? Can you tell what trail, pip, candle or atr? What works best.
Nothing has changed, the range for TP is still something 4.2 - n Pip depending on market conditions. What currently we analyze is the fact that the first move has become smaller. That's why the hard earned profit needs to be protected. The trailer uses a 0.5 Pip step from being in profit.

Edit: This is to confirm my above statement. I just read it in the user manual (guide) of another (commercial) scalping system.

If you increase the volume size while scalping, do not go for more than 5 pips even if the indicator shows a perfect trend. Or you must be prepared to close the trade at any moment when the price bar moves opposite direction.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #272
  • Quote
  • Oct 17, 2015 10:59am Oct 17, 2015 10:59am
Quoting 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...
Here is one superb post. Thanks for straightening the definitions. Many a times we tend to use the same term but the math is completely different. For excel development, we need our math absolutely perfect. The definitions should be on the first page for sure.
  • #273
  • Quote
  • Oct 18, 2015 1:17am Oct 18, 2015 1:17am
Quoting dtlase
{quote} The Heat Map will not work because I always run a script on the MT4 to get the Open price of the daily candle. The script populate another excel file before I now run a macro on the speedometer excel to copy and paste. It is a process that I don't want us to start with. Let me just summarise the calculation of HeatMap: Open Price Bid Price change= Bid - OpenPrice %changeD1 or HeatMap = change/open price * 1/100
Just make your script an indicator or expert which will run continuously on a chart and export all data on specified interval (eg M30)! The generated csv file then can be automatically imported / updated into your excel sheet. Should be not that much difficult, right?
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #274
  • Quote
  • Oct 18, 2015 1:22am Oct 18, 2015 1:22am
Quoting Marialuiza
{quote} thanks jibala for your nice explanation. From where i can get this gap sheet?
http://www.forexfactory.com/showthread.php?t=561309
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #275
  • Quote
  • Oct 18, 2015 1:24am Oct 18, 2015 1:24am
Hey Jibala

Thanks for all your help. I have spent the last 3 months reading and re reading your posts and when I had finished reading them I went back and read them again. i have studied each picture of your trades you post for hours.
Starting to get good results.

Thanks for teaching me how to fish and not just throwing me a couple of fish.

Cheers John
Attached Image (click to enlarge)
Click to Enlarge Name: MetaTrader 4 IC Markets.png Size: 27 KB
  • #276
  • Quote
  • Edited 10:56am Oct 18, 2015 8:29am | Edited 10:56am
Quoting JibalaPasan
All can be found inside forum / threads (GAP / DB Trading). Excel sheet & CSM is available! No "flexi" filter for GAP trading necessary! Set GAP entry to +/- 1.75 / 2.25! Signal [+] GAP: {image} CSM on signal / entry: {image} CSM on trade end / TP: {image} {image} Time to rest! Good night.

it does appear we have some sort of 'strength' formula there ........................ +/- 1.75 / 2.25! Signal [+] GAP...................... to go with our gap as our basic formula.

what is the formula with the GVC dash into incorporated
  • #277
  • Quote
  • Oct 18, 2015 9:48pm Oct 18, 2015 9:48pm
Quoting 44johnw
Hey Jibala Thanks for all your help. I have spent the last 3 months reading and re reading your posts and when I had finished reading them I went back and read them again. i have studied each picture of your trades you post for hours. Starting to get good results. Thanks for teaching me how to fish and not just throwing me a couple of fish. Cheers John {image}
Thanks a lot bro! Wish you good luck and many green pips always!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #278
  • Quote
  • Oct 18, 2015 10:08pm Oct 18, 2015 10:08pm
Quoting tembangjapuh
{quote} Good idea to strategy but. forex is fast moving and trend how about this template http://4.bp.blogspot.com/-QCmxF803lP...1600/trend.jpg This trend simple forex Any idea to perfect this sytem guys ?
Guys be careful if you use this excel sheet, it's calling back home! I got the info last Saturday from our excel specialist.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #279
  • Quote
  • Oct 19, 2015 6:37am Oct 19, 2015 6:37am
Hey,

when twinned trend and excel , for a short time to allow it to gain a significant competitive advantage. what do you think?

regard
Attached Image (click to enlarge)
Click to Enlarge Name: 2b.png Size: 196 KB
if you're doing we all have results with all
  • #280
  • Quote
  • Oct 19, 2015 10:32am Oct 19, 2015 10:32am
Hi

Does anyone can tell me,How can i change "auto update 30M" to 1H?
Thanks in advance
4 traders viewing now