Hello, I'm trying to figure out a formula to tell me how long a price has been negative for (consecutive days up until todays date)
For example:
21 June 20 June 19 June 18 June 17 June 16 June 15 June 14 June
.....-3........-2.........-8..........5...........4...........3.........-5........-8....
If todays 21st June - How many days has the row been negative for: answer = 3 days (incl 21st)
So, firstly, only if the number is negative - then I want to know how long has it been negative for.
many thanks in advance for the help
Paul
Bookmarks