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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04/01/2000[/TD]
[TD]96.19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03/01/2000[/TD]
[TD]94.31[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04/01/2000[/TD]
[TD]96.19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03/01/2000[/TD]
[TD]94.31[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Kind regards