MT4 Trading the GAP With Excel

Quoting the bourne

Disliked

Hello Jibala I can see you started posting your trades with AMS at the bottom again many thx ! a little question about Correlation I know correlation and pairs sync is very important for your trading system I've been watching your STB for weeks About correlation ,I think it doesn't have to be calculated on timeframes,but using ticks I guess your excel can collect XX numbers of ticks in a buffer,and start calculating the correlation from these values so it should not be time related am I right? If yes,how many ticks are needed to fill the buffer?...

Ignored

Quoting JibalaPasan

Disliked

{quote} The only thing I can offer about correlation is this small video and the information the calculation is based on daily for a certain period of days. Not even I have access because this seems to be the holy grail! {file}

Ignored

Quoting project13et

Disliked

{quote} You're numbers go very high/low , like you recommended in other posts, if basket above >90% is a good entry, I totally agree to that, but you're numbers go very early and easy to that values, fast reaction of the market. And is not because OHLC and that every tick is measure, watching you're video I observe maxim around 4-5 ticks per seconds, I also have that speed or even better. Is because the data you array and the method you apply to that data. Pearson, Kendall, Spearman , M1 , M5 , M15, M30 , H1 , H4 , D1 , applied to different MA's...

Ignored

Quoting BlacMoni

Disliked

@Jibala Forgive me if my question is lame but i'm just starting to get my head around excel. How can I get the right datas filled into the columns marked with red arrows?... {image} the wrong and empty datas are affecting my MTF GAP calculations. Thanks {image}

Ignored

Quoting JibalaPasan

Disliked

{quote} The video is from 2105/04/10 which was a Friday at ~15.30 maybe that's why. And kindly do not forget that it is used for short term entries hence, there must be a difference in the calculation.

Ignored

Quoting JibalaPasan

Disliked

{quote} Since I do not use this Excel sheet and don't know about the formulas behind it, I can't tell you that much. But the best way would be to have a look what are the formulas in M15 / M30 / H1 and adapt them to H4 / D1. Jibala

Ignored

Quoting project13et

Disliked

Monday, very few news today, so an easy day for trading. I have to repeat my self again TP settings are experimental , and I don't recommend, since can complicate thinks out. Go for maxim 5 pips is safer like that, after you trade a lot you can develop a flexibile TP that can work with the market behavior. I found the trade when I wake up. {image}

Ignored

Quoting JibalaPasan

Disliked

{quote} The video is from 2105/04/10 which was a Friday at ~15.30 maybe that's why. And kindly do not forget that it is used for short term entries hence, there must be a difference in the calculation.

Ignored

Quoting project13et

Disliked

{quote} Regarding you're previous post where you confirmed that daily data is used, is that available for the short term entries that you use? Because there a lot of contradiction here. Thanks,

Ignored

Quoting JibalaPasan

Disliked

{quote} Where do you see or read contradiction?

Ignored

Quoting the bourne

Disliked

Trading around CAD and NZDUSD(twice) maybe I've found an AMS calculation similar to yours waiting for your next posts {image} {image} {image}

Ignored