Kentucky110

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
 

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
 

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

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
 

Today's Championship selection ( depending on early results we may have a selection in Premiership will post later)

@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

@tryerHi there depending on what format your current model is in and how you display and update it I may be able to help or point you in the right direction.
I am by no means a vba programmer but my program uses excel and displays and updates the data from a user form driven by vba
is this the type of thing you are looking for?
Kentucky110

Hi all,
          I'm looking to maybe start this up again I've been away for a while I know but I feel like giving this one last go. It would take me a while to get things up and running again but if there is some interest in what I do then I'm all for starting again and sharing it on the forum.
This time I would like to go in full depth of what I do and share all but for now I will get back to working on this project and hopefully in the next few weeks I can share how I intend to go forward with it.
thanks for reading 

Link for Updated sheet
https://docs.google.com/spreadsheets/d/1QzJhDLTA4wE5cZOP8Ws5LrQLxTWL98Xb3jMC-apQ3b4/edit?usp=sharing
Note it is called UpdatedMarch12

@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

@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

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
 

@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

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
 

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
 

Today's selections If there are any changes I will re post later

Today's picks Note after last nights result we now have a second pick in the Championship

Just the 2 Leagues qualify today

Just the one for tonight

One for today

@YoungBishop apologies for the late response but your query didn't pop up on the post 
Perhaps I didn't explain clearly in the above post
I will try to explain a little more clearly
see example below for tonight's Game
Aston Villa v Sheff Utd 
(Av.GFH= Average Goals scored by home team Home games only) (Av.GH = Total goals (home+away) Home games only)
(Av.GFA= Average Goals scored by away team Away games only) (Av.GH = Total goals ( away+home) Away games only)
Aston Villa Av.GFH 2.27 Ranked 2 + Av.GH 4.07 Ranked 1 = Rating 3
Sheff Utd Av.GFA 1.60 ranked 4  + Av.GA 2.80 Ranked 9 = Rating 13
This gives a Master rating of 16
One thing to note Selections are only made if a minimum of 70% of games are played in the round
A round consists of scheduled games to played as in the case of the Championship this week these can be played over a number of days if you look a the fixture list this will give you games in the round for the week example Championship this week is Round 31
so in a 20 team league (gives a round of 10 matches) minimum of 7 games must be played
24 team league (gives a round of 12 matches) minimum of 8 games must be played
Results are updated as soon as they are confirmed as this sometimes changes the selection
Example 5 games were postponed in League 2 Last Saturday so no selection was made
 

 
If you look through the posts there is a google sheet that can be downloaded ( you will need to update it) this should help to explain a little more clearly
Any questions please feel free to ask

@YoungBishop apologies for the late response but your query didn't pop up on the post 
Perhaps I didn't explain clearly in the above post
I will try to explain a little more clearly
see example below for tonight's Game
Aston Villa v Sheff Utd 
(Av.GFH= Average Goals scored by home team Home games only) (Av.GH = Total goals (home+away) Home games only)
(Av.GFA= Average Goals scored by away team Away games only) (Av.GH = Total goals ( away+home) Away games only)
Aston Villa Av.GFH 2.27 Ranked 2 + Av.GH 4.07 Ranked 1 = Rating 3
Sheff Utd Av.GFA 1.60 ranked 4  + Av.GA 2.80 Ranked 9 = Rating 13
This gives a Master rating of 16
One thing to note Selections are only made if a minimum of 70% of games are played in the round
A round consists of scheduled games to played as in the case of the Championship this week these can be played over a number of days if you look a the fixture list this will give you games in the round for the week example Championship this week is Round 31
so in a 20 team league (gives a round of 10 matches) minimum of 7 games must be played
24 team league (gives a round of 12 matches) minimum of 8 games must be played
Results are updated as soon as they are confirmed as this sometimes changes the selection
Example 5 games were postponed in League 2 Last Saturday so no selection was made
 

 
If you look through the posts there is a google sheet that can be downloaded ( you will need to update it) this should help to explain a little more clearly
Any questions please feel free to ask

@Xtc12 Hi there I would need to look at the back testing results to decide on a staking plan but from what I have checked so far it would be 2 singles

Here are the next set of selections for anyone who is still interested
Approx halfway through the season and showing a small profit
 

Here are the next set of selections for anyone who is still interested
Approx halfway through the season and showing a small profit