MT4 Trading the GAP With Excel | Page 53 | 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,041
  • Jan 2, 2016 7:25am Jan 2, 2016 7:25am
Quoting braintheboss
{quote} No. I will see. Thanks PS: With that option better ( strenght28 is parcial fine ). But some spreads showed wrong. Heatmap dont show some data too. But all MT4 data is loaded. :S {image}
Kindly compare the formula for Spread, Point Range and Bid Ratio just for AUDCAD:

Spread: =(C5-C6)*IF(RIGHT(C$3;3)="JPY";100;10000)

Point Range: =($C4:$AD4-$C7:$AD7)*IF(RIGHT(C$3;3)="JPY";100;10000)​

Bid Ratio: =($C6:$AD6-$C7:$AD7)/$C10:$AD10*IF(RIGHT(C$3;3)="JPY";100;10000)

The range of the cells may vary (I don't hope so) but important is the red marked part of the formula. It checks whether it is a JPY cross pair or not because the multiplicator then has to be 100 instead of 10000.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,042
  • Jan 2, 2016 7:46am Jan 2, 2016 7:46am
Quoting JibalaPasan
{quote} Kindly compare the formula for Spread, Point Range and Bid Ratio just for AUDCAD: Spread: =(C5-C6)*IF(RIGHT(C$3;3)="JPY";100;10000) Point Range: =($C4:$AD4-$C7:$AD7)*IF(RIGHT(C$3;3)="JPY";100;10000)​ Bid Ratio: =($C6:$AD6-$C7:$AD7)/$C10:$AD10*IF(RIGHT(C$3;3)="JPY";100;10000) The range of the cells may vary (I don't hope so) but important is the red marked part of the formula. It checks whether it is a JPY cross pair or not because the multiplicator then has to be 100 instead of 10000.
The formula is right. The problem is excel is a crap. Sometimes I have reload app because first time fails formatting numbers. Really have weird behavior. But now is enough for me. I want excel for understand how dashboards calculate things. For trading I prefer MT4 dash but this thread and dashboard trading thread are awesome. Thanks to all people made possible
Try don't lose pants never...
  • #1,043
  • Jan 2, 2016 8:19am Jan 2, 2016 8:19am
Hello everyone.

Can somebody upload or point me out where i can found the following indicators:

Currency Strength - Giraia

Modoki HeatMap


Thanks in advance

Regards
Attached Image
  • #1,044
  • Jan 2, 2016 9:40am Jan 2, 2016 9:40am
Quoting howa61
Hello everyone. Can somebody upload or point me out where i can found the following indicators: Currency Strength - Giraia Modoki HeatMap Thanks in advance Regards {image}
Here it is-
Attached File(s)
File Type: ex4 Currency Strength - Giraia.ex4   30 KB | 570 downloads
File Type: mq4 HeatMapModokiV1.mq4   8 KB | 747 downloads
  • #1,045
  • Jan 2, 2016 9:49pm Jan 2, 2016 9:49pm
Quoting ppuruswani
{quote} Here it is- {file} {file}
Hello ppuruswani.

thanks for your indi.

I load the modoki indi and appear like this:

Attached Image


Any suggestions?

Thanks in advance

Regards
  • #1,046
  • Jan 3, 2016 7:42pm Jan 3, 2016 7:42pm
Welcome 2016! Great start in the new year.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_09h03m37s_001_.png Size: 178 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_09h12m18s_002_AUDJPY-M1.png Size: 47 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_09h12m33s_003_NZDJPY-M1.png Size: 46 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_09h12m48s_004_NZDUSD-M1.png Size: 50 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_09h13m02s_005_AUDUSD-M1.png Size: 55 KB

I wish you guys a prosperous, happy and healthy 2016!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,047
  • Jan 3, 2016 8:22pm Jan 3, 2016 8:22pm
Quoting JibalaPasan
What an amazing year-end closing! It couldn't be any better. {image} {image} {image} {image} {image} {image} {image} Result for this week so far: {image} That's it, guys! More improvements will come. {image} @dlouw & @project13et: Just try it! After you've made hundreds or thousands of successful trades show us your results.
Hi Jabala,
It is really good start for this new year, wish you all the best.

Kindly would you let us know what are the numbers in the marked box
Attached Image
  • #1,048
  • Jan 4, 2016 12:40am Jan 4, 2016 12:40am
Quoting htawfik
{quote} Hi Jabala, It is really good start for this new year, wish you all the best. Kindly would you let us know what are the numbers in the marked box {image}
= mtf gap
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,049
  • Jan 4, 2016 6:48am Jan 4, 2016 6:48am
Quoting howa61
{quote} Hello ppuruswani. thanks for your indi. I load the modoki indi and appear like this: {image} Any suggestions? Thanks in advance Regards
Guess the solution?
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.04_20h45m15s_006_.png Size: 64 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,050
  • Jan 4, 2016 8:24am Jan 4, 2016 8:24am
Quoting JibalaPasan
{quote} = mtf gap
Thanks a lot
  • #1,051
  • Jan 4, 2016 9:14am Jan 4, 2016 9:14am
Quoting JibalaPasan
{quote} Guess the solution? {image}

Thanks JibalaPasan.

GOT IT

  • #1,052
  • Jan 4, 2016 11:44am Jan 4, 2016 11:44am
First day using gap with excel. I know it's not much but happy with the result anyway
Attached Image (click to enlarge)
Click to Enlarge Name: Bez tytułu.png Size: 11 KB
The only thing that will make us successful is if we can control ourselves!
  • #1,053
  • Jan 5, 2016 1:34am Jan 5, 2016 1:34am
Quoting pabuuu
First day using gap with excel. I know it's not much but happy with the result anyway {image}
Congrats for your positive result! But you must work on the losses, they are too much.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,054
  • Jan 6, 2016 4:37am Jan 6, 2016 4:37am
Fully auto mode, couldn't take all screenshots, the interval of order execution is too fast! 91 for this week so far.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_16h12m34s_002_.png Size: 171 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_16h13m11s_003_.png Size: 17 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_16h14m00s_004_EURCAD-M1.png Size: 43 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h02m14s_012_.png Size: 16 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h02m50s_013_.png Size: 171 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h11m11s_014_.png Size: 16 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h11m37s_015_.png Size: 174 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h12m52s_016_USDCHF-M1.png Size: 39 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h13m03s_017_GBPCHF-M1.png Size: 47 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,055
  • Jan 6, 2016 4:43am Jan 6, 2016 4:43am
And manually!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h49m37s_019_.png Size: 22 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h50m22s_020_EURAUD-M1.png Size: 43 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h50m43s_021_AUDCHF-M1.png Size: 46 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h50m57s_022_AUDJPY-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h51m15s_023_GBPAUD-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h51m36s_025_AUDUSD-M1.png Size: 44 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h51m49s_026_AUDCAD-M1.png Size: 44 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_17h52m01s_027_AUDNZD-M1.png Size: 46 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,056
  • Jan 6, 2016 4:46am Jan 6, 2016 4:46am
But auto mode is better today! It took 26 sec. to TP
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_18h07m07s_030_.png Size: 18 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_18h05m43s_028_.png Size: 168 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_18h06m10s_029_GBPCAD-M1.png Size: 42 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,057
  • Jan 6, 2016 8:39am Jan 6, 2016 8:39am
Below, today results with dtlase V5q dashboard, only the 0.02 lot, if I can control the set of the "Max trades overall" there be a better MM.
Regards
Attached Image(s) (click to enlarge)
Click to Enlarge Name: dtlase-V5Q-002.jpg Size: 105 KB
Click to Enlarge Name: v5q.jpg Size: 40 KB
  • #1,058
  • Jan 7, 2016 12:01am Jan 7, 2016 12:01am
Quoting JibalaPasan
But auto mode is better today! It took 26 sec. to TP {image} {image} {image}
Hi Jibala,

Would you please keep posting your trades as we learn a lot from it , also would you please let me know what is the setting for your SL that you use in the tread manager.

Thanks a lot
  • #1,059
  • Jan 7, 2016 12:15am Jan 7, 2016 12:15am
Quoting JibalaPasan
But auto mode is better today! It took 26 sec. to TP {image} {image} {image}

Can you tell us what this value is? It's related to ASM ?

Many thanks,
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.06_18h07m07s_030_.png Size: 18 KB
By failing to prepare, you are preparing to fail.
  • #1,060
  • Jan 7, 2016 12:18am Jan 7, 2016 12:18am
Some nice trades are taken during sleeping time:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.07_09h24m06s_036_EURUSD-M1.png Size: 44 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.07_09h24m27s_037_NZDJPY-M1.png Size: 43 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.07_09h24m46s_038_AUDJPY-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.07_13h58m09s_003_CADJPY-M1.png Size: 49 KB

Attached Image

UDGDBA = Ultra Double Gap DashBoard Algo! These guys are always one step ahead. Congrats and many thanks to the team! ​
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
1 trader viewing now