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

  • #181
  • Dec 27, 2020 4:48pm Dec 27, 2020 4:48pm
Hi mtharwat and JibalaPasan, thanks for your contributions here, indeed RTD have a huge potential espcially for some like me who does not have coding skills.
I want to ask you if it is possible to transfer the information from two moving averages, for example 10 ema and also the information from 10 sma applied to the first indicator´s data? thank you again.
Humble & Kalcker CLO2 = Covid killer
  • #182
  • Dec 28, 2020 4:26am Dec 28, 2020 4:26am
Quoting jusiur
Hi mtharwat and JibalaPasan, thanks for your contributions here, indeed RTD have a huge potential espcially for some like me who does not have coding skills. I want to ask you if it is possible to transfer the information from two moving averages, for example 10 ema and also the information from 10 sma applied to the first indicator´s data? thank you again.
Hello jusiur,

You are welcome..

To answer your question: I am not aware of any special formula we can use to retrieve an SMA of an EMA from FX Blue Labs. However: we can still do it by retrieving the last 10 EMA data series (by using the built-in formula of Blue Labs) and then get their simple average by using Excel average function.

Let me know if you need a template. I can do one for you.
  • #183
  • Dec 28, 2020 7:12am Dec 28, 2020 7:12am
mtharwat, thanks for your reply, that sounds great, my goal is to achieve a csm dahboard based on that idea. With time and studying the template I could change parameters but initially with 5 periods both the EMA and its average would be very good and usefull for me. I would really appreciate your help if you have some time for that template.
Humble & Kalcker CLO2 = Covid killer
  • #184
  • Edited 9:09pm Dec 28, 2020 8:58pm | Edited 9:09pm
Quoting jusiur
mtharwat, thanks for your reply, that sounds great, my goal is to achieve a csm dahboard based on that idea. With time and studying the template I could change parameters but initially with 5 periods both the EMA and its average would be very good and usefull for me. I would really appreciate your help if you have some time for that template.

Attached a template for One Time Frame. You can copy it and only type the TF at the top and everything will be adjusted accordingly.
Attached Image (click to enlarge)
Click to Enlarge Name: 2020-12-29 (2).png Size: 47 KB


The calculation I made:
1- Retrieved EMA (10) data for 10 bars including the current bar (from current 0 to 9 bars ago).
2- Average sum of the 10 bars to get SMA of the 10 EMA.
3- Calculated the percentage distance of the current price to the SMA of EMA.
4- Created a second sheet for final calculation for each currency group. The calculation is adding all percentage moves for each currency pairs and then averaging them for each pair. (Or you may add the percentage move for each currency's pairs without averaging them).

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-12-29 (3).png Size: 43 KB

Please test it and let me know if there are any issues or miscalculations.
Attached File(s)
File Type: xlsx SMA of EMA CSM.xlsx   30 KB | 530 downloads
  • #185
  • Dec 28, 2020 10:16pm Dec 28, 2020 10:16pm
thanks. Have not data in CMS calc tab, maybe I miss something?
Attached Image (click to enlarge)
Click to Enlarge Name: cms tab.png Size: 51 KB
Humble & Kalcker CLO2 = Covid killer
  • #186
  • Dec 28, 2020 10:44pm Dec 28, 2020 10:44pm
Quoting jusiur
thanks. Have not data in CMS calc tab, maybe I miss something? {image}
Have you typed the account number in the first sheet? Is there Data?

The first sheet also has the inputs for Time Frame and EMA.
  • #187
  • Edited 7:18am Dec 29, 2020 5:12am | Edited 7:18am
Quoting mtharwat
{quote} Have you typed the account number in the first sheet? Is there Data? The first sheet also has the inputs for Time Frame and EMA.
Oh yes, I did, it is a JFD demo account. It is a bit strange because I have downloaded another templates in this thread and they work perfect
edit: I tried change =_xlfn.XLOOKUP function for BUSCAR instead but I´m affraid that import wrong data
Attached Image (click to enlarge)
Click to Enlarge Name: EMA abd SAMA Data.png Size: 58 KB
Attached Images
Humble & Kalcker CLO2 = Covid killer
  • #188
  • Dec 30, 2020 2:11am Dec 30, 2020 2:11am
Quoting jusiur
{quote} Oh yes, I did, it is a JFD demo account. It is a bit strange because I have downloaded another templates in this thread and they work perfect edit: I tried change =_xlfn.XLOOKUP function for BUSCAR instead but I´m affraid that import wrong data {image} {image} {image}
Changed Xlook UP to VLook up.
Placed the percentage column next to the symbols column and then changed the function.
Attached File(s)
File Type: xlsx SMA of EMA CSM (Vlook up).xlsx   36 KB | 564 downloads
  • #189
  • Dec 30, 2020 3:58am Dec 30, 2020 3:58am
Quoting mtharwat
{quote} Hello, I watched the video and will give a short answer until I come back for a further detailed response. What you are trying to accomplish is easy. You do not need to click on the "Place Order". This is VBA coded to make life easier for the trader. However, if you check for now page 21-22 in the EXCEL RTD PDF in the first post, you will find a way to type a formula to execute a buy order for example whether it is a market order or a pending one. I will work on it as I have not yet used the buy/sell orders and will come back with the formula....
no working if i wrote =IF(A1="X", cmd.SendCommand("Account Number", "BUY", "s=AUDJPY|v=10000", 5), 0)

did any one know how to set , like when column A1 >10 will auto buy or sell from mt4
  • #190
  • Dec 30, 2020 6:56am Dec 30, 2020 6:56am
Quoting mtharwat
{quote} Changed Xlook UP to VLook up. Placed the percentage column next to the symbols column and then changed the function. {file}
mtharwat hi. Yes, VLook was the solution, it works nicely, now i can test those ema and sma averages, thank you.
I wish you the best in this new year !!!
Humble & Kalcker CLO2 = Covid killer
  • #191
  • Jan 2, 2021 3:40am Jan 2, 2021 3:40am
Quoting nicholas87
{quote} no working if i wrote =IF(A1="X", cmd.SendCommand("Account Number", "BUY", "s=AUDJPY|v=10000", 5), 0) did any one know how to set , like when column A1 >10 will auto buy or sell from mt4
You need Excel VBA knowledge to program a dashboard that can trade fully automatically. The VBA macro then will permanently check cell A1 if its value has been changed. For this check out the VBA basics about "IF...THEN". Furthermore, you need the API (a script for MT4 which you can find here in FF) that will check every second (the lowest value to be set) if an order has been sent to the respective MT4 folder to be executed.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #192
  • Jan 3, 2021 12:53am Jan 3, 2021 12:53am
Quoting nicholas87
{quote} no working if i wrote =IF(A1="X", cmd.SendCommand("Account Number", "BUY", "s=AUDJPY|v=10000", 5), 0) did any one know how to set , like when column A1 >10 will auto buy or sell from mt4
Hey Nicholas,

you will need to write the code in VBA within the calculating section.

Private Sub Worksheet_Calculate()

--- write your code here

---

End Sub


Cheers
Trading is SIMPLE not EASY.
  • #193
  • Jan 3, 2021 3:39am Jan 3, 2021 3:39am
Hi.

I would like to find the yearly price and I use the following formula , but I receive “wait”…

=RTD("FXBlueLabs.ExcelRTD", , "123456", "@bh,GBPUSD,W52,close,0")

Is there a manner to have yearly prices?

Thanks for yours help
  • #194
  • Jan 3, 2021 4:24am Jan 3, 2021 4:24am
Quoting garfield75
{quote} Hey Nicholas, you will need to write the code in VBA within the calculating section. Private Sub Worksheet_Calculate() --- write your code here --- End Sub Cheers
example:
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
If= Range("A1") = >10 Then
End If
strResult = cmd.SendCommand("account", "BUY", "s=EURUSD|v=10000", 5)
sub end

can some people help me motify this ?
  • #195
  • Jan 3, 2021 11:51am Jan 3, 2021 11:51am
Quoting dionmanol
Hi. I would like to find the yearly price and I use the following formula , but I receive “wait”… =RTD("FXBlueLabs.ExcelRTD", , "123456", "@bh,GBPUSD,W52,close,0") Is there a manner to have yearly prices? Thanks for yours help
Did you rtfm?

The property name for bar history is as follows: @bh,symbol,timeframe,data,shift.

For example, the following formula shows the high of the current EUR/USD H1 bar:

=RTD("FXBlueLabs.ExcelRTD", ,"156734", "@bh,EURUSD,H1,high,0")

There are no timeframe W52 but W! The property "shift" stands for the bar which values you want to know hence, your formula must be like

=RTD("FXBlueLabs.ExcelRTD", , "123456", "@bh,GBPUSD,W,close,52")

to show you the close of the weekly bar from 52 weeks ago.


Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #196
  • Jan 3, 2021 8:20pm Jan 3, 2021 8:20pm
Quoting JibalaPasan
{quote} Did you rtfm? The property name for bar history is as follows: @bh,symbol,timeframe,data,shift. For example, the following formula shows the high of the current EUR/USD H1 bar: =RTD("FXBlueLabs.ExcelRTD", ,"156734", "@bh,EURUSD,H1,high,0") There are no timeframe W52 but W! The property "shift" stands for the bar which values you want to know hence, your formula must be like =RTD("FXBlueLabs.ExcelRTD", , "123456", "@bh,GBPUSD,W,close,52") to show you the close of the weekly bar from 52 weeks ago. Best of luck and stay green always! Jibala...

Jibala thanks a lot
for your reply.
  • #197
  • Jan 4, 2021 10:31am Jan 4, 2021 10:31am
I am trying to get RTD to work with IG Markets. Everything is installed but they don't give an example of the Excel function call. I have tried lots of variations but get nothing back.
=RTD("ig-markets.excelrtd", ,"12345","balance")

Anyone able to help with the correct parameters to pass?

Thanks.
  • #198
  • Jan 4, 2021 10:50am Jan 4, 2021 10:50am
Quoting Moxy_UK
I am trying to get RTD to work with IG Markets. Everything is installed but they don't give an example of the Excel function call. I have tried lots of variations but get nothing back. =RTD("ig-markets.excelrtd", ,"12345","balance") Anyone able to help with the correct parameters to pass? Thanks.
The download package from IG does show it uses the FXBlue.dll so I have also tried =RTD("FXBlueLabs.ExcelRTD", ,"12345", "balance") but no joy there either.
Attached Image
  • #199
  • Jan 4, 2021 2:55pm Jan 4, 2021 2:55pm
Quoting Moxy_UK
{quote} The download package from IG does show it uses the FXBlue.dll so I have also tried =RTD("FXBlueLabs.ExcelRTD", ,"12345", "balance") but no joy there either. {image}
Check the installation of those files in their respective folder:

[Install]
1:experts.ini=config
2:experts.ini=config,16
1:FXBlue.dll=MQL4\libraries,48
2:FXBlue.dll=MQL4\libraries,32
FXBlueExcelRTD.dll=system32,64
FXBlueExcelRTD64.dll=system64,192
1:GKFX - Excel RTD.ex4=MQL4\Experts,16
2:GKFX - Excel RTD.ex4=MQL4\Experts

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #200
  • Jan 4, 2021 3:56pm Jan 4, 2021 3:56pm
Quoting JibalaPasan
{quote} Check the installation of those files in their respective folder: [Install] 1:experts.ini=config 2:experts.ini=config,16 1:FXBlue.dll=MQL4\libraries,48 2:FXBlue.dll=MQL4\libraries,32 FXBlueExcelRTD.dll=system32,64 FXBlueExcelRTD64.dll=system64,192 1:GKFX - Excel RTD.ex4=MQL4\Experts,16 2:GKFX - Excel RTD.ex4=MQL4\Experts Best of luck and stay green always! Jibala
thanks Jibala, still no success though.
i tried on a different machine and fresh installation of MT4 with the same results.

DDE is working fine so I know that side of things is working.

any other suggestions?
0 traders viewing now