Sports Betting

[windowq]

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.

[#2]

@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.

[#3]

If only don't care that

Charlotte, NC

Charlotte, FL

Charlotte, MI

Charlotte, Canada

are different cities.

[#4]

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!

[#5]

@Peter Bartholomew 

What is wildcard?  

[#6]

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.

[#7]

It is not so easy to earn enough money these days. Therefore, I decided to try myself in the role of betting, especially since I know a little about football and tennis. I accidentally stumbled upon betonline promo code and immediately used its bonuses in various offices. Anyone who is interested in the field of sports and betting, I advise you to take a closer look.

[#8]

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.

[#9]

Apologies for the late response, but I just saw your post.One potential solution that comes to mind is to create a separate table with all of the different naming variations for each team. Then, you could use the INDEX-MATCH function to look up the correct team name in your main data table based on the matchup you entered. Additionally, if you're looking for more inspiration and tools for your sports betting project, you might want to check out Online Glücksspiel Österreich. This website offers access to a range of top-notch gaming sites and platforms that can provide great functionality and insights to help you find the solution you need. It’s a great place to start exploring and discovering new ideas for your project.

[#10]

Thanks for your information, guys. Even though you shared it a long time ago, it's still helpful.

[#11]

Hi, I'm new to this forum and just stumbled upon this old post. Have you considered using a macro in Excel to automate this process even further? It might take a little bit of time to set up, but it could save you a lot of hassle in the long run. Btw, have you heard of bandar bola resmi? It might be worth checking out if you're looking to improve your model and streamline your data sources. They can often provide more consistent naming conventions for teams and matchups, which would solve your problem of having to input each matchup four separate times.