scream2012 Posted November 25, 2018 Share Posted November 25, 2018 here's the problem ... there are lots of empty spaces Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 25, 2018 Author Share Posted November 25, 2018 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 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 27, 2018 Author Share Posted November 27, 2018 Hi all below are next lot of Over selections Quote Link to comment Share on other sites More sharing options...
chrisgas Posted November 27, 2018 Share Posted November 27, 2018 Hi Kentucky110, Will there be an update on the profit and loss for each of your systems at the end of the month? I am particularly interested in how your result-over/under is doing. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 27, 2018 Author Share Posted November 27, 2018 @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 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted November 27, 2018 Share Posted November 27, 2018 (edited) ENGLAND League One something is wrong here ...i do not have the same ratink Edited November 27, 2018 by scream2012 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 28, 2018 Author Share Posted November 28, 2018 @scream2012Are all the results correct? Email me your league 1 sheet showing the Rankings you have and I will have a look Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 28, 2018 Author Share Posted November 28, 2018 @scream2012Hi there Just checked my data and you are correct I had a result in twice this has now been corrected Will recheck all my results as there may be something wrong with they way VBA is recording the data Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted November 28, 2018 Author Share Posted November 28, 2018 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 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 1, 2018 Author Share Posted December 1, 2018 Hi all selection for Premiership today no selection for today's games in Championship as yet Program has a selection for Monday but that could all change once results are entered Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 2, 2018 Author Share Posted December 2, 2018 A selection for MNF 2/12/18 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 2, 2018 Share Posted December 2, 2018 who match to bet it? FILI34 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 3, 2018 Author Share Posted December 3, 2018 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 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 4, 2018 Author Share Posted December 4, 2018 One for today FILI34 1 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 MONTENEGRO: Prva Crnogorska Liga Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 SCOTLAND: Premiership Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 4 hours ago, scream2012 said: MONTENEGRO: Prva Crnogorska Liga Final 3-0 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 you can also make the formula for Over 1.5? Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 FRANCE: Ligue 1 ROMANIA: Liga 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 5, 2018 Author Share Posted December 5, 2018 @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 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 12 hours ago, scream2012 said: SCOTLAND: Premiership Final 2-2 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted December 5, 2018 Share Posted December 5, 2018 9 hours ago, scream2012 said: FRANCE: Ligue 1 ROMANIA: Liga 1 Strasbourg - PSG Final 1-1 Gaz Metan Medias - Viitorul Constanta Final 2-2 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 6, 2018 Author Share Posted December 6, 2018 @scream2012 Hi There If you are going to post your selections can you create a new thread this will avoid any confusion and unnecessary questions to me. Looks like you are having a little success and I am pleased you have found the spreadsheet useful but I am only interested in English leagues and would like to keep the thread confined to that Thanks Kentucky110 scream2012 and FILI34 2 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 7, 2018 Author Share Posted December 7, 2018 Hi All one selection for tonight in Championship FILI34 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 8, 2018 Author Share Posted December 8, 2018 Below are today's selections. If there are any changes due t early KO then I will post new selections. This may be later as I have been summoned to go Xmas shopping by the boss Quote Link to comment Share on other sites More sharing options...
spajki323 Posted December 8, 2018 Share Posted December 8, 2018 (edited) nice! keep us updated! Edited December 8, 2018 by Sir Puntalot email addresses not allowed on forum. Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 8, 2018 Author Share Posted December 8, 2018 After a disastrous set of results and an expensive day out with the missus After entering the earlier results we have another selection in the premiership Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 10, 2018 Author Share Posted December 10, 2018 Hi all @chrisgasAs promised below are the next set of results (see post 29th Oct for first set) I have only been posting Over results/Selections Still losing but I haven't given up but then I have had a bit of fun and only tiny loss to date If anyone fancies do a bit what would the returns be if you backed under 2.5? odds look like they would have been more favourable. I have also been working on a new formula although selections are fewer they look quite interesting just back testing on last season using football-Data.co.uk results The new selection method gives Home win/Away Win /Over and Under 2.5. Once all the data has been painstakingly entered then I will post results Maybe something new for next season Quote Link to comment Share on other sites More sharing options...
chrisgas Posted December 11, 2018 Share Posted December 11, 2018 @Kentucky110 Thank you for updating the results much appreciated. Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted December 15, 2018 Author Share Posted December 15, 2018 Morning All Only League 1 and 2 so far as Premiership and Championship picks are Sunday and Monday so selections may change I will update once early games data has been updated Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.