Jump to content
Announcements
** February Poker League Result : 1st rosco, 2nd Danshot, 3rd avongirl **
** Football Tipster Competition Result : 1st Marek76, 2nd 1945harry, 3rd Budgie 65, 4th dj.orange, 5th Procalc **
** February Naps Competition Result: 1st adamross, 2nd paulat, 3rd rolandcooper. KO Cup Winner Fist2k8. Most Winners Zidane123 **

trading on Fh or SH for overs?


Rey86
 Share

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.

 Share

×
×
  • Create New...