Jump to content
Download the PL Forum App!
** ELO Ratings are now back **

Kentucky110

New Members
 View Profile  See their activity

  • Posts

    155

  • Joined

  • Last visited

 Content Type 

Posts posted by Kentucky110

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    @scream2012 The Rankings would not change as they are based on the Average Total Goals for Team That is goals For Plus Goals Against divided by Games played (Home games only) this is then Ranked Highest to Lowest. The next step is to do the same for Home goals For This again is Ranked Highest to Lowest (Home games Only) these two Rankings figures whatever you wish to call then are added together This gives the Home team Ranking. Exactly the same is done for the Away team This time using the away table. Again these two figures are added together to Give the Master Ranking The Lowest being the selection

    If you want to back over 1.5 then do so If you want the sheet to Show Over 1.5 instead of Over 2.5 then change the formulas in Ranking page Column L where it includes "Over 2.5" to "Over 1.5" but the ratings will not Change

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    Hi there they both have the same Master Rating (24) this is what the selection is based on

    But why are you rating on a daily basis? There are 20 teams in the league the games from below should also be in the list.

    You appear to be trying to change the rules for Rating the round of games. If that's what you want to do then carry onbut you are not following the concept of the rating system. If you check out my posts then ALL games in the round are rated I do not remove a game until all the games have been played but you must add the results once known

    What are the ratings with the below Games in the List

    Su 2 Dec 20:00 Acassuso - Def. Unidos  
    Su 2 Dec 20:00 Estud. Caseros - Fenix  
    Su 2 Dec 20:00 Flandria - Almirante Brown  
     
    Sa 1 Dec 20:00 UAI Urquiza - Sacachispas  

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    For anyone who may be interested Updated sheet can be found in Link below (Over-Under )

    Fixed the issue in Cells J5:J16

    Now shows Home table League Position and Away Table league Position

    You Can turn off/on Under selections Enter Y into H3  (H2 should be blank)

    You Can turn off/on Rank last 4 Games Enter Y into H2 (H3 should be Blank)

    H2 Blank and H3 Blank shows Over selection

    Notes

    If the rankings are not favourable then it shows no selection

    Rank last 4 Games only shows Over selection

     

    https://docs.google.com/spreadsheets/d/14NiDeKkTSVG1DsGAQzKKQtRuQbmTCdeFmb7NtDSxhqk/edit#gid=1935003603

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    @chrisgasHi there I will probably wait until 50 bets have been made There was an update on 29th October post

    showing a small loss of -1.84 to 1pt stakes it is currently showing a small profit.

    More importantly I have found an error in the formula for calculating over bets fortunately it is only affecting the game between

    Brentford and Sheffield tonight This game even though posted will NOT be recorded as a selection.

    The reason being the Rating for Home is not one of the lowest 3 nor is the rating for Away even though the master is the lowest

    All previousselections have been correct

    any one who has downloaded the google sheet can if they wish change the formula in Cell J5 to

    =IF(OR(VLOOKUP(D5,'League Table'!C$6:T$29,10,FALSE)<4,VLOOKUP(G5,'League Table'!C$6:T$29,18,FALSE)<4),"",IF(AND(OR(E5<=SMALL(E$5:E$16,3),H5<=SMALL(H$5:H$16,3)),I5<=SMALL(I$5:I$16,3)),"X",""))

    copy the formula down to J16

    This will correct the issue

    apologies for any inconvenience if anyone needs any help then let me know

     

     

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    Looking at your league table you are missing some results ALL the teams have played 18 games so far your table is showing some with only 16 and 17 it can only calculate the rankings correctly from the data you enter always check your data

    2nd query that column is correct it calculates Y for Home win over 2.5 and X for Away win over 2.5 any other result it is blank

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    The Basis of the program is to look at the league in rounds

    All games need to be rated but you add but you add results as they happen as this can change the selection Sometimes not all games in the round can be entered because they have been postponed (Champions league,Europa bad weather ect) Do not enter these games

    If you look at my Postings then for example Premiership this week all games played in round have been rated

    The round = games played 24th 25th and 26th results are entered as they are known this sometimes changes the selection or gives a second selection in the League (examples of which have been posted)

     using the last 4 will often give a different ranking (uses a different formula) than the ranking that is uses ALL games

    see example from my program below The sheet I posted replicates only the Over/Under selections and the last 4 Games

    program below has calculated Tuesdays Championship selection and if you enter ALL games you should get the same

    image.png.0c76a4f57249ba75536527af12950d34.png

    different selection for last 4 games over ( this was added for Jazzman45)

    image.png.45f957dd104689cc38d3d132fa4f8ed4.png

    Hope that explains this a little more clearly

    What does concern me is that your screen shot is missing Rankings for Din Bucuresti and CFR Cluj

    are the formulas still in the sheet have both teams played more than 4 home games or 4 away games

    if you spend a little time reading through the posts you may understand the concept a little better

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    @scream2012Hi there you are still not getting the same as me

    Can you show a screen shot with Ipswich game in and Aston Villa game in

    Make sure the Ipswich (Friday)and the Rotherham(12:00 KO Saturday) results are entered(1-2 and 2-2) in Fixtures and Results

    and you should have below

    image.png.7024dac70062a0f87a158f8df9268923.png

    If you don't want to see Under 2.5 then change the formula in CELL  L5 to  =IF(OR(G5="",D5=""),"",IF(AND(J5="X",I5=MIN(I$5:I$16)),"Over 2.5",""))

    and copy down to CELL L16

    Let me know how you get on

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    @scream2012 Hi there have you added all the results?

    The Over Under sheet that you are was modified as some users wanted to rate last 4 games only and they wanted to see the under selections

    From your screen shot it looks like you have Rank Last 4 games selected ( this should be Blank)

    Have you added the result of the Ipswich West Brom Game played on Friday This would changes ratings as screen shot for selections Saturday was taken on Saturday

    This is the screen shot I have with last 4 games blank and Fridays result entered

    If you don't want to see Under selections then you can Modify your sheet

    image.png.a9d9f08cea10854527566f7c8cf81f50.png

    Over 2.5 Goals a Different Method

    in Betting Systems & Strategy

    Posted

    @scream2012 if you check out the post on On 26/10/2018 at 5:29 PM  there is a link there it will need updating with results  if you read through the posts there are some explanations on how it is calculating the bets. There are some instructions on the sheet and you should be able to modify it for any league.if you need any help then let me know

    one bet in the Premiership tomorrow

    image.png.4919e38af6bc29313a452b60878a6b39.png

     

×
×
  • Create New...