MT4 Trading the GAP With Excel | Page 65 | 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,281
  • Mar 2, 2016 1:10am Mar 2, 2016 1:10am
So far no perfect condition for auto trading.
By failing to prepare, you are preparing to fail.
  • #1,282
  • Mar 2, 2016 11:07am Mar 2, 2016 11:07am
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!
Thanks !!!

I missed that one indeed, will need to re-read that whole thread, see if I missed more nuggets.

LuXing
Wisdom begins in wonder
  • #1,283
  • Mar 2, 2016 8:08pm Mar 2, 2016 8:08pm
A big surprise this morning when I had a look at my account!

This is what I call a perfect (breakout) trade:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_10h07m11s_011_AUDJPY-M30.png Size: 59 KB

Main Trend UP, BR: 0.98 (+/- 0.77), RS: 8.99 (+/- 7.15), BS: 7.00 (+/- 4.98), BS GAP: 2.43 (+/- 0.45), Bs&Bs: 1.13 / 0.00 (+/- 0.53)
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_10h41m11s_013_AUDCAD-M30.png Size: 61 KB

AUDCAD took quite a bit longer to TP. If you compare the order details you maybe will find out why! Both orders were executed the same time 04:15:33 / 04:15:45

Main Trend UP, BR: 0.98 (+/- 0.77), RS: 8.99 (+/- 7.15), BS: 5.30 (+/- 4.98), BS GAP: 1.85 (+/- 0.45), Bs&Bs: 1.13 / 0.00 (+/- 0.52)

Bs&Bs: Bulls vs Bears

Have a green day all together!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,284
  • Mar 3, 2016 3:49am Mar 3, 2016 3:49am
Quoting JibalaPasan
A big surprise this morning when I had a look at my account! This is what I call a perfect (breakout) trade: {image} Main Trend UP, BR: 0.98 (+/- 0.77), RS: 8.99 (+/- 7.15), BS: 7.00 (+/- 4.98), BS GAP: 2.43 (+/- 0.45), Bs&Bs: 1.13 / 0.00 (+/- 0.53) {image} AUDCAD took quite a bit longer to TP. If you compare the order details you maybe will find out why! Both orders were executed the same time 04:15:33 / 04:15:45 Main Trend UP, BR: 0.98 (+/- 0.77), RS: 8.99 (+/- 7.15), BS: 5.30 (+/- 4.98), BS GAP: 1.85 (+/- 0.45), Bs&Bs: 1.13 / 0.00 (+/- 0.52)...

Based on your photos the trades has been placed at 3:15 not 4:15. A Bulls vs Bears for the whole market how will work for a GBP basket strong signal , because if Bulls are in control you will not gone take EURGBP ?

Thanks,
By failing to prepare, you are preparing to fail.
  • #1,285
  • Mar 3, 2016 4:21am Mar 3, 2016 4:21am
Quoting project13et
{quote} Based on your photos the trades has been placed at 3:15 not 4:15. A Bulls vs Bears for the whole market how will work for a GBP basket strong signal , because if Bulls are in control you will not gone take EURGBP ? Thanks,


Absolutely correct, I was wrong by 1h. Bulls vs Bears reflects not the entire market, it's Broker related.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,286
  • Mar 3, 2016 6:09am Mar 3, 2016 6:09am
Done for today!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_21h48m06s_023_.png Size: 206 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_21h49m44s_024_CADCHF-M30.png Size: 62 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_21h50m20s_025_USDCAD-M30.png Size: 57 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_21h55m54s_027_AUDCAD-M30.png Size: 63 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_21h59m37s_028_EURCAD-M30.png Size: 62 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,287
  • Mar 3, 2016 7:05am Mar 3, 2016 7:05am
I couldn't resist!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_22h51m48s_030_.png Size: 201 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_23h00m41s_032_GBPUSD-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_23h00m55s_033_AUDUSD-M30.png Size: 59 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_23h01m08s_034_NZDUSD-M30.png Size: 60 KB

Time to rest.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,288
  • Mar 3, 2016 7:43am Mar 3, 2016 7:43am
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!
Brilliant !
PA = PA and independent of candle close.
i-(maginary)Line cleared, other conditions met, good to go now.

Thanks, if it were not for your advice, I would have passed on these 2 EURJPY trades and missed green pips.

LuXing
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot2.png Size: 81 KB
Wisdom begins in wonder
  • #1,289
  • Mar 3, 2016 7:59am Mar 3, 2016 7:59am
Quoting JibalaPasan
I couldn't resist! {image} {image} {image} {image} Time to rest.

To be continued ... Did you resist with AUD/NZD strong and USD/JPY weak ?
By failing to prepare, you are preparing to fail.
  • #1,290
  • Mar 3, 2016 8:09am Mar 3, 2016 8:09am
Quoting LuXing
{quote} Brilliant ! PA = PA and independent of candle close. i-(maginary)Line cleared, other conditions met, good to go now. Thanks, if it were not for your advice, I would have passed on these 2 EURJPY trades and missed green pips. LuXing {image}
You couldn't have done any better!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,291
  • Mar 3, 2016 8:12am Mar 3, 2016 8:12am
Quoting project13et
{quote} To be continued ... Did you resist with AUD/NZD strong and USD/JPY weak ?
I've finished my day already, but there are still signals.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.03_23h57m51s_035_.png Size: 195 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,292
  • Mar 3, 2016 8:12pm Mar 3, 2016 8:12pm
I'm happy for the successful Tokyo session since we have NFP today.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h02m04s_039_AUDNZD-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h02m22s_040_AUDUSD-M30.png Size: 61 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h02m33s_041_AUDJPY-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h02m45s_042_AUDCHF-M30.png Size: 62 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h02m59s_043_CADJPY-M30.png Size: 56 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h03m13s_044_CHFJPY-M30.png Size: 57 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h03m28s_045_GBPJPY-M30.png Size: 59 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h03m42s_046_EURJPY-M30.png Size: 60 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h03m59s_047_AUDCAD-M30.png Size: 64 KB

All orders manual!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,293
  • Mar 3, 2016 8:14pm Mar 3, 2016 8:14pm
To be continued:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h00m33s_038_USDJPY-M30.png Size: 61 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_12h07m31s_048_USDJPY-M30.png Size: 58 KB

We can't get them all!

Have a green day all together.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,294
  • Mar 4, 2016 4:12am Mar 4, 2016 4:12am
Quoting JibalaPasan
{quote} I've finished my day already, but there are still signals. {image}
Thank a lot, Jibala, for your remarkable trading lessons.
Will you please tell on which timeframe and number of bars do you calculate correlation?
And is it Pearson or Spearman method?
BR, alex
  • #1,295
  • Mar 4, 2016 4:39am Mar 4, 2016 4:39am
Quoting sevan62
{quote} Thank a lot, Jibala, for your remarkable trading lessons. Will you please tell on which timeframe and number of bars do you calculate correlation? And is it Pearson or Spearman method?
1. No timeframes but M$ Excel with tick by tick processing
Attached Image (click to enlarge)
Click to Enlarge Name: corr_sheet.png Size: 178 KB

2. If I am not totally mistaken M$ Excel uses the Pearson method
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,296
  • Mar 4, 2016 5:08am Mar 4, 2016 5:08am
Quoting JibalaPasan
{quote} 1. No timeframes but M$ Excel with tick by tick processing {image} 2. If I am not totally mistaken M$ Excel uses the Pearson method
The correlation must be measured by looking at rs/br/bs since this is the only thing measured on a tick by thick base.
By failing to prepare, you are preparing to fail.
  • #1,297
  • Mar 4, 2016 5:43am Mar 4, 2016 5:43am
Trading the USD on NFP:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_21h22m56s_050_.png Size: 215 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_21h24m33s_051_.png Size: 214 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_21h29m21s_052_.png Size: 217 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.04_21h31m46s_054_.png Size: 221 KB

I wish you all a peaceful weekend.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,298
  • Mar 4, 2016 6:23am Mar 4, 2016 6:23am
Quoting project13et
{quote} The correlation must be measured by looking at rs/br/bs since this is the only thing measured on a tick by thick base.
Correlation is not related with rs/br/bs.
It is a value of relation of two data arrays. We have to take some (for example 20) bars of one currency par (for example EURUSD) and the same number of another currency pair (for example EURJPY) and calculate Correlation Koefficient based on some method. The best one for this type is Spearman rank correlation because it suits for any random distribution. Pearson is developed for normaly distributed arrays with linea dependence. In forex practice mostly used Pearson method as it is has much less CPU consumption. But Spearman rank method is more accurate because market price sequences are not not normaly distributed and have non-linea dependence.

Anyway we need two parameters for correlation calculations in each data array.
1. Number of values in each data array. I.E. number of bars.
2. TF timeframe because each bar belongs to definite TF.

And there is no need to calculate correlation each tick to save CPU usage. It do not alter very fast.

I think Jibala uses correlation indicator with default values and does not bother.
BR, alex
  • #1,299
  • Mar 4, 2016 6:23am Mar 4, 2016 6:23am
Quoting JibalaPasan
Trading the USD on NFP: {image} {image} {image} {image} I wish you all a peaceful weekend.


Wow, nice trades ! A bit too daredevil for me, but I might consider it in the future.

Have a good weekend !!

LuXing
Wisdom begins in wonder
  • #1,300
  • Mar 4, 2016 6:31am Mar 4, 2016 6:31am
Quoting sevan62
{quote} Thank a lot, Jibala, for your remarkable trading lessons. Will you please tell on which timeframe and number of bars do you calculate correlation? And is it Pearson or Spearman method?
If you are doing it in MS Excel, you could use the =CORREL function, which is Pearson.
Instead of thinking MT4 TimeFrames, you could use a "floating" period of 1 hour, 4 hours, or whatever tickles your fancy.
Although I have only started looking into gap trading, I donīt think the correlation part is necessary for it...

LuXing
Wisdom begins in wonder
1 trader viewing now