MT4 Exports to Excel Spreadsheet - HELP PLEASE! - page 2

 
HUZorba:

This is my first time trying to submit a comment. Not sure how to do so everyone can see it.


I am looking for advice/technique/programming which shows me how to transfer data from a cell in a spreadsheet (Excel or Oppen Office) into an Expert running on MT4. Any help would be apprecitated.


Thanks

I found this script recently and it works very well. You can use it to export other indicator data as well...


You can change the time frame by changing PERIOD_D1 to whatever you want :)


Best,


R

Files:
 

Hi Rich,


Another great tool from you. Thank you ! The last one I got is a staple now on my chart :D

 
yosrixp:

Hi all

i developed dll can transfer any type of data to excel, you can transfer quotes,orders,account information,indicators,etc ...,anything you want to move from mt4 to excel in real time mode,by the way i don't use DDE, i use more high performance method,so if there is anyone interest let me know


Yosri Amarneh

I am very interested! This would help me a lot in my analysis.

 
gutsu001 wrote >>

i would be very interested in this, please share this

Dear, Yosri Amarneh

Would you please help me to get this from you. I am intrested to convert RSI and other indicators in excell sheet.

 
k1alid03 wrote >>

Dear, Yosri Amarneh

Would you please help me to get this from you. I am intrested to convert RSI and other indicators in excell sheet.

Is there any body who can help?

 
k1alid03 wrote >>

Dear, Yosri Amarneh

Would you please help me to get this from you. I am intrested to convert RSI and other indicators in excell sheet.

Is there any body who can help?

 

Why dont you see here how to do that and other cool things with MT4 and Excel www.fxdialogue.com


 

Hi Yosri,

.

I am wanting to get the data in the Journal (& Experts tab) into an (Excel) SpreadSheet AFTER I have it in either Html and/or CSV file formats to analyze the data. It would appear that you have this worked out (< 8)

Will you please share it with me and others?

.

Thanks and kind regards,

DougRH4x

 
paullondon:

Hello,

When I put the following, "=MT4|BID!USDCHF" into an excel cell the USDCHF BID is exported successfully to excel.

Is there a formula (or any other way) for the 60 period simple moving average to be exported to an excel spreadsheet?

Any help is greatly appreciated.

Thanks, Paul

Paul I'm sorry for interupting your forum, but I was wondering if anyone can tell me how to open an .ex4 file? I noticed you're speaking of transfering info to Excel spreadsheets?

 
// EXCELLINK
// http://www.fx1.net/excellink.php  demonstration
//
// download and copy .dll file into experts/libraries directory
//
// This simple demonstration script in mql4
// Starts excel and generates a 5 x 5 random number generated matrix
// then adds them with help of sum() excel function
// It also demonstrates cell formatting capabilities of addon
//
#import "excellink.dll"
   int ExcelStart(string,int);
   string ExcelVersion();
   int ExcelPutString(int,int,int,string);
   int ExcelPutValue(int,int,int,double);
   int ExcelFormatCellColor(int,int,int,int,int);
   int ExcelFormatCellFontSize(int,int,int,int);
   int ExcelFormatCellFont(int,int,int,int);
   double ExcelGetValue(int,int,int);
   string ExcelGetString(int,int,int);
   int ExcelSaveFile(string);
   int ExcelSheetRename(int, string);
   int ExcelPutCalc(int,int,int,string);
   string ExcelCell(int,int);
   int ExcelUnixTime();
#import


int start()
  {
   // we open excel
   int row,col;
   string filename = "c:\temp\demo1.xls";
   int e = ExcelStart(filename,1);
   if ( e >= 0 )
      {
      // success

      // String operations and formatting
      ExcelPutString(1,1,1,"Excel Link Demonstration");
      ExcelPutString(1,2,1,"You are running ExcelLink Version "+ExcelVersion());
      ExcelFormatCellFontSize(1,1,1,15);
      ExcelFormatCellFont(1,1,1,1+2);
      ExcelFormatCellFontSize(1,2,1,12);
      ExcelFormatCellColor(1,1,1,White,Red);

      // Lets generate random numbers
      row = 3; col = 3; MathSrand(TimeLocal());
      ExcelPutString(1,2,8,"Sum()");
      for (row=2;row<8;row++)
         {
         for (col=3;col<8;col++)
            {
               if (row==2)
               {
                  ExcelPutString(1,row,col,"Col "+DoubleToStr(col-2,0));
                  ExcelFormatCellFont(1,row,col,7);
               }
               else
               {
                  ExcelPutValue(1,row,col,MathRand());
               }
            }
            // we use =sum() function to add cells
            if (row>2)
               {
                  ExcelPutCalc(1,row,col
                  ,"=Sum("+ExcelCell(row,col-5)+":"+ExcelCell(row,col-1)+")");
               }
         }

      }
         ExcelSaveFile(filename);
   return(0);
  }