Basic formulae for MS Excel stockmarket / forex spreadsheet

I have a MS Excel 2010 spreadsheet containing OHLC price data, and ATR / Keltner Channel values for each row.

I need further calculations applied to specific rows as outlined in the Detailed Requirements.

## Deliverables

RULESET ONE

a1) Find the first row where C is > I (for example row 27)

a2) Count forward the number of rows specified in S10 (for example "2")

a3) Does the value of D in each of the count-forward rows (ie D28 and D29), stay above the value of the first row's D value (ie D27). If so mark row 27 as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat

b1) Find the first row where D is < J

b2) Count forward the number of rows specified in S10

b3) Does the value of C in each of the count-forward rows, stay below the value of the first row's C value. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat

RULESET TWO

c1) Find the first row where C is > I

c2) Count forward the number of rows specified in S10

c3) Does the value of D in each of the count-forward rows, stay above the value of K on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat

d1) Find the first row where D is < J

d2) Count forward the number of rows specified in S10

d3) Does the value of C in each of the count-forward rows, stay below the value of K on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat

RULESET THREE

e1) Find the first row where C is > I

e2) Count forward the number of rows specified in S10

e3) Does the value of D in each of the count-forward rows, stay above the value of J on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat

f1) Find the first row where D is < J

f2) Count forward the number of rows specified in S10

f3) Does the value of C in each of the count-forward rows, stay below the value of I on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat

Calculate number of wins as a percentage of total number of trades (ie if we had 60 wins and 40 losses then the percentage of wins would be 60%) for each ruleset, so that we have separate percentage wins figure for Ruleset One, Ruleset Two and Ruleset Three.

Excel Microsoft Access Microsoft Exchange Powerpoint Windows Desktop Word

Kitambulisho cha Mradi: #2753483

Kuhusu mradi