Export to Excel

Hanover: Did you notice my post where I am looking for a way of having the "COMMENTS" in MT4 on the same line when copied to XL. At the moment the "COMMENTS appear on a 2nd line underneath the trade in XL. You assistance would be greatly appreciated. Thanks

Just happened to notice your post now (my previous involvement in this thread was > 12 months ago).

I assume you're referring to the comment in the monthly performance statement (trades won/lost etc). The data being exported by the indicator earlier in this thread is the open/high/low/close prices on historical candles, not the monthly statement.

The statement format is pre-programmed into MT4. Hence, to rearrange it, you'd need to export to XL like you're currently doing, and then write a macro using XL's Visual Basic language (which falls outisde the scope of MT4 programming).

Sorry that I can't be of more help.

Hi Hanover: Thanks for looking at my post anyway. What I am referring to is under comments in each trade "if comments are turned on" an EA's name & or ID No. will display but when printed to XL it appears on the line underneath the trade & NOT on the same line - is this what you are referring to or is it possible somehow to have it on the same line in XK>
Cheers Peter

Yes, that's what I was referring to.

is their a way to log a price at a specific time into excel, script or something

What i am trying to do is set up excel DDE server to fill a cell at a specific time

Yes

1) make a formula/function on preferred cells where you want the DDE data to go or,

2) write a VB program that will record the DDE data to your preferred cell location at a certain time of the day.

Yes thank you for your reply, yes i was also think a VB script would work,
but thats a little over my head

An old thread, but I believe an important one.

What am I doing wrong though? I'm trying to export the values of a SMA 20 to excel. I simply put in this line of code into the script and all I get is a file export that has the headings of data and ohlc. There aren't any values for any of those columns nor is there a column for my SMA values.

string time1 = TimeToStr(iTime(ccy,tf,i),TIME_MINUTES);
FileWrite(handle, date1, time1, iOpen(ccy,tf,i), iLow(ccy,tf,i), iHigh(ccy,tf,i), iClose(ccy,tf,i), iVolume(ccy,tf,i), iMA(ccy,tf,20,0,MODE_SMA,PRICE_OPEN ,i));
// The above line writes the data to the file in the order: date, time, open, low, high, close, volume. Change the order to suit, if necessary


How do I fix this?

Thanks,
Matt

Try the attached indicator. The default parameters will output
date,time,O,H,L,C,V,SMA(20)
of every candle for the pair/timeframe of the chart to which its attached. For more info, see here.

To verify that it's working correctly, I've also attached the output it produced for GBPCHF,D1.

Perfect. Thanks for that.

It appears that it calculates the SMA off of the open, which is what I want. Just wondering, is there a way to change it to the close? Don't worry about posting another whole script for this as I'm just curious.

Although I am curious to know how I would adjust the variable if I wanted to export the values for a SMA 50 intead of a SMA 20.

A quick thought that came to mind is that it would be cool if it could automatically detect the indicators loaded on the chart and export their values for each one to its own column.

Thanks for the tool though. Very useful!

It appears that it calculates the SMA off of the open, which is what I want. Just wondering, is there a way to change it to the close? Don't worry about posting another whole script for this as I'm just curious.
Download the attached indicator. Change PRICE_OPEN to PRICE_CLOSE in the line of code that reads:

Although I am curious to know how I would adjust the variable if I wanted to export the values for a SMA 50 intead of a SMA 20.
Same line of code. Change the 20 that's highlighted in red to 50

A quick thought that came to mind is that it would be cool if it could automatically detect the indicators loaded on the chart and export their values for each one to its own column.
Great idea, but sorry, I don't know how to do this - not sure if it's even possible.

Hi Hanover,
The export history mq4 didn't work in Window 7, no file was exported ,appreciate if you could help.Thanks

The file is created in the ...../experts/files folder.

Sorry, I am unable to help you further. I do not run Windows 7 (which is newly released and probably unstable, if it's anything like Vista), so I can't attempt to reproduce the problem. The indicator runs fine on Windows XP. Maybe somebody else who is using Windows 7 can help?

Thank for your immd reply, i found the files at last in the same folder but were hidden in Windows 7 Compatibility File Directory.

Things work bit different in Windows7 and Vista. Try searching the files here


C:Users YourUserName AppData LocalVirtualStore Program Files YourMTFolder experts Files

Something weird is happening ... I'm not able to type a back-slash between the folder names but I hope you understand the location.

This is a wonderful script IMHO, I've been looking for this kind of thing.

Is it possible to modify the code so that it can generate multiple files for multiple pairs depending on the input provided by user, something like the following:

//---- input parameters
extern bool EURUSD=true;
extern bool GBPUSD=true;
extern bool USDJPY=true;
extern bool USDCHF=true;
extern bool USDCAD=true;
extern bool EURJPY=true;
extern bool USDNOK=false;
extern int TF=240;

Also, just wondering how it can be modified so that it runs on the open of every new bar. Doesnt matter even if it over-writes the whole data set.

Also, how about another parameter which accepts the start date and time and then the script only looks for quotes between that start-date and the last bar ...

Thanks.

It's an indicator, not a script. Please ensure that you load it into the ..../experts/indicators folder, and run it as an indicator.

Re running it on multiple pairs, simply attach the indicator to every pair whose data you wish to have exported. A separate file will be generated for each pair.

If run as an indicator, then the whole file should be rewritten every time a new candle begins on the TimeFrame you specify. If you leave the TimeFrame parameter blank, then it defaults to the same TF as the chart to which it's been attached. I can't test this for you until the market re-opens on Monday, but I'm pretty sure this is the way it operates.

Only quotes between the FromDateTime and ThruDateTime settings should be output. Leave the ThruDateTime set to the default value 2019.12.31 00:00 and it will always include the last bar (until we get to Jan 1, 2020)

I haven't run it for a while; I assume all of the above still works as I described. At least that's the way it was originally intended to operate.

I follow your method a number of attempts, but without success. Can you help me to change about this code Mody? Thank you very much! ~ My English is not good, very sorry ~

#property indicator_chart_window
#property indicator_buffers 4
#property indicator_color1 ForestGreen
#property indicator_color2 Red
#property indicator_color3 Black
#property indicator_color4 Black
//---- input parameters
extern int FastClosePeriod=13;
extern int FastCloseShift=0;
extern int FastOpenPeriod=34;
extern int FastOpenShift=0;
extern int SlowClosePeriod=34;
extern int SlowCloseShift=0;
extern int SlowOpenPeriod=62;
extern int SlowOpenShift=0;

//---- indicator buffers
double ExtBlueBuffer[];
double ExtRedBuffer[];
double ExtDarkVioletBuffer[];
double ExtBlackBuffer[];

//+------------------------------------------------------------------+
//| Custom indicator initialization function |
//+------------------------------------------------------------------+
int init()
{
//---- line shifts when drawing
SetIndexShift(0,FastCloseShift);
SetIndexShift(1,FastOpenShift);
SetIndexShift(2,SlowCloseShift);
SetIndexShift(3,SlowOpenShift);
//---- first positions skipped when drawing
SetIndexDrawBegin(0,FastCloseShift+FastClosePeriod);
SetIndexDrawBegin(1,FastOpenShift+FastOpenPeriod);
SetIndexDrawBegin(2,SlowCloseShift+SlowClosePeriod);
SetIndexDrawBegin(3,SlowOpenShift+SlowOpenPeriod);
//---- 3 indicator buffers mapping
SetIndexBuffer(0,ExtBlueBuffer);
SetIndexBuffer(1,ExtRedBuffer);
SetIndexBuffer(2,ExtDarkVioletBuffer);
SetIndexBuffer(3,ExtBlackBuffer);
//---- drawing settings
SetIndexStyle(0,DRAW_HISTOGRAM,0,2);
SetIndexStyle(1,DRAW_HISTOGRAM,0,2);
SetIndexStyle(2,DRAW_NONE,0,2);
SetIndexStyle(3,DRAW_NONE,0,2);
//---- index labels
SetIndexLabel(0,"FastClose");
SetIndexLabel(1,"FastOpen");
SetIndexLabel(2,"SlowClose");
SetIndexLabel(3,"SlowOpen");
//---- initialization done
return(0);
}
//+------------------------------------------------------------------+
//| 9Squared Trader |
//+------------------------------------------------------------------+
int start()
{
int limit;
int counted_bars=IndicatorCounted();
//---- check for possible errors
if(counted_bars<0) return(-1);

//---- last counted bar will be recounted
if(counted_bars>0) counted_bars--;

limit=Bars-counted_bars;

//---- main loop
for(int i=0; i<limit; i++)
{
//---- ma_shift set to 0 because SetIndexShift called abowe
ExtBlueBuffer[i]=iMA(NULL,0,FastClosePeriod,0,MODE_EMA,PRICE_CLOSE,i);
ExtRedBuffer[i]=iMA(NULL,0,FastOpenPeriod,0,MODE_EMA,PRICE_OPEN,i);
ExtDarkVioletBuffer[i]=iMA(NULL,0,SlowClosePeriod,0,MODE_EMA,PRICE_OPEN,i);
ExtBlackBuffer[i]=iMA(NULL,0,SlowOpenPeriod,0,MODE_EMA,PRICE_MEDIAN,i);
}

//---- done
return(0);
}

I am sorry. I do not understand what modification you would like me to make. I am too busy trying to solve other people's coding problems to help you.

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.