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

  • #2,101
  • Jul 11, 2016 4:08am Jul 11, 2016 4:08am
Quoting hypervash
{quote} are you really pinay?sorry but i followed all the steps and guidelines..what to do with this?im not good in excel.please
Hindi mo kailangan i-add ang suffix sa pangalan ng mga pares. Ang dapat mong baguhin ay ang formula!

edit: at tingnan mo ang cell na may #VALUE! At baguhin ang pangalan (add suffix) sa formula.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,102
  • Jul 11, 2016 4:13am Jul 11, 2016 4:13am
This should be the last version available on the forum but password free. It was provided by the owner at that time with the right to share it here.
Attached File(s)
File Type: rar Speedometer_v4c.rar   449 KB | 1,617 downloads
By failing to prepare, you are preparing to fail.
  • #2,103
  • Jul 11, 2016 4:25am Jul 11, 2016 4:25am
thanks,what i dont understand is how to change the formula and add suffix..can you give me hint?and what tab will i change the formula.
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 69 KB
  • #2,104
  • Jul 11, 2016 4:28am Jul 11, 2016 4:28am
and im getting this error.
Attached Image
  • #2,105
  • Jul 11, 2016 4:41am Jul 11, 2016 4:41am
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_10h56m31s_008_.png Size: 86 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_11h15m46s_009_.png Size: 83 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_11h17m27s_010_.png Size: 87 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_11h19m46s_011_.png Size: 81 KB

All orders some ticks missing only to hit TP. Soon we will know if this broker has the Virtual Dealer Plugin running! We're almost sure about it.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,106
  • Jul 11, 2016 4:52am Jul 11, 2016 4:52am
Quoting hypervash
thanks,what i dont understand is how to change the formula and add suffix..can you give me hint?and what tab will i change the formula. {image}
Once again: read the thread!

http://www.forexfactory.com/showthre...82#post8531582
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,107
  • Jul 11, 2016 4:55am Jul 11, 2016 4:55am
Quoting JibalaPasan
{quote} Once again: read the thread! http://www.forexfactory.com/showthre...82#post8531582
nabasa ko toh kasi pagkakaintindi ko sa "OO" apache open office.MSexcel gamit ko.so eto un?add lang ako ng x?thanks kababayan.


edit: ok kuha ko na..hint lang pla un..ahaha maraming salamat.
  • #2,108
  • Jul 11, 2016 5:01am Jul 11, 2016 5:01am
Quoting JibalaPasan
{image} {image} {image} {image} All orders some ticks missing only to hit TP. Soon we will know if this broker has the Virtual Dealer Plugin running! We're almost sure about it.
Almost all brokers will keep the slippage for them even TRUE ECN, or a part of it. Almost same problem here and I am running 3 brokers at this moment. When the price is about to reverse the spread is increased preventing TP's or hitting SL's . My latency is good execution very fast , we talk about milliseconds here not even seconds, but of course they will be much faster and have the data before sending to clients.

I am trying to leverage that by using a trailing SL/TP near TP, when price is at X from TP start trailing SL/TP. From all analyze so far it improve the number of pips and decease the describe situations. TP formula's doesn't get affected and it remains the same.
By failing to prepare, you are preparing to fail.
  • #2,109
  • Jul 11, 2016 5:07am Jul 11, 2016 5:07am
Quoting hypervash
{quote} nabasa ko toh kasi pagkakaintindi ko sa "OO" apache open office.MSexcel gamit ko.so eto un?add lang ako ng x?thanks kababayan. edit: ok kuha ko na..hint lang pla un..ahaha maraming salamat.
Ok, this is english language forum and we should stick to the language that all members will understand. You honestly can use Open Office if you only change all the formulas. I have described in my post how to do this and it works! If it works for me then it works for others as well, right? Just follow the steps or change to M$ Excel!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,110
  • Jul 11, 2016 5:14am Jul 11, 2016 5:14am
Quoting project13et
{quote} Almost all brokers will keep the slippage for them even TRUE ECN, or a part of it. Almost same problem here and I am running 3 brokers at this moment. When the price is about to reverse the spread is increased preventing TP's or hitting SL's . My latency is good execution very fast , we talk about milliseconds here not even seconds, but of course they will be much faster and have the data before sending to clients. I am trying to leverage that by using a trailing SL/TP near TP, when price is at X from TP start trailing SL/TP. From all analyze...
In a video (search on youtube for mt4 virtual dealer plugin) they show already how Brokers cheat their customers. The first part shown in the video we can do ourselves already and what I can say all 4 orders have been executed with a delay of 3 - 4 seconds! This is the first indication already that something must be wrong. More to find out!

We should make a Black List where all such Brokers can be reported and listed!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,111
  • Jul 11, 2016 5:17am Jul 11, 2016 5:17am
Quoting hypervash
{quote} nabasa ko toh kasi pagkakaintindi ko sa "OO" apache open office.MSexcel gamit ko.so eto un?add lang ako ng x?thanks kababayan. edit: ok kuha ko na..hint lang pla un..ahaha maraming salamat.
finally!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,112
  • Jul 11, 2016 5:44am Jul 11, 2016 5:44am
And here comes the idea for preventing to hit TP and Stop Hunting!

It needs an ea / indicator (don't know what will work better with lower resources) that will record all ticks (buy/sell) of open orders if they are some ticks away from TP with a time stamp. Later one can just open the txt file and look for the specific time and can see if spread has been increased to just prevent from TP or to trigger SL.

I am sure our team can solve this with M$ Excel since we have all open orders and tick data available in Excel.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,113
  • Jul 11, 2016 7:12am Jul 11, 2016 7:12am
Today analyze of missed trades, lots of winning trades prevented that is not good. Need to find a better solution to analyze all this trades since is killing my time, but first of all they should be reduced.

One of the most epic fail, when the auction start GBP was the second most weak pair after JPY, when it end it was very high at top . The ball hit the wall very hard, so a counter wouldn't be a bad decision.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: missed2.png Size: 19 KB
Click to Enlarge Name: GBPJPY.png Size: 55 KB
Click to Enlarge Name: GBP.png Size: 148 KB
By failing to prepare, you are preparing to fail.
  • #2,114
  • Jul 11, 2016 7:24am Jul 11, 2016 7:24am
Quoting project13et
Today analyze of missed trades, lots of winning trades prevented that is not good. Need to find a better solution to analyze all this trades since is killing my time, but first of all they should be reduced. One of the most epic fail, when the auction start GBP was the second most weak pair after JPY, when it end it was very high at top . The ball hit the wall very hard, so a counter wouldn't be a bad decision. {image} {image} {image}
Bro, you are doing pretty good already! Remember, if you have 10 trades per day and once in a while a loser your rate is above 90%! And yes, the GBP was good for a nice rebound.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,115
  • Jul 11, 2016 8:12am Jul 11, 2016 8:12am
Quoting JibalaPasan
{quote} Bro, you are doing pretty good already! Remember, if you have 10 trades per day and once in a while a loser your rate is above 90%! And yes, the GBP was good for a nice rebound.
Can't agree more, this is not the fact I want 100 or 200 pips more . I am not greedy, I don't care about number of trades or number of pips, all I care is to keep the win rate to 90% but so far that is not stable. Continues of Asia results.
Attached Image
By failing to prepare, you are preparing to fail.
  • #2,116
  • Jul 11, 2016 8:49am Jul 11, 2016 8:49am
Quoting project13et
{quote} Almost all brokers will keep the slippage for them even TRUE ECN, or a part of it. Almost same problem here and I am running 3 brokers at this moment. When the price is about to reverse the spread is increased preventing TP's or hitting SL's . My latency is good execution very fast , we talk about milliseconds here not even seconds, but of course they will be much faster and have the data before sending to clients. I am trying to leverage that by using a trailing SL/TP near TP, when price is at X from TP start trailing SL/TP. From all analyze...
It's a common problem. I've also seen brokers delaying their opening times.
  • #2,117
  • Jul 11, 2016 8:57am Jul 11, 2016 8:57am
Quoting project13et
{quote} Can't agree more, this is not the fact I want 100 or 200 pips more . I am not greedy, I don't care about number of trades or number of pips, all I care is to keep the win rate to 90% but so far that is not stable. Continues of Asia results. {image}
My result is only a little bit better (I mentioned about what's the real problem!) because of the ct - module is back to work what you can see on the latest trades. It nicely recognized the turning point!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_15h42m18s_015_.png Size: 78 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_15h42m50s_016_.png Size: 78 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_15h43m31s_017_.png Size: 81 KB

Slowly slowly JPY is back.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.11_15h56m05s_021_.png Size: 260 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,118
  • Jul 11, 2016 9:03am Jul 11, 2016 9:03am
Quoting JibalaPasan
{quote} My result is only a little bit better (I mentioned about what's the real problem!) because of the ct - module is back to work what you can see on the latest trades. It nicely recognized the turning point! {image} {image} {image} Slowly slowly JPY is back. {image}
Was the concept of the ratio CT module change totally or just little adjustments with same principle ?
Many Thanks,
By failing to prepare, you are preparing to fail.
  • #2,119
  • Jul 11, 2016 9:07am Jul 11, 2016 9:07am
Quoting project13et
{quote} Was the concept of the ratio CT module change totally or just little adjustments with same principle ? Many Thanks,
Completely new because of the logic behind. It doesn't mean success is granted from now on, we still have to watch and to analyze.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,120
  • Jul 11, 2016 10:27am Jul 11, 2016 10:27am
Hello
Today results for my 3 trading sessions,Tokyo open,LO,NYOpen +3 hours

Tokyo: 2 trades\2 winners
London: 5 trades\4 w\1 loser
NY: 2 trades\ 1w\1 L

generally speaking,NY session is the worst,Tokyo is the sweetest

@Jibala
you know I can't resist without askin' you something,lol

1)PLEASE could you publish some of your standard trade(not counter trades) with the old-fashion trade report details,such as:

AUDUSD, OP_SELL Order Details: Main Trend FLAT, BR: 0.07 (+/- 0.74), RS: -5.76 (+/- 6.95), BS: -4.17 (+/- 3.98), BS GAP: -1.95 (+/- 0.45), APS: -2.68, AMS: 3.70 ,please with Timestamp of the entry included????

2)PLEASE when you publish your pics,could we have your Broker time showing in the pic..?
you see,we are all here to learn,and the exact time of your pic would be so much useful !

Okay,maybe I crossed the line just a little this time
DO UT DES
4 traders viewing now