Need help exporting mt4 data | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Exporting historical data from mt4 4 replies

Exporting live MT4 data to a wordpress website 6 replies

Printing/Exporting/Clipboard the Content of the MT4 Alert Window 3 replies

Simple way of exporting MT4 data from Data Window into Excel? 2 replies

Exporting MT4 data to Excel 7 replies

Attachments: Need help exporting mt4 data
Exit Attachments

Need help exporting mt4 data

  • #1
  • First Post: Jun 1, 2011 7:06am Jun 1, 2011 7:06am
As the title indicates, I'm looking for someone that would know how to export stochastic values from mt4 into a spreadsheet. Is this possible using DDE? Or is it more involved than that? Any help would be appreciated.

Cope
  • #2
  • Jun 1, 2011 10:43am Jun 1, 2011 10:43am
There have been many, many threads on this subject. The best way to do it is a script that writes a CSV file.
  • #3
  • Jun 1, 2011 12:57pm Jun 1, 2011 12:57pm
Thanks for taking your time and replying CodeMeister. However, I haven't been able to find one of these many, many threads that you claim exist and I don't really have the time to dig through all of FF. I'm still hoping that someone can share further insight or a script, as CM put it, that will help me to accomplish what I would like.
  • #4
  • Jun 1, 2011 1:26pm Jun 1, 2011 1:26pm
i copy pasted this straight from some scripting i did the other day so you will have to make it work for what you are doing, but at least you can see one way to get data in and out. mt4 handles files in the most backwards dumbfuckery way and the help file is next to useless for it.

this spits out 5 lines of data in one go...

Inserted Code
    if (doneinit && WriteNewFile) {
      stemp = "nb" + Symbol() + Period() + FileExtension;
      if (filehandle == 0) filehandle = FileOpen(stemp, FILE_BIN|FILE_WRITE);
      stemp = Time[1] + "rn" + Open[1] + "rn" + High[1] + "rn" + Low[1] + "rn" + Close[1]+ "rn";
      FileWriteString(filehandle, stemp, StringLen(stemp));
    }

blah, the forum strips out slashes in \ r \ n (imagine no spacing), so the rn above should have slashes to left of the r and n. that's to write the return carriage and then new line ascii codes. you could replace the numerous "rn" with "," to create an actual csv file, keeping in mind you still require the ending one to signal a new row... but you can figure that out i'm sure. or you could try to figure out how to actually use the file_csv type for outputting to file.

and this reads the data in line by line...

Inserted Code
  string stemp;  

  stemp = "nb" + ShowSymbol + Period() + FileExtension;
  filehandle = FileOpen(stemp, FILE_CSV|FILE_READ);
  if (filehandle > 0) {
    IndicatorShortName(ShowSymbol);
    count = 0;
    while(!FileIsEnding(filehandle)) {
      count++;
      stemp = FileReadString(filehandle);  //dt
      if (stemp != "") {
        ArrayResize(datearray, count);
        ArrayResize(openarray, count);
        ArrayResize(higharray, count);
        ArrayResize(lowarray, count);
        ArrayResize(closearray, count);
        
        datearray[count-1] = StrToDouble(stemp);        
        stemp = FileReadString(filehandle); //o
        openarray[count-1] = StrToDouble(stemp);
        stemp = FileReadString(filehandle);  //h
        higharray[count-1] = StrToDouble(stemp);
        stemp = FileReadString(filehandle);  //l
        lowarray[count-1] = StrToDouble(stemp);
        stemp = FileReadString(filehandle);  //c
        closearray[count-1] = StrToDouble(stemp);
      }
    }  
    FileClose(filehandle); 
  }

  doneinit = false;
  filehandle = 0;
  
  arrayindex = 0;
i don't do error checking. this is possibly the worst way to do it... but you should be able to see how you can dump any type of data out, even an actual csv file, and also read data in.
Congratulations ScalaFX for coming out of the closet!
  • #5
  • Jun 1, 2011 8:26pm Jun 1, 2011 8:26pm
Thanks Nubcake, I'll see if I can get this to do what I am looking for.
  • #6
  • Jun 2, 2011 12:57am Jun 2, 2011 12:57am
Quoting Cope
However, I haven't been able to find one of these many, many threads that you claim exist and I don't really have the time to dig through all of FF.
I found this one in less than 30 seconds using the FF search engine.

Anyway, no matter, I've attached a script (install it in your scripts folder) that will output stochastic(8,3,3) values, for the pair/timeframe of the chart it's attached to. It can easily be modified to perform just about any type of historical output.
Attached File(s)
File Type: mq4 output_history.mq4   4 KB | 440 downloads
  • #7
  • Jun 2, 2011 6:57am Jun 2, 2011 6:57am
It's no wonder why I don't post here much, or anywhere for that matter. The internet is full of those on their soapboxes. Hanover, I appreciate your link, but was it really necessary to point out that you're so good you found it in 30 seconds?
  • #8
  • Jun 2, 2011 7:44am Jun 2, 2011 7:44am
the gods help those who help themselves
Old Benjamin was right
  • #9
  • Jun 2, 2011 1:05pm Jun 2, 2011 1:05pm
There is only one true God, it's not plural..and by simply asking the question I fulfilled that prophecy.
  • #10
  • Last Post: Jun 2, 2011 1:09pm Jun 2, 2011 1:09pm
Anyway, I'm done here. I've searched and did not find what I'm looking for here. You've heard the last from me so you can move on and berate others now. What a great community this use to be...now it seems like the Chicago Cubs message board.
0 traders viewing now