Forum Discussion

windowq's avatar
windowq
Copper Contributor
Nov 07, 2021

Sports Betting

So I am made a sports betting model (very simple) and its more so just for fun. But I have been more and more interested in improving it. I recently started using power ratings found online from different sources.

Basically I have 4 different sources (power ratings) and I use the html function on excel to get them into my workbook. I then use a drop down arrow and Vlookup to get the different matchups projected spread from that power rating. And because the sources I use do not have the same names on their site (unfortunately) for example, For the Charlotte 49ers,

One says Charlotte 49ers, The other says Charlotte, another says North Carolina - Charlotte and the other says Charlotte.

So I have to put the matchup in four separate times (which is annoying).

I was wondering if anyone knows how to help me with my problem, so I only have to put the matchup in one time and it pulls from all my data bases.

 

Thanks in advance.

  • windowq 

    I assume they are differing renderings of the same team name?

    For me, the solution would to be to conduct a 'wildcard' enabled search

    = XLOOKUP(
        "*"&Name&"*",
        TeamName, 
        Pts, 
        "Not found",
        2)

    where the final 2 introduces the wildcard setting.  Without XLOOKUP, I am guessing; perhaps

    = INDEX(
         Pts, 
         MATCH(
            TRUE, 
            ISNUMBER(FIND(Name, TeamName)),
         0)
      )

    but I am not the ideal person to answer non-365 questions.

      • PeterBartholomew1's avatar
        PeterBartholomew1
        Silver Contributor
        Both within XLOOKUP and the xxxIFS family of functions a "?" and a "*" can have special significance matching a single character or multiple characters respectively. That allows a search to be conducted for a substring occurring within the target string.
  • If only don't care that

     

    Charlotte, NC

    Charlotte, FL

    Charlotte, MI

    Charlotte, Canada

     

    are different cities.

    • PeterBartholomew1's avatar
      PeterBartholomew1
      Silver Contributor
      True; the trick is to provide the minimum number of wrong answers required to define the question. A somewhat archane game of answer and question!
  • BallChrIstopher's avatar
    BallChrIstopher
    Copper Contributor
    I can definitely understand how frustrating it must be to have to enter the same matchup multiple times due to naming inconsistencies across your data sources. . I'm not an expert in Excel, but have you considered using a formula like "IF" or "INDEX/MATCH" instead of VLOOKUP to match the team names across your different sources? That way, you could input the matchup once and have the formula do the rest of the work for you.
  • tundra18's avatar
    tundra18
    Copper Contributor

    It's fascinating to hear about your sports betting model and how it started as a fun project but has now evolved into a deeper interest for improvement. Incorporating power ratings from various online sources sounds like a smart move to enhance your model's accuracy. Remember, sports betting can be an engaging hobby, but it's essential to approach it responsibly and be aware of the risks involved. Continuously seeking data and refining your strategies can lead to more informed decisions. If you're interested in exploring further insights, websites like https://affiliazionescommesse.com/ might offer valuable informatio

    • BrianMarks's avatar
      BrianMarks
      Copper Contributor

      Dealing with inconsistent team names can be a hassle. One solution could be creating a mapping table where you associate different names with a standardized one, like "Charlotte 49ers." This way, you can input the matchup once, and your model can reference the standardized name across all databases. By the way, have you considered checking out SFTC CFB consensus for college football? It might provide some useful insights for your model!

  • KoltzSteiner's avatar
    KoltzSteiner
    Copper Contributor

    Sports betting is good both as entertainment and as a way to earn money. Some even consider it a more stable way to make money online. But honestly, I’m a fan of gambling and can’t help myself, even though sometimes I do think it’s riskier than betting. Speaking of gambling, choosing an online casino can be done using reviews, which is the safest and most secure option for me. From what’s new, I recommend trying crypto casinos like those found at https://bestcrypto.casino/. I think this is a safer option right now because you can withdraw your earnings anonymously with the help of trusted crypto wallets.

Resources