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

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

MNF we have now reached the penultimate selection

They Have a great forum with loads of tips and ideas plus loads of vba code which you can use / modify to suit your needs Note if you are not familiar with using vba then everything can be done from the excel sheet Good luck

Have a look at Gruss they give you a free trial

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

Saturdays selections Will post Sunday once early results have been added

Selections for today

Today's selections

Picks for today and tomorrow (any changes I will update later

@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

There is one for today Just for info it is also selected by the new rating system

@tryerHi there I now see the enormity of your issue and to be honest it is too complex for my vba skills there are too many variables firstly you have the date then you have the team then you have the Calculated ELO rating that need to be carried forward for each Date/Team. Have you considered trying one of the dedicated VBA help sites ( Mr Excel, Stackoverflow ect) I have used these sites in the past to learn what little I know about VBA or there maybe someone on this forum with skills far greater than mine who can help Sorry I could not be of assistance on this occasion but good luck with your quest

@tryerSo Image 1 is showing all past results and image 2 is showing current games with results added Is that correct? I am just trying to understand how your sheet works do you manually enter the upcoming games and then add the result to image 1 or are you copying data from a site to populate image 1

@tryerHi There could you give me an example of a league where you would enter results (A screen shot will give me an Idea where to start and can you make sure it is showing columns and rows) something like below how many leagues do you do? do you want it just in excel or stand alone with a userform? I would assume that the vba formula would need to check your current ELO to calculate the New ELO once results have been entered (hope that makes sense) if you were to add extra sheets to your current model couldn't you just use formulas to pull your current data to create your ratings?