I thought they came with sample excel spreadsheet when you install MT. Here's one for you not from the install.... From what I read, the stuff you can do with it is very limited, there was something posted metaquotes.net with all the functions you can use to get information, but like like I said, its not much.
Excel 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.
|
Joined Apr 2006
|
Status: Friss Die Haelfte
|110 Posts
I have collected links and spreadsheets in this Thread. There is one in there with DDE links and also on one of the treads there is some instructions to get it to work on Open Office as well.
Hope it helps. Please post any useful spreadsheets you have or find.
Its a shame that metatrader does not allow one to retrieve previous prices this way except for the current bar. It would be nice if one could use the functionality to send alerts based upon various indicators for those who does not know how to code an EA.
Excel 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.
