Export to Excel | Page 11 | Forex Factory

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

  • #201
  • Jan 16, 2018 12:17pm Jan 16, 2018 12:17pm
Quoting Jehan
I would like to use this out_hist indicator with the CCFp indicator. I think, I put the code to the right place....When I do the compile: no errors, but when I put the Indi on a chart the MT4 is total frozen...do not work...
I compiled your mq4 file using the build 509 compiler and I have attached the resulting ex4. I ran the ex4 on my computer with the attached CCFp.ex4 present, and I got the output in the attached zip file after a short delay without any problem.

I don't know what version of CCFp you are using, but its input parameters must match those in any iCustom() statement that calls it, otherwise the results will be unpredictable.

I do all my coding using the Metaeditor/compiler build 509. If you are using a later MT4 build to compile your mq4 files, I cannot reproduce your results and you will need to find another programmer to help you.
Attached File(s)
File Type: zip GBPUSD,15.zip   733 KB | 1,156 downloads
File Type: ex4 out_hist (1).ex4   4 KB | 1,042 downloads
File Type: ex4 CCFp.ex4   19 KB | 1,019 downloads
  • #202
  • Jan 16, 2018 12:40pm Jan 16, 2018 12:40pm
Quoting hanover
{quote} I compiled your mq4 file using the build 509 compiler and I have attached the resulting ex4. I ran the ex4 on my computer with the attached CCFp.ex4 present, and I got the output in the attached zip file after a short delay without any problem. I don't know what version of CCFp you are using, but its input parameters must match those in any iCustom() statement that calls it, otherwise...

Hello Hanover

I use the 1090 build MT4.
I try your version out_hist with the version from CCpf installed on my PC...... do not work...ach....
And then I try with your version from CCPf and it works very fine....
I am happy....thanks a lot Hanover.....wish you a very good 2018 year !
  • #203
  • Feb 28, 2018 11:10am Feb 28, 2018 11:10am
Hi,

I am searching for a script that can export Price Data from Renko Chart in Metatrader to Excel. In this thread Page 4, Post 78 a script "FXPT CSV3 Modified.mq4" was shared by Cyber1.

https://www.forexfactory.com/showthr...37#post5555037

But, using this script I am unable to export Price Data of Stock Charts, it only works for Currencies. I am not an MQL4 programmer so I don't know what changes to make in the script so that it can work for all types of symbols. I would be truly grateful if someone could either make this script do the needful or could suggest any other indicator or script. Thanks.
  • #204
  • Mar 1, 2018 1:38am Mar 1, 2018 1:38am
As I was searching on the internet for script/indicator to export renko price data from metatrader to excel I stumbled upon a code. I placed that code in metaeditor, but its showing some errors. Can someone help me by telling me what to change in this code to make it work? Here is the code:

--------------------------------------
void export() {

string file="export_"+Symbol()+"_"+Period()+".csv";
int f=FileOpen(file,FILE_CSV|FILE_WRITE,",");

if(f<1) {
Alert("File opening error");
return(0);
}

for(int i=0;i<Bars;i++) {
FileWrite(f,TimeToStr(Time[i],TIME_DATE|TIME_MINUTES),
Open[i],High[i],Low[i],Close[i]);
}

Alert("Export "+Symbol()+" finished. Exported: "+Bars+" records");

FileFlush(f);
FileClose(f);

}
--------------------------------------

I hope someone can help me with this code. Thanks.
  • #205
  • Mar 21, 2018 3:46pm Mar 21, 2018 3:46pm
Can any one fix this indicator to allow to export non-standard instrument names?
It wont export any cfd instruments like "#C-CORN" for examples from ifcmarkets.
  • #206
  • Apr 30, 2018 4:11pm Apr 30, 2018 4:11pm
Quoting hanover
{quote} I realize that the original post is over 2 months old. However, if anybody wants to export data to a CSV file, I have written the out_hist.mq4 indicator (attached to this post). Currently it outputs only OHLCV, but the line that readsFileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i)); could easily be adapted to add data from any indicator. 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,...
Nearly perfect for me but when i start to import the csv in to my offline MT4 it shows nothing,maybee its an issue becouse the generated csv is endless in colums...haw can we fix that ? thnaks
  • #207
  • Last Post: Mar 14, 2020 3:14pm Mar 14, 2020 3:14pm
very informative thread. Thank you
1 trader viewing now