Page 1 of 1

Poisson exported to EXCEL file

Posted: Fri Jun 01, 2018 3:26 am
by Mihai
I received a suggestion and because I think this will help a lot of users I implemented it.

What it is about

As you know there is a free Poisson calculator where just have to set the expected goals for home/away team.
The Poisson calculator is embeded into main program also. If you select in UPCOMING "goals scored" for both teams, see picture no 1, the Poisson button will be activated and allows you to see the Poisson calculator for the selected game, like in the picture no.2

I just added the possibility to export into EXCEL file the Poisson probabilities for all games in the UPCOMING table. For example, in the picture 2, after you select "goals scored" for home/away teams, then set whatever you want for season, last 10 games....home, away...etc if you click on "Poisson export" button will be asked to export all the Poisson values to an EXCEL file, where you may play with it.

Will be exported probabilities, for each game, for home and away: home, draw, away, scored 0,1,2,3,4,5,6,7,8,9 goals, over/under 0.5, 1.5, 2.5, 3.5, 4.5 GG, NG, ODD, EVEN and AH 0,1/4,1/2,3/4,1,11/4,11/2,13/4,2 and of course correct score.

I am open to discussions in order to improve this feature.


Image


Image

Re: Poisson exported to EXCEL file

Posted: Fri Jun 01, 2018 1:40 pm
by dimdan
Mihai,please when you have time read this and consider add it to cgm since everything we need is already into the program https://www.pinnacle.com/en/betting-articles/Soccer/how-to-calculate-poisson-distribution/MD62MLXUMKMXZ6A8

Cheers
Dimitris

Re: Poisson exported to EXCEL file

Posted: Sun Jun 03, 2018 1:19 pm
by _FlashGordon_
I second Dimitris 100%. Poisson usable only after implementing these rules.
--
_FlashGordon_

Re: Poisson exported to EXCEL file

Posted: Sun Jun 03, 2018 2:02 pm
by Mihai
Ok, may be an interesting debate because I do not agree with you. :)

Poisson distribution has nothing to do with any rating system. Is just Poisson distribution. It has entry values (in this case expected number of goals/game) and will give the probability (according with Poisson) to be scored 0,1,2,3,4...etc goals

The way we find the entry values is somethng else. Probably this is what both of you wanted to point. My program offers a lot of way to introduce values in Poisson formulas. You can select home, home+away, last 1,2,3,4... all games....etc and etc.

Of course there are other milions of possibilities to calculate expected goals. One guy from Pinnacle had an idea... and I like it very much but it is just his interesting opinion. You may find many many other ways presented over the Internet.

I do not think that somebody will prove ever what is the best way to calculate expected goals.

On the other hand of course it is possible to add this on the software and probably will do that finally. :)

Re: Poisson exported to EXCEL file

Posted: Tue Jun 12, 2018 7:07 am
by fhazza
The Poisson export key is not activatedImage

Re: Poisson exported to EXCEL file

Posted: Tue Jun 12, 2018 2:47 pm
by Mihai
The button is activated only if you select "goals scored" for home team and for away team

Then you will click the button to open Poisson with the calculated values.