Sequences of positive and negative numbers in array

The Excel spreadsheet I have created will answer the first four asterisks you pose. Here is how to read my spreadsheet:

Column A: This is where you enter your sequence or list of numbers.

Columns B thru Columns E: These columns are there to help generate the output.

Columns G and H should give you what you need.

A few important things to note.

(1) The formulas in cell C1 and the rest of column C are different in nature.
(2) The formulas in cell E1 and the rest of column E are different in nature.
(3) This spreadsheet assumes that the winnings are strictly positive or strictly negative, i.e., no zero winnings.
(4) This spreadsheet assumes that there is always a mix of strictly positive and strictly negative numbers. If there are only strictly positive numbers, then the output relating to the losing total and losing streak will show 1 (and you will know from seeing this that there are only winnings in your list in Column A). A similar situation holds for the case when there are only losses. Book1.xlsx