Hi,
Below is a table with the daily settlment price for ICE Brent Futures. Highlighted in red are three consecutive days on which Brent finished in the red. I would like to be able to find the last time Brent suffered three consecutive daily losses or more. In other words, I would like to be able to make statements similar to the following: "This is Brent's longest losing streak since the [# of days] ended [date]."
Many thanks for all your help in advance.
Below is a table with the daily settlment price for ICE Brent Futures. Highlighted in red are three consecutive days on which Brent finished in the red. I would like to be able to find the last time Brent suffered three consecutive daily losses or more. In other words, I would like to be able to make statements similar to the following: "This is Brent's longest losing streak since the [# of days] ended [date]."
Many thanks for all your help in advance.
![EpuD4jI.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FEpuD4jI.jpg&hash=f90156a1234509c0273314da012bb7ec)