Calculating Streaks with more than 2 variables

Dear All,

I have a scenario where there are 3 teams with different players competing every week.
The players may or may not make an appearance.

I have compiled a table which shows the following values of a single player for 21 weeks:

W = Winning Team
L1 = 2nd Place Team
L2 = 3rd Place Team
0 = Non Appearance

As there are more than 2 variables, is it possible to calculate the following information using a single formula for each?

Most Consecutive Appearances (W,L1,L2)
Most Consecutive Wins (W)
Most Consecutive Losses (L1,L2)
Current Consecutive Appearance

I have attached the spreadsheet with the details.

Thank you for your help!

Sorry, the desired result for the most consecutive losses should be 8 instead of 5.

Thanks and Regards,
Poko

Hi there,

Can anyone help on my query?

Thanks!

Best Regards,
Chee Heng