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

  • #1,401
  • Apr 12, 2016 6:43am Apr 12, 2016 6:43am
Quoting LuXing
{quote} Nice Leet, First thing that comes to my mind seeing the trades (that JibalaPasan's dash would not take in automode) is a long trade after a bearish M30 candle and viceversa. i suppose you are aware, but I thought I would mention it nevertheless. All the best and green pips. Luxing
Let see different scenario's , maybe next time this will come in your mind.

1. Simple Previous bar direction it's not a criteria for trading, LBAR use a different and more complex formula.

2. Even if it will be , it will be part of LBAR check , the "bearish" candle is not "bearish" enough, and new other criteria has been meet so trading is allowed.

3. This could be one of the first @nasap trading styles, that use a counter bar on different time frames

Project Leet
Attached Image
By failing to prepare, you are preparing to fail.
  • #1,402
  • Apr 12, 2016 7:48am Apr 12, 2016 7:48am
Trying an experimental option, maybe JibalaPasan can confirm if this approach is correct or not, the order is placing at the first pending order level, then the price is retracing and the pending order is NOT hit, if the signal come again the pending order will be modify on the first new level available, like that you don't need to wait until it get to the previous level, and take the order at the new level.
Attached Image (click to enlarge)
Click to Enlarge Name: AUDCHF1.png Size: 67 KB
Attached Image
By failing to prepare, you are preparing to fail.
  • #1,403
  • Apr 17, 2016 3:33pm Apr 17, 2016 3:33pm
Quoting project13et
Trying an experimental option, maybe JibalaPasan can confirm if this approach is correct or not, the order is placing at the first pending order level, then the price is retracing and the pending order is NOT hit, if the signal come again the pending order will be modify on the first new level available, like that you don't need to wait until it get to the previous level, and take the order at the new level. {image} {image}
Your idea is good and we do it like that for a long time already, but manually only and if the price drops back for >= 10 Pip. It's not easy to automate within excel.

My trades from last week so far:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.04.17_22h23m17s_002_.png Size: 26 KB

The program runs in a fully auto mode now. I spend most of my time outside, a new world to explore!

Good luck to everybody for the new week.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,404
  • Apr 17, 2016 3:37pm Apr 17, 2016 3:37pm
Quoting JibalaPasan
{quote} Your idea is good and we do it like that for a long time already, but manually only and if the price drops back for >= 10 Pip. It's not easy to automate within excel. My trades from last week so far: {image} The program runs in a fully auto mode now. I spend most of my time outside, a new world to explore! Good luck to everybody for the new week.

Great to have you back
By failing to prepare, you are preparing to fail.
  • #1,405
  • Apr 17, 2016 3:53pm Apr 17, 2016 3:53pm
Quoting project13et
{quote} Great to have you back
Thanks mate!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,406
  • Apr 17, 2016 6:20pm Apr 17, 2016 6:20pm
Quoting JibalaPasan
{quote} Thanks mate!
Hey hey hey !!!

Happy to see you back.
Hope the move went as planned ?
May the green pip Gods be with you and looking forward to eye openers.

LuXing
Wisdom begins in wonder
  • #1,407
  • Apr 19, 2016 4:44am Apr 19, 2016 4:44am
An example of an automatic trade using counter bar that @nasap describe in the past, because everything is automatic this is very early experimental and includes also other filters not only the counter bar signal. I am not even sure if @JibalaPasan is still using this anymore, or if @nasap was using it in automatic trading also, or just for manual trading
Attached Image (click to enlarge)
Click to Enlarge Name: 1.png Size: 62 KB
By failing to prepare, you are preparing to fail.
  • #1,408
  • Apr 19, 2016 7:33am Apr 19, 2016 7:33am
Hi everyone !

I read all the thread and i can't find the excel file which could open (close) a position with excel. Could you help me? :-)
  • #1,409
  • Apr 20, 2016 3:52pm Apr 20, 2016 3:52pm
Quoting kimou78
Hi everyone ! I read all the thread and i can't find the excel file which could open (close) a position with excel. Could you help me? :-)
There is no such an excel file! You need to code in vba a macro to copy your order in a text file. On mt4 you have to run the api (interpreter between mt4 and excel) to execute the order. One of such an api can be found here: http://paulsfxrandomwalk.blogspot.nl...atrader-4.html

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,410
  • Apr 21, 2016 2:38am Apr 21, 2016 2:38am
Quoting JibalaPasan
{quote} There is no such an excel file! You need to code in vba a macro to copy your order in a text file. On mt4 you have to run the api (interpreter between mt4 and excel) to execute the order. One of such an api can be found here: http://paulsfxrandomwalk.blogspot.nl...atrader-4.html Jibala
I hope you're system is operational and you didn't miss all this market opportunists, we look forward for feature examples, since I miss you're teaching.

Many thanks,
By failing to prepare, you are preparing to fail.
  • #1,411
  • Apr 23, 2016 4:01pm Apr 23, 2016 4:01pm
Quoting kimou78
Hi everyone ! I read all the thread and i can't find the excel file which could open (close) a position with excel. Could you help me? :-)
It is here: http://www.forexfactory.com/showthre...91#post8640691
  • #1,412
  • Apr 24, 2016 9:34am Apr 24, 2016 9:34am
Quoting JibalaPasan
{quote} Maybe you're missing this post http://www.forexfactory.com/showthre...50#post8481250 Also click on the link inside that post. No signal if Fibo / Pivot is just some Pips ahead!
Hi Jibala.
Are you looking at daily Pivots and Fibo levels only? Or also on weekly and monthly?
  • #1,413
  • Apr 24, 2016 9:46am Apr 24, 2016 9:46am
Quoting LFN
{quote} Hi Jibala. Are you looking at daily Pivots and Fibo levels only? Or also on weekly and monthly?
Only on a daily base!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,414
  • Apr 24, 2016 9:48am Apr 24, 2016 9:48am
Quoting JibalaPasan
{quote} Only on a daily base!
On what period should we look for bulls/bears ? Will be daily open too much and we should use a rolling 60 / 240 minutes?

Thanks,
By failing to prepare, you are preparing to fail.
  • #1,415
  • Apr 24, 2016 9:49am Apr 24, 2016 9:49am
Quoting JibalaPasan
{quote} Only on a daily base!
Thanks
  • #1,416
  • Apr 24, 2016 9:56am Apr 24, 2016 9:56am
Mixed result for the last week hence, +/- 0.00

The problem we can not find, because it always happens during sleeping time, the system sometimes cuts all cells instead of copy & paste only. If this happens, all text files remain empty and no updates anymore.

All trades were taken in fully auto mode:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.04.24_16h16m04s_003_.png Size: 50 KB

One of the best:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.04.20_19h34m06s_003_.png Size: 64 KB

The worst:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.04.24_10h51m39s_002_.png Size: 69 KB

Wish you all a prosperous week!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,417
  • Apr 24, 2016 10:11am Apr 24, 2016 10:11am
Quoting JibalaPasan
Mixed result for the last week hence, +/- 0.00 The problem we can not find, because it always happens during sleeping time, the system sometimes cuts all cells instead of copy & paste only. If this happens, all text files remain empty and no updates anymore. All trades were taken in fully auto mode: {image} One of the best: {image} The worst: {image} Wish you all a prosperous week! Jibala
Why does you're system is using copy paste at all? Copy is bad , if you want to keep the trades log's why not making a function and call that function in vba but instead of copy or paste, just us the with and .value

With Sheets("LogTrades").Range("A1").End(xlDown).Offset(1, 0)
.Value = Sheets("TradingSignal").Range("A1").Value

for example exporting in other sheet, or if you want in a text file


For Each R In Sheets("LogTrades").Range("b4:b900").Rows
For Each c In R.Cells
output = output & c.Value & ","
Next c
output = output & vbNewLine
Next R

MyPath = Sheets("Example").Range("Folder")
MyFileName = "Trades"

Open MyPath & "" & MyFileName & ".txt" For Output As #1

Print #1, output
Close #1

With the same logic can be build a .jpg capture, or .csv in case you want to fast extract all data from the time of trade.

For me this is everything that left in the VBA excel (screenshots, and trade logs), all the other data are imported in real time, no meter at what hour I open the excel the data is there, don't need to wait for any update or calculation to be made everything is pushed in real time.

Hope this helps
Thanks,
By failing to prepare, you are preparing to fail.
  • #1,418
  • Apr 24, 2016 10:25am Apr 24, 2016 10:25am
Quoting project13et
{quote} On what period should we look for bulls/bears ? Will be daily open too much and we should use a rolling 60 / 240 minutes? Thanks,
First of all your post above. Some data is just copied from the live data stream as a value into some other cells. It happens on this operation. Don't know why but will have a look in this.

Your other question, we measure twice. Once it's measured tick by tick and the other on 1h base.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,419
  • Apr 24, 2016 10:45am Apr 24, 2016 10:45am
Quoting JibalaPasan
{quote} First of all your post above. Some data is just copied from the live data stream as a value into some other cells. It happens on this operation. Don't know why but will have a look in this. Your other question, we measure twice. Once it's measured tick by tick and the other on 1h base. Jibala
I will try to translate to everyone , correct me if I am wrong

if Bid above previous 60 minutes open , count the total 1h volume in the bull's side
if Bid below previous 60 minutes open, count the total 1h volume in the bear's side


Regarding the other issue I use similar to "copy" data from live stream to other trade log sheet, just look at the approach different, instead of copy/paste , use insert with .value. Has much more advantages, and no disadvantage.

Thanks,
By failing to prepare, you are preparing to fail.
  • #1,420
  • Apr 24, 2016 3:17pm Apr 24, 2016 3:17pm
Quoting JibalaPasan
{quote} First of all your post above. Some data is just copied from the live data stream as a value into some other cells. It happens on this operation. Don't know why but will have a look in this. Your other question, we measure twice. Once it's measured tick by tick and the other on 1h base. Jibala
Thank you for all the hints. So sorry that Excel hung up on you. The curse of Microsoft

When you refer to tick by tick does this mean you are copying the DDE data for each pair on every change? Or do you compare the DDE data to the last Hour? If on every change is that critical? Why not just export DDE and do the M1 values with MQL? It is not difficult to export historical date from MT4. (even on a rolling basis factoring in weekends).

Leet, did I read that right "volume"?
0 traders viewing now