Working with Excel (tools, indicators, conversion ...) - Page 18

Hazel · #**171** (**permalink**) 12-28-2008, 02:32 AM

Want to compare your trading data to the free data available from internet? Here is an excel tool.

After opening the excel workbook, allow the data connection, then the workbook will get data from MSN Money every 5 mins. The chart has room for 2 hrs data. Best to all the guys in this new year.

Hazel · #**172** (**permalink**) 01-09-2009, 07:47 PM

First of all, function of this indicator. This indicator can differentiate flat not moving market and rapid moving market.
One thing I like about this indicator is that it is not coded with mql, so that no one can de-compile it, no one can see the logic.
How to use it. Must allow the data connection. The data has to be fresh. It will get data every 5 mins when it refreshes automatically. It needs at least 2 hours recharge all the current data. Don't do save or any thing to refresh the worksheets manually, otherwise you will get repeated data.

trushar_9 · #**173** (**permalink**) 01-29-2009, 06:48 AM

U have so many book in pdf format.
Can give it?

mineforever · #**174** (**permalink**) 02-04-2009, 09:46 AM

Quote:

Originally Posted by Linuxser

It also works great with Open Office 3

[ATTACH][/ATTACH]

Hi Linuxser,

I have found many threads on exporting data from MT4 to Excel but not much usefull information on exporting a data from excel to MT4 indicator.

I have a complex caluclation done on excel based on the (O,H,L,C) data I get from MT4, excel run the calculation on realtime and the output of the calculation will be one integer variable that can have one of those 3 values (either +1,-1, or 0). I am looking for a way that an MT4 indicator read that value from excel so that I can use it to confirm a trade.

Do you have any idea on how to proceed, an mq4 example will be very usefull.

Cheers,

mineforever

Linuxser · #**175** (**permalink**) 02-04-2009, 04:28 PM

Quote:

Originally Posted by mineforever

Hi Linuxser,

I have found many threads on exporting data from MT4 to Excel but not much usefull information on exporting a data from excel to MT4 indicator.

I have a complex caluclation done on excel based on the (O,H,L,C) data I get from MT4, excel run the calculation on realtime and the output of the calculation will be one integer variable that can have one of those 3 values (either +1,-1, or 0). I am looking for a way that an MT4 indicator read that value from excel so that I can use it to confirm a trade.

Do you have any idea on how to proceed, an mq4 example will be very usefull.

Cheers,

mineforever

In theory we could use the period converter code as example to write hst files.

giraia_br · #**176** (**permalink**) 02-04-2009, 08:45 PM

i still want a expert which can read an Excel file

but i have a new request. How can i put information like this spreadsheet posted a few pages back in a chart form? I have a spreadsheet with values that goes from -9.0 to 9.0. But it is a pain to test it. Anyone here knows how can i plot this values in a chart so i dont nees to watch this spreadsheet every second.

thanks in advance.

mineforever · #**177** (**permalink**) 02-06-2009, 09:56 AM

Quote:

Originally Posted by Linuxser

In theory we could use the period converter code as example to write hst files.

Hi Linuxser,

Thanks for your reply.

I tried to look for more info on the period converter and this is what I foundamong others
Period Converter - MQL4 Code Base

However I couldn't see at all how to use it as a solution to my problem.

Wha I am looking after is how to transfer on real-time one integer variable from excel to an MT4 indicator. In fact on 1 min TF, every min excel will be calculating based on (O,H,L,C) that I got from MT4 DDE and excel will generate one value. I want an MT4 idicator that will read this value from excel.

Could you please elaborate on how your proposal can handle this?

Cheers,

way2Feedom

Linuxser · #**178** (**permalink**) 02-06-2009, 10:43 PM

Quote:

Originally Posted by mineforever

Hi Linuxser,

Thanks for your reply.

I tried to look for more info on the period converter and this is what I foundamong others
Period Converter - MQL4 Code Base

However I couldn't see at all how to use it as a solution to my problem.

Wha I am looking after is how to transfer on real-time one integer variable from excel to an MT4 indicator. In fact on 1 min TF, every min excel will be calculating based on (O,H,L,C) that I got from MT4 DDE and excel will generate one value. I want an MT4 idicator that will read this value from excel.

Could you please elaborate on how your proposal can handle this?

Cheers,

way2Feedom

I understand. Seems a bit complex.

Period converter code is useful to create hst files. MT read the OHLC data from hst files. In theory you could write any kind of data to a hst file by just using a product name. Like EURUSD value 100/200/300 and so son.

How to write an hst file using excel. I don't know.

mrwobbles · #**179** (**permalink**) 02-26-2009, 01:46 PM

Hey all, I'm currently training a neural network to look predict high, low and close prices for GBPJPY, so far I've had some success, mainly due to having access to a Cray supercomputer at uni. Anyway part of that is feeding it a mass of data and letting it chug through it and find patterns, with the help of the RSI_to_FILE script on MQL4: automated forex trading, strategy tester and custom indicators with MetaTrader I've been able to modify that script to output more data from a variety of indicators and other prices, but I'm still not giving it enough data.

Basically what I want is all the price and indicator data for all symbols on one spreadsheet. My question is this, if you look at the FileWrite(...) part is there anyway for me to set up an array of symbols so I can have only one iClose,iOpen,iVolume and it plug the symbols from the array into those? The way I've been doing it so far is quite long winded and I'm inherently lazy.

Here's what I've got so far... Would appreciate any help on this

Code:

//+------------------------------------------------------------------+
//|                                                  RSI_to_File.mq4 |
//|                      Copyright © 2007, MetaQuotes Software Corp. |
//|                                        http://www.metaquotes.ru/ |
//+------------------------------------------------------------------+
#property copyright "Copyright © 2007, MetaQuotes Software Corp."
#property link      "http://www.metaquotes.ru/"

#property show_inputs
string SymbolsArray[2]={"","GBPJPY"};
IndicatorDigits(Digits+5);
 
//+------------------------------------------------------------------+
//| string SymbolByNumber                                   |
//+------------------------------------------------------------------+
string GetSymbolString(int Number)
  {
//----
   string res="";
   res=SymbolsArray[Number];   
//----
   return(res);
  }

//+------------------------------------------------------------------+
//| âîçâðàùàåò ïåðèîä                                                |
//+------------------------------------------------------------------+
int PeriodNumber(int number)
   {
   int per_min;
   switch (number)
      {
      case 0: per_min=PERIOD_M1;break;
      case 1: per_min=PERIOD_M5;break;
      case 2: per_min=PERIOD_M15;break;
      case 3: per_min=PERIOD_M30;break;
      case 4: per_min=PERIOD_H1;break;
      case 5: per_min=PERIOD_H4;break;
      default: per_min=PERIOD_D1;break;
      }
   return(per_min);   
   }

//+------------------------------------------------------------------+
//|   âûâîäèò â ôàéë êîòèðîâêè + çíà÷åíèÿ èíäèêàòîðà                 |
//+------------------------------------------------------------------+
void RSI_output(string SymbolName,int PeriodMinutes)
   {
   int size=iBars(SymbolName,PeriodMinutes);
//----
   if (size==0) return;
   int handle=FileOpen(SymbolName+PeriodMinutes+"_RSI.csv",FILE_WRITE|FILE_CSV);
   if (handle<0) return;
   FileWrite(handle,"Time seconds;Time;Open;Low;High;Close;Volume;GBPUSD;EURGBP;AUDJPY;USDJPY;CADJPY;GBPCHF;GBPAUD;NZDJPY;RSI;ATR;ADX;+DI;-DI;5MA;13MA;25MA;50MA;100MA;150MA;200MA;Stoch-Main;Stoch-Signal;CCI;MACD-Main;MACD-Signal");
   for (int i=size-1;i>=0;i--)
      {
      FileWrite(handle,iTime(SymbolName,PeriodMinutes,i),TimeToStr(iTime(SymbolName,PeriodMinutes,i))
         ,iOpen(SymbolName,PeriodMinutes,i),iLow(SymbolName,PeriodMinutes,i),iHigh(SymbolName,PeriodMinutes,i)
         ,iClose(SymbolName,PeriodMinutes,i),iVolume(SymbolName,PeriodMinutes,i),iClose("GBPUSD",PeriodMinutes,i)
         ,iClose("EURGBP",PeriodMinutes,i),iClose("AUDJPY",PeriodMinutes,i),iClose("USDJPY",PeriodMinutes,i)
         ,iClose("CADJPY",PeriodMinutes,i),iClose("GBPCHF",PeriodMinutes,i),iClose("GBPAUD",PeriodMinutes,i)
         ,iClose("NZDJPY",PeriodMinutes,i),iCustom(SymbolName,PeriodMinutes,"RSI",0,i),iATR(SymbolName,PeriodMinutes,14,i)
         ,iADX(SymbolName,PeriodMinutes,16,PRICE_CLOSE,MODE_MAIN,i),iADX(SymbolName,PeriodMinutes,16,PRICE_CLOSE,MODE_PLUSDI,i)
         ,iADX(SymbolName,PeriodMinutes,16,PRICE_CLOSE,MODE_MINUSDI,i),iMA(SymbolName,PeriodMinutes,5,0,MODE_EMA,PRICE_CLOSE,i)
         ,iMA(SymbolName,PeriodMinutes,13,0,MODE_EMA,PRICE_CLOSE,i),iMA(SymbolName,PeriodMinutes,25,0,MODE_EMA,PRICE_CLOSE,i)
         ,iMA(SymbolName,PeriodMinutes,50,0,MODE_EMA,PRICE_CLOSE,i),iMA(SymbolName,PeriodMinutes,100,0,MODE_EMA,PRICE_CLOSE,i)
         ,iMA(SymbolName,PeriodMinutes,150,0,MODE_EMA,PRICE_CLOSE,i),iMA(SymbolName,PeriodMinutes,200,0,MODE_EMA,PRICE_CLOSE,i)
         ,iCustom(SymbolName,PeriodMinutes,"Stochastic",15,7,9,MODE_EMA,PRICE_CLOSE,MODE_MAIN,i)
         ,iCustom(SymbolName,PeriodMinutes,"Stochastic",15,7,9,MODE_EMA,PRICE_CLOSE,MODE_SIGNAL,i)
         ,iCustom(SymbolName,PeriodMinutes,"CCI",14,PRICE_CLOSE,MODE_MAIN,i),iCustom(SymbolName,PeriodMinutes,"Zero Lag MACD",12,24,9,PRICE_CLOSE,MODE_MAIN,i)
         ,iCustom(SymbolName,PeriodMinutes,"Zero Lag MACD",12,24,9,PRICE_CLOSE,MODE_SIGNAL,i));
      }
   FileClose(handle);      
//----
   return;
   }
//+------------------------------------------------------------------+
//| script program start function                                    |
//+------------------------------------------------------------------+
int start()
  {
  int SymbolCounter,PeriodCounter; 
//----
   for (SymbolCounter=1;SymbolCounter<13;SymbolCounter++)
      {
      for (PeriodCounter=2;PeriodCounter<=6;PeriodCounter++)
         {
         //Print("NewBar on ",GetSymbolString(SymbolCounter),PeriodNumber(PeriodCounter),"M");
         RSI_output(GetSymbolString(SymbolCounter),PeriodNumber(PeriodCounter));
         }
      }
   
//----
   return(0);
  }
//+------------------------------------------------------------------+

toddanderson · #**180** (**permalink**) 03-08-2009, 07:42 PM

Is thier any web sites, excel sheets that look for
data patterns , statistics,
like for example the euo moves 100 pips up what % of time reverse 20 pips
or something on a 30min time frames or similar type statistics

or just price statistics in general