Export to Excel

Quoting djarum11

Disliked

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!

Ignored

Quoting djarum11

Disliked

Hey David, after poking around the MT4 'Help' I think i know the answer to this (NO but is there a way to specify a different export folder ? if not, any ways in windows (shortcuts, drive mapping or something unusual) to get around this?

thanks
mark

Ignored

Quoting Syxf

Disliked

For clarification, the post and logtickdata create charts in an offline chart linked to a one minute chart... can this be done?

Ignored

Quoting keatchye

Disliked

I was wondering if it is possible to export MT4 data such as
currency, time(say 0:00 specific time), date(specific day, say weekend), O,H,L,C to my excel sheet? Appreciate any help I can get.

Ignored

Quoting hanover

Disliked

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 reads

FileWrite(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...

Ignored

Quoting pa18

Disliked

Hi all,

Thank you David for this indi, I'm able to export multiple TF in one go too.

But can someone help me, is it possible to export all the data of different TF into one excel file and separated into different tabs?

Thanks again,
Pab

EDIT: And also I noticed that you can't export custom TF data, for example, I want to export H3 or H7 data, is this correct and possible?

Ignored

Quoting mrgreen

Disliked

I do not think that ma and etc. data can be exported from MT4 - But you could generate the data from excel once u export the price data.
This link will get u started.

http://www.ta-lib.org/

Ignored

extern int      RSI_Period          = 13;   // 8-25
extern int      RSI_Price           = 0;     // 0-6
extern int      Volatility_Band     = 34;    // 20-40
extern int      RSI_Price_Line      = 2;      
extern int      RSI_Price_Type      = 0;     // 0-3
extern int      Trade_Signal_Line   = 7;   
extern int      Trade_Signal_Type   = 0;     // 0-3
extern double   VB_Deviations       = 1.6185;

Quoting carlleese24

Disliked

hi Hanover

Could you please help me on the following or anyone

The indicator I have attached shows a line on the chart and depending on the trend it will change color to either red or green and I would like this indicator exported to excel and to show in some numeric or alpha value to represent green and red because at the moment it is all zeros.

Maybe the indicator needs changing in order for it to be exported into excel to show what I need.


Carl

Ignored

//+------------------------------------------------------------------+
//|                                        sa MTEI Supertrend EA.mq4 |
//|                              Copyright © 2008, TradingSytemForex |
//|                                http://www.tradingsystemforex.com |
//+------------------------------------------------------------------+

#property copyright "Copyright © 2008, TradingSytemForex"
#property link "http://www.tradingsystemforex.com"

#define eaN "sa MTEI Supertrend EA"

extern string separator1="---------------- Entry Settings";
extern int CCIPeriod=50;
extern int ATRPeriod=5;
extern string separator2="---------------- Lot Management";
extern double Lots=0.1;
extern bool RiskManagement=false; //money management
extern double Risk=10; //risk in percentage
extern bool Martingale=false; //martingale
extern double Multiplier=1.5; //multiplier
extern double MinProfit=0; //minimum profit to apply the martingale
extern string separator3="---------------- TP SL TS BE";
bool EnableRealSL=false;
int RealSL=5; //stop loss under 15 pÓps
bool EnableRealTP=false;
int RealTP=10; //take profit under 10 pÓps
extern int StopLoss=0; //stop loss
extern int TakeProfit=0; //take profit
extern int TrailingStop=0; //trailing stop
int TSStep=1; //trailing step
extern int BreakEven=0; //breakeven
extern string separator4="---------------- Extras";
extern bool Reverse=false;
extern bool AddPositions=false; //positions cumulated
extern int MaxOrders=100; //maximum number of orders
extern bool MAFilter=false; //moving average filter
extern int MAPeriod=20;
extern int MAMethod=1;
extern int MAPrice=0;
extern bool TimeFilter=false; //time filter
extern int StartHour=8;
extern int EndHour=21;
extern int Magic=0;

Quoting cyber1

Disliked

You have posted the EA not the indicator.
[code]//+------------------------------------------------------------------+
//| sa MTEI Supertrend EA.mq4 |
//| Copyright 2008, TradingSytemForex |
//| http://www.tradingsystemforex.com |
//+------------------------------------------------------------------+

#property copyright "Copyright 2008, TradingSytemForex"
#property link "http://www.tradingsystemforex.com"

#define eaN "sa MTEI Supertrend...

Ignored

Quoting carlleese24

Disliked

Apologies I have attached the correct one this time


Carl

Ignored

Quoting cyber1

Disliked

OK, drop in your experts/scripts folder then Restart MT4 or recompile in MetaEditor.
Then drop on chart.
Is set up to do EURUSD and GBPUSD. (see script to see how to add more)
Will export whatever TF you drop it on.
File will be in the experts/files folder.

Ignored