Closed

Excel user defined function Demark

This project was awarded to slavisatosic for $127.5 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $5000 USD
Total Bids
2
Project Description

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).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online