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

  • #81
  • Edited 11:07pm May 17, 2012 8:47pm | Edited 11:07pm
Quoting ferry678
Could somebody help me to put the value from the tick separate volume indicator to CSV file, so when we open the CSV file, we could see the tick volume for the already formed candles just like in MT4. The ticking of volume updated itself after completion the last candle. So in CSV file it looks like this :

Buy xxx xxx xxx
Sell xxx xxx xxx and so on...(no matter if it lines down)

1 column/line for 1 candlestick in anytimeframe,1 file for 1 day.If we put on H1 chart ,there'll be 24 columns.It doesn't matter ,either as EA/indicator or script....
Try the attached script. Your outline was unclear, hence I had to make some guesses. I took you at your word when you said "1 file for 1 day" (hence if the data history goes back 2,000 days, you'll get 2,000 files).

Anyway, it's the best that I can do in the time that I have available.

[EDIT] I've attached the .mq4 source code to post #82. Please read the instructions in the first paragraph in post #82, if you want to use the source code.
Attached File(s)
File Type: ex4 Output History ferry678.ex4   29 KB | 979 downloads
  • #82
  • May 17, 2012 11:03pm May 17, 2012 11:03pm
The latest version of the OutputHistory script is attached. It allows bulk output of OHLCV history for multiple pairs/timeframes. If you don't need the source, copy only the .ex4 file into your .../experts/scripts folder, and restart MT4. If you want to use the source, copy the .mq4 file into the scripts folder, and also the .mqh files attached to this post into the .../experts/include folder (otherwise you'll get compile errors). You can easily modify the out_line() module in the source to add additional data fields to your outputs.

You can enter up to 40 CurrencyPairs, and 9 TimeFrames (M1,M5, etc) , separated by commas. Upper or lowercase doesn't matter. Pair symbols may be entered in either shorthand (e.g. EU) or in full (e.g. EURUSD). Separate output files will be created for each pair/timeframe. All files will be created/overwritten in the .../experts/files folder. Files will be organized into different sub-folders if you set DifferentSubfolderPerTimeFrame to TRUE. The rest of the parameter settings should be self-explanatory. The formats are explained in the link above. You can save and recall parameter presets using MT4's SAVE and LOAD buttons in the script attach dialog window.

David
Attached File(s)
File Type: ex4 Output History.ex4   35 KB | 1,115 downloads
File Type: mq4 Output History.mq4   3 KB | 1,263 downloads
File Type: mq4 Output History ferry678.mq4   2 KB | 1,070 downloads
  • #83
  • May 18, 2012 3:57pm May 18, 2012 3:57pm
Dear Mr.Hanover,

Firstly,thanks for quick response.I've checked it.The file"Output History ferry678" is at least the one I needs,but all the ticks data joined/packed in 1 cell,so I cannot do mathematical operation in it. As I wished that 1 candlestick in 1 column.Is that term Buy/Sell the cause of this? Recognized in Excel as character not numeric.The word "Buy/Sell", just to explain,can be omitted.Could sir help me to fix it and give "ekstern" option to limit the days to be exported? Why the ticks in a row move from right to the left.The left is newest.At last ,I wait for response & thanks for the time given.
Attached File(s)
File Type: csv EURUSD,H1_2012-05-18.csv   < 1 KB | 1,078 downloads
  • #84
  • May 18, 2012 6:56pm May 18, 2012 6:56pm
Quoting ferry678
Dear Mr.Hanover,

Firstly,thanks for quick response.I've checked it.The file"Output History ferry678" is at least the one I needs,but all the ticks data joined/packed in 1 cell,so I cannot do mathematical operation in it. As I wished that 1 candlestick in 1 column.Is that term Buy/Sell the cause of this? Recognized in Excel as character not numeric.The word "Buy/Sell", just to explain,can be omitted.Could sir help me to fix it and give "ekstern" option to limit the days to be exported? Why the ticks in a row move from right to the left.The...
I did my best to follow the instructions that you gave. These were not clear.

Try the attached script. I have reversed the sequence of the values (the oldest value is now at the left), removed the "Buy"/"Sell" titles, and added a NumberOfDays parameter.

The values are now separated by tabs instead of spaces. I have also renamed the file to .tsv instead of .csv, which means that Excel should recognize the tabs and automatically place one value per column. However, if this doesn't occur, you'll need to use Excel's "Text To Columns" facility (explained in this video).
Attached File(s)
File Type: ex4 Output History ferry678.ex4   29 KB | 813 downloads
  • #85
  • May 19, 2012 6:07am May 19, 2012 6:07am
Dear Sir Hanover,

Excellent idea,everything about columns is fine .In this neat columns,I've just realized that some of my minus tick figures became positive.
1. Just try by using renko/range bar chart,it used to have one-sided (buy/sell) minus tick figures(I thought minus has meaning).We could see this in Data Window(Ctrl+D).Is this natural(must be) or something missed in coding ,so all became positive?

2. I'm used to put script to EA folder in order to have automatically updated in TSV. But the complete message come out intermittently.These will be perfect ,if the Extern option give the time range.If set to 10,it 'll be updated every 10 second.If set to zero,only once and could be used as script .No need message if set more than 0.The date limit extern is very useful,please let it stayed.

3. When updated,anything (note/value/formula) made by our own that already saved in that same tsv file ,all disappeared when opened again.Isn't there a possibility , our note/idea/formula(plus,multiplying,divide this & that) made at least on next Sheet(the same tsv file),undisturbed by updating process?

Thanks for time,effort,idea contributions to me.
Attached Image (click to enlarge)
Click to Enlarge Name: eur renko tick seperate.gif Size: 41 KB
  • #86
  • Edited May 20, 2012 3:26pm May 19, 2012 3:46pm | Edited May 20, 2012 3:26pm
Quoting ferry678
Dear Sir Hanover, .....
I am sorry, but I am too busy now to do anything further on this job. No offense intended, but I gave you what you asked for in the first place; however, you keep adding/changing your rules. I do not understand "renko/range chart", or what you mean by "minus ticks". Volume is always positive.

What I wrote was a script, not an EA. It must be installed in the .../experts/scripts folder, just like I explained in post #82. By running it as an EA it will output/overwrite the files every time a new price tick occurs.

There may also be problems if you are trying to run MT4 on either Win7 or Vista, as explained here.

Anyway, I am sorry, but I am a professional software developer. I can not afford to spend too much time on unpaid work, as I must pay my bills somehow.

I have attached the .mq4 source, in case another programmer wants to develop this further for you. It requires the .mqh files attached to this post, to compile successfully.
Attached File(s)
File Type: mq4 Output History ferry678.mq4   2 KB | 902 downloads
  • #87
  • May 19, 2012 11:17pm May 19, 2012 11:17pm
Firstly,I must say thanks for effort that has been given. I don't mean to force sir to help me any further.To clarify, when the first indicator given,it was so packed in 1 cell(so small text) so I canot see that the negative is not exist sir.Just try to put renko chart and drag the Tick Seperate Volume.mq4,we could see there must be a negative volume.The negative volume is main actor in this matter that to be analyzed by me.

Then the source code is the first one that is still joined/packed in 1 cell.So does Ex4(the right one but no negative) is locked .So in this situation, I could not move onward and backward,halt in half way. So for the last time I beg the last help to review the point No1 only(the negative problem).Not must be today, after sir have spare time.
Thanks one more time and forgive me for inconvenience.
Attached File(s)
File Type: mq4 RenkoLiveChart_v3.2.mq4   14 KB | 926 downloads
  • #88
  • May 20, 2012 9:03am May 20, 2012 9:03am
Dear Mr.Hanover,

I've added "+"(Mqh funtion) to the code,and fine as I want.About the source code,that(last attached) is the last one(columns fixed) but has problem when compiled by MT4. The log file attached.Thanks so much.
Attached File(s)
File Type: txt Output History ferry678.txt   6 KB | 923 downloads
  • #89
  • May 20, 2012 9:04am May 20, 2012 9:04am
Dear Mr.Hanover,

I've added "+"(Mqh funtion) to the code,and fine as I want.About the source code,that(last attached) is the last one(columns fixed) but has problem when compiled /opened by MT4. The log file attached.Thanks so much.
  • #90
  • Edited 6:32pm May 20, 2012 3:25pm | Edited 6:32pm
Quoting ferry678
Then the source code is the first one that is still joined/packed in 1 cell.So does Ex4(the right one but no negative) is locked .So in this situation, I could not move onward and backward,halt in half way. So for the last time I beg the last help to review the point No1 only(the negative problem).Not must be today, after sir have spare time.
Thanks one more time and forgive me for inconvenience.
I'm sorry, but I do not understand exactly what you are asking.

In the attached .ex4, the script will place a minus sign in front of every value in the second row in each file.

Please DELETE the .mq4 and .mqh files; these are for programmers only. Simply copy the attached .ex4 file to your ..../experts/scripts folder, and then re-start MT4. If this does not produce your desired output, I don't know how to help you further.

I am sorry, but due to other work commitments, I can not answer any more posts in this thread.
____________________________

Note to any programmer who wishes to further this work: I have attached the latest .mq4 source to post #86. Please see the note in the first paragraph of post #82.
Attached File(s)
File Type: ex4 Output History ferry678.ex4   29 KB | 814 downloads
  • #91
  • Jul 16, 2012 4:29am Jul 16, 2012 4:29am
Hi Hanover,

First of all thank you so much for this script and also your extension functions. It is a fabulous tool helping me analyze my trades.

I know you said not answering anymore on this thread but if you can help that would be great.

I am using the script to get values of indicators and it works great!

Only thing is when getting the values from a stochastic momentum indicator it brings them all in as positive, when values can be negative.

I've been reading the extension file and i know the answer lies with that but just not sure how to add it to the code.

This is what i have so far:

+ NumberToStr(iCustom(ccy,tf,"Stochastic Momentum Indicater Altered 833",8,3,3,3,0,i),OHLCFormat) + FieldSeparator

+ NumberToStr(iCustom(ccy,tf,"Stochastic Momentum Indicater Altered 833",8,3,3,3,1,i),OHLCFormat) + FieldSeparator

I think I need to put something in using the mask functions that will put the - sign in front of any negative values.

I just need to know where to put it. I was looking at these functions
string NumberToStr(double n, string mask="")
//+------------------------------------------------------------------+
// Formats a number using a mask, and returns the resulting string
// Usage: string result = NumberToStr(number,mask)
//
// Mask parameters:
// n = number of digits to output, to the left of the decimal point
// n.d = output n digits to left of decimal point; d digits to the right
// -n.d = floating minus sign at left of output
// n.d- = minus sign at right of output
// +n.d = floating plus/minus sign at left of output
//
// These characters may appear anywhere in the string:
// ( or ) = enclose negative number in parentheses

If you have time can you please let me know how I would incorporate the - mask function into my code.

Warm Regards
Em
  • #92
  • Aug 24, 2012 6:50am Aug 24, 2012 6:50am
Hi Hanover,

I have read this thread & been trying to use yout out_hist tool to export data to excel. I just can't get it to work for an indicator I want to use - DynamicRangeIndicator.

When I try and edit the script in out_hist, I ger an error when I try to compile - "iDynamicRangeIndicator function is not defined". I have tried playing around with the parameters but no joy.

Any help gratefully received.
Attached File(s)
File Type: ex4 DynamicRangeIndicator.ex4   9 KB | 780 downloads
  • #93
  • Aug 24, 2012 3:16pm Aug 24, 2012 3:16pm
Quoting Embod
Hi Hanover,

First of all thank you so much for this script and also your extension functions. It is a fabulous tool helping me analyze my trades.

I know you said not answering anymore on this thread but if you can help that would be great.

I am using the script to get values of indicators and it works great!

Only thing is when getting the values from a stochastic momentum indicator it brings them all in as positive, when values can be negative.

I've been reading the extension file and i know the answer lies with that but just not sure how...
Hi,

I only just saw your post now.

The solution is to simply place a negative sign somewhere in the mask, e.g.
TR-5.2 will cause a leading negative sign to be output; TR5.2- will cause a trailing minus sign.

Hence you could replace OHLCFormat with something like "TR-5.5"
(allows a max of 5 digits to the left of the dec point, and 5 digits to the right)

Hope that helps,
David
  • #94
  • Aug 24, 2012 3:23pm Aug 24, 2012 3:23pm
Quoting jonny007
Hi Hanover,

I have read this thread & been trying to use yout out_hist tool to export data to excel. I just can't get it to work for an indicator I want to use - DynamicRangeIndicator.

When I try and edit the script in out_hist, I ger an error when I try to compile - "iDynamicRangeIndicator function is not defined". I have tried playing around with the parameters but no joy.

Any help gratefully received.
Jonny,

I suspect that you need to use iCustom()

Something like this:
iCustom(Symbol(), Period(), "DynamicRangeIndicator", p1,p2,p3, ..... ,0,i)
where p1, p2, p3, are values for the Dynamic Range Indicator that you wish to apply.

The 0 (second to last parameter) is the buffer#. Every custom indy can plot up to eight lines, each line in a buffer numbered 0 thru 7. For example, a Bollinger band has three lines, an upper channel boundary, a median line, and a lower channel boundary. Hence these would likely be plotted using buffers 0, 1 and 2, respectively. Hence if you wanted the value of the upper line, you'd specify 0 in the iCustom function, and so on.

The final value i is the data point that you wish to retrieve. The rightmost datapoint/candle on a chart is #0, the second from the right is #1, and so on. The out_hist script (as best as I can remember) uses a loop, varying an integer register that's arbitrarily named i, from 0 to the number of candles in the chart, thus allowing it to output one row into the export file, for every candle.

Hope that helps,
David
  • #95
  • Aug 26, 2012 3:06am Aug 26, 2012 3:06am
Excellent, Thanks Hanover - got it working.

Strange thing with this indicator is that it only gives limited historical data. As shown on the attached 1 min EURUSD chart, the signals only go back about 1000 bars. As such when I export the data to Excel I only get the signals generated that are shown on the chart. This is the same on all time frames & all currencies - only about 1000 bars of historic signals, then nothing but the price data. Could this be a feature of the indicators code, or gaps in the price history data causing the indicator to fail?


http://s15.postimage.org/3l6hqla07/e...screenshot.jpg
  • #96
  • Aug 26, 2012 5:25am Aug 26, 2012 5:25am
Quoting jonny007
Strange thing with this indicator is that it only gives limited historical data. As shown on the attached 1 min EURUSD chart, the signals only go back about 1000 bars. As such when I export the data to Excel I only get the signals generated that are shown on the chart. This is the same on all time frames & all currencies - only about 1000 bars of historic signals, then nothing but the price data. Could this be a feature of the indicators code, or gaps in the price history data causing the indicator to fail?
Most likely the way the indicator's code operates, but I can only guess, given the info that you've provided. I'm not familiar with the indy, and I don't know who your br0ker is. You should be able to see any gaps in the data on the chart, and also in the output generated by out_hist.
  • #97
  • Aug 26, 2012 4:05pm Aug 26, 2012 4:05pm
Can we export alerts to excel sheet?
  • #98
  • Aug 27, 2012 3:19am Aug 27, 2012 3:19am
Quoting hir0406
Can we export alerts to excel sheet?
I'm almost afraid to answer this, as nubcake might jump in and say "yes it can be done easily". If so, I leave it to him to provide a solution.

Anyway, and given that I'm a mere mortal, my answer is this: I don't know any way of exporting MT4 alerts directly to Excel.
  • #99
  • Aug 27, 2012 6:46am Aug 27, 2012 6:46am
Quoting hanover
I'm almost afraid to answer this, as nubcake might jump in and say "yes it can be done easily". If so, I leave it to him to provide a solution.

Anyway, and given that I'm a mere mortal, my answer is this: I don't know any way of exporting MT4 alerts directly to Excel.
that's cute. if you are given some special consideration that allows you to post wherever you like, despite being a commercial member, and also seem to have taken on some type of coding expert role to the newbies around here, then i would expect your tech area posts to be better and more knowledgeable with far better code and far better logic. you just don't like it when others who know better actually bother to take a moment to override you.

as for logging alerts... what is that even meant to mean? log them as they occur? log alerts that have occurred in the past? what sort of 'alert' is it? the question is too ambiguous and the reply requires some specificity. if the alert is from some random indicator that plots junk on the chart then one could log to a file the price and datetime of a stream of certain objects depending on the object name or type or some other defining factor. if the alert is some random indicator happening in real time spitting out an alert box, or from the user defined alert list in the terminal, then i'm sure that can be handled but that is above my pay grade and others more crafty can answer that aspect if they can be bothered. i'm confident the actual experts are off doing much more interesting things.

if you want to bait a reply (that's twice now) and you've been a good boy all year then santa might just deliver you that reply for xmas. don't expect it all year though. this one and the previous you get for free.

do better code, give more coherent and relevant replies, or expect others to sometimes do it for you. that's how a forum works.
Congratulations ScalaFX for coming out of the closet!
  • #100
  • Aug 27, 2012 9:16am Aug 27, 2012 9:16am
Quoting hanover
If you're smarter than I am, well I'm afraid there's not too much I can do about that. It's hardly my fault if God gave you a better brain than the one he gave me.

Meantime, I'll just carry on coding, and answering questions, to the best of my ability, and as time permits. In an open forum, that's everybody's privilege, including mine.

I assume that the previous poster means the alerts that pop up whenever the Alert() function is called. But I'm only guessing.
i have an ea n my chart.it gives alert to buy and sell in alert pop up window.i want that alert data in excel.is that possible?
2 traders viewing now