About Soccer Poisson again

[jtrader]

Hi!

All credits to georgebets - https://georgebets.com/guides/football- ... t-matches/
and Derek27 on this forum.

I've merged georgebets' spreadsheet and calculations from Soccer Poisson Database (Derek27).- viewtopic.php?p=265874#p265874

That is original georgebets' spreadsheet - https://georgebets.com/wp-content/uploa ... tches.xlsx

I've corrected just a little poisson distribution according to real observed games- https://journals.le.ac.uk/ojs1/index.ph ... /3471/3111


And that is the new spreadsheet:

PREDICT_FOOTY_GAMES_INPLAY.xlsx

All spreadsheet input data could be found on https://www.soccerstats.com/matches.asp

Screenshot (836)_LI-min.png

[MemphisFlash]

i've noticed that some people are allowed to upload excel files.
How do you do that?

[jtrader]

i've noticed that some people are allowed to upload excel files.
How do you do that?

Just added as any other file from options "Add".

[Derek27]

i've noticed that some people are allowed to upload excel files.
How do you do that?

I think macro-enabled files aren't allowed, but you can put it in a zip file and upload that.

[jtrader]

Hi!

All credits to georgebets - https://georgebets.com/guides/football- ... t-matches/
and Derek27 on this forum.

I've merged georgebets' spreadsheet and calculations from Soccer Poisson Database (Derek27).- viewtopic.php?p=265874#p265874

That is original georgebets' spreadsheet - https://georgebets.com/wp-content/uploa ... tches.xlsx

I've corrected just a little poisson distribution according to real observed games- https://journals.le.ac.uk/ojs1/index.ph ... /3471/3111


And that is the new spreadsheet:


PREDICT_FOOTY_GAMES_INPLAY.xlsx


All spreadsheet input data could be found on https://www.soccerstats.com/matches.asp


Screenshot (836)_LI-min.png

I've corrected the spreadsheet,cause there were errors in first edition.

PREDICT_FOOTY_GAMES_INPLAY.xlsx

[Fgpredictuk]

Thank you for the spreadsheet

[avs_kz]

thanks. have you test it?

[jtrader]

thanks. have you test it?

Still not,but you could test it and share results!

[Astraliym]

Hi. How do I add a historical database?

[Rich1950]

Hi Folks,

I have a spreadsheet based on soccerstats data with a poisson model,

Output 2.png

I have 2 output workbooks one of which contains selected data from the main sheet ( can be altered to extract other data) which is all good and well but results have to be added manually.

I can get the results by re-running the matches.

No point in re-running the matches as the data would not then be as it was prior to the match.

Match output2.png

Anyone have any suggestions as to how the results could be obtained and then matched up with the matches in the Match Output List

HT Home Away FT Home Away

cheers

Rich1950