{quote} That implicates that the cell "C2" is changed manually but that never happens since you calculate the cell by reference to another cell. Therefore, you must adjust that piece of code and you have to work with "Private Sub Worksheet_Calculate()" instead. Best of luck and stay green always!Jibala
MT4 to Excel through Excel RTD (Finally!)
- #82
- Edited Oct 26, 2020 12:37am Oct 25, 2020 11:37pm | Edited Oct 26, 2020 12:37am
{quote} That implicates that the cell "C2" is changed manually but that never happens since you calculate the cell by reference to another cell. Therefore, you must adjust that piece of code and you have to work with "Private Sub Worksheet_Calculate()" instead. Best of luck and stay green always!
I will adjust the code and upload a new sheet.
- #85
- Edited 8:08am Oct 27, 2020 7:13am | Edited 8:08am
{quote} That implicates that the cell "C2" is changed manually but that never happens since you calculate the cell by reference to another cell. Therefore, you must adjust that piece of code and you have to work with "Private Sub Worksheet_Calculate()" instead. Best of luck and stay green always!
I got an error when I made the one change you mentioned (Calculate) instead of (Change)
{quote} Ok, sorry it was my mistake. VBA cannot interpret the pointer "RTD!A1", where RTD! is referring to the table and "A1" the cell with the account number. You have to hard code it with the account number instead! Accordingly to the manual: Private Sub CommandButton1_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(12345678, "BUY", "s=EURUSD|v=1500", 5) End Sub Private Sub CommandButton2_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(12345678, "SELL", "s=EURUSD|v=1500",...
I tried with my account number instead of referencing a cell. There is no error but there is no action either. When I click on the button nothing is bought or sold.
I am trying to find out in the documentation what is missing.
- #87
- Oct 27, 2020 1:49pm Oct 27, 2020 1:49pm
- Joined Jun 2014 | Status: Trader | 2,498 Posts
{quote} I tried with my account number instead of referencing a cell. There is no error but there is no action either. When I click on the button nothing is bought or sold. I am trying to find out in the documentation what is missing. {image}
Inserted Code
0 11:28:58.936 '1234567': order sell market 0.02 EURUSD sl: 0.00000 tp: 0.00000 1 11:28:59.106 '1234567': order sell 0.02 EURUSD opening at market sl: 0.00000 tp: 0.00000 failed [Market is closed] 0 11:29:22.278 '1234567': order sell market 0.02 EURUSD sl: 0.00000 tp: 0.00000 1 11:29:22.434 '1234567': order sell 0.02 EURUSD opening at market sl: 0.00000 tp: 0.00000 failed [Market is closed]
Best of luck and stay green always!
Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
- #89
- Edited 11:52am Oct 28, 2020 11:35am | Edited 11:52am
One more formula for calculating Currency strength.
This is something I created and I want to share it with you.
I am calculating strength in three time frames.
In each time frame, the formula is as follows
(Current Price - Low)/Low * 100 The result will always be positive
(Current Price - High)/High * 100 The result will always negative
Add the two results and if the net one is positive, it implies (potential) bullishness, and the opposite is true.
-----------------
I am attaching two workbooks: (One for Excel RTD) and another for (DDE MT4). The latter will obviously be for a one-time frame due to its limitations.
--------------
Excel RTD Workbook:
All you need to do is to type the time frames on the top right corner in the second sheet. All headers and charts will be adjusted accordingly.
And in the first one, you just type your account number in the top left corner.
---------------------------------------
DDE Workbook if you do not have Excel RTD
This is something I created and I want to share it with you.
I am calculating strength in three time frames.
In each time frame, the formula is as follows
(Current Price - Low)/Low * 100 The result will always be positive
(Current Price - High)/High * 100 The result will always negative
Add the two results and if the net one is positive, it implies (potential) bullishness, and the opposite is true.
-----------------
I am attaching two workbooks: (One for Excel RTD) and another for (DDE MT4). The latter will obviously be for a one-time frame due to its limitations.
--------------
Excel RTD Workbook:
All you need to do is to type the time frames on the top right corner in the second sheet. All headers and charts will be adjusted accordingly.
And in the first one, you just type your account number in the top left corner.
---------------------------------------
DDE Workbook if you do not have Excel RTD
{quote} Kindly check the MT4 logfiles. Maybe you'll find an entry there. 0 11:28:58.936 '1234567': order sell market 0.02 EURUSD sl: 0.00000 tp: 0.00000 1 11:28:59.106 '1234567': order sell 0.02 EURUSD opening at market sl: 0.00000 tp: 0.00000 failed [Market is closed] 0 11:29:22.278 '1234567': order sell market 0.02 EURUSD sl: 0.00000 tp: 0.00000 1 11:29:22.434 '1234567': order sell 0.02 EURUSD opening at market sl: 0.00000 tp: 0.00000 failed [Market is closed] Best of luck and stay green always!
- #92
- Oct 30, 2020 6:04am Oct 30, 2020 6:04am
- Joined Jun 2014 | Status: Trader | 2,498 Posts
{quote} Did you send those orders by clicking the "place trade" object yourself or done automatically when some conditions were met?
Best of luck and stay green always!
Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
- #94
- Oct 30, 2020 11:33am Oct 30, 2020 11:33am
- Joined Jun 2014 | Status: Trader | 2,498 Posts
Hello, I try to get the ADR with excel RTD but I get the value not valid... =RTD("fxbluelabs.excelrtd"; ; "6147013"; "@atr;GBPUSD;D1;20;0"). My other formulas are working
Best of luck and stay green always!
Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
