Nov 07 2021 08:07 AM
Nov 07 2021 08:07 AM
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.
Nov 07 2021 08:44 AM
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.
Nov 07 2021 10:31 AM
Nov 07 2021 01:10 PM
Mar 27 2023 03:46 PM
Aug 03 2023 05:50 AM - edited Aug 07 2023 08:14 AM
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
Sep 24 2023 01:26 PM - edited Sep 26 2023 04:47 AM
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!