Export to Excel | Page 9 | Metals Mine

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

MT4 export to Excel? 8 replies

How do you Export MT4 price to Excel? 7 replies

Export to Excel 6 replies

Export OHLC to Excel 4 replies

Attachments: Export to Excel
Exit Attachments

Export to Excel

  • #161
  • Jan 13, 2014 12:00pm Jan 13, 2014 12:00pm
The file I have attached works for me. I essentially tell it to wait a certain number of ticks (default set to 5) after init/restart before running the full export. I don't know why it works since I tried a lot of other ways to no avail. I think there is either a bug associated with FileOpen/FileClose or there is something about how it works that is not specifically described/documented but I am no expert.

You can implement what I did and erase the debug variables I included if you wish. However, I'm a big fan of using DebugView with MQL4 so if you don't use it already, I encourage you to take a closer look.

Aim

Quoting ForceFollowr
I'm sorry, but after the changes described above the indicator works at the start of MT4, but it no longer refreshes the exported file. The reason, I suppose, is the code in point 4) should initiate that refresh process at the completion of the tfr bar and here it does nothing - no call to the Export() function, as there is no Export() function after I removed the void block. After many experiments with this code I have noticed that just doing without the 'void' structure and leaving that code in start() makes it start at the software opening and...
Attached File(s)
File Type: mq4 FXDataExport v2.mq4   16 KB | 978 downloads
  • #162
  • Jan 14, 2014 4:13am Jan 14, 2014 4:13am
Thank you very much, Aim! Yeah, you've made it work! What you've done way exceeded my expectations, so many thanks again! I didn't think of the funny tick countdown, but it seems to play a key role in your solution. :-) I like it, although, I'd rather not have it going after every change of time frame. You've also trimmed the figures to three decimal places, which is very reasonable. I only wonder, if the decimals are properly limited (according to the rules of statistical precision, like in the NormalizeDouble()) or are they simply cut to the third digit after the point? But overall, it works fabulously and I still explore the code within, as I'm not an IT developer, but just a trader, who wants to automate some manual work. I will check out DebugView, because I've never used it.
FF
  • #163
  • Jan 14, 2014 4:52am Jan 14, 2014 4:52am
This tickdata collector (indicator) will create a new .csv file everyday and constantly updates it, there is also a readme file for some advice and etc. - This indicator is downloaded from Armada Markets.

But when you open the .csv document, Metatrader 4 cannot update the contents of this opened file, so always copy paste this file to another location. - I am confident that the same rule will apply for all the EA-s or indicators which modify files.
Attached File(s)
File Type: mq4 TickDataCollector.mq4   3 KB | 906 downloads
File Type: txt Readme.txt   1 KB | 994 downloads
  • #164
  • Jan 14, 2014 10:23am Jan 14, 2014 10:23am
As far as the statistical precision, it appears DoubleToStr vs NormalizeDouble has the same precision up to 8 decimals when I compare them. However, I don't know that from any other source than my own testing so please check for yourself. Since the number of decimals is an external variable, you can set it to whatever you want if you need more than 3 decimals in your data.

As far as DebugView, check out the thread started with 7bit a few years ago. It should get you started. http://www.forexfactory.com/showthread.php?t=245303

Do you arbitrarily change time frames or do you always go through a certain set e.g. M30, H1, H4 etc to export data for each? If you always go through a certain set, why don't you set up an array with each of them like you did with Pair_Name[], loop through each of them and have the output file name be Outputfile + timeframe?

Aim

Quoting ForceFollowr
Thank you very much, Aim! Yeah, you've made it work! What you've done way exceeded my expectations, so many thanks again! I didn't think of the funny tick countdown, but it seems to play a key role in your solution. :-) I like it, although, I'd rather not have it going after every change of time frame. You've also trimmed the figures to three decimal places, which is very reasonable. I only wonder, if the decimals are properly limited (according to the rules of statistical precision, like in the NormalizeDouble()) or are they simply cut to the third...
  • #165
  • Jan 14, 2014 12:09pm Jan 14, 2014 12:09pm
So I'm OK with DoubleToStr and the decimal precision you've set, Aim. A very good job!
Yeah, I've already found that thread and I'm going to explore it, when I have more spare time.
I export only the data for H4 to my 'control centre' in Excel - that's where I manage the fx markets and build my database for further analysis. Currently I can't think of any use of other time frames other than for the charting and trading purposes. So H4 will certainly do for me. But I see your point - sure, if I needed to export the data for several time frames, a loop through each of them would be an indispensible solution here.
FF
  • #166
  • Jan 14, 2014 12:21pm Jan 14, 2014 12:21pm
Glad you find it useful. Based on your comment "I'd rather not have it going after every change of time frame" I thought you were changing the time frame parameter (by default set to 240) to get new values. Otherwise I didn't see a need to change the time frame at all, so the indicator would just keep running. For indicators/EAs like this, I just keep the in a separate chart so they don't interfere with my "trading" charts where have my trading EAs running.

FYI, I am "just a trader" too looking to automate as much as possible. Turns out, writing the code is the easy part...

Aim
  • #167
  • Feb 20, 2014 5:22pm Feb 20, 2014 5:22pm
Quoting hanover
{quote} Try this. {file} {file}
Dear hanover,

Could you update your indicator (Output History), which would be suitable for new MT4?

Thank You in advance.
  • #168
  • Feb 20, 2014 9:32pm Feb 20, 2014 9:32pm
Quoting GKarl
{quote} Dear hanover, Could you update your indicator (Output History), which would be suitable for new MT4? Thank You in advance.
MetaQuotes assure us that .ex4 files that ran correctly on build 509 will continue to do so on build 600 onward. Simply copy the .ex4 file to the new location, NOT the .mq4 file. This video by CompassFX explains how.

I can not update the .mq4 program code, because I’m not fully conversant with the new programming language. Hence I won't be updating any of my indicators or EAs, or undertaking any more MT4 programming projects. If you really need the .mq4 file, you could try posting your request in one of the "I code your indicators for free" threads.
  • #169
  • Feb 21, 2014 5:00am Feb 21, 2014 5:00am
Hanover,
Thnx for the tip. i was searching for the solution. Also i know u are so busy. Good work again.
  • #170
  • Feb 21, 2014 6:44am Feb 21, 2014 6:44am
Quoting GKarl
{quote} Could you update your indicator (Output History), which would be suitable for new MT4? T
It work in MT 604 for me
  • #171
  • Feb 21, 2014 9:46am Feb 21, 2014 9:46am
Thank You hanover, it works for me too.
  • #172
  • Apr 25, 2014 2:01pm Apr 25, 2014 2:01pm
Quoting hanover
{quote} For example, to output data for a 5 period SMA of the Close price, simply add the code in red typeface:FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iMA(ccy,tf,5,0,MODE_SMA,PRICE_CLOSE,i)); {file}
Could you please help me with iATR? It doesn't change. iMa is working...

A picture attached.

nchosen
Attached Image (click to enlarge)
Click to Enlarge Name: iatr.jpg Size: 94 KB
  • #173
  • Apr 25, 2014 3:34pm Apr 25, 2014 3:34pm
I'm no expert, but you've put zero as 'int shift', whereas you probably wanted to put an 'i'.
Try this: iATR(NULL, PERIOD_D1, 14,i).
FF
  • #174
  • Apr 25, 2014 3:55pm Apr 25, 2014 3:55pm
Quoting nchosen
{quote} Could you please help me with iATR? It doesn't change. iMa is working... A picture attached. nchosen {image}
if you would like to see a faster changing atr value just change PERIOD_D1 to PERIOD_M1 ...
PM me with coding requests and I'll probably put you on my ignore list
  • #175
  • May 17, 2014 9:41am May 17, 2014 9:41am
Quoting ForceFollowr
I'm no expert, but you've put zero as 'int shift', whereas you probably wanted to put an 'i'. Try this: iATR(NULL, PERIOD_D1, 14,i).
Sorry for a late reply.

Thank you FF and fxdaytrader. That "i" did the trick.

nchosen
  • #176
  • Aug 12, 2014 3:26am Aug 12, 2014 3:26am
Is it possible to export the indicator valve to CSV file every tick with time in ?
  • #177
  • Aug 12, 2014 5:05am Aug 12, 2014 5:05am
Quoting sunyc1982
Is it possible to export the indicator valve to CSV file every tick with time in ?
I think you mean "indicator value". You can do it - every minute - with my file (working thanks to superb modification by AimHigher, please find enclosed my v.4). But every tick? I don't know; perhaps there is a way to do it?
Attached File(s)
File Type: mq4 FXDataExport v4.mq4   18 KB | 987 downloads
FF
  • #178
  • Sep 23, 2014 10:55am Sep 23, 2014 10:55am
Quoting ForceFollowr
{quote} I think you mean "indicator value". You can do it - every minute - with my file (working thanks to superb modification by AimHigher, please find enclosed my v.4). But every tick? I don't know; perhaps there is a way to do it? {file}
can't mange exporting data indicator to excel..plz help
http://i61.tinypic.com/2ceiuc4.jpg
  • #179
  • Sep 23, 2014 4:04pm Sep 23, 2014 4:04pm
i founded this site but i can't determine the appropriate version
https://fx1.net/excellink.php#excelsheetrename
  • #180
  • Sep 24, 2014 9:42pm Sep 24, 2014 9:42pm
hi guys....
can't hear from you....i founded that one can export data values via c++ library dell
any help???
0 traders viewing now