MT4 to Excel through Excel RTD (Finally!) | Page 17 | Forex Factory

Options

Go to
Permalinks
Print Thread

Related Instruments

EUR/USD, EUR/JPY, GBP/USD

Similar Threads

Calculating EMA strength like RTD on break free trading 0 replies

MT4 RTD API 0 replies

MT4 export to Excel? 8 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 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

  • #321
  • Feb 4, 2021 12:46pm Feb 4, 2021 12:46pm
Quoting mtharwat
{quote} Can you please check rows 52 and 53. There are two Short TP hit. {image}
A glitch in the Matrix!!
When I click the button to run code, their is only 1 TP (Row 52). Delete everything on column "R" and run the code again to check the result.
Attached Image (click to enlarge)
Click to Enlarge Name: e94fdfba9f81a9fb3fa65b4acacd993b.png Size: 67 KB
Trading is SIMPLE not EASY.
  • #322
  • Edited 9:05pm Feb 4, 2021 8:54pm | Edited 9:05pm
Quoting mtharwat
{quote} This awesome Garfield and very much appreciated. Do you mind adding in a (cell) the total number of pips gained or lost? This way we can multiply this number of pips by lot size and calculate profit or loss. Many thanks,
To calculate TP in Pips, What would be your point/price of entry into the trade?
Trading is SIMPLE not EASY.
  • #323
  • Feb 4, 2021 9:02pm Feb 4, 2021 9:02pm
Quoting garfield75
{quote} To calculate TP in Pips, What would be your point of entry into the trade?
The point of entry will be the first Long or Short signal In the data series.
  • #324
  • Feb 4, 2021 9:11pm Feb 4, 2021 9:11pm
Quoting mtharwat
{quote} The point of entry will be the first Long or Short signal In the data series.
Open or High or Low or Close?
Trading is SIMPLE not EASY.
  • #325
  • Feb 4, 2021 9:23pm Feb 4, 2021 9:23pm
Quoting nicholas87
{quote} not yet solved my problem, if i want close tickets how to set? i have trying .>strresult = cmd.SendCommand("xxxxxx", "CLOSETICKTES", "Ta", 0) but not functon. or i want to close all sell position is it possible to setting? thank you for reply
I can create it for you in excel as per the screenshot.
Attached Image (click to enlarge)
Click to Enlarge Name: 10e3bbe8db9d195ac6397c4ec2f6e8d3.png Size: 13 KB
Trading is SIMPLE not EASY.
  • #326
  • Feb 4, 2021 10:31pm Feb 4, 2021 10:31pm
Quoting garfield75
{quote} Open or High or Low or Close?
The signals are triggered based on the close of the time series. So I believe on the close or once the Signal (Long/Short) is printed. It will be the same as the open of the new bar in the time series.
  • #327
  • Feb 5, 2021 12:23am Feb 5, 2021 12:23am
Quoting garfield75
{quote} I can create it for you in excel as per the screenshot. {image}
THANK YOU
  • #328
  • Feb 5, 2021 7:07pm Feb 5, 2021 7:07pm
Quoting mtharwat
{quote} The signals are triggered based on the close of the time series. So I believe on the close or once the Signal (Long/Short) is printed. It will be the same as the open of the new bar in the time series.
updated file attached, you may need to tweak the macro for jpy pairs pip calculation.
Attached Image
Attached File(s)
File Type: xls Backtesting Ver1-Garfield.xls   911 KB | 352 downloads
Trading is SIMPLE not EASY.
  • #329
  • Feb 6, 2021 12:44am Feb 6, 2021 12:44am
Quoting garfield75
{quote} I am in your option a). Have a strategy that I trade manually on 4 hr chart. using excel RTD to configure the same parameters and monitor that across multiple timeframe charts and when that confluence happen than trigger an alert to my mobile via Telegram to check the currency pair for trade setup. This is a lot more convenient for me than having to check charts at regular interval. This week I started a new strategy to test out based on the hypothesis:- if Weekly and Daily trends are in the same direction then when price pulls back to 50...
if anyone interested attached is the result of trades executed using excel rtd for a very simple strategy as per this post. Demo terminal ran on AWS all day all week. https://www.forexfactory.com/thread/...1#post13379621
Attached File(s)
File Type: xlsx Test Result.xlsx   29 KB | 438 downloads
Trading is SIMPLE not EASY.
  • #330
  • Feb 6, 2021 2:22am Feb 6, 2021 2:22am
Quoting garfield75
{quote} updated file attached, you may need to tweak the macro for jpy pairs pip calculation. {file} {image}
Thanks a lot, Garfield....

So this means that my simple strategy netted profits of 1000+ pips in three months and in M15 TF?. I had some doubts when I tested it before manually and found it would generate more than 700 pips or so but I was skeptical. The simple cross-over system does not take into account if the price is between the MAs so I thought of initiating the trade when the price goes above the MAs and Ma1 is above MA2.

I will test other pairs..

I was thinking that I should analyze the trend in H4/Daily and then only trade in direction of trend during active hours but it seems I do not need to do so..

I am still skeptical as it is too good to be true. I will test other pairs.
  • #331
  • Feb 6, 2021 2:27am Feb 6, 2021 2:27am
Quoting garfield75
{quote} if anyone interested attached is the result of trades executed using excel rtd for a very simple strategy as per this post. Demo terminal ran on AWS all day all week. https://www.forexfactory.com/thread/...1#post13379621 {file}
Very impressive considering the short span of time (three weeks) and the fact that it has been forward tested.
  • #332
  • Feb 6, 2021 2:30am Feb 6, 2021 2:30am
Quoting garfield75
{quote} Demo terminal ran on AWS all day all week. https://www.forexfactory.com/thread/...1#post13379621 {file}

Do you mean a virtual computer/Server?
  • #333
  • Feb 6, 2021 3:51am Feb 6, 2021 3:51am
Quoting mtharwat
{quote} Do you mean a virtual computer/Server?
Yes. Virtual server!!
Trading is SIMPLE not EASY.
  • #334
  • Feb 6, 2021 4:11am Feb 6, 2021 4:11am
Quoting mtharwat
{quote} Thanks a lot, Garfield.... So this means that my simple strategy netted profits of 1000+ pips in three months and in M15 TF?. I had some doubts when I tested it before manually and found it would generate more than 700 pips or so but I was skeptical. The simple cross-over system does not take into account if the price is between the MAs so I thought of initiating the trade when the price goes above the MAs and Ma1 is above MA2. I will test other pairs.. I was thinking that I should analyze the trend in H4/Daily and then only trade in direction...
You are welcome!! most traders are chasing a fantasy! In my view, any strategy which can return 20% with low drawdown (yearly) is a winner. So I think you are onto a winner!!
Trading is SIMPLE not EASY.
  • #335
  • Feb 6, 2021 6:22am Feb 6, 2021 6:22am
@Garfield,

Can you please re-check the VBA whenever you are free?

I deleted the three columns R, S, T and made sure the upper three cells G2:I2 turn (0) before clicking. I have done that many times with different pairs. I redownloaded the template.


I found some time the Stop Loss is triggered after a reversed order is executed. I thought may be the VBA does not close the order and does hedging. But then I found Target profit recorded twice.

Screenshots attached.

Take your time..

Cheers,

---------
BTW: Does the VBA close the last deal or leave it open?
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 1.png Size: 12 KB
Click to Enlarge Name: 2.png Size: 17 KB
Click to Enlarge Name: 3.png Size: 7 KB
  • #336
  • Feb 6, 2021 2:58pm Feb 6, 2021 2:58pm
Quoting mtharwat
@Garfield, Can you please re-check the VBA whenever you are free? I deleted the three columns R, S, T and made sure the upper three cells G2:I2 turn (0) before clicking. I have done that many times with different pairs. I redownloaded the template. I found some time the Stop Loss is triggered after a reversed order is executed. I thought may be the VBA does not close the order and does hedging. But then I found Target profit recorded twice. Screenshots attached. Take your time.. Cheers, --------- BTW: Does the VBA close the last deal or leave it...

Can you pls attach one of the excel sample with error?
VBA currently doesnt close a trade based on oppsite signal, it lets it run till sl or tp hit. So you could have multiple trades open in same or oppsite direction.
Trading is SIMPLE not EASY.
  • #337
  • Feb 7, 2021 3:12am Feb 7, 2021 3:12am
Quoting garfield75
{quote} I can create it for you in excel as per the screenshot. {image}
thank you for helping, hope fully can get your excel file soon

thank you very much
  • #338
  • Feb 7, 2021 3:29am Feb 7, 2021 3:29am
Quoting garfield75
{quote} Can you pls attach one of the excel sample with error? VBA currently doesnt close a trade based on oppsite signal, it lets it run till sl or tp hit. So you could have multiple trades open in same or oppsite direction.


The first sheet is AUDCHF15

Row 158 and 159 have short TP hit twice.

The Second sheet is EURCAD15

Rows 135 and 136 have Long TP Hit twice

There may be more as I have not scrolled down to the end of the data series.

Thanks,
Attached File(s)
File Type: xlsx AUDCHF15.xlsx   1.2 MB | 395 downloads
File Type: xlsx EURCAD15.xlsx   1.2 MB | 393 downloads
  • #339
  • Feb 7, 2021 5:47am Feb 7, 2021 5:47am
Quoting mtharwat
{quote} The first sheet is AUDCHF15 Row 158 and 159 have short TP hit twice. The Second sheet is EURCAD15 Rows 135 and 136 have Long TP Hit twice There may be more as I have not scrolled down to the end of the data series. Thanks, {file} {file}

I have introduced TradeID to match Entry with SL/TP. (macro in the attachment)
Since market range and multiple trades can be open in one or both direction, sometimes TP or SL are hit at the same time for more than 1 trades.
in the attached excel Tradeid 2 & 3 SL hit at the same time (on row 133) and it recorded a Loss for Trade 3.
Not sure how to solve the PIP count of the loss here, its recorded 15, where it should have recorded 30 pips for that.
Attached File(s)
File Type: xlsx AUDCHF15.xlsx   1.9 MB | 361 downloads
Trading is SIMPLE not EASY.
  • #340
  • Feb 7, 2021 8:25am Feb 7, 2021 8:25am
Quoting garfield75
{quote} I have introduced TradeID to match Entry with SL/TP. (macro in the attachment) Since market range and multiple trades can be open in one or both direction, sometimes TP or SL are hit at the same time for more than 1 trades. in the attached excel Tradeid 2 & 3 SL hit at the same time (on row 133) and it recorded a Loss for Trade 3. Not sure how to solve the PIP count of the loss here, its recorded 15, where it should have recorded 30 pips for that. {file}

I have a solution:

I intitally wanted one trade at a time so no opposite trade until the first's target or stop is hit.

So the logic would be as follows:
1- Once the close of the bar closes and triggers Entry, buy/sell at the next open price.
2-If close triggers TP or SL, then no new trading until new conditions are met (i.e, the cross should be fresh--In case of buy(the prevous SMA 1 was < Previous SMA2 and the current close recorded current SMA1>current SMA2 and price is above the two SMAs). In this case we will not be entering an opposite trade if stop loss for previous trade was hit and getting late when SMA cross changes. The freshness of the signal with SMA cross and price above/below is more important - at least with what I wanted to test.

What do you think?

Thanks for your efforts.
1 trader viewing now