Hi, first time user, therefore apologies if i am re-posting that which has been posted before.
I have the net cumulative total return daily series for the FTSE 100 and i am trying to write a formula that will calculate the peaks and troughs from start date to latest date.
So my dates are in column A: 03/01/2000, 04/01/2000, 05/01/2000 etc
My returns are in column B
I would like to identify the peaks and troughs in column C.
<tbody>
</tbody>
Kind regards
I have the net cumulative total return daily series for the FTSE 100 and i am trying to write a formula that will calculate the peaks and troughs from start date to latest date.
So my dates are in column A: 03/01/2000, 04/01/2000, 05/01/2000 etc
My returns are in column B
I would like to identify the peaks and troughs in column C.
A | B | |
04/01/2000 | 96.19 | |
03/01/2000 | 94.31 | |
<tbody>
</tbody>
Kind regards