Peak/Trough analysis

[skyup0053]

Hello,

I'm working on a pet project for my economics thesis that deals with the Federal Funds Rate and several other capital market rates. I'm charting 2 rates at a time against each other and would like to measure the areas that are peaks and the areas that are troughs with each respective rate.

I have 478 rows of data for each rate, so there's a good deal of data.

Any idea how to do this?

Thanks!

 

[shg]

Welcome to the board.

How do you define peak and trough? It it as simple as local minima and maxima?

 

[skyup0053]

I'm trying to be as thorough as possible. So, yes, local minima and maxima would probably be correct.

 

[shg]

Like this?

       --A--- ---B---
   1    Data  Extrema
   2   621.78        
   3   334.19 min    
   4   417.78        
   5   668.71 max    
   6   655.15        
   7   403.79 min    
   8   433.79        
   9   532.91        
  10   726.11 max    
  11   491.96 min    
  12   558.43 max    
  13   464.68        
  14   444.66 min    
  15   593.18 max    
  16   347.46 min    
  17   530.22 max    
  18   456.69

The formula in B3 and down is

=IF((A3>A2)*(A3>A4), "max", IF((A3<A2)*(A3<A4), "min", ""))

 

[shg]

Oops:

=IF((A3>A2)*(A3>A4), "max", IF((A3< A2)*(A3< A4), "min", ""))