MT4 to Excel through Excel RTD (Finally!)

Quoting nicholas87

Disliked

{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

Ignored

Quoting dionmanol

Disliked

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

Ignored

Quoting Moxy_UK

Disliked

{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}

Ignored

Quoting nicholas87

Disliked

{quote} 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 ?

Ignored

Quoting mtharwat

Disliked

{quote} Hi nicholas87, I had a previous post (can not find it atm) in which I asked if anyone has a template to share that has a VBA embedded to initiate a buy or sell based on a certain cell value. There were some suggestions but they did not work; at least with me. I will look for a solution when I get free and share it here. The one that is currently working (in theory as I have not tested it) is the template supplied by FXBLUE Labs with clickable buy/sell boxes but cannot be used with an if formula.

Ignored

Quoting mtharwat

Disliked

{quote} Hi Moxy, Have you placed the EXCELRTD.exe in the Experts folder and then have applied it to the chart. If so, Did you see the mini window that has your account number and two tick boxes within it? If not, then you have not installed it properly. Try to uninstall everything and then when installing the package from IG, find IG MT4 (in case you have more than one terminal) and choose this platform. I have done a similar thing with my broker. ---- you also mentioned you have tried =RTD("FXBlueLabs.ExcelRTD", ,"12345", "balance". Was this account...

Ignored

Quoting garfield75

Disliked

{quote} Template attached with VBA code. Since the site doesn't allow for any VBA/Macro enabled file to be updated. I have changed the extension to .xls so I could upload it. Please download the file. change the extension from .xls to .xlsm before opening the file. it is bare minimal code checking cell A1 value to execute a trade based on fixed parameters (buy 0.01 lot of EURUSD). All parameters can be configured to read from specific cells values in realtime. Cheers {file}

Ignored

Quoting garfield75

Disliked

{quote} Template attached with VBA code. Since the site doesn't allow for any VBA/Macro enabled file to be updated. I have changed the extension to .xls so I could upload it. Please download the file. change the extension from .xls to .xlsm before opening the file. it is bare minimal code checking cell A1 value to execute a trade based on fixed parameters (buy 0.01 lot of EURUSD). All parameters can be configured to read from specific cells values in realtime. Cheers {file}

Ignored

Quoting Moxy_UK

Disliked

{quote} Hi Mtharwat, I've reinstalled everything just now onto a 3rd PC. This time using a new Oanda Demo (https://www.oanda.com/us-en/trading/...um-indicators/) account instead of using the IG live account. Just to see if it was an IG issue. I still get exactly the same behaviour. {image}

Ignored

Quoting Moxy_UK

Disliked

{quote} Hi Mtharwat, I've reinstalled everything just now onto a 3rd PC. This time using a new Oanda Demo (https://www.oanda.com/us-en/trading/...um-indicators/) account instead of using the IG live account. Just to see if it was an IG issue. I still get exactly the same behaviour. {image}

Ignored

Quoting mtharwat

Disliked

{quote} Ok, I will just think out loud with you... Clearly, you have done all the steps correctly. And you also mentioned it is a PC, not mac. Is there any security box that needs to be disabled for API? Usually one gets a pop-up tab to enable the connection. I really wish if I can help you more. It is very weird. Why is it happening? Apart from the (Balance) you are trying to get, Have you tried opening any of the dashboards I shared here? Same problem? I would have said maybe because it is a demo account and the broker needs to be emailed first...

Ignored

Quoting JibalaPasan

Disliked

{quote} From the top menu choose "extras => options => experts" and show us the settings. Best of luck and stay green always! Jibala

Ignored

Quoting Moxy_UK

Disliked

{quote} {quote} mtharwat & JibalaPasan .... Thanks for the help. I finally Figured it out!!! Looking at the Excel Options => Add-ins page that shows all the Excel Add-ins that are installed, Active and Inactive. I noticed the fxbluelabs.excelrtd add-in was inactive and there was no Location showing where the file is located.. {image} So, I opened up the installation archive and manually extracted the FXBlueExcelRTD.dll file into a folder. Then I registered the DLL .. {image} The Excel Add-ins page now shows the add-in as active and the file location....

Ignored

Quoting garfield75

Disliked

{quote} Hey Nicholas87, This is the exact code you need to execute trades. Private Sub Worksheet_Calculate() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") If Range("A1") >= 10 Then strResult = cmd.SendCommand("xxxxxx", "BUY", "s=EURUSD|v=1000", 5) End If End Sub Replace xxxx with your account number. Make sure the "Accept Commands" is checked on excel RTD Link screen Let me know if you have any issue. Cheers {image}

Ignored

Quoting nicholas87

Disliked

{quote} how to control if i want buy only 1 time, if like (A1) >= 10 the excel will help me buy many time. thank you

Ignored

Quoting nicholas87

Disliked

{quote} how to control if i want buy only 1 time, if like (A1) >= 10 the excel will help me buy many time. thank you

Ignored

Quoting garfield75

Disliked

Hi Mtharwat, What is your thought on creating this in excel rtd for all timeframe? Cheers Garfield {image}

Ignored

Quoting JibalaPasan

Disliked

{quote} Did you hack my account? All over strength is something I'm looking into already. {image} {image} Actually, I don't trade it because I'm too much focused on the German DAX / GER30 where I gain the most of my profits. Best of luck and stay green always! Jibala

Ignored

Quoting garfield75

Disliked

Hi Mtharwat, What is your thought on creating this in excel rtd for all timeframe? Cheers Garfield {image}

Ignored