MetaTrader 4 Help
MetaTrader 4 HelpToolsExport of Quotes

Export of Quotes

Source data serving as a basis for the entire analytical work of the terminal user are those about security price changes. This information is provided by the brokerage company. Price data allow to draw symbol charts, research in financial markets, use various trading tactics, and make trade decisions. Quotes represent files with records in format of "SYMBOL, BID, ASK, DATE" (security symbol, bid price, ask price, date and time) and income in the terminal automatically as soon as connection to the server has been established.

The terminal allows to export the current quotes to other programs in the real-time mode through "DDE" (Dynamic Data Exchange) protocol. This is a protocol of operational systems of MS Windows used for dynamic data exchange among various applications. Quotes are given through DDE only at incoming of new ticks (ADVISE mode), but not immediately on request (REQUEST mode) where the latest price is shown. N/A is shown on the first REQUEST, and after the new price has been income, quotes will appear.

To activate the export of quotes from the terminal through DDE, one has to enable the "Enable DDE server" option in the terminal settings.

Attention: History Data cannot be exported through DDE protocol. The current quotes are exported only when the client terminal is online.

DDE request formats and their possible results by the example of "DDE-sample.xls" file:

   BID     request:    = MT4|BID!USDCHF         result:  1.5773
   ASK     request:    = MT4|ASK!USDCHF         result:  1.5778
   HIGH    request:    = MT4|HIGH!USDCHF        result:  1.5801
   LOW     request:    = MT4|LOW!USDCHF         result:  1.5741
   TIME    request:    = MT4|TIME!USDCHF        result:  21.05.02 9:52
   TIMESEC request:    = MT4|TIME!USDCHF        result:  21.05.02 9:52:43
   QUOTE   request:    = MT4|QUOTE!USDCHF       result:  21.05.02 9:52:43 1.5773 1.5778 1.5776

Attention: For data to be shown properly in MS Excel, one has to enable "Tools – Options... – Translation – Translation formula entry" menu option of MS Excel.