question re DDE to Excel data transfer

I'm looking at the DDE-sample.xls provided by MT4 and it works fine.

It shows the DAILY high/low/last etc in the Excel cells.

However I want to DDE the high/low/last of the chart timeframe that I am currently looking at. (or even specify a different timeframe)

How can I change the timeframe of the high/low/last of the DDE data going to Excel??

Thankyou for any help

I think you misunderstand DDE. It is simply a raw data feed from one program to another. No filtering or formatting is done. In the case of MT4, the feed is tick data. Tick data is fed into charts on the MT4 platform. Think of your spreadsheet as another "chart" receiving tick data and you might have a better idea of what is happening.

To do what you want would require data manipulation in Excel with macros or VBA which is not easy.

Thankyou for your reply CodeMeister

What you are saying makes sense

BUT

if you look at the spreadsheet "DDE-sample.xls" as supplied by MT4 in the 'MetaTrader' folder - it shows the daily HIGH and daily LOW (as well as the current BID and ASK)

This daily HIGH and LOW is updated in realtime is a result of the statements:

BID request: = MT4|BID!USDCHF
ASK request: = MT4|ASK!USDCHF
HIGH request: = MT4|HIGH!USDCHF
LOW request: = MT4|LOW!USDCHF
TIME request: = MT4|TIME!USDCHF
QUOTE request: = MT4|QUOTE!USDCHF

--As supplied from the MT4 help.--

So my question is: do these statements (high and low) ONLY apply to daily bars or can it be changed to 1 min or 5 min bars.

I'm a bit rusty on Excell, but as you say that may be the only way.

Any help appreciated.

dde client and server have to use the same predefined data format in order to exchange information. when server send data 0100 0001 (binary), without knowing the format of that data, client can display this data as "65" or "A".

afaik, other than tick data, MT4 DDE server only provide high/low of daily bar. to get hi/lo of another time frame, the workaround would be:
1. having a dde wrapper in the form of dll and call it from mt4 indicator. indicator supply the value of hi/lo, dll send / poke that data to excel. in this scenario. excel act as dde server
2. having a separate dde server which is linked to MT4 so that MT4 (via ea/indictor) can provide up-to-date data to this dde server. excel connect to this dde server and request data when you typed "service_name|topic!item". in this scenario, excel act as client.

hth

DDE is raw data. It is not formatted in any manner that is selectable. There is no way to do what you suggest without coding.

Most people export CSV file data from MT4 to Excel if they want chart specific data. There are a number of EAs on the forums to do this for you.

i don't understand what you mean by "DDE is raw data". What is raw data and what is not raw data?
DDE is not about the data itself. Dynamic Data Exchange is a protocol that regulate how to exchange data. You can send string, integer, double, even picture using DDE, as long as you follow the protocol, and provide information about the format of data you are exchanging to the other side.

From the technical point, you are right. I was trying to put it into terms that a non technical person could understand. That isn't easy.