Skip to main content

Tools - Export of Quotes

Updated over 3 months ago

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 one to draw symbol charts, research in financial markets, use various trading tactics, and make trade decisions. Quotes represent files with records in the format of "SYMBOL, BID, ASK, DATE" (security symbol, bid price, ask price, date, and time) and income in the terminal automatically as soon as the connection to the server has been established.

The terminal allows exporting the current quotes to other programs in real-time mode through the "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 the 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 the 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.

Did this answer your question?