how to fetch different time frame data in excel from mt4?

[[Deleted]]

Hi,
I am currently developing a calculator.But that i will need mt4 data in excel.
Well i know that basics of excel data fatching with DDE server and formulas like

Quote:

=MT4|bid!EURUSD Instead of "bid", you can also put: ask, open, close, high, low & volume

But this shows daily data range.Does anybody knows,any tricks or way,where i can fetch data per chart and time frame wise.Cause for 5M or 1M chart frame,High and low will be different.

Any information will be helpful.

Thanks.