MT4 Trading the GAP With Excel | Page 66 | 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,301
  • Mar 4, 2016 8:37am Mar 4, 2016 8:37am
Quoting LuXing
{quote} Wow, nice trades ! A bit too daredevil for me, but I might consider it in the future. Have a good weekend !! LuXing
I only can suggest watching USD some minutes prior to high impact news and you will become very familiar with it. ​
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,302
  • Mar 4, 2016 8:41am Mar 4, 2016 8:41am
Quoting sevan62
{quote} 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...

I miss the part where I ask the wikipedia description of correlation , but ok we can do it Does the data arrays has to be close, bid , open , average, median sma prices? Or it can be also other values , indicator numbers based on time frames, or tick by tick ? If I array that kind of values the correl will not work ?

And if you ask for answer's that you don't want to listen just don't ask She confirm she use the standard Pearson , if you form a opinion about Spearman go for it.

P.S. We don't have a CPU problem.
By failing to prepare, you are preparing to fail.
  • #1,303
  • Mar 4, 2016 10:04am Mar 4, 2016 10:04am
Quoting LuXing
{quote} 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.
I was going to code mql function for correl calculation.

Quoting LuXing
{quote} Although I have only started looking into gap trading, I dont think the correlation part is necessary for it... LuXing
Thanks a lot for your opinion, i greatly apreciate it.
BR, alex
  • #1,304
  • Mar 4, 2016 10:19am Mar 4, 2016 10:19am
Quoting project13et
{quote} I miss the part where I ask the wikipedia description of correlation , but ok we can do it Does the data arrays has to be close, bid , open , average, median sma prices? Or it can be also other values , indicator numbers based on time frames, or tick by tick ? If I array that kind of values the correl will not work ? And if you ask for answer's that you don't want to listen just don't ask She confirm she use the standard Pearson , if you form a opinion about Spearman go for it. P.S. We don't have a CPU problem.
Sorry, project, i had no intention to offend you anyway. I only wanted to improve the system that is why tried to clarify the difference of the methods.
I use bar close prices as array data. But i'm not sure of correl importance after LuXing's answer.
BR, alex
  • #1,305
  • Mar 4, 2016 10:34am Mar 4, 2016 10:34am
Quoting sevan62
{quote} Sorry, project, i had no intention to offend you anyway. I only wanted to improve the system that is why tried to clarify the difference of the methods. I use bar close prices as array data. But i'm not sure of correl importance after LuXing's answer.

It will not be hard to try to match a closed price correl , and to look in the past if the values match with what Jib posted. Of course you will not have every tick but can try approximate.

But just my two cent's advice that's not a standard close price correl.
By failing to prepare, you are preparing to fail.
  • #1,306
  • Mar 4, 2016 12:49pm Mar 4, 2016 12:49pm
Quoting LuXing
{quote} 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 dont think the correlation part is necessary for it... LuXing
Quoting sevan62
{quote} Sorry, project, i had no intention to offend you anyway. I only wanted to improve the system that is why tried to clarify the difference of the methods. I use bar close prices as array data. But i'm not sure of correl importance after LuXing's answer.

Just a little correction , maybe you missed this posts.

http://www.forexfactory.com/showthre...72#post8784872

"You need all pieces to get the whole picture. Important information I am looking for is in a red frame." Quoting JibalaPasan

And now about one of the values, my question regarding some values

http://www.forexfactory.com/showthre...60#post8768260

Again quoting JibalaPasan "The question from your former post is not something "top secret" it was answered already in 00-level trading iirc. The bigger (%) numbers show the correlation while the smaller (%) numbers show the Bid Ratio."

http://www.forexfactory.com/showthre...73#post8769273

So this values are still "important information", so is correlation important or not ? I know sometimes thinks are hard to achieve but the solution is not to ignore them

Project Leet
By failing to prepare, you are preparing to fail.
  • #1,307
  • Mar 7, 2016 5:15am Mar 7, 2016 5:15am
Hello dear jibalapasan
dear how could I get this excel and can u tell me the whole method ....MT4 Trading the GAP With Excel

Plz reply will wait..


....husnain ali khan
  • #1,308
  • Mar 7, 2016 9:32am Mar 7, 2016 9:32am
Quoting husnaink
Hello dear jibalapasan dear how could I get this excel and can u tell me the whole method ....MT4 Trading the GAP With Excel Plz reply will wait.. ....husnain ali khan
Husnain,

Dear Jibalapasan came and told us the whole method ! Everybody was there and we were waiting for you, but you did not wait !!!
Look at all these green pips you missed. I mean, what were you sinking ? Now you will have to read the whole thread yourself.

LuXing

Inserted Video
Attached Image (click to enlarge)
Click to Enlarge Name: 07032016.png Size: 101 KB
Wisdom begins in wonder
  • #1,309
  • Mar 7, 2016 10:56am Mar 7, 2016 10:56am
Luxing I dont know what to say u dear I just need that excel which pick the gap of trading
hope u xan give me the details. .....I realy dont know what u r saying man
  • #1,310
  • Mar 7, 2016 5:30pm Mar 7, 2016 5:30pm
Quoting husnaink
Luxing I dont know what to say u dear I just need that excel which pick the gap of trading hope u xan give me the details. .....I realy dont know what u r saying man
If you read the whole thread, you will definitively understand what he is saying ...
MT4/MT5 EAs/Indicators/Alerts coder
  • #1,311
  • Mar 7, 2016 8:43pm Mar 7, 2016 8:43pm
Yesterday no setups for "automated" trading hence, I used the 2 signals coming from "STB".
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.08_00h46m14s_007_.png Size: 192 KB

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

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

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

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

Good luck to everybody!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,312
  • Mar 8, 2016 12:38am Mar 8, 2016 12:38am
Quoting LuXing
{quote} Husnain, Dear Jibalapasan came and told us the whole method ! Everybody was there and we were waiting for you, but you did not wait !!! Look at all these green pips you missed. I mean, what were you sinking ? Now you will have to read the whole thread yourself. LuXing https://www.youtube.com/watch?v=0MUsVcYhERY {image}
What are you sinGing about..

You have made my day, men!

Stay positive, Multimillion
"All will be correctly, in this world is built" - The Master and Margarita
  • #1,313
  • Mar 8, 2016 10:01am Mar 8, 2016 10:01am
A lonely fight of the JPY!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.08_22h34m07s_016_.png Size: 183 KB

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

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

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

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

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

All manual! Time to rest a bit.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,314
  • Mar 8, 2016 10:21am Mar 8, 2016 10:21am
Quoting JibalaPasan
A lonely fight of the JPY! {image} {image} {image} {image} {image} {image} All manual! Time to rest a bit.
chapeau.

I see you even got GBPJPY "the right moment", as always. Got whiplashed on that one at NYO, luckily on demo...
Wondering if you took it in full auto mode and if not, what kept you out, =LOOKLEFT ?

LuXing
Wisdom begins in wonder
  • #1,315
  • Mar 8, 2016 10:35am Mar 8, 2016 10:35am
Quoting JibalaPasan
A lonely fight of the JPY! {image} {image} {image} {image} {image} {image} All manual! Time to rest a bit.
Yep, amazing, as always.


Stay positive, Multimillion
"All will be correctly, in this world is built" - The Master and Margarita
  • #1,316
  • Mar 8, 2016 2:35pm Mar 8, 2016 2:35pm
Quoting JibalaPasan
A lonely fight of the JPY! {image} {image} {image} {image} {image} {image} All manual! Time to rest a bit.
How bad will be the idea too use the average price of last X ticks with a period of X averages in total and make a corral on that instead of time ?
By failing to prepare, you are preparing to fail.
  • #1,317
  • Mar 8, 2016 4:49pm Mar 8, 2016 4:49pm
Quoting LuXing
{quote} chapeau. I see you even got GBPJPY "the right moment", as always. Got whiplashed on that one at NYO, luckily on demo... Wondering if you took it in full auto mode and if not, what kept you out, =LOOKLEFT ? LuXing
1. The right moment would have been around 160.250
2.
Quoting JibalaPasan
A lonely fight of the JPY! {image} {image} {image} {image} {image} {image} All manual! Time to rest a bit.
Not every trade comes with a perfect timing / entry, even in "auto" mode.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,318
  • Mar 8, 2016 5:03pm Mar 8, 2016 5:03pm
Quoting project13et
{quote} How bad will be the idea too use the average price of last X ticks with a period of X averages in total and make a corral on that instead of time ?
The period for the calculation should be either 12 or 40.

https://www.tradingview.com/stock-ch...oefficient_(CC)
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,319
  • Mar 9, 2016 5:10am Mar 9, 2016 5:10am
Great opportunities by a weak Swissy.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.09_18h28m14s_029_.png Size: 189 KB

The perfect:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.09_18h46m25s_030_GBPCHF-M30.png Size: 60 KB

The total:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.03.09_18h52m42s_032_.png Size: 19 KB

Have a green day all together.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,320
  • Mar 9, 2016 5:37am Mar 9, 2016 5:37am
Quoting JibalaPasan
Great opportunities by a weak Swissy. {image} The perfect: {image} The total: {image} Have a green day all together.
Whoa thatīs really nice, +30 pips on CHFJPY !!!
I must be doing something seriously wrong to leave all those pips on the table.

LuXing
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 82 KB
Click to Enlarge Name: Screenshot2.png Size: 64 KB
Wisdom begins in wonder
1 trader viewing now