How do I stream MT4 tick data into a spreadsheet using .CSV (no DDE)? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Formatting CSV tick data for MT4 0 replies

Tick Size, Tick Rate, Tick Spread, and Tick Logger indicators 36 replies

Getting MT4 data via DDE server using Python 4 replies

Stream Live data from CSV to MT4/5 2 replies

Attachments: How do I stream MT4 tick data into a spreadsheet using .CSV (no DDE)?
Exit Attachments

How do I stream MT4 tick data into a spreadsheet using .CSV (no DDE)?

  • #1
  • First Post: Edited Mar 27, 2011 7:50am Mar 26, 2011 11:48pm | Edited Mar 27, 2011 7:50am
I'd like to create a "live" spreadsheet for "real-time" visual analysis. So I need to be able to retrieve live tick data from MT4 and import to constantly updating spreadsheet. I understand that there might be a slight lag during the conversion/import process.

DDE is not an option. (1) Due to security risks (2) OpenOffice (Open Source) can't use it. (Excel is available if absolutely a must).

(Hints I've found: "collect data through CSV and not DDE"... and ... "Excel reads external data with auto-counter"... if that helps)

Thank you for the help.
  • #2
  • Mar 27, 2011 8:04pm Mar 27, 2011 8:04pm
http://www.forexfactory.com/showthre...36#post4135336

do a earch on sangmane
find his named pipes and xls examples.
  • #3
  • Mar 27, 2011 9:41pm Mar 27, 2011 9:41pm
Holister,

How competent are you with coding ? Reason I ask is that without DDE, coding will be required...

If you could do with candle completion and not tick data, then there are code examples posted on this forum that will export bars (history and updates) to a file.

This is not advertising (as it's free) but if you take a look at the link in my signature, you can download my analysis application and that has an EA which will download history of bars and update the file on completion of each new bar. Don't need to use the app if you don't want to, feel free to use the data exporter EA...
  • #4
  • Mar 27, 2011 9:43pm Mar 27, 2011 9:43pm
Sorry, forgot to mention that Excel has a 'timed' file import update function such that the new data would be reflected in the spreadsheet (don't know if OpenOffice has a similar function though...).

All the best.
  • #5
  • Edited Mar 28, 2011 7:41am Mar 27, 2011 11:09pm | Edited Mar 28, 2011 7:41am
Quoting TheGeneral

How competent are you with coding ? Reason I ask is that without DDE, coding will be required...
I'm no master coder but I can find my way around mql4 as well as Excel fairly well. Basic understanding though. This would be a great opportunity to take a step towards a higher level. Not afraid to dig

Quoting TheGeneral
... has a 'timed' file import update function... (don't know if OpenOffice has a similar function though...)
OpenOffice does too. I have Excel as well but if (when) I complete this project, I no longer have use for Windows. I trade for a living so I have plenty of time to do this while watching charts.

I know how to create the spreadsheet (formulas, etc...). Now I need to know how to feed the data to it in real time without using DDE.

Here is exactly what I'd like to accomplish.

Attached Image (click to enlarge)
Click to Enlarge Name: real_time01.jpeg Size: 59 KB

.
  • #6
  • Feb 21, 2012 10:37pm Feb 21, 2012 10:37pm
Anyone have more information on the application shown above?
  • #7
  • Last Post: Apr 5, 2017 5:03am Apr 5, 2017 5:03am
Quoting TheGeneral
Holister, How competent are you with coding ? Reason I ask is that without DDE, coding will be required... If you could do with candle completion and not tick data, then there are code examples posted on this forum that will export bars (history and updates) to a file. This is not advertising (as it's free) but if you take a look at the link in my signature, you can download my analysis application and that has an EA which will download history of bars and update the file on completion of each new bar. Don't need to use the app if you don't want...
dear sir i need to get OHLC from MT4 upon candle completion and not tick data, i want to download history of bars and update the file on completion of each new bar. but am almost ignorant in programming (my major is business), am fine in excel. can have a solution that does not require coding skills, if it is like pasting a code in meta editor or so.. is something i can do but not much more pls.you cooperation is highly appreciated, i can pay anyone who has the file.
0 traders viewing now