Jump to content
** March Poker League Result : =1st Bridscott, =1st Like2Fish, 3rd avongirl **
** Cheltenham Tipster Competition Result : 1st Old codger, 2nd sirspread, 3rd Bathtime For Rupert **

trading on Fh or SH for overs?


Rey86

Recommended Posts

Using the free data from football data

I am basing my example on championship data 18/19.  My response will only make sense if you have some knowledge of excel.

Overs 2.5

If looking for Strike Rate use the formula       =IF(E2+F2>2,1,0)

Calculate the sum of this column (275)

Therefore strike rate = 100*275/552 = 50%.  (552 = the number of games in the season)

If looking for return, use the formula  = IF(E2+F2>2,BG2,0)

Calculate the sum of this column (535.56)

Profit of this method = 535.56 – 552

 

Over 1.5 if HT result is nil nil

Find out how many HT finish 0-0.   =IF(H2+I2=0,1,0).   Calculate the sum of this column (170)

To get the strike rate see how many of the games that were 0-0 at HT ended up over 1.5 goals

=IF(AND(N2=1,E2+F2>1),1,0).   Calculate the sum of this new column  (72)

Therefore % strikerate = 100*72/170 =42%

To calculate the return of this method using the premise that “the odds for over 1.5 goals on the SH are almost the same as over 2.5 on Fh”

=IF(AND(H2+I2=0,E2+F2>1),BG2,0).   Calculate the sum of this column (140.38)

Profit of this method = 140.38-170

regards

Link to comment
Share on other sites

18 minutes ago, RandomB said:

Using the free data from football data

 

I am basing my example on championship data 18/19.  My response will only make sense if you have some knowledge of excel.

 

 

unfortuanattely i do not know excel but it is on my plans to learn how to use it

thanks for the reply m8

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...