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

Projekt-ID: #2753483

Über das Projekt