Export to Excel | Page 3 | 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

  • #41
  • Dec 15, 2009 9:51pm Dec 15, 2009 9:51pm
Quoting hdmencn
Nothing, I just want to output data (FastClose FastOpen SlowClose SlowOpen) to excel, like pictures, the use of ExportHistory.mq4, but I do not know how to change.
Please try the attached indicator.
Attached File(s)
File Type: mq4 ExportHistory hdmencn.mq4   20 KB | 1,344 downloads
  • #42
  • Dec 16, 2009 1:48am Dec 16, 2009 1:48am
Quoting hanover
Please try the attached indicator.
Great！

thank you very very much！~

  • #43
  • Dec 27, 2009 7:28am Dec 27, 2009 7:28am
Dear All,

Thanks for this skillful way of exporting data to excel. I've attached an exported .csv - it's is just of weekly closes and date. My issue is with the date. Can anyone explain why every so often, it exports the date in a different format? most are mm-dd-yyyy but then every so often it goes to mm/dd/yyyy - the subtle difference between the - and / does affect how one can manipulate this data. Yes - I have tried reformatting all the cells to the same date format.

Nothing urgent this, have provided lots of data on the FTSE for a friend, but I'm interested to know if there's an answer.

Dave
Attached File(s)
File Type: csv ff excel.csv   20 KB | 1,320 downloads
  • #44
  • Dec 27, 2009 9:21am Dec 27, 2009 9:21am
Is their any way to create a script, indicator that will export any indicator data
by placing the name of the custom indicator in the script


Quoting hanover
Please try the attached indicator.
  • #45
  • Dec 27, 2009 6:52pm Dec 27, 2009 6:52pm
Quoting dgrs
Dear All,

Thanks for this skillful way of exporting data to excel....
The problem is most likely that Excel sees some of the values as dates, and some as straight text.

Try outputting the date using the format YYYY-MM-DD, i.e.
set DateTimeFmt = Y-M-D,H:I

Works for me here (I'm running Excel 97), but I recall reading somewhere that when it comes to date conversions, much depends on how the settings in Excel are configured.
  • #46
  • Dec 28, 2009 6:39am Dec 28, 2009 6:39am
Thanks Hanover. This works a treat on all currency pairs so thanks. I've actually been trying to export the FTSE100 data (available through BrocoTrader MT4) and for some reason it doesn't like this chart.

Thanks for your response.

Dave
  • #47
  • Dec 28, 2009 1:43pm Dec 28, 2009 1:43pm
Quoting toddanderson
Is their any way to create a script, indicator that will export any indicator data
by placing the name of the custom indicator in the script
Assuming that I understand you correctly, I'm currently working on a script that will do this. Will probably post it in a new thread.
  • #48
  • Dec 28, 2009 3:24pm Dec 28, 2009 3:24pm
Great look forward to it
Thank you


Quoting hanover
Assuming that I understand you correctly, I'm currently working on a script that will do this. Will probably post it in a new thread.
  • #49
  • Mar 23, 2010 2:49am Mar 23, 2010 2:49am
hi all,

i've tried the ExportHistory hdmencn.mq4, it creates a ExportHistory hdmencn.ex4 but i see no results. i've tried attaching it to charts of many timeframes, and no luck. if i right-click on the chart i DO have the option to 'Remove Script' although that doesn't work either.

This is a fresh install of MT4. any advice is appreciated! as i am currently manually exporting about 10 sets of data every day (i would love to automate this whole process.).

cheers
mark
  • #50
  • Mar 23, 2010 12:29pm Mar 23, 2010 12:29pm
Quoting djarum11
hi all,

i've tried the ExportHistory hdmencn.mq4, it creates a ExportHistory hdmencn.ex4 but i see no results. i've tried attaching it to charts of many timeframes, and no luck. if i right-click on the chart i DO have the option to 'Remove Script' although that doesn't work either.

This is a fresh install of MT4. any advice is appreciated! as i am currently manually exporting about 10 sets of data every day (i would love to automate this whole process.).

cheers
mark
I am running Win-XP, and all versions posted in this thread work correctly on my config here. The output file is created in the ....../experts/files folder. If you are running either Vista or Win-7, I can not troubleshoot problems.

I've heard that Vista somehow restricts writing files to any application installed under the Program Files folder. If you're running Vista, perhaps you could try installing MT4 elsewhere. I'm only guessing, but it might be worth a try.
  • #51
  • Mar 23, 2010 5:02pm Mar 23, 2010 5:02pm
Quoting hanover
I've heard that Vista somehow restricts writing files to any application installed under the Program Files folder. If you're running Vista, perhaps you could try installing MT4 elsewhere. I'm only guessing, but it might be worth a try.
hey hanover..... the vista user account control panel, which can be turned off, is the source of confusion for many.... it is a true pain, or was, i turned it off.....

the ExportHistory hdmencn works properly for me on xp and vista...... personally i have yet to have any issue, other than user account panel, with vista......

can check windows 7 if anyone has concerns about it..... h
to trade and code, keep both simple... no call to impress....h
  • #52
  • Mar 24, 2010 12:21am Mar 24, 2010 12:21am
hey hanover, no way man, i only use WinXP

how long is the macro supposed to take? i've tried it on my laptop as well now (XP also) and still i don't see it doing anything. except i notice that 'Remove Script' is now on the right-click menu for that chart. I'm trying H1 & H4 charts.

has anyone else seen this behaviour, where nothing happens when you drag the Export macro onto a chart?

cheers
mark


Quoting hanover
I am running Win-XP, and all versions posted in this thread work correctly on my config here. The output file is created in the ....../experts/files folder. If you are running either Vista or Win-7, I can not troubleshoot problems.

I've heard that Vista somehow restricts writing files to any application installed under the Program Files folder. If you're running Vista, perhaps you could try installing MT4 elsewhere. I'm only guessing, but it might be worth a try.
  • #53
  • Edited 2:15pm Mar 24, 2010 1:52pm | Edited 2:15pm
Quoting djarum11
how long is the macro supposed to take?
Just one thought...... It's an indicator, not a script, hence it should be installed in the ....../experts/indicators folder, and run accordingly.

I just dragged it (the version attached to post #41) onto a USDCAD,M30 chart. It took maybe 4-5 seconds to run, generated the comment "History export complete to file ...../experts/files/USDCAD,M30.csv" when it completed, and created a 755KB output file called USDCAD,M30.CSV in the ....../experts/files folder. An excerpt from the start of the file is shown below.

I don't know why it isn't working for you.

Inserted Code
03-24-2010,20:30,1.02316,1.02430,1.02284,1.02426,552,1.02386,1.02150,1.02166,1.02014
03-24-2010,20:00,1.02454,1.02456,1.02268,1.02317,920,1.02380,1.02140,1.02150,1.02004
03-24-2010,19:30,1.02561,1.02561,1.02394,1.02455,1031,1.02390,1.02121,1.02140,1.01989
03-24-2010,19:00,1.02448,1.02681,1.02382,1.02562,1660,1.02379,1.02095,1.02121,1.01970
03-24-2010,18:30,1.02636,1.02679,1.02441,1.02447,1580,1.02349,1.02073,1.02095,1.01955
03-24-2010,18:00,1.02643,1.02693,1.02579,1.02636,1420,1.02333,1.02039,1.02073,1.01932
03-24-2010,17:30,1.02607,1.02802,1.02567,1.02641,1886,1.02282,1.02003,1.02039,1.01909
03-24-2010,17:00,1.02331,1.02717,1.02326,1.02608,2327,1.02223,1.01966,1.02003,1.01886
03-24-2010,16:30,1.02255,1.02336,1.02176,1.02332,1639,1.02159,1.01944,1.01966,1.01872
03-24-2010,16:00,1.02238,1.02306,1.02102,1.02259,1758,1.02130,1.01925,1.01944,1.01859
03-24-2010,15:30,1.02350,1.02399,1.02235,1.02241,1913,1.02108,1.01906,1.01925,1.01847
03-24-2010,15:00,1.02353,1.02375,1.02215,1.02346,1416,1.02086,1.01879,1.01906,1.01830
03-24-2010,14:30,1.02221,1.02541,1.02176,1.02354,2199,1.02043,1.01851,1.01879,1.01813
03-24-2010,14:00,1.02182,1.02410,1.02114,1.02221,1087,1.01991,1.01828,1.01850,1.01800
03-24-2010,13:30,1.02219,1.02265,1.02155,1.02183,852,1.01953,1.01807,1.01828,1.01787
03-24-2010,13:00,1.02173,1.02217,1.02114,1.02217,588,1.01915,1.01782,1.01806,1.01773
03-24-2010,12:30,1.02149,1.02331,1.02135,1.02172,888,1.01865,1.01758,1.01781,1.01760
03-24-2010,12:00,1.01957,1.02157,1.01891,1.02148,1333,1.01813,1.01734,1.01758,1.01747

@Hayseed: many thanks for the info.
  • #54
  • Mar 25, 2010 12:45am Mar 25, 2010 12:45am
thanks hanover, i had assumed it was a script. it works great and will save me a ton of time exporting data into Gannalyst.

i'm not great with the MT4 language but i can edit & tweak.. would you tell me, if i wanted this indicator to run at regular intervals, overwriting the existing CSV, would it involve modifying the indi, or creating a script?

thanks again for this, much better than 40 mouse clicks in the History window
mark



Quoting hanover
Just one thought...... It's an indicator, not a script, hence it should be installed in the ....../experts/indicators folder, and run accordingly.

I just dragged it (the version attached to post #41) onto a USDCAD,M30 chart. It took maybe 4-5 seconds to run, generated the comment "History export complete to file ...../experts/files/USDCAD,M30.csv" when it completed, and created a 755KB output file called USDCAD,M30.CSV in the ....../experts/files folder. An excerpt from the start of the file is shown below.

I don't...
  • #55
  • Mar 25, 2010 11:24pm Mar 25, 2010 11:24pm
Quoting djarum11
i'm not great with the MT4 language but i can edit & tweak.. would you tell me, if i wanted this indicator to run at regular intervals, overwriting the existing CSV, would it involve modifying the indi, or creating a script?
A script will run once, every time you drag it onto the chart.

The init() module of an indicator runs immediately you attach the indy to a chart, while the start() module runs once every time there's a new price tick. So if by 'regular intervals' you mean that you want the export to be re-run (for example) every 5 minutes, you'd check to see whether 5 minutes had elapsed since the last export, and if so, re-export the data.
  • #56
  • Mar 25, 2010 11:57pm Mar 25, 2010 11:57pm
ah so ..based on the code extracted below, setting the export interval is a matter of adjusting prev_time? i didn't find any info on 'datetime' ...if i am correct here could you explain datetime, and the value of -9999 ?


//+------------------------------------------------------------------+
int start() {
//+------------------------------------------------------------------+
if (prev_time != iTime(CurrencyPair,tfr,0)) {
export_hist();
prev_time = iTime(CurrencyPair,tfr,0);
}
return(0);
}

----------------

datetime prev_time = -9999;



Quoting hanover
A script will run once, every time you drag it onto the chart.

The init() module of an indicator runs immediately you attach the indy to a chart, while the start() module runs once every time there's a new price tick. So if by 'regular intervals' you mean that you want the export to be re-run (for example) every 5 minutes, you'd check to see whether 5 minutes had elapsed since the last export, and if so, re-export the data.
  • #57
  • Mar 26, 2010 12:59am Mar 26, 2010 12:59am
Quoting djarum11
ah so ..based on the code extracted below, ........
To possibly save you any programming bother........ the indy (attached to post #41) performs a fresh export every time the first tick on a new candle occurs on the chart to which it's attached. So if TimeFrame parameter is set to 15, but it's attached to a M1 chart, the output will be the OHLC of M15 candles, but it will be re-exported every 1 minute.

Does this help?
  • #58
  • Edited 2:29am Mar 26, 2010 2:21am | Edited 2:29am
i think i understand. it exports on schedule according to the current timeframe being viewed, regardless of what the indi parameters are set to.

incidentally it also exports whenever i manually switch timeframe (using the toolbar at the top), which is cool.

I have customized and saved 2 versions of the indi, one is suffixed _D1 and the other _H4. they are both attached to a chart. Ideally i would like to control the export time independent of current chart timeframe, would this be possible?

Big thanks for your time and expertise Hanover!
Mark


Quoting hanover
To possibly save you any programming bother........ the indy (attached to post #41) performs a fresh export every time the first tick on a new candle occurs on the chart to which it's attached. So if TimeFrame parameter is set to 15, but it's attached to a M1 chart, the output will be the OHLC of M15 candles, but it will be re-exported every 1 minute.

Does this help?
  • #59
  • Mar 26, 2010 3:43pm Mar 26, 2010 3:43pm
Quoting djarum11
i think i understand........
It exports on schedule according to the current timeframe being viewed, regardless of what the indi parameters are set to.
Yes, that's correct.

Incidentally it also exports whenever i manually switch timeframe (using the toolbar at the top), which is cool.
Yes, doing any of the following refreshes an indicator:
1. Changing timeframe.
2. Changing currency pair.
3. Pressing Ctrl-I, or otherwise editing its parameters.
4. Removing, and then re-attaching the indy.

I have customized and saved 2 versions of the indi, one is suffixed _D1 and the other _H4. they are both attached to a chart. Ideally i would like to control the export time independent of current chart timeframe, would this be possible?
Sorry, this is not currently possible. When I coded the indy, I couldn't see why anybody would want the data re-exported unless it had changed. For example, if you're exporting M15 data, it's only going to change each time a new M15 candle forms.

However, if you want the data re-exported every (for example) 1 minute, you could attach the indy to a M1 chart. Then set the TimeFrame parameter to whatever data you want exported. You could attach multiple occurrences of the indy to any M1 chart, each with different CurrencyPair and TimeFrame parameters, if you wished. I haven't tested this, but I assume that it would work correctly.
  • #60
  • Mar 27, 2010 4:12pm Mar 27, 2010 4:12pm
Just out of curiosity, what happens if the chart is being viewed on W1 and the indi is an H4. will it still output a new file every time an H4 candle is formed, or will the chart view take precedence? I will try it out...

Cheers and thanks again man!
0 traders viewing now