Basic formulae for MS Excel stockmarket / forex spreadsheet

Cancelled Posted Jun 23, 2012 Paid on delivery
Cancelled Paid on delivery

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

Project ID: #2753483

About the project

12 proposals Remote project Active Jul 2, 2012

12 freelancers are bidding on average $51 for this job

dpune

See private message.

$50.15 USD in 3 days
(129 Reviews)
6.2
DenisSmolentsev

See private message.

$120.7 USD in 3 days
(40 Reviews)
4.5
subramaniankv

See private message.

$55.25 USD in 3 days
(30 Reviews)
4.2
gonzalobianchi

See private message.

$25.5 USD in 3 days
(24 Reviews)
4.3
ultimate1vw

See private message.

$50.15 USD in 3 days
(5 Reviews)
3.6
zhoumo

See private message.

$50.15 USD in 3 days
(1 Review)
3.3
zydeconinte

See private message.

$12 USD in 3 days
(2 Reviews)
1.6
khailo

See private message.

$20.4 USD in 3 days
(2 Reviews)
1.6
jakobbs

See private message.

$10 USD in 3 days
(0 Reviews)
0.0
boardampfield

See private message.

$70.55 USD in 3 days
(0 Reviews)
0.0
gagangags

See private message.

$85 USD in 3 days
(0 Reviews)
0.0
louissavalli

See private message.

$60.35 USD in 3 days
(0 Reviews)
0.0