Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

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

Has anyone made an Excel spreadsheet to analyze your MT4 trades? 0 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!)

Will be useful for many if you post it if no copyrights are violated..
Thanks for your initiative.
By the way, does MT4 or Excel needs to be shutdown/restarted to update the data?
Quoting cuchuflito
I do have an Indi for MT4 that saves your chart data (any tf,)to your hard drive, updates auto as a new tick shows, will go back as far as the chart you have opened does.It saves csv or any other common format. I use it for my Dynamic Trader software, had a russian nerd program that for me a decade ago, payed for it. I can share for free.

Will be useful for many if you post it if no copyrights are violated..
Thanks for your initiative.
By the way, does MT4 or Excel needs to be shutdown/restarted to update the data?
  •  Dmh
  • | Joined Oct 2018 | Status: Member | 82 Posts |
Here you have a free data downloader for MT4 as well. I used the MT5 version in the past and was satisfied with it. MT4 or Excel does not need to be shutdown/restarted to update the data. The data downloader downloads the data simply every X minutes and stores the data in a CSV file. In Excel you can "import from CSV" so that everything goes automatically. https://www.mql5.com/en/market/produ...#!tab=comments
Quoting Dmh
Here you have a free data downloader for MT4 as well. I used the MT5 version in the past and was satisfied with it. MT4 or Excel does not need to be shutdown/restarted to update the data. The data downloader downloads the data simply every X minutes and stores the data in a CSV file. In Excel you can "import from CSV" so that everything goes automatically. https://www.mql5.com/en/market/produ...#!tab=comments
Oh yeah... I remembered this indicator and couldn't find it again. I forgot what it is called to search for it.
Thank you for mentioning it.

I forgot if it was stable or had issues with the continuous update... Anyway it will still be very good for quickly exporting multi pairs data at once.
Can anyone do a probability study for any Symbol of FX and Indices for determining suitable mode of Exit .
Exit by Pip Size
or
Exit by TF is better

Y axis will have Pips size (ADR x 1.25 multiply and divide by 20 groups, starting from 10 pips) and X pips will have minutes 240 bars (divided into 20 groups starting 5 bars) for TFs of M1, M5, M15, M30, H1 and H4) for both Long and Shorts.
Attached Image (click to enlarge)
Click to Enlarge Name: heatmap probability of achieving y pip target within an x bar window.jpg Size: 254 KB
Practice makes a person perfect
Golden 88 Pips Today: 0
I am still working on the Backtesting template in my post https://www.forexfactory.com/thread/...3#post13373523.

What has stopped me so far is finding the formula for calculating the transactions and whether the stop loss or target profit is hit or not. Bear in mind that I am using a percentage input to determine exits (TP and SL) and not reversing orders for crossovers.

@Garfield75 or any other member...
Can we think loud with each other? What would be the logic formula to use?
For simplicity:
For the long setups: I want to think of a formula for the target values in the target column to be looked up in the close column and if it is equal to or less, then type "Target Hit" and then redo this again when I have a new long signal in the Long/Short Signal column. It is straightforward if we do it once but how to recalculate based on a new signal? I was thinking of an xlookup/Vlook up formula since the latter will always retrieve the first match....
Quoting mtharwat
I am still working on the Backtesting template in my post https://www.forexfactory.com/thread/...3#post13373523. What has stopped me so far is finding the formula for calculating the transactions and whether the stop loss or target profit is hit or not. Bear in mind that I am using a percentage input to determine exits (TP and SL) and not reversing orders for crossovers. @Garfield75 or any other member... Can we think loud with each other? What would be the logic formula to use? For simplicity: For the long setups: I want to...
Please check column "R" in the attached screenshot, is that what you are trying to achieve?
Attached Image (click to enlarge)
Click to Enlarge Name: e34d6482fa8832b9eb00f6df2acdf8d8.png Size: 377 KB
Trading is SIMPLE not EASY.
ExcelRTD Return This Week: 0.9%
Quoting garfield75
{quote} Please check column "R" in the attached screenshot, is that what you are trying to achieve? {image}
Thank you Garfield. Yes, this is the one.
I believe I can now expand on it and get the net profit/loss.
what was the formula logic you came up with?
Quoting mtharwat
{quote} Thank you Garfield. Yes, this is the one. I believe I can now expand on it and get the net profit/loss. what was the formula logic you came up with?
Forgot to add:
In the formula in column (R), can you edit the formula to not show target/stop loss hit if the corresponding (I) column is showing opposite signal or the previous trade”s stop loss has been hit?
For example in the screenshot, there is “long target hit” while column (I)has a short signal and the previous long trade had a “stop loss Hit”.

Thanks
Quoting garfield75
{quote} Please check column "R" in the attached screenshot, is that what you are trying to achieve? {image}
Am I reading this correctly ...
Trade 1 looks like it hit SL first?
When you are successful perhaps give a thought to others ... Kiva dot org
Quoting PayItForward
{quote} Am I reading this correctly ... Trade 1 looks like it hit SL first?
yes,
This is why I asked Garfield in previous post to try and edit it.
we are getting there...
BTW, it was Trade 3...
The first trade is the up one.
Quoting mtharwat
{quote} yes, This is why I asked Garfield in previous post to try and edit it. we are getting there... BTW, it was Trade 3... The first trade is the up one.
I think you guys are doing a great job, envious of skills, I read it incorrectly - my bad - thanks.
When you are successful perhaps give a thought to others ... Kiva dot org
Quoting garfield75
{quote} Please check column "R" in the attached screenshot, is that what you are trying to achieve? {image}
Excellent Collection of statistics
Practice makes a person perfect
Golden 88 Pips Today: 0
Quoting mtharwat
{quote} Thank you Garfield. Yes, this is the one. I believe I can now expand on it and get the net profit/loss. what was the formula logic you came up with?
Cool. Haven't got any formula yet, I updated those columns manually to make sure I understand the problem you are trying to solve.

I should be able to solve this using some code in a macro.
Do you want the execution to calculate trade outcome automatically or when you click a button on the sheet "Calculate".

Couple of other question
- How close the price has to get to SL/TP to agree on the outcome
- can it be possible to have 2 trades open on the opposite direction (1 Buy and 1 Sell) without any of them hitting a TP/SL
Trading is SIMPLE not EASY.
ExcelRTD Return This Week: 0.9%
Quoting garfield75
{quote} Cool. Haven't got any formula yet, I updated those columns manually to make sure I understand the problem you are trying to solve. I should be able to solve this using some code in a macro. Do you want the execution to calculate trade outcome automatically or when you click a button on the sheet "Calculate". Couple of other question - How close the price has to get to SL/TP to agree on the outcome - can it be possible to have 2 trades open on the opposite direction (1 Buy and 1 Sell) without any of them hitting a TP/SL
Thank you Garfield,
At the moment I prefer an Excel formula.
I will allocate more time for it and try to find a solution.

If Iam clueless, I will ask you to do a macro..

Cheers
Quoting mtharwat
{quote} Thank you Garfield, At the moment I prefer an Excel formula. I will allocate more time for it and try to find a solution. If Iam clueless, I will ask you to do a macro.. Cheers
No problem.

To get the outcome of TP/SL hit based on Signal.
1) Need to check column “L” for Long or Short value row by row.
2) Once encountered “Long” or “Short” then move to next row to check column C,D,E,F values against signal row column M, N for Long or O,P for Short.
3) Keep repeating the check for each row till there is a match.
4) Number of rows to check once a signal is triggered is not fixed, it is dynamics.

IMHO it can't be solved with excel formula alone, will need a recursive loop to get the result.

Cheers
Garfield
Trading is SIMPLE not EASY.
ExcelRTD Return This Week: 0.9%
Thoughts ...
Using say a M5 template (scalping) or M15 or longer, determine what are the times where the greatest movement occurs in a security. I understand that news events would influence this and cause deviations however news is generally fuel and is burnt rapidly.
So that everyone can adapt the information to their time zone use a column to adjust to GMT and then their server time as the basis.
This will mean approx 1440 bars for a week M5 (this will vary depending on the security, e.g Gold only a 23 hr day) and the template can be cycled over a number of weeks, include start date/time finish date/time to establish if there is a clear number of specific time ranges during a day/week, e.g. Tokyo Open, Luxemberg Open, London Open, New York Open.
Next could be the frequency at which price crosses the Daily/Weekly Pivot, S38, R38 during the course of a day and week.
Using these levels Pivot, what other levels may be of significance, could they be average sessions (e.g. 24hr day / 3 sessions = 9 hrs = on M5 EMa 108, Daily 288, EMa 100, EMa 200, Open, Yesterdays High/Low etc - all important levels that price is attracted to and where price often stalls and either moves through or is reversed.
If you are looking at crossovers to determine opens/closes, what is the relationship between say EMa108 and VWMA108, could this be used a trigger and is it reliable?
Just a few thoughts, if anyone thinks there may be some merit
When you are successful perhaps give a thought to others ... Kiva dot org
Does anyone know/suggest a simple trade manager EA set SL/TP for trades.
I can execute trades from Excel RTD once all the conditions are met, then want the EA to take over to manage the trades.
Trading is SIMPLE not EASY.
ExcelRTD Return This Week: 0.9%
Quoting garfield75
Does anyone know/suggest a simple trade manager EA set SL/TP for trades. I can execute trades from Excel RTD once all the conditions are met, then want the EA to take over to manage the trades.
Found Swiss Army EA to manage trades.
Trading is SIMPLE not EASY.
ExcelRTD Return This Week: 0.9%
  • Post #280
  • Quote
  • Edited at 9:27am Jan 26, 2021 9:15am | Edited at 9:27am
Quoting garfield75
{quote} Found Swiss Army EA to manage trades.
I have found some indicators for you. Not sure useful or not. I never tested them
Attached Files
File Type: zip Xl models.zip   544 KB | 65 downloads
File Type: pdf INSTRUCTIONS for Free Trading Model.pdf   59 KB | 70 downloads
Practice makes a person perfect
Golden 88 Pips Today: 0
0 traders viewing now