No sure if that is accurate. Why did you divided non-yen pair with 10 to get the pip count?

MT4 to Excel through Excel RTD (Finally!)

That is a good result. Should work well with trending pairs, non-trending pairs have low pip count. trading just EUR and GBP pairs would be more than enough. Did you try with JPY Pairs to see the result?

MT4 to Excel through Excel RTD (Finally!)

hey nicholas Please see attached excel to close trades

MT4 to Excel through Excel RTD (Finally!)

@mtharwat - Please use attached V2 for testing. Column "R" now amends comment to capture if more than 1 trade closed on the same line/timeframe and TP/SL pip count also captures the same.

MT4 to Excel through Excel RTD (Finally!)

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 ...

MT4 to Excel through Excel RTD (Finally!)

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.

MT4 to Excel through Excel RTD (Finally!)

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!!

MT4 to Excel through Excel RTD (Finally!)

Yes. Virtual server!!

MT4 to Excel through Excel RTD (Finally!)

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. url

MT4 to Excel through Excel RTD (Finally!)

updated file attached, you may need to tweak the macro for jpy pairs pip calculation.

MT4 to Excel through Excel RTD (Finally!)

I can create it for you in excel as per the screenshot.

MT4 to Excel through Excel RTD (Finally!)

Open or High or Low or Close?

MT4 to Excel through Excel RTD (Finally!)

To calculate TP in Pips, What would be your point/price of entry into the trade?

MT4 to Excel through Excel RTD (Finally!)

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.

MT4 to Excel through Excel RTD (Finally!)

Thanks for the excel, this will have to done for each stock symbol per sheet. There are 1000+ symbols in ASX and US exchange. That is why I was trying to use EXCEL RTD to if it can get the indicator info on single row per stock (screenshot) It seems ...

MT4 to Excel through Excel RTD (Finally!)

Hey Mtharwat, Please see attached excel with the code and let me know if this is what you are after. Button "Click me" has the code behind to check all and update column "R". A message appears with Total Row count once the script completes checking ...

MT4 to Excel through Excel RTD (Finally!)

Sure will take a look at this over the weekend. The file is in Post #259?

MT4 to Excel through Excel RTD (Finally!)

Hi nicholas87, Sorry been away!! Have you solved your Close ticket issue or need some help? Cheers

MT4 to Excel through Excel RTD (Finally!)

Thanks for the reply, I have 2 brokers who can provide CFD data, one of them is live account. Excel RTD is able to get the ASK Price for all 100+ symbol. But it is unable to extract may of the indicator info for more than 10 symbols, which I find ...

MT4 to Excel through Excel RTD (Finally!)

Anyone ever tried Excel RTD on MT5 to get Stock CFD data?

MT4 to Excel through Excel RTD (Finally!)