Working with Excel (tools, indicators, conversion ...) - page 27

To add comments, please log in or register
Mladen Rakic
145467
Mladen Rakic  
moncypothen:
Dear friends,

I would request your help to resolve some issues related to data export from MT4 to Excel using the script output_history2.mq4. Thanks to of forum Forex factory and all who contributed to the development of the script.

Issues:

1. We have to Execute the script output_history2.mq4 on each time frame of each pair to get the data exported for each pair and time frame.

2. We have to open each data file exported to the MT4/expert/files folder to update the data in our Excel worksheet.

We have to continue the process each time whenever we want to update the data in our excel worksheet.

If somebody convert the script Output_history2.mq4 to an indicator or ea which should stay on each pair and export and update the data on optional intervals like 1M, 5M, 15M, 30M or 1Hour. This will resolve the first issue.

Secondly please think how do we update the excel worksheet without opening all the files in the expert/files folder each time when we need to update the excel worksheet. Experts please help. Thank you all in advance.

I am attaching the Output_history3.mq4 with some changes and my excel worksheet with data exported from csv file. I do not have any knowledge in the making of MT4 scripts or indicators hence I am not able to any changes on the script. I am using Metatrader Platform from Pepperstone which is providing all the pairs as listed on my Excel worksheet.

moncypothen

Since metatrader does not allow normal output to any folder but the files folder, you can not avoid that

Karl
38
Karl  

Hello, could I kindly ask you to fix this script? I've had Open, High, Low, Close and many other indicators on the old version of MT4. However, I updated MT4 and it is no longer working.

csv_export_script.mq4

Many thanks,

Karl

Files:
Mladen Rakic
145467
Mladen Rakic  
akrolytis:
Hello, could I kindly ask you to fix this script? I've had Open, High, Low, Close and many other indicators on the old version of MT4. However, I updated MT4 and it is no longer working.

csv_export_script.mq4

Many thanks,

Karl

Karl

Please check this post : https://www.mql5.com/en/forum/179357/page110

Karl
38
Karl  
mladen:

Karl

Please check this post : https://www.mql5.com/en/forum/179357/page110

mladen,

Thank you. However, it's not working for me. Could you please tell me why? More details are here.

If anyone has something similar, I would be appreciate.

BR,

Karl

Mladen Rakic
145467
Mladen Rakic  
akrolytis:

mladen,

Thank you. However, it's not working for me. Could you please tell me why? More details are here.

If anyone has something similar, I would be appreciate.

BR,

Karl

Karl

Sorry, but since on my terminal it is working OK I can not reproduce what is happening on your terminal (I would need to have an error in order to start looking for the cause of the error, and that I can not do since I do not have that error)

Muhammad Syamil Bin Abdullah
1379
Muhammad Syamil Bin Abdullah  
matfx:

I have found an excel file which enable import MT4 data to analyze the USD, CHF, EUR and GBP strength against other crosses. Furthermore it does have multiple informations at a glance. Just allow MT4 DDE server, then open the excel file. All quotes will be refresh. Quite useful visual tools. Enjoy.

This excel file still working, open with LibreCalc and updated.


Oguzhan Atman
58
Oguzhan Atman  

Hello,

I need to help about calculation smooted moving avarega in excel.I'am using this formula;

SUM1 = SUM(CLOSE, N)
SMMA1 = SUM1/N

SMMA(i) = (SUM1-SMMA1+CLOSE(i))/N

Where:
SUM1 — is the total sum of closing prices for N periods;
SMMA1 — is the smoothed moving average of the first bar;
SMMA(i) — is the smoothed moving average of the current bar;
CLOSE(i) — is the current closing price;
N — is the smoothing period.

Example

Close

1.24908

1.24927

1.24933

1.24929 and i want to calculate smma(3).

SUM1=1.24908+1.24927+1.24933

SMMA1=(1.24908+1.24927+1.24933)/3

SMMAi=(1.24908+1.24927+1.24933)-(1.24908+1.24927+1.24933)/3+1.24929)/3=1.24925


So my result is 1.24925 but the real result is 1.24918. Can you help me how to calculate in excel?

Thank you.

STAVROS
193
STAVROS  

Hello

I would like to ask if someone can help me, I have a program written in excel language and I would like to convert it to MQL4 so that I can do automated transactions. Is there some software I can write a type written in excel and converts it to MQL4 ? 


Thanks 

STAVROS
193
STAVROS  

I need some tools i make convert excel to MQL 4 / MQL 5 . Have somebody help me .......

Sergey Golubev
Moderator
111875
Sergey Golubev  

Excel

Systems and tools

  1. Working with Excel (tools, indicators, conversion ...) - the thread 
  2. Forex data converters thread 
  3. MULTI FIBO CALCULATOR with DDE off course - the thread 
  4. FX risk calculator with DDE - the thread 
  5. Excel Spreadsheet to simulate cost averaging strategies objectively - the thread 

Articles

  1. MQL5 Cookbook: Writing the History of Deals to a File and Creating Balance Charts for Each Symbol in Excel - the article
  2. How to Prepare MetaTrader 5 Quotes for Other Applications - the article

CodeBase

  1. Export Indicator's Values - MT5 tool 
  2. Export Summary Grouped by Symbols - script for MetaTrader 5
  3. VR Orders History MT5 Lite - script for MetaTrader 5
  4. DDE - Server - MT5 tool
  5. History Dump CSV with heat map for Excel analysis - MT4 tool 
  6. MS Excel: Data Exchange and Management - MT4 tool 
  7. Export to Excel in Real Time - MT4 tool 
  8. MetaCOT 2 CFTC ToolBox (Set of Indicators) MT4 - COT in Excel 
  9. Export Trades to excel - MT4 script 
  10. Converting hst-files into csv files - MT4 tool 
To add comments, please log in or register