In Progress

Excel user defined function Demark

The project is to create in VBA an Excel user defined function returning the Demark TD Sequential stage.

TD Sequential is defined as explained below (given a price series, already loaded):

A. Set Up Criteria

1. For a Buy signal. Nine consecutive daily price closes which are lower than the close four days earlier.

For a Sell signal. Nine consecutive daily price closes which are higher than the closes four days earlier.

2. An Absolute Prerequisite

The day prior to the first day of a nine consecutive set up sequence must:

for a buy signal have a close higher than or equal to the close four days earlier,

for a sell signal have a close lower than or equal to the close four days earlier.

B. Count Down

For a buy signal, following the successful completion of the count down we wait for thirteen closes which are lower than the close two days earlier (not consecutive, in fact extremely unlikely to be so).

For a sell signal, after successful set up, wait for thirteen closes which are higher than the close two days earlier.

\the user defined excel function would be

i) either the stage in the set up ("SETUP-x"

ii) the stage in the countdown (Cf. BUYCOUNTDOWN-x (Cf. 1, 2,....13)

Cf. file attached for details.

P.S: the time series will only be 'closing prices' so all discussions about high / low / close should be ignored

## Deliverables

What I need is the VBA code to create a user defined excel function

The structure of the function will be

TDSequential(initial cell chosen, "H" or "V" if the function works horizontally or vertically)

The output would be

i) Setup "x"

or

ii) BUY-x or SELL-x

(see description of TD Sequential).

Skills: PHP

See more: sequential excel, demark excel, demark sequential excel, vba demark, demark count excel, function demark, sequential setup excel, sequential excel vba, sequential vba, demark signal excel, excel code sequential, demark sequential excel code, countdown excel, excel demark, works need excel, price for vba for excel, excel user defined function, what is vba in excel, vba code excel, excel function, vba function, excel count, daily time series, excel excel 2010, excel cell

About the Employer:
( 6 reviews ) United Kingdom

Project ID: #3249103

Awarded to:

slavisatosic

See private message.

$127.5 USD in 14 days
(111 Reviews)
6.0

2 freelancers are bidding on average $149 for this job

rlgoodwin

See private message.

$170 USD in 14 days
(4 Reviews)
2.9