A function to obtain max and min price over last 24 hours for a pair into Excel

[Anupam Sharma]

Hi,

I want to write a routine to make buy/sell decisions based on:
- Current price for EUR/USD and USD/CHF
- Min and Max of these pairs over the last 24 hours

I prefer to do this in Excel as I know it quite well.

Is there a MT4 function I can use in Excel which will give me the min and max of a pair over the last 24 hours?

Regards....

[rv]

chiefandroid wrote >>
Hi,

I want to write a routine to make buy/sell decisions based on:
- Current price for EUR/USD and USD/CHF
- Min and Max of these pairs over the last 24 hours

I prefer to do this in Excel as I know it quite well.

Is there a MT4 function I can use in Excel which will give me the min and max of a pair over the last 24 hours?

Regards....

dde, look to the samples in the folder of MetaTrader Installation

[Anupam Sharma]

EADeveloper:

dde, look to the samples in the folder of MetaTrader Installation

I only see 1 sample Excel file there, "DDE-Sample.xls". Do you mean this one? I did not see anything there except current quotes.

[Fadel]

here it is the high and the low for the past 24 hours

ExcelSetValueCell(2,4,iHigh("EURUSD",PERIOD_D1,1));

ExcelSetValueCell(2,5,iLow("EURUSD",PERIOD_D1,1));