Export to Excel | Page 10 | Crypto Craft

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

  • #181
  • Nov 6, 2014 9:41am Nov 6, 2014 9:41am
Hi parties to this thread.
This is exactly the folks I'm looking for regarding interfacing with Discipulus (rmltech.com)
Here's my idea, After coming up with a basic strategy with StrategyQuant the pseudocode is available to show the indies and the EA is available from it.
I'm thinking place these indies on max historical not-online chart at the SQ recommended settings and whatever indy you folks came up with to shove all that data to excel and then Discipulus imports and churns. As I recall playing with Discipulus 5yrs ago you can ask it to do 1/0 outputs for ideal points vs the points to open/close as the strategy found, the ideal points may need be enterred by hand, but Discipulus will find what points can be had as a solution mathematically.

Reason I bring it up and found this thread is I don't know if I can have StrategyQuant nor forexsb do pure math geneticism, so wildly thinking aloud thought of any indy that can splay all chart data. Playing with Discipulus 5yrs ago I "felt" the power of it and can never forget the awestruckness I got from it. You can do a trial of it for couple weeks if you are curious.

Well, putting it out there.

Truly,
Jerry
  • #182
  • Apr 10, 2015 11:46am Apr 10, 2015 11:46am
Is there any way (with an Indicator/ Script/r EA) to collect some specific objects (like all Horizontal-lines or so ) in 1 Chart and import it to an Excel-file to export this list of objects into an other Platform???
Thanks for any help here as I cannot make it work after many hours of trying.
Thanks.
Zack
  • #183
  • Apr 10, 2015 5:11pm Apr 10, 2015 5:11pm
Quoting zackery
Is there any way (with an Indicator/ Script/r EA) to collect some specific objects (like all Horizontal-lines or so ) in 1 Chart and import it to an Excel-file to export this list of objects into an other Platform??? Thanks for any help here as I cannot make it work after many hours of trying. Thanks. Zack
Zack,

I don't know if it will do what you require, but you could try the attached script which I wrote several years ago. There's no point in my supplying the .mq4 files as they won't compile in MT4 builds later than 509. It's offered on a 'take it or leave it' basis as I'm no longer undertaking programming requests.

David
Attached File(s)
File Type: ex4 List Object Details.ex4   47 KB | 853 downloads
  • #184
  • Apr 10, 2015 5:45pm Apr 10, 2015 5:45pm
@hanover:
perfect.Thanks a lot.
Is it possible that you could share the .mq4-file because I am working with a Programmer who should be able to translate this file into the newer MT4-600builds
for sure.
I think there will be some changes for my needs with this script.So I appreciate if you could give me the -mq4-file .
Thanks.
Regards Zack
  • #185
  • Apr 10, 2015 5:51pm Apr 10, 2015 5:51pm
Quoting zackery
Is it possible that you could share the .mq4-file because I am working with a Programmer who should be able to translate this file into the newer MT4-600builds
Here it is. He will also need the library files from this thread.
Attached File(s)
File Type: mq4 List Object Details.mq4   3 KB | 868 downloads
  • #186
  • Nov 15, 2015 4:48am Nov 15, 2015 4:48am
  •  Neio
  • Joined Oct 2012 | Status: Can't think outside?Enlarge the box | 688 Posts
Hi,

Appreciate if someone could kindly write a script that enables me to export the swing points created by the attached indicator into Excel for analysis please.

Regards

Neio
Attached File(s)
File Type: mq4 SemaphorPrice2.mq4   7 KB | 933 downloads
An expert is a man who has made all the mistakes which can be made
  • #187
  • Nov 16, 2015 4:38am Nov 16, 2015 4:38am
  •  Neio
  • Joined Oct 2012 | Status: Can't think outside?Enlarge the box | 688 Posts
Quoting Neio
Hi, Appreciate if someone could kindly write a script that enables me to export the swing points created by the attached indicator into Excel for analysis please. Regards Neio {file}
Lol don't all rush at once!

Just to say that a friend sorted this for me, so please ignore this request now.
An expert is a man who has made all the mistakes which can be made
  • #188
  • Feb 23, 2016 8:34pm Feb 23, 2016 8:34pm
Hi all,

I have googled around but i need confirmation

Is it still not possible to export price + indicator value out to excel?

thanks
  • #189
  • Apr 24, 2016 12:34pm Apr 24, 2016 12:34pm
Hello.

See my post above 181.

If anyone can help then you'd have free setup of said EA developer package project. (You'd still need lease for yourself Discipulus)

Am at initial pondering development phase.

Need an EA that spits not only OHL of chart into excel but also the in-between ticks and their time and any indy on chart output data.

Hmmm, perhaps the above posts is sufficient?

Truly,
Jerry
  • #190
  • Apr 25, 2016 7:23am Apr 25, 2016 7:23am
Am having Witold of mqlsoft.com quote me on complete EA job that would assign a named file, load it with both bar and data named indies placed on chart and while still attached to chart would continue updating the file upon new bars completed. The re-initializing of EA I spec to not wreck data stored thus far.

Would anyone like to share in the cost to also have said EA?

Even if not interestd in this being highly conducive for Discipulus thrashing you may have another use for it.

Thx.
  • #191
  • Dec 30, 2016 8:48am Dec 30, 2016 8:48am
Quoting hanover
{quote} Here it is. He will also need the library files from this thread. {file}
Hi Hanover,
I tried your code on the CCFp indicator. It is a currency meter kind of indicator that gives a number for eight major currency. I want to export like a year reading to excel.
I tried this:
FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,i) );

And I get the History output complete, but I can't find the file. Can you please take a look at the code? If it should work, where should I find the excel file? Thanks.
Attached File(s)
File Type: ex4 CCFp.ex4   19 KB | 684 downloads
  • #192
  • Dec 31, 2016 7:55am Dec 31, 2016 7:55am
Quoting ljiangd
I tried this: FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,i) );
I downloaded your attached CCFp indicator, and the parameters appear in the screenshot below. The parameters highlighted in yellow appear to be missing from your iCustom() call (which I've highlighted in red in the quoted text above). Check the correct format for the iCustom() function here.

As far as I know, the output file should be created in your .../MQL4/Files folder.

Also, the indicator I wrote was coded to run in MT4 build 509. It may compile with errors, or might otherwise work incorrectly, in build 600 or later.
Attached Image (click to enlarge)
Click to Enlarge Name: PPI 092.png Size: 42 KB
  • #193
  • Dec 31, 2016 9:21am Dec 31, 2016 9:21am
Quoting hanover
{quote} I downloaded your attached CCFp indicator, and the parameters appear in the screenshot below. The parameters highlighted in yellow appear to be missing from your iCustom() call (which I've highlighted in red in the quoted text above). Check the correct format for the iCustom() function here. As far as I know, the output file should be created in your .../MQL4/Files folder. Also, the indicator I wrote was coded to run in MT4 build 509. It may compile with errors, or might otherwise work...
Happy new year and thanks for spending time help us during the holiday!!
I didn't change my code yet. Just searched the file and I did find it. It has the output. It just has the indicator reading for one currency EUR. This indicator has the reading for eight currency. How can I change the code to get all the readings? Or at least get them one by one? Thanks again.
  • #194
  • Edited Jan 1, 2017 11:17am Dec 31, 2016 12:30pm | Edited Jan 1, 2017 11:17am
Quoting ljiangd
How can I change the code to get all the readings? Or at least get them one by one?
Try something like this (CCFp parameter settings shown with yellow highlight):

FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i),
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,0,i), // USD
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,1,i), // EUR
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,2,i), // GBP
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,3,i), // CHF
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,4,i), // JPY
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,5,i), // AUD
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,6,i), // CAD
iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,7,i)); // NZD


How to use iCustom (general notes)

The format for iCustom is:

iCustom (symbolID, timeframe, "indicator name", P1, P2, P3, P4, ..... ,Pn, buffer#, datapoint#)

where:
symbolID is the ID for the currency pair/instrument (e.g. "EURUSD");
timeframe is the timeframe (1=M1, 5=M5, 15=M15, 30=M30, 60=H1, 240=H4, 1440=daily, 10080=weekly, 43200=monthly);
"indicator name" is the name of the indicator whose values will be used;
P1, P2, P3, etc are the values of first parameter, second parameter, third parameter, etc to be passed to the indicator;
buffer# (0,1,2,...7) is which line (data set) to use;
datapoint# (0,1,2,3,...) is which point on the line (0=rightmost point (most recent candle), 1=next most recent point, etc)

See screenshots below (uses CCFp indicator as an example).

Please note: this is the way it operates in MT4 build 509; I can not guarantee that it works the same way in build 600 or later.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: PPI 093.png Size: 22 KB
Click to Enlarge Name: PPI 095.png Size: 49 KB
Click to Enlarge Name: PPI 094.png Size: 35 KB
Click to Enlarge Name: PPI 127.png Size: 25 KB
  • #195
  • Dec 31, 2016 3:07pm Dec 31, 2016 3:07pm
Quoting hanover
{quote} Try something like this (CCFp parameter settings shown with yellow highlight): FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,0,i), // USD iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,1,i), // EUR iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,2,i), // GBP iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,3,i),...
Thanks for all the detailed explanation. Have a wonderful new year.
  • #196
  • Jan 1, 2017 5:03am Jan 1, 2017 5:03am
Connecting two Metatrader to Excel with DDE can anyone do this ?
rat
  • #197
  • Jan 1, 2017 7:03am Jan 1, 2017 7:03am
Quoting hanover
{quote} I downloaded your attached CCFp indicator, and the parameters appear in the screenshot below. The parameters highlighted in yellow appear to be missing from your iCustom() call (which I've highlighted in red in the quoted text above). Check the correct format for the iCustom() function here. As far as I know, the output file should be created in your .../MQL4/Files folder. Also, the indicator I wrote was coded to run in MT4 build 509. It may compile with errors, or might otherwise work...
I was look for this function
Thats working
Thank you nice man
Happy your new year hanover
  • #198
  • Feb 12, 2017 8:00pm Feb 12, 2017 8:00pm
Quoting hanover
{quote} Sorry Dave, I missed your post until now. Hope you're still around. Make sure that the code is outputting the records in descending date order, i.e. for(int i=0; i<iBars(ccy,tf); i++) // Use descending date sequence // for(int i=iBars(ccy,tf)-1; i>=0; i--) // Use ascending date sequence then insert the following line of code (red typeface): string time1 = TimeToStr(iTime(ccy,tf,i),TIME_MINUTES); FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iHigh(ccy,tf,i), iLow(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i)); // The above line writes...
Dear Hanover....

Going through all the post in this thread give me some hope in doing my research in trade based in candle formation ...but its seems I still failed to modified the indicator in oder to suite the excel data needed to furnished on every miniute interval to the excel data ...can you help me in perfecting the script to feed the excel file to the specific sheet within the specific data. Attached herewith is the excel file to feed the data, need to feed the M5,M15, H1, H4, D1 ,W1 and MN on every minute basis in order for the EUR USD file to function well.

Thank you for you help...
Attached File(s)
File Type: xlsx CSFHE AUTO.xlsx   26 KB | 869 downloads
  • #199
  • Feb 13, 2017 3:33am Feb 13, 2017 3:33am
Quoting guliemas
can you help me in perfecting the script to feed the excel file to the specific sheet within the specific data.
Despite being very old, the script earlier in the thread (post #15) seems to compile without errors on the latest MT4 builds. However, you would need to run it every time you want updated CSV files for import into Excel. Hence both the export from MT4 and import to Excel would need to be separate manual processes.

I recall seeing a DDE interface between MT4 and Excel, but that was many years ago and I can't recall how that operated now, let alone if it still works in the latest MT4 builds. You would need to research that for yourself.

I'm sorry that I can't help you further. I am trying to focus on trading rather than programming these days.
  • #200
  • Jan 16, 2018 10:57am Jan 16, 2018 10:57am
Quoting hanover
{quote} Try something like this (CCFp parameter settings shown with yellow highlight): FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,0,i), // USD iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,1,i), // EUR iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,2,i), // GBP iCustom(ccy,tf,"CCFp",3,6,3,5,true,true,true,true,true,true,true,true,0,0,0,0,0,0,0,0,2,0,0,3,i),...
Hello,
First, I want to apologize for my bad English, this is not my native language.
Thank you Hanover for your share
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...
Thanks a lot for your help.
Attached File(s)
File Type: mq4 out_hist (1).mq4   9 KB | 681 downloads
2 traders viewing now