Excel Formula

Hi,

I tried to convert a MQ4 file to an Excel file manually.

So I search the codes in the in the Turtle Trading indicator and this are the results:

Go Long:

if(((CLOSE > rhigh && i > 0) || (HIGH > rhigh && StrictEntry == true)) && LongInfo[i] == OUT_OF_MARKET)

Go Short:

if(((CLOSE < rlow && i > 0) || (LOW < rlow && StrictEntry == true)) && ShortInfo[i] == OUT_OF_MARKET)

Stop Long:

if(((CLOSE < slow && i > 0) && (CLOSE > long_price || Greedy== false)) ||

(LOW < slow && StrictExit == true && (LOW > long_price || Greedy == false)) &&

LongInfo[i] == IN_THE_MARKET)

Stop Short:

if(((CLOSE > shigh && i > 0) && (CLOSE < short_price || Greedy == false)) ||

(HIGH > shigh && StrictExit == true && (HIGH < short_price || Greedy == false)) &&

ShortInfo[i] == IN_THE_MARKET)

The formula for excel (Go Long) should be: =ALS(EN(CLOSE>rlow;LOW>rlow);CLOSE;0)

... I want to calculate the Close Value, so if the formula is 'true' I want to see the Close value of it.

But it didn't work.

Who know the correct formula's for the entries and stops (for long and short)?

The system is attached as a zip (including Excel, ex4 and mq4 file).

Specification:

A. The Trading strategy is based on Turtle Trading system.

B. Rules of opening positions:

1). Signals to open long position (buy):

    - CLOSE > than rHigh (only the first bar)

2). Signals to open a short position (short):

    - CLOSE < than rLow (only the first bar)

3). Signals to exit a long position:

    -When the short position starts, the previous bar/line

4). Signals to exit a short position:

    -When the long position starts, the previous bar/line

5). It's the same formula that be used in the attached file on the jobpage.

rHigh = The highest value in a period (20)

rLow = The lowest value in a period (20)

rHigh = Lowerline

rLow = Upperline 

A more extensive explanation is enclosed. 

Best Regards,

Bastiaan