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

  • #101
  • Nov 12, 2020 3:41am Nov 12, 2020 3:41am
Quoting martijn25
I am wondering why I see differences on the charts open on mt4 and the open I get in excel RTD anyone familiar with this problem? for example for audjpy I see an open of 76.507 in rtd and a open of of 76.371 on the chart. A difference of 13 pips... Formula I use for open =RTD("fxbluelabs.excelrtd"; ;$B$1;"@bh,AUDJPY,60,open,"&0)
The candle before the candle with an open of 76.371 has an open of 76.507.
Attached Image (click to enlarge)
Click to Enlarge Name: bd019595d9ddd7eda74b42dd5c656b07.png Size: 18 KB
  • #102
  • Nov 12, 2020 4:00am Nov 12, 2020 4:00am
Quoting Dmh
{quote} The candle before the candle with an open of 76.371 has an open of 76.507. {image}
I get it now the open is 8.00 but how to get the open of the last candle instead of the open candle of 8.00?
  • #103
  • Nov 12, 2020 4:39am Nov 12, 2020 4:39am
Quoting martijn25
{quote} I get it now the open is 8.00 but how to get the open of the last candle instead of the open candle of 8.00?
I don’t know, I’m not familiar with Excel RTD.
  • #104
  • Nov 12, 2020 12:59pm Nov 12, 2020 12:59pm
Quoting martijn25
{quote} I get it now the open is 8.00 but how to get the open of the last candle instead of the open candle of 8.00?
Read the manual!

Quote
2.3.4.3 Bar shift

The final part of the price history formula is the bar "shift", i.e. which bar to get information about. Bars are numbered with the newest at zero, and increasing in order of age. In other words, bar 0 is the current in-progress bar; bar 1 is the last complete bar etc.

Therefore, the close price on bar 0 (for any timeframe) is the current bid price. In effect, the following two formulas are identical:

=RTD("FXBlueLabs.ExcelRTD", , "156734", "bidGBPUSD")
=RTD("FXBlueLabs.ExcelRTD", , "156734", "@bh,GBPUSD,60,close,0")

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #105
  • Nov 12, 2020 3:49pm Nov 12, 2020 3:49pm
Quoting mtharwat
Hello everyone, I am still looking for a solution for initiating an order (Buy/Sell, close, etc..) based on referencing another cell. For example, if Cell (B10) equals a value, then Buy or sell or close. If anyone has done it, then post your sheet with the embedded VBA/Formula. And I am not referring to Blue Labs sample sheet with clickable buttons. The problem is in referencing another cell. Ultimately, I am looking for a sample sheet that contains different buy/sell/close orders including partial closes so it is a full rounded sheet with all the...
We are pending on this for a long time and no one seems to have a solution
Automation is out of question without this

This is the original code. An additional condition need to be inserted, something like "If A1>0.001"

' Create the FXBlueLabs.ExcelCommand object and send the command
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.sendCommand(strAccount, strCommand, strParameters, lTimeoutSeconds)
  • #106
  • Nov 13, 2020 3:28am Nov 13, 2020 3:28am
Quoting JibalaPasan
{quote} Read the manual! {quote} Best of luck and stay green always! Jibala
I did but its not clear for me what formula to use when I want to refer to a current bar.
  • #107
  • Nov 13, 2020 9:42am Nov 13, 2020 9:42am
Quoting martijn25
{quote} I did but its not clear for me what formula to use when I want to refer to a current bar.
Sorry, but what's not clear on that statement?

In other words, bar 0 is the current in-progress bar; bar 1 is the last complete bar etc.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #108
  • Nov 13, 2020 1:35pm Nov 13, 2020 1:35pm
Quoting mtharwat
Hello everyone, I am still looking for a solution for initiating an order (Buy/Sell, close, etc..) based on referencing another cell. For example, if Cell (B10) equals a value, then Buy or sell or close. If anyone has done it, then post your sheet with the embedded VBA/Formula. And I am not referring to Blue Labs sample sheet with clickable buttons. The problem is in referencing another cell. Ultimately, I am looking for a sample sheet that contains different buy/sell/close orders including partial closes so it is a full rounded sheet with all the...
Wrong approach!
You should have a strategy at the first. Secondly, test your strategy. This is very important to know if the signals coming from your strategy are good enough. Execute the trades manually from within your Excel Sheet. If everything works fine, think about how to automate the execution thru VBA.

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2020.11.13_15h30m43s_005_GAP-Scalper-GER30-xlsb.png Size: 50 KB
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2020.11.13_15h57m12s_006_.png Size: 74 KB

I think I have a good strategy so far although it's not automated yet. This will come with the next version.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #109
  • Edited 6:48pm Nov 13, 2020 6:32pm | Edited 6:48pm
Quoting JibalaPasan
{quote} Wrong approach! You should have a strategy at the first. Secondly, test your strategy. This is very important to know if the signals coming from your strategy are good enough. Execute the trades manually from within your Excel Sheet. If everything works fine, think about how to automate the execution thru VBA. {image}{image} I think I have a good strategy so far although it's not automated yet. This will come with the next version. Best of luck and stay green always! Jibala

It is not a wrong approach!

I simply want to create something similar to a money management EA.
For example, I am entering a trade with partial orders and then will do partial closes and each partial lot will have its own trailing stop/step trailing stop after break-even, etc...

I have been trading for almost two decades H4/Daily/Weekly and also M15/H4 intraday trading for forex and stocks. I have a thread for my trading in my other thread https://www.forexfactory.com/thread/...s-and-entering?

With regard to me posting a few ideas about percentage changes, that is to encourage others to learn about Excel and offer them a tool to try our their ideas.
Another thing is that I am trying in my free time (when I am not trading) to create strategies for scalping but this is a different story. Also trying to create a "heads-up" tool based on certain conditions to point me at checking good potential trading setups for intraday or long term without the need to check each chart individually every day and this includes stocks as well!

The main interest for me at the moment is to create a money management tool through Excel.
  • #110
  • Nov 14, 2020 5:48am Nov 14, 2020 5:48am
Hi guys, glad to find this thread here

I have a problem hope someone can help me

I want to import M5 data from all the 28 majors (288 for 1 day, open,close,high and low) but after importing 600 - 700 datas my excel alway crashs down.

Is the import of data limited? can I change this somewhere?

Mike
  • #111
  • Nov 14, 2020 7:34am Nov 14, 2020 7:34am
Quoting mattkirby
Hi guys, glad to find this thread here I have a problem hope someone can help me I want to import M5 data from all the 28 majors (288 for 1 day, open,close,high and low) but after importing 600 - 700 datas my excel alway crashs down. Is the import of data limited? can I change this somewhere? Mike
It's hard to give an or the right answer as long as you don't tell us about how you try to import data into M$ Excel.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #112
  • Nov 14, 2020 10:21am Nov 14, 2020 10:21am
I do it via Excel RTD function with metatrader 4.

At some amount of imported data my excel crashes down. Till that point everything works fine........
  • #113
  • Nov 14, 2020 10:55am Nov 14, 2020 10:55am
Quoting mattkirby
I do it via Excel RTD function with metatrader 4. At some amount of imported data my excel crashes down. Till that point everything works fine........
From the RTD manual:

Quote
2.3.4.3 Bar shift
[...]
The amount of data available on each timeframe depends on the underlying platform, but will typically be around 250 bars.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #114
  • Nov 15, 2020 4:53am Nov 15, 2020 4:53am
thank you Jibala. I must have overread this......
  • #115
  • Nov 15, 2020 10:53pm Nov 15, 2020 10:53pm
Hi you guys,
Did you trust this method? when I checked the open price of day and week with ICmartkets, I found that the data was modified.

You see the open price of GU: 1.31664, but the data from RTD is 1.322. I check others also, and give a conclusion: the data can't trust.

How about your RTD with others brokers?
Attached Image(s) (click to enlarge)
Click to Enlarge Name: dc91f88f56ec60c778d98553839ad0be.png Size: 211 KB
Click to Enlarge Name: 1373383fe3dcc6f25afcde475408285c.png Size: 197 KB
  • #116
  • Edited 8:18pm Nov 16, 2020 7:52pm | Edited 8:18pm
Retrieving Indicators Data with "Concat" Function:

Attached a workbook with a number of indicators with Concat function. It is tricky sometimes. If you need other indicators, it will be much easier to just change the indicator name in the formula. For example, @RSI could be @CCI, for indicators that require one input. If you are new to EXCEL in general, look at the dollar sign and see which cells are fixed and which ones are not to learn about it.

Each sheet in the workbook represents a time frame. If you need more time frames, then just copy the sheet (from the bottom tab that has the name of the sheet) and then choose other time frames. I have two sheets already in the workbook.

All you need to do is to type the timeframe you want to retrieve. I found that allocating a sheet for each time frame is easier for referencing cells later on. Each sheet has in its top row fileds including account number, time frame, lookback period (0 for the current bar), and open/high/low/close. you can get high/low data for some indicators. The latter is left at close by default.
NB: After you type your account number, please give the workbook sometime to load the data.

Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot (5).png Size: 58 KB
Attached File(s)
File Type: xlsx Indicators Data with Concat Function.xlsx   25 KB | 696 downloads
  • #117
  • Nov 16, 2020 7:55pm Nov 16, 2020 7:55pm
Quoting dodiep
Hi you guys, Did you trust this method? when I checked the open price of day and week with ICmartkets, I found that the data was modified. You see the open price of GU: 1.31664, but the data from RTD is 1.322. I check others also, and give a conclusion: the data can't trust. How about your RTD with others brokers? {image} {image}
Mind if you share with me the exact formula you used. and then I will check it for you.
  • #118
  • Nov 16, 2020 7:58pm Nov 16, 2020 7:58pm
Quoting mattkirby
I do it via Excel RTD function with metatrader 4. At some amount of imported data my excel crashes down. Till that point everything works fine........
There are also other factors involved:
1- The internet speed. It does wonders when it is good. (From Experience)
2- The PC/Laptop capabilities. It makes a difference too based on my experience.
  • #119
  • Nov 16, 2020 8:01pm Nov 16, 2020 8:01pm
Quoting martijn25
{quote} I did but its not clear for me what formula to use when I want to refer to a current bar.
Hello,
Sorry for my late reply.
Are you still having difficulties? Please let me know.
Have you tried any of the workbooks I have attached here for percentage change and currency strength. Those workbooks have sheets allocated for retrieving data. You can change close to ope, etc.. I believe some of them already have close/open/high/low fileds.
  • #120
  • Nov 16, 2020 10:43pm Nov 16, 2020 10:43pm
Thank mtharwat,
I figured out my problem, due to internet latency and maybe my PC too, so the open price from RTD and history is not the same.
When I restart it several time, it's fine now.
0 traders viewing now