MT4 to Excel through Excel RTD (Finally!) | Page 8 | 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!)

  • #141
  • Nov 21, 2020 1:31am Nov 21, 2020 1:31am
Quoting mtharwat
{quote} I attached the previous indicators template with stochastics added. In case you need a list of other indicators, list them for me. {file}Still working on the Fibonacci levels.
NaSap did it on her trading dashboard some years ago and it's very helpful in trading without to stare at the charts all the time.

https://www.forexfactory.com/thread/...55#post8438155

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #142
  • Nov 21, 2020 3:45am Nov 21, 2020 3:45am
Quoting garfield75
{quote} Hi mtharwat, Do you think it is possible to calculate in excel Fib levels from previous leg an trigger alerts when price reaches a specific level (61.8 or 50) ? Please share any other execl templates you have with RTD, I am trying to work out how to get multiple Stochatics values in there. Cheers Garfield75

Hi garfield75,

I am attaching a workbook for Fibonacci calculations based on legs that has two sheets; each one of them has a different calculation.

The first sheet named "Swing High Low" is using the @swingh and @swingl indicators.
Attached Image (click to enlarge)
Click to Enlarge Name: Swing High Low.png Size: 83 KB

Swing high and swing low is basically the same as the fractals indicator. In other words, If I choose (2) for swing high, this means we will look for a bar that its high is higher than two previous highs and is followed by two lower highs. The only difference with the @swinh indicator is that there is an option to confirm or unconfirm the swing (i.e not waiting for the next two candles'highs to close lower).
So in the first sheet, you can do the following:

1- change Confirmed swing to unconfirmed by typing (0) or (1) respectively. (0) will give you the same result as the fractals indicator for high and low swing.
2- change (N) of Bar swing. If you want a fractal of 2 then type 2 or a fractal of 5 then type 5.
3-same thing applies on the Swing Low.
4-Change Time Frame

Then I calculated the range between the swing high and the swing low to get Fibonacci levels of this range.

The second sheet is named "High Low N bars ago"
Attached Image (click to enlarge)
Click to Enlarge Name: High Low N Bars ago.png Size: 48 KB


The calculation is different as in this sheet you can get the highest high and the lowest low based on (N) bars ago that you specify. For example, if you want to find fibonacci levels between the highest high and the lowest low over the last 20 bars, then you type 20.

In this sheet you can do the following:
1- change time frame
2-Change the number of bars to find the highest high and lowest low. You can input 10 or 20 or 100, etc..
3- Change how far the distance between current price and any fib level should be. For example, If I want to know if price is about 15 pips far from a fib level, then I can specify the range as 0.0010 and 0.0020 (10-20 pips)

I then calculated fib levels based on the range between the highest high and lowest low.

------------------------------------------------------

Now, there is something you should be aware of:

As you already know, in order to calculate Fibonacci right, if we have a bullish trend i.e( the highest high appeared in time after the lowest low), then the 0.38% retracement should be closer to the lowest low.
The opposite is true if we have a bearish trend.

In order to find the right time when the highest height or lowest low did occur, I could not find a straightforward indicator from FX BLUE Labs to give me the exact time. For example, a 0.38 retracement in a bullish trend will be a 0.618 retracement in a bearish trend.
The way around it is to get the last 10 or 20 bars highs and lows which I initially did and looked up the value of the max highs and lows to find the time of occurrence but it was very resource-intensive and may lead to crashes. Imagine multiplying 28 pairs by 10 for readings of high and lows and another 28 X 2 for time.

So in short, all calculations assume bullish trends. The idea is that price is approaching or leaving a fib level within a certain range albeit the fib level may be 0.38 / 0.618 or 0.23/0.764 etc..

-------------------------------------

Excel has a built-in hyperlink formula to send an email but we need a VBA to automatically reference a cell and send email without clicking on sending an email. I assume a VBA may help but I do not have it.

---------------------------------
Let me know if the workbook is of help.
Attached File(s)
File Type: xlsx Fibs Calculation.xlsx   34 KB | 673 downloads
  • #143
  • Nov 21, 2020 3:59am Nov 21, 2020 3:59am
Quoting JibalaPasan
{quote} NaSap did it on her trading dashboard some years ago and it's very helpful in trading without to stare at the charts all the time. https://www.forexfactory.com/thread/...55#post8438155 Best of luck and stay green always! Jibala

garfield75 was initially asking for retrieving indicators values through Excel RTD. Nasap's post is about using EXCEL DDE and the latter is very limited and does not provide indicators readings.

Even for Fib levels, DDE can only provide values based on the current High and Low of the day but not other time frames.
  • #144
  • Nov 21, 2020 4:23am Nov 21, 2020 4:23am
Quoting mtharwat
{quote} Hi garfield75, I am attaching a workbook for Fibonacci calculations based on legs that has two sheets; each one of them has a different calculation. The first sheet named "Swing High Low" is using the @swingh and @swingl indicators. {image} Swing high and swing low is basically the same as the fractals indicator. In other words, If I choose (2) for swing high, this means we will look for a bar that its high is higher than two previous highs and is followed by two lower highs. The only difference with the @swinh indicator is that there is...
hey mtharwat,

Wow !! this is amazing, will need a day to digest this and post a detail reply on Monday!

THANK YOU
Trading is SIMPLE not EASY.
  • #145
  • Nov 21, 2020 5:21pm Nov 21, 2020 5:21pm
Any idea why the Stochistc values are different between MT4 chart and excel RTD.
Using the EURUSD Daily chart as an example.
Attached Image (click to enlarge)
Click to Enlarge Name: 1fda0b830d6d5eeb0a72750d8919510c.png Size: 20 KB
Attached Image
Trading is SIMPLE not EASY.
  • #146
  • Edited Nov 22, 2020 1:27am Nov 21, 2020 6:08pm | Edited Nov 22, 2020 1:27am
Quoting mtharwat
{quote} garfield75 was initially asking for retrieving indicators values through Excel RTD. Nasap's post is about using EXCEL DDE and the latter is very limited and does not provide indicators readings. Even for Fib levels, DDE can only provide values based on the current High and Low of the day but not other time frames.
Hi Mtharwat,

Thought it would be good to share my current strategy to give you some context on why I am requesting Fib and Stoch indicator.
I feel if we can get this setting on Excel and then have 1 excel dashboard which can show all pairs and timeframe and give alerts on which timeframe and pair there is a setup to take a trade. Currently, it is a very manual process to go though each chart and timeframe to identify trades, that is why I only trade it on daily and 4 hours timeframe.
Do you think something like this would be possible to do on EXCEL RTD?
Sending emails or SMS or Telegram Chat alert from excel is not a problem I have done that in the past of we can easily incorporate that bit.

Cheers
Garfield
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 6abf50e4612d44837d4695fa2d8180a2.png Size: 165 KB
Click to Enlarge Name: 7a3a94c2fd64edc676508f6f2e363265.png Size: 475 KB
Click to Enlarge Name: cce88459481c06d141cba92dd81bc1b2.png Size: 81 KB
Trading is SIMPLE not EASY.
  • #147
  • Nov 22, 2020 5:16am Nov 22, 2020 5:16am
Quoting blablabla
Does anyone know how to import account history/ Active Orders in to excel? Automatically, without copy and pasting the CSV? thx,
Hi blablabla,

Sorry I missed your post.
Other than what we can import through the EXCEL RTD, I am afraid we can not..
  • #148
  • Nov 22, 2020 5:39am Nov 22, 2020 5:39am
Quoting garfield75
Any idea why the Stochistc values are different between MT4 chart and excel RTD. Using the EURUSD Daily chart as an example. {image} {image}
Thank you for checking the indicator's values with MT4.
It was a mistake from my part as I referenced "close" within the indicator and it was unnecessary and influenced the output value somehow.

I am reattaching the same workbook with corrected stochastics. I checked it from my end. Check it please from your end and any other indicator.
Attached File(s)
File Type: xlsx Indicators Data with Concat Function (Stochastics added) (Corrected).xlsx   31 KB | 757 downloads
  • #149
  • Nov 22, 2020 5:58am Nov 22, 2020 5:58am
Quoting garfield75
{quote} Hi Mtharwat, Thought it would be good to share my current strategy to give you some context on why I am requesting Fib and Stoch indicator. I feel if we can get this setting on Excel and then have 1 excel dashboard which can show all pairs and timeframe and give alerts on which timeframe and pair there is a setup to take a trade. Currently, it is a very manual process to go though each chart and timeframe to identify trades, that is why I only trade it on daily and 4 hours timeframe. Do you think something like this would be possible to...

----If you are able to work on the SMS alert, it will be great. I was trying to find a VBA to record the time of occurrence of conditions but did not find one. An email or similar will be great to get notified and to backtest when conditions are met. I will be using this to test group currency strength.

-----Let us break your strategy into pieces.
What you wish to do is to have a dashboard across multiple time frames (6 from your picture) and you have 7 indicators/requests from EXCEL RTD and one indicator/request for the current price. So initially you will need 6*7*28 requests/indicators from EXCEL RTD. I can give it a try and if it freezes, then we can split the dashboard into two workbooks (one for HTF and one for LTF).
After that, we can apply two more indicators/requests from EXCEL RTD for FIB calculations. The good thing is that this condition will be the last one and will be applicable only to the pairs that have their conditions met.

The logic will be simple in implementing it. I would use the IF condition for each indicator and if fulfilled give it a value of one. If the sum of all values equals the number of conditions, then "Conditional Formatting"or alert/email.

---------------

If you can attach the last sheet in your photos (the one with EMA Setting/Stochastic setting/Fib 50) that you are using, I can build it up to the format you are looking for. I will reference the values in this sheet and make it the dashboard sheet. And...Let's see if it freezes or not. We need to try first.
  • #150
  • Nov 22, 2020 9:25am Nov 22, 2020 9:25am
Quoting mtharwat
{quote} Thank you for checking the indicator's values with MT4. It was a mistake from my part as I referenced "close" within the indicator and it was unnecessary and influenced the output value somehow. I am reattaching the same workbook with corrected stochastics. I checked it from my end. Check it please from your end and any other indicator. {file}
Thank you. Updated template now displays the values correctly.
Trading is SIMPLE not EASY.
  • #151
  • Edited 10:07am Nov 22, 2020 9:30am | Edited 10:07am
Quoting mtharwat
{quote} ----If you are able to work on the SMS alert, it will be great. I was trying to find a VBA to record the time of occurrence of conditions but did not find one. An email or similar will be great to get notified and to backtest when conditions are met. I will be using this to test group currency strength. -----Let us break your strategy into pieces. What you wish to do is to have a dashboard across multiple time frames (6 from your picture) and you have 7 indicators/requests from EXCEL RTD and one indicator/request for the current price. So...
Please see attached xls. It is still work-in-progress.
Agree it might have some issues with performance and may freeze during active market.
Attached Image (click to enlarge)
Click to Enlarge Name: 082d3b1a58dfb70ec70853ffd8429510.png Size: 87 KB
Attached File(s)
File Type: xlsx GF-RTD - V01.xlsx   78 KB | 724 downloads
Trading is SIMPLE not EASY.
  • #152
  • Nov 22, 2020 7:04pm Nov 22, 2020 7:04pm
Quoting garfield75
{quote} Please see attached xls. It is still work-in-progress. Agree it might have some issues with performance and may freeze during active market. {file} {image}
I will work on it.
  • #153
  • Edited 9:54pm Nov 22, 2020 7:06pm | Edited 9:54pm
Candlestick Direction in MTF

A simple workbook to find candlestick direction in multi-timeframe and the percentage of the move (close - open)/open *100.
Then I added the %move for each currency group.

The first column on the left has all pairs and their candle directions.

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-23 (1).png Size: 78 KB
Attached File(s)
File Type: xlsx Candlestick Direction.xlsx   45 KB | 594 downloads
  • #154
  • Nov 22, 2020 9:49pm Nov 22, 2020 9:49pm
Quoting garfield75
{quote} Please see attached xls. It is still work-in-progress. Agree it might have some issues with performance and may freeze during active market. {file} {image}

Hi garfield,

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-23.png Size: 105 KB


Attached your workbook with FIBS. When the cell says "one level", it is either 0.5 or 61.8. I followed the same logic you want in the dashboard.
When it says "both levels", it means the price is close to both 50 and 61.8 within the range of pips that you specify.
The range of pips can be specified from within the added sheets for fib level calculations at the top right. Each timeframe can be adjusted to preference.

I used (@swing indicator) to act the same as confirmed fractals in MT4 to provide the most recent swing (High or Low) based on your input. I believe you may need to adjust this parameter for each time frme. For example, if the (swing bar number) is 2, then @swing High will look for the bar that has two previous low highs and is followed by confirmed two lower lows. Each time frame would need its own adjustment.

--------

One limitation:
0.618 level means 0.618 or 0.382 depending on the trend Bullish or Bearish.
There is a workaround it but we will need more requests.
Test this template now to see if it is crashing or not during active hours.
If you do not want to have 0.382 levels and just prefer 0.618 levels for deep retracement, then I can figure a solution around it. (If you remember my previous post about this in particular). We just need to find which swing happened first in time. It is doable.
Attached File(s)
File Type: xlsx GF-RTD - V01 (with FIBS).xlsx   125 KB | 630 downloads
  • #155
  • Nov 22, 2020 10:21pm Nov 22, 2020 10:21pm
@Garfiled

To better understand the @swing indicator, put the Fractals indicator in MT4. The latter is using 2 bar swing. There are custom indis which allows the change of the (2 bar swing) to other number. I currently do not have.

When you place the fractals you will instantly understand the logic of calculations of the @swing indicator. I believe all the Automatic FIB indicators for MT4 are using the fractals logic albeit with changing the number of swing bars (Any one can correct me if I am wrong).

====================

In the meantime, do not forget the other way to calculate Fibonacci based on the highest high and lowest low over the user-specified last No of Bars per time frame. (The second sheet in my previous workbook).
This one is also a great alternative if you wish to use it instead.
For example, we can assign Fibonacci to be drawn based on the last 20 bars. (highest high and lowest low of these 20 bars) will be our base for calculations.

---------------------------

Regardless of the approach, we can still find which high or which low happened first in time, so we can determine if Fibonacci levels are in a downtrend or a bullish trend.
---
I hope I have not confused you as this point is important to understand.
  • #156
  • Nov 22, 2020 10:30pm Nov 22, 2020 10:30pm
Quoting mtharwat
@Garfiled To better understand the @swing indicator, put the Fractals indicator in MT4. The latter is using 2 bar swing. There are custom indis which allows the change of the (2 bar swing) to other number. I currently do not have. When you place the fractals you will instantly understand the logic of calculations of the @swing indicator. I believe all the Automatic FIB indicators for MT4 are using the fractals logic albeit with changing the number of swing bars. ==================== In the meantime, do not forget the other way to calculate Fibonacci...
@mtharwat,

Will check the file during London session today. I prefer the Fractal approach to calculate fib level instead of x number of past bars which can cause issue during ranging market IMHO.

Looking forward to testing this today

Cheers
Trading is SIMPLE not EASY.
  • #157
  • Edited 2:34am Nov 23, 2020 12:43am | Edited 2:34am
Single Pairs' Strength and Currency strength based on Fractals/swing indicator...

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-23 (3).png Size: 13 KB

The 'Pairs Swing Strength' Sheet has 5 inputs you can change.

The first three are for time frames.
The fourth input (Swing Bars) are for choosing how many bars for the swing. (2) is same as Fractals indicator in MT4
The fifth input is for either confirming the swing or to leave it unconfirmed. (confirmed) will yield the same results as fractals indicator in MT4

These cells are Master cells and the workbook references from them.

Edit: Forgot to add that the calculation is based on the close of the Fractal/Swing bar not its Low/High.
I may do another one later on based on the High and Low,
Attached File(s)
File Type: xlsx CSM Based on Fractals.xlsx   46 KB | 524 downloads
  • #158
  • Nov 23, 2020 12:56am Nov 23, 2020 12:56am
Quoting garfield75
{quote} @mtharwat, Will check the file during London session today. I prefer the Fractal approach to calculate fib level instead of x number of past bars which can cause issue during ranging market IMHO. Looking forward to testing this today Cheers
I agree with you.
  • #159
  • Nov 23, 2020 2:11am Nov 23, 2020 2:11am
Quoting mtharwat
{quote} I agree with you.
I am used to trading 4 hr charts, going down to 5Min TF seems to be noisy. Daily, 4hr, 1hr and 30Min seems to be align to my style.
Not sure if the Fib is doing what I would like it to do, which is to draw 61.8% level depending on the trend. (up or down)
Attached Image (click to enlarge)
Click to Enlarge Name: 2262121552d18b3e1f24f7dcc8369ede.png Size: 78 KB
Trading is SIMPLE not EASY.
  • #160
  • Nov 23, 2020 2:20am Nov 23, 2020 2:20am
Quoting garfield75
{quote} I am used to trading 4 hr charts, going down to 5Min TF seems to be noisy. Daily, 4hr, 1hr and 30Min seems to be align to my style. Not sure if the Fib is doing what I would like it to do, which is to draw 61.8% level depending on the trend. (up or down) {image}
I will look into it after the session.
I may need to retrieve the last 20 bars for each timeframe to make sure the swing occurred within these bars. I think 20 is enough. 10 bars was not enough for all pairs when I sampled it once.
0 traders viewing now