Help with current streak + most common text value based between two numbers

[FastLikePepe]

Hi,
I have finally had to realize my defeat after several hours spent on Google trying to solve a few formulas.
In my betting spreadsheet listed below, with most of it translated to English for you, I have marked some cells with yellow. These are the cells where I am seeking guidance.

Help

BETS NICHLAS No.,Date,Sport,Match,Bet,Odds,Amount,Result,+/-,Total,Note,Økonomi,Stats,Day,Amount 1,29/05/2022,Motorsport,Match 1,Bet 1,1,55,200,W,110,00,110,00,Deposit,20.843,00,Won,18,29/5,-200,00 2,29/05/2022,Tennis,Match 2,Bet 2,1,55,200,L,-200,00,-90,00,LIVE,Avg. profit,20,66,Lost,19,30/5,-8...

docs.google.com

First of all I am looking to calculate the current streaks of wins/losses. Somewhere in my formula (found in a Google search) I have made a mistake, as the formula is working well until it changes from W to L or from L to W (see example 1 in the spreadsheet).
Second I am looking to find out which sport is the most frequent within an odds interval. Again I have tried a formula based on a similar issue in a Google search just with two dates as criteria and without knowing if I am anywhere close to being correct.

I hope this is understandable and I am looking forward to any help you can give.

 

[etaf]

I know this question is old now and you may have already received answers or solved yourself

i can not see from your spreadsheet what you are trying to do
I have to say, i know nothing about betting

I have marked some cells with yellow. These are the cells where I am seeking guidance.

the only yellow i see is column , U - which counts the date
Result column H is all W - so not sure about you question

as the formula is working well until it changes from W to L or from L to W (see example 1 in the spreadsheet).

I assume english is not the language on the computer

with most of it translated to English for you

As this is in "General Discussion & Other Applications" , is this a question about googlesheets or a question using Excel ?

MrExcel does have a forum titled "Questions in Other Languages " - not sure if tht may be better for you , than translating the sheet

its possible that maybe
A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.