Basic formulae for MS Excel stockmarket / forex spreadsheet
$30-100 USD
착불
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.
프로젝트 ID: #2753483