MGCOLBY's Picker Thread 2024

[mgcolby]

Ok sorry for not updating this yesterday. The excel file became a total shitshow. I spent every free minute I had yesterday and my entire evening unfucking the shitshow that it became. I have still have to work out the automation of the lines. So be careful and double check those, which you should be anyway as the lines are constantly moving. The prediction data is accurate and correct IAW the formula. Here is today's game. I included the scores of the games already played.

Edit Note: the yellow highlighted text indicates a predicted win for the dog based on this morning's lines.

 

[mgcolby]

Can A.I. automate it for you?

That is what I am using to write the vba macros. I am pretty solid with M query for Power Queries in excel. But this is pretty complex from just from an organization perspective. And ironically that is what led to my shitshow yesterday. Just blindly following the Grok code changes which work pretty well in general. But it does cause issues when working on different vba scripts within the vba project. Essentially after so long it forgets the base parameters of various functions and modules and how they work together. When that happens it inserts calls within the script code that are already a shared function for all the modules. This caused a bunch of corruption. Then I went back into the versioning and opened a previous version, but then I needed to work back to where I was etc...it sucked. It is now functioning again with a bit of manual labor. I will work on that this weekend.

But to your overall question, yes! I wouldn't be as far on this as I am without it. This has also opened my eyes for ways to streamline the NFL picker. But more importantly, it has shown me that I can essentially create one for any sport assuming I can come up with a formula that works for that sport. But that is down the road.

 

[mgcolby]

Here is yesterday's results. I am running the script to scrap the data and it takes a bit hour to hour and a half. Its been running for about 20 minutes. Hopefully I will have it up in time for the 3pm games. There are 100 games today.

 

[mgcolby]

A little late but here it is:

Still a lot of manual entries on the lines. Hence why the Moneyline column is not completely filled out. Ran out of time. Lines are constantly moving so as always verify the lines are still accurate when placing the bet. Yellow are dogs it predicts to win outright.