Kentucky110 Posted March 23, 2019 Author Share Posted March 23, 2019 @note3userLooking good after 23 mins and evens was available! have you been following National League? if so what have the results been like? Quote Link to comment Share on other sites More sharing options...
note3user Posted March 23, 2019 Share Posted March 23, 2019 @Kentucky110 Not been following its the first time I made the sheet for National League Yeah evens was the odds so be good if it wins good value. Quote Link to comment Share on other sites More sharing options...
note3user Posted March 23, 2019 Share Posted March 23, 2019 We have a winner Quote Link to comment Share on other sites More sharing options...
note3user Posted March 24, 2019 Share Posted March 24, 2019 Spain LaLiga2 Bet365 2.40 Betfair 2.55 Quote Link to comment Share on other sites More sharing options...
note3user Posted March 24, 2019 Share Posted March 24, 2019 Well unlucky not win 1 missed penalty 1 goal disallowed Ended 1 - 0 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted March 25, 2019 Author Share Posted March 25, 2019 @note3user Yes I was unlucky also as Colchester had a goal disallowed Just one query re your La Liga 2 selections You are only showing 5 games rated and I recommend that a minimum of 70% of the games should be rated in the round and in round 31 of the league there should be 11 games rated ( 1 game tonight) with there being 22 teams in the league I would recommend that a minimum of 8 games must be played (70% of 11 possible matches = 7.7) and all games even the ones that have been played should be included as previous results can alter the ratings Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted March 26, 2019 Author Share Posted March 26, 2019 For those that are interested I have been working on a new Selection method for next season which I hope will perform a bit better than I have done so far this season ( That being said all selections backed are only showing a loss of 3.85pts from 112 selections)The above stat has convinced me that there is hope in the selection method. The new selections will be rated using the same criteria as the original i.e 3 lowest pts from both home and away but it will use a new rating method (Highest being the selection) The new Rating method will use Goals per game and Points per game this combined with table positions and games being won give the selection Back testing over the last 2 seasons is looking promising although it does not always make a selection even when their are enough qualifying games in the round.(for my own personal use it also displays Home and away stats for the game when a Game is clicked in the list) see below image I will carry on posting the original selections as promised until the end of the season. Hopefully I will be able to start next season with the new selection method more than likely under a different thread any comments or ideas are welcome YoungBishop, alani42 and jazzman45 2 1 Quote Link to comment Share on other sites More sharing options...
note3user Posted March 26, 2019 Share Posted March 26, 2019 That's sounds a good ideal I like the look of your software in the screen shot Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted March 27, 2019 Author Share Posted March 27, 2019 @note3userAll the info you see has been created in excel It is just displayed using User forms and VBA. (I prefer User forms to display my Data) The same info can be created using the basic info in the sheet that you have been using to create over 2.5 selections A small example is shown below Quote Link to comment Share on other sites More sharing options...
alani42 Posted March 27, 2019 Share Posted March 27, 2019 post the excel pls Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted March 27, 2019 Author Share Posted March 27, 2019 @alani42Sorry I cannot post the excel 1. It is all generated in VBA (so it will only update from the user form) 2. It also contains lots of other data which I am unwilling to reveal (currently) If you require help in creating your own sheet and need help with formulas then please ask and I will assist where possible if you checkout the link posted 13th March this should give you a good starting point thecurlyone1, aussietennisexpert, jazzman45 and 1 other 3 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted March 30, 2019 Author Share Posted March 30, 2019 This weekends selections If there are any changes to selection After results have been entered then I will update later Note 2 Games with the same Rating in League 1 Just for info the new rating method also picks the Bury game Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 1, 2019 Author Share Posted April 1, 2019 This weeks round 33 is spread over the below dates with other "catch up Games" being played This is due to FA Cup semi finals being played over the weekend To avoid any confusion I will not be posting selections for Premiership Round 33 but will add results of games played this week ready for Round 34. Championship and Leagues 1 and 2 will be posted Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 6, 2019 Author Share Posted April 6, 2019 Today's selections Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 8, 2019 Author Share Posted April 8, 2019 Selection for Tuesday Just for info the Selection will be recorded as a bet so at the end of the season I can give a full update on P/L The new selection method which I will be using next season picks this game as a under 2.5 (be interesting to see the outcome) Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 12, 2019 Author Share Posted April 12, 2019 Below are Saturdays selections ( will post Premiership when results have been added) Word of warning here the Portsmouth v Rochdale game has a negative rating on the new rating system which could indicate a low scoring game the selection will still be added to the final results at the end of the season Just for info the Crewe v Notts County game is also selected by the new rating system Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 14, 2019 Author Share Posted April 14, 2019 There is one for today Just for info it is also selected by the new rating system Quote Link to comment Share on other sites More sharing options...
scream2012 Posted April 14, 2019 Share Posted April 14, 2019 Kentucky110 where can download the latest file with the last chances ... or the new format file?? Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 14, 2019 Author Share Posted April 14, 2019 @scream2012Hi there there new rating method is still in development stage and currently isn't available I will be back testing it during the close season and may have everything up and running for the start of next season Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 19, 2019 Author Share Posted April 19, 2019 Picks for today and tomorrow (any changes I will update later Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 22, 2019 Author Share Posted April 22, 2019 Today's selections Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted April 27, 2019 Author Share Posted April 27, 2019 Selections for today Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted May 3, 2019 Author Share Posted May 3, 2019 Saturdays selections Will post Sunday once early results have been added Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted May 5, 2019 Author Share Posted May 5, 2019 Today's Championship selection ( depending on early results we may have a selection in Premiership will post later) thecurlyone1 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted May 6, 2019 Author Share Posted May 6, 2019 MNF we have now reached the penultimate selection Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted May 8, 2019 Author Share Posted May 8, 2019 Final Selection for this season. Its been a long road but the Data collected will be analysed during the closed season With a view to getting something in place for next season. Hope you have enjoyed the journey and for those who created their own leagues perhaps you have learnt something Any ideas or suggestions will be welcomed Will post P/L after results have been entered thecurlyone1 1 Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted May 13, 2019 Author Share Posted May 13, 2019 Well that the season finished in total there were 140 selections with 76 winners to 1 pt level stakes there was a small loss of 3.45pts ( this would have been improved by finding best prices available I only used prices from Sportsbook and W Hill) Breakdown by league Premiership 28 selections 17 winners with a loss of 0.63pts Championship 38 selections 21 winners with a loss of 0.95pts League 1 39 selections 17 winners with a loss of 7.78pts League 2 35 selections 21 winners with a profit of 5.91pts If you had only backed selections that were evens or greater 32 selections 17 winners profit of 3.47pts The work now begins on next season I will start a new thread for that LEE-GRAYS, thecurlyone1 and note3user 1 2 Quote Link to comment Share on other sites More sharing options...
note3user Posted July 18, 2019 Share Posted July 18, 2019 Hi Kentucky110 hope you are well, Will we be using same spreadsheets like we did for last season or have you been working on something new James Quote Link to comment Share on other sites More sharing options...
note3user Posted July 22, 2019 Share Posted July 22, 2019 @Kentucky110 Quote Link to comment Share on other sites More sharing options...
scream2012 Posted August 25, 2019 Share Posted August 25, 2019 Kentucky110 some news with the new sheet? 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.