Welcome to Forex-TSD!, one of the largest Forex forums worldwide, where you will be able to find the most complete and reliable Forex information imaginable.
From the list below, select the forum that you want to visit and register to post, as many times you want. It’s absolutely free. Click here for registering on Forex-TSD.
Exclusive Forum
The Exclusive Forum is the only paid section. Once you subscribe, you will get free access to real cutting-edge Trading Systems (automated and not), Indicators, Signals, Articles, etc., that will help and guide you, in ways that you could only imagine, with your Forex trading.
Elite Section
Get access to private discussions, specialized support, indicators and trading systems reported every week.
Advanced Elite Section
For professional traders, trading system developers and any other member who may need to use and/or convert, the most cutting-edge exclusive indicators and trading systems for MT4 and MT5.
I will like to get some quotes and indicator data from my MT4 to excel spreadsheet.
can some one explain how to do it or direct me where I can learn to do so?
thanks.
Sorry if this is patronising (I'm new to all this too) but if you haven't already done this, open up the file DDE-Sample within your MT4 installation folder. This at least shows you how to get a live feed into excel. Beyond that you're into scripts and indicators which create csv files. These can then be imported into excel via macros but I'm struggling with this at the moment as you will see from my posts!
I will like to get some quotes and indicator data from my MT4 to excel spreadsheet.
can some one explain how to do it or direct me where I can learn to do so?
thanks.
The easiest way to export data is to use the history centre which allows you to export data to a comma seperated variable file that can be imported into excel.
I think the F2 key opens the history centre.
If you want indicator values, you'll need to write an indcator that writes the data you require to a text file. There are examples of these scattered around various forums, alternatively there are TA libraries that can be used with excel, again plenty of links on various forums to these libraries.
DDE might be useful, but its a right pain in the ass, and not really suppoted these days.
The easiest way to export data is to use the history centre which allows you to export data to a comma seperated variable file that can be imported into excel.
I think the F2 key opens the history centre.
If you want indicator values, you'll need to write an indcator that writes the data you require to a text file. There are examples of these scattered around various forums, alternatively there are TA libraries that can be used with excel, again plenty of links on various forums to these libraries.
DDE might be useful, but its a right pain in the ass, and not really suppoted these days.
Forexcashman being an enormous help to me, but zupcon, could you comment on importing data into an excel file from one of the csv files created by an indicator? Does the csv file need to be open if one writes a macro to get the info from the csv file?
There are several ways to get the CSV data into excel.
If your using Excel 2007 there's a data tab, with the option to import from a text file.
In earlier versions you need to use the file import wizard (I dont have an old version of excel so cant remember where this is found, probably under the data menu). Once the wizard starts it guides you step by step through the process, it allows you to pick the delimiter etc, drop unwanted columns etc
You can write a macro to read text files, but its not necessary, and unless your opening hundreds of files, probably not worth the effort.
Another option is to use star office, if you double click a text file the application is sensible enough to start the import wizard, and you coud always save the spreadsheet in XLS format if you really wanted to use Excel
There are several ways to get the CSV data into excel.
If your using Excel 2007 there's a data tab, with the option to import from a text file.
In earlier versions you need to use the file import wizard (I dont have an old version of excel so cant remember where this is found, probably under the data menu). Once the wizard starts it guides you step by step through the process, it allows you to pick the delimiter etc, drop unwanted columns etc
You can write a macro to read text files, but its not necessary, and unless your opening hundreds of files, probably not worth the effort.
Another option is to use star office, if you double click a text file the application is sensible enough to start the import wizard, and you coud always save the spreadsheet in XLS format if you really wanted to use Excel
hope this helps
That helps enormously. In 5mins look, it looks like you can set it to update itself automatically. What I can't see is how to only import say a few rows - otherwise I end up with so much data it's very cluttered.
Once setup, because it will refresh itself automatically I presumably then only have to worry about my indicator within MT4 which creates the csv files.... I haven't worked out yet whether the indicator simply writes over the previous file.....
I have only one tiny problem.
I get data out from indicator, saved as .txt or .csv.
That's ok.
But data is like 1.5898 and excel understands value like 1,5898.
For example, if I get tick data out, I can't make any charts out from that file because Excel don't understand those numbers because of that point (.).
Same thing with my custom indicator, always point inside the numbers.
Is there any way to make it write , instead of . ?
Or anybody knows how to make that change in Excel, so it will print out chart to web and updating it every 5sec?
Linear Mode
