Download MetaTrader 5

Watch how to download trading robots for free

Interesting script?
So post a link to it -
let others appraise it

You liked the script? Try it in the MetaTrader 5 terminal

2013.06.03 08:01
Libraries

Export to Excel in Real Time - library for MetaTrader 4

| English Español Português 日本語 Deutsch

Views:
12835
Rating:
votes: 10

I use DDE library provided by Windows and wrap it up so that a novice coder can use it easily.

DDE works as follow:

  1. Initialize DDE
  2. Create string handle for Excel Application (in DDE term, it is known as SERVICE)
  3. Create string handle for Sheet name (TOPIC)
  4. Connect to Sheet
  5. Free the above handles, they won't be used anymore
  6. Create string handle for cell (ITEM) using cell address in R1C1 style
  7. Send the data
  8. To export data to another cell, repeat 6-7
  9. You can reuse the already created items' handle (in case you want to update the cells regularly)
  10. Before program return, free all items' string handle
  11. Disconnect Excel and sheet
  12. Uninitialize DDE

Make sure to enable "Allow DLL imports" in Expert Advisor settings. You may need to disable MT4 DDE Server before running this script.

There are 2 files attached in this post:
  • ExcelExportLib.mq4, put this file in experts\libraries folder. This is just a simple mq4 library that wrap a few DDE functions.
  • ExcelExportTest.mq4, put this file in experts\scripts folder. This is a test script that will write text on Excel Sheet 1, cell R2C2

Cheers,

sangmane

Sliders Sliders

Uses up to 4 visual "sliders" in the chart window to quickly and easily adjust values of any technical indicator in a separate window. Based on MetaTrader 4 chart objects, not DLLs.

VR---FIGURA VR---FIGURA

Different view of the figures and the patterns of the day ....

Ichimoku Moving Average Ichimoku Moving Average

Ichimoku with Moving Average instead middle Price channel (Donchian channel) .

Aeron Expert Advisor Aeron Expert Advisor

Aeron Expert Advisor is well known. I am the author of Aeron Expert Advosor. It is based on martingale pattern and all of its parameters are fully customisable.