• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 3:38pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 3:38pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

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

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 227
Attachments: MT4 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

  • Last Post
  •  
  • 1 45Page 678 29
  • 1 5Page 67 29
  •  
  • Post #101
  • Quote
  • Nov 12, 2020 4:41am Nov 12, 2020 4:41am
  •  Dmh
  • | Joined Oct 2018 | Status: Member | 98 Posts | Invisible
Quoting martijn25
Disliked
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)
Ignored
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
 
 
  • Post #102
  • Quote
  • Nov 12, 2020 5:00am Nov 12, 2020 5:00am
  •  martijn25
  • | Joined Dec 2017 | Status: Member | 6 Posts
Quoting Dmh
Disliked
{quote} The candle before the candle with an open of 76.371 has an open of 76.507. {image}
Ignored
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?
 
 
  • Post #103
  • Quote
  • Nov 12, 2020 5:39am Nov 12, 2020 5:39am
  •  Dmh
  • | Joined Oct 2018 | Status: Member | 98 Posts | Invisible
Quoting martijn25
Disliked
{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?
Ignored
I don’t know, I’m not familiar with Excel RTD.
 
 
  • Post #104
  • Quote
  • Nov 12, 2020 1:59pm Nov 12, 2020 1:59pm
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,496 Posts
Quoting martijn25
Disliked
{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?
Ignored
Read the manual!

Quote
Disliked
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)
 
 
  • Post #105
  • Quote
  • Nov 12, 2020 4:49pm Nov 12, 2020 4:49pm
  •  antariks
  • | Joined Mar 2007 | Status: Member | 80 Posts
Quoting mtharwat
Disliked
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...
Ignored
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)
 
 
  • Post #106
  • Quote
  • Nov 13, 2020 4:28am Nov 13, 2020 4:28am
  •  martijn25
  • | Joined Dec 2017 | Status: Member | 6 Posts
Quoting JibalaPasan
Disliked
{quote} Read the manual! {quote} Best of luck and stay green always! Jibala
Ignored
I did but its not clear for me what formula to use when I want to refer to a current bar.
 
 
  • Post #107
  • Quote
  • Nov 13, 2020 10:42am Nov 13, 2020 10:42am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,496 Posts
Quoting martijn25
Disliked
{quote} I did but its not clear for me what formula to use when I want to refer to a current bar.
Ignored
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)
 
 
  • Post #108
  • Quote
  • Nov 13, 2020 2:35pm Nov 13, 2020 2:35pm
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,496 Posts
Quoting mtharwat
Disliked
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...
Ignored
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)
 
 
  • Post #109
  • Quote
  • Edited at 7:48pm Nov 13, 2020 7:32pm | Edited at 7:48pm
  •  mtharwat
  • Joined Aug 2015 | Status: Member | 978 Posts
Quoting JibalaPasan
Disliked
{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
Ignored

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.
 
 
  • Post #110
  • Quote
  • Nov 14, 2020 6:48am Nov 14, 2020 6:48am
  •  mattkirby
  • | Joined Mar 2012 | Status: being close on price secret's heel | 249 Posts
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
 
 
  • Post #111
  • Quote
  • Nov 14, 2020 8:34am Nov 14, 2020 8:34am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,496 Posts
Quoting mattkirby
Disliked
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
Ignored
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)
 
 
  • Post #112
  • Quote
  • Nov 14, 2020 11:21am Nov 14, 2020 11:21am
  •  mattkirby
  • | Joined Mar 2012 | Status: being close on price secret's heel | 249 Posts
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........
 
 
  • Post #113
  • Quote
  • Nov 14, 2020 11:55am Nov 14, 2020 11:55am
  •  JibalaPasan
  • Joined Jun 2014 | Status: Member | 2,496 Posts
Quoting mattkirby
Disliked
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........
Ignored
From the RTD manual:

Quote
Disliked
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)
 
 
  • Post #114
  • Quote
  • Nov 15, 2020 5:53am Nov 15, 2020 5:53am
  •  mattkirby
  • | Joined Mar 2012 | Status: being close on price secret's heel | 249 Posts
thank you Jibala. I must have overread this......
 
 
  • Post #115
  • Quote
  • Nov 15, 2020 11:53pm Nov 15, 2020 11:53pm
  •  dodiep
  • | Joined Nov 2020 | Status: Junior Member | 4 Posts
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 Images (click to enlarge)
Click to Enlarge

Name: dc91f88f56ec60c778d98553839ad0be.png
Size: 211 KB Click to Enlarge

Name: 1373383fe3dcc6f25afcde475408285c.png
Size: 197 KB
 
 
  • Post #116
  • Quote
  • Edited at 9:18pm Nov 16, 2020 8:52pm | Edited at 9:18pm
  •  mtharwat
  • Joined Aug 2015 | Status: Member | 978 Posts
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
File Type: xlsx Indicators Data with Concat Function.xlsx   25 KB | 219 downloads
 
 
  • Post #117
  • Quote
  • Nov 16, 2020 8:55pm Nov 16, 2020 8:55pm
  •  mtharwat
  • Joined Aug 2015 | Status: Member | 978 Posts
Quoting dodiep
Disliked
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}
Ignored
Mind if you share with me the exact formula you used. and then I will check it for you.
 
 
  • Post #118
  • Quote
  • Nov 16, 2020 8:58pm Nov 16, 2020 8:58pm
  •  mtharwat
  • Joined Aug 2015 | Status: Member | 978 Posts
Quoting mattkirby
Disliked
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........
Ignored
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.
 
 
  • Post #119
  • Quote
  • Nov 16, 2020 9:01pm Nov 16, 2020 9:01pm
  •  mtharwat
  • Joined Aug 2015 | Status: Member | 978 Posts
Quoting martijn25
Disliked
{quote} I did but its not clear for me what formula to use when I want to refer to a current bar.
Ignored
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.
 
 
  • Post #120
  • Quote
  • Nov 16, 2020 11:43pm Nov 16, 2020 11:43pm
  •  dodiep
  • | Joined Nov 2020 | Status: Junior Member | 4 Posts
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.
 
 
  • Platform Tech
  • /
  • MT4 to Excel through Excel RTD (Finally!)
  • Reply to Thread
    • 1 45Page 678 29
    • 1 5Page 67 29
0 traders viewing now
  • More
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2022