MGCOLBY's Picker Thread 2024

[Deus Irae]

03/28/2025

Went old school today. Tried using the not ready for prime time system yesterday and in a rush I put the wrong totals in. Prediction scores were what they should of been etc...Hopefully I'll have this beast conquered shortly. Until then the old way:

View attachment 17498

I went the "didn't get home in time to put the games in, so am stuck, again, with whatever the hell the program assigned" method.

 

[mgcolby]

03-29-25

So I now have the new automated score working (mostly), azure has some issues but the functions in SQL all work and display correctly. Which has been monumental process to tackle for me as I have zero sql experience. However, because I had to change the formula up a bit for not wanting to webscrape any longer and use APIs. One of the things in the new model formula (i.e. where the confidence score comes from for the original model) is not available via API, so I had to develop my own version to replace it so it changed the new model methadology slightly. I will display that outcome in a seperate post along with a new feature I worked on as well.

 

[mgcolby]

The new model has the scores:
Texas Tech: 75.9
Florida: 82.5
Total: 158.3

Alabama: 82.3
Duke: 86.3
Total: 168.6

 

[Kontradiction]

The new model has the scores:
Texas Tech: 75.9
Florida: 82.5
Total: 158.3

Alabama: 82.3
Duke: 86.3
Total: 168.6

Took the under at 157. I was happy to see those free throws go in and lose the money.

 

[mgcolby]

Took the under at 157. I was happy to see those free throws go in and lose the money.

I took TT and Alabama on the spread. I knew better than to take Alabama, they shot some stupid 50+ from the floor and 3s the other night. But I did it anyway. So went 1-1.

 

[PM15]

@everyone else! eat cock and watch!

I went on a vacation so had to detox from the web. Cruise to be exact.

 

[mgcolby]

My apologies for the neglect gentlemen. Saying I have been busy with work and then the picker automation in Azure is an understatement. I have spent more time than I care to admit, building out an Azure SQL backend and functions app. Note not having any SQL experience that would be worth noting. But after many, many, many trials and tribulations over the past 15 days or so I have nearly conquered. I putting the final touch on the output display as I type this. Hopefully I will have tonight's picks up shortly. I am through the roof with the new system. Bye bye excel! Hello Happiness.

 

[mgcolby]

Until I get the final output displayed correctly, here is the sql output so its out there:

 

[mgcolby]

Again not ready for primetime having table display issues. But this is sneak peak before 9pm. Notice the total column is not displaying correctly and its a bit scrunched due to it pumping out the results table versus the prediction table. I am close though.

Edit: just noticed the moneyline display is lacking the "-" daggnabbit.