Can anyone tell me how to create a live DDE/OLE link from a price feed to an Excel spreadsheet?
Every market live Excel dashboard 19 replies
MT4 to Excel through Excel RTD (Finally!) 609 replies
Importing live data into excel? 19 replies
live quotes to Excel from brokers that do not use MT4 ? 1 reply
DislikedExcel implements a DDE client with a syntax that is extremely easy to use and helps in debugging. To communicate, the client needs to know the DDE Application name, the DDE Topic, and the DDE Item. To make a request, the syntax is as follows: =DDEAppName|DDETopic!DDEItem
The DDEAppName for Metatrader 4.0 is MT4, the supported DDETopics are listed below:
<table class="txt2" height="286" width="508"> <tbody><tr> <th>DDE Topic</th> <th>DDE Item</th> <th>Description</th> <th>Example</th> <th>Output</th></tr> <tr> <td>BID</td> <td>Forex Pair</td> <td>Requests Bid price for pair</td> <td>=MT4|BID!EURUSD</td> <td>1.2294</td></tr> <tr> <td>ASK</td> <td>Forex Pair</td> <td>Requests Ask price for pair</td> <td>=MT4|ASK!EURUSD</td> <td>1.2298</td></tr> <tr> <td>HIGH</td> <td>Forex Pair</td> <td>Requests High value price for pair</td> <td>=MT4|HIGH!EURUSD</td> <td>1.2306</td></tr> <tr> <td>LOW</td> <td>Forex Pair</td> <td>Requests Low value price for pair</td> <td>=MT4|LOW!EURUSD</td> <td>1.2262</td></tr> <tr> <td>QUOTE</td> <td>Forex Pair</td> <td>Returns full information on pair</td> <td>=MT4|QUOTE!EURUSD</td> <td>2006/08/30 17:12
1.2294 1.2298</td></tr> <tr> <td>TIME</td> <td>
</td> <td>Returns time of last tick</td> <td>=MT4|TIME</td> <td>2006/08/30 17:12</td></tr></tbody></table> The DDE Topic STATUS and DDE Items ACCOUNT, BALANCE and CONNECT have been deprecated and obsoleted in version 4.0 of the client.
You have to enable the DDE Server inside your MT4 client, which has to be running.
Tools -> Options -> Server -> Enable DDE Server.
Hope this helps.
-johnIgnored