Determining length of trend before significant retrace

  • Thread starter DouglasinHawaii
  • Start date
D

DouglasinHawaii

In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace. (x in this case being a specified whole
number)
Please help with a formula or direct me to where I could find this
information.
Using Excel 2007
For example: in range of numerical data, the largest directional integer
movement was 300 before the data moved 25 in reverse.
Example 2: The largest directional integer movement was 224 before
the data moved 30 in reverse.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top