Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

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

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
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.
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
  • Post #184
  • Quote
  • Edited at 10:09pm Dec 28, 2020 9:58pm | Edited at 10: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
File Type: xlsx SMA of EMA CSM.xlsx   30 KB | 42 downloads
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
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.
  • Post #187
  • Quote
  • Edited at 8:18am Dec 29, 2020 6:12am | Edited at 8: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
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
File Type: xlsx SMA of EMA CSM (Vlook up).xlsx   36 KB | 42 downloads
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
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
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)
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.
ExcelRTD Return This Month: 11.3%
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
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 ?
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)
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.
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.
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
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)
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?
2 traders viewing now