# Current Streak

1. ## Current Streak

Hello, if anyone can help that would be great. I asked in a previous post on another site, not the exact same question but similar but it did not work.

I'm looking for the current streak for ATS and straight up W/L. I've attached a workbook and I have the final scores for away and home teams with how each game finished, W or L for both ATS and straight up. If someone can help to determine what the current streak is for each team. For example the Bears finished the season -1 in ATS and -1 in W/L straight up.

Can someone come up with a formula for that, that would be really awesome!

2. ## Re: Current Streak

First, I don't know what ATS means. But, on the sheet it says that you want find the current W/L streak. Are the games listed in order with the most recent game being at the bottom of the list?
How do you get a negative streak. The least a streak can be (if it can be a W or a L streak) would be 1 (whether it's a W or a L). If I'm looking at this correctly (and apparently, I'm NOT), the Bears most recent game was a loss (row 240). The game before that (row 231) was a W. So I would consider their streak to be 1 (Loss), but your worksheet shows 3. So if you can explain the logic behind that, that will help.

3. ## Re: Current Streak

Hey Greg, thanks for getting back. ATS means against the spread. But we can use W/L rows. Yes the most recent games are at the bottom. That is correct the Bears most recent game was a L, so -1. In my worksheet I only included 3 as an example but that is not correct, it should be -1. So I would be looking for the formula for the streak for W/L.

Thanks..

4. ## Re: Current Streak

I asked in a previous post on another site, not the exact same question but similar but it did not work.
Thanks for telling us, but can you please provide details of the site and the thread in question? You are required to do this to fall in line with the forum rules. You may have to post the link in sections as you have under 10 posts here.

When you have done that, explain the numbers: what do -1 and 3 represent?

5. ## Re: Current Streak

Hi, yes for sure. It was ozgrid and I was asking for how to find the against the spread wins and losses in the last 5 games as well as how to find the current streak. The first part was resolved, ats wins and losses in the last 5 games but the latter, current streak was not. A formula was provided but not correct. Let me know is this works. Thank you.

6. ## Re: Current Streak

Here is the required cross-post link: https://www.ozgrid.com/forum/index.p...ak#post1250201

On OzGrid you said you had a solution but failed to share it. What was the solution and where did you get it from?

This is why both forums have the cross-post rule - it's to avoid our time being wasted.

7. ## Re: Current Streak

Hello, I have provided the solution in OzGrid with the formula and workbook for reference. Thanks.

8. ## Re: Current Streak

Good evening just bumping this up to see if anyone can help. Thank you.

9. ## Re: Current Streak

You have a solution on the other forum. What more do you need?

10. ## Re: Current Streak

Hello, part of the question was resolved, how to calculate wins and losses in the last 5. But the calculate streak was not. Although a formula was provided it is not correct. It does not match up. Im looking for a formula only to calculate current streak.

Thanks if anyone can provide help.

11. ## Re: Current Streak

This has been solved thanks.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1