LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Finding major peaks and troughs

Hi Guys, I wonder if anyone can share me on how to find the major peaks
and valleys(trough) of an array of time series daily data (eg. stock
data).
A major Peak needs the following conditions to be formed:
1. Must be the highest peak since last major Trough and
2. Must be at least some percentage (eg. 10%) higher than that Trough.

A major Trough needs the following:
1. Must be the lowest trough since last major Peak and
2. Must be at least some percentage (eg. 10%) lower than that Peak.

You kind cooperation is very much appreciated.


zack

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hot to calculate peaks of an "irregular" sine wave federico tiso Excel Worksheet Functions 1 November 16th 11 07:56 AM
Area under the curve for each peak in a graph of mulitple peaks? Kn Excel Worksheet Functions 0 April 10th 08 10:01 PM
Identify peaks and troughs in range James Booth Excel Discussion (Misc queries) 1 November 23rd 05 09:21 PM
Need to get slope of peaks on excel graph Capillod Excel Discussion (Misc queries) 3 May 13th 05 03:58 PM
Need to get slope of peaks on excel graph Capillod Charts and Charting in Excel 3 May 13th 05 03:16 PM


All times are GMT +1. The time now is 08:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"