Predicted Goals and Over & Under Predictions - Guardian Market List Layout

Get all your markets loaded at once into a fully customisable layout
Post Reply
rkuk
Posts: 11
Joined: Sat Jun 28, 2025 8:29 pm

Wowzers ODPaul,

This all sounds very technical / complex maths.

How do you go about creating something like that? Does it require coding skills? Perhaps excel?

Thanks for sharing, hope the model is working well for you! :)
User avatar
ODPaul82
Posts: 807
Joined: Sun May 08, 2011 6:32 am

rkuk wrote:
Thu Jul 17, 2025 9:49 am
Wowzers ODPaul,

This all sounds very technical / complex maths.

How do you go about creating something like that? Does it require coding skills? Perhaps excel?

Thanks for sharing, hope the model is working well for you! :)
The probability element can be calculated in Excel, Peter has done a video on it before https://www.youtube.com/watch?v=Ihkv3kSWt-Y&t=798s
I do a modified version of that.
I had mine running in Excel with a fair amount of VBA to automate the entire calculation process and then had an MS Access DB running in a loop which was calling API from somewhere to get the current goals, elapsed time and red cards.
Have recently migrated it all to C# code with SQL Server backend.
rkuk
Posts: 11
Joined: Sat Jun 28, 2025 8:29 pm

ODPaul82 wrote:
Thu Jul 17, 2025 6:13 pm
rkuk wrote:
Thu Jul 17, 2025 9:49 am
Wowzers ODPaul,

This all sounds very technical / complex maths.

How do you go about creating something like that? Does it require coding skills? Perhaps excel?

Thanks for sharing, hope the model is working well for you! :)
The probability element can be calculated in Excel, Peter has done a video on it before https://www.youtube.com/watch?v=Ihkv3kSWt-Y&t=798s
I do a modified version of that.
I had mine running in Excel with a fair amount of VBA to automate the entire calculation process and then had an MS Access DB running in a loop which was calling API from somewhere to get the current goals, elapsed time and red cards.
Have recently migrated it all to C# code with SQL Server backend.
Yep....that's all above my head! lol Do you have an IT / maths background in order to do all that or is it something you have learned alongside trading?
rkuk
Posts: 11
Joined: Sat Jun 28, 2025 8:29 pm

Hi all, I was looking to try the goal predictor tonight on the England Women's game but unsure if there's the data necessary or my install is incorrect. Anyone else looking at this match / able to check for me if it's not too much of an inconvenience? Just under half an hour to go before kick off :)
Post Reply

Return to “Guardian market list layouts”