Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hot to calculate peaks of an "irregular" sine wave | Excel Worksheet Functions | |||
Area under the curve for each peak in a graph of mulitple peaks? | Excel Worksheet Functions | |||
Identify peaks and troughs in range | Excel Discussion (Misc queries) | |||
Need to get slope of peaks on excel graph | Excel Discussion (Misc queries) | |||
Need to get slope of peaks on excel graph | Charts and Charting in Excel |