note3user Posted August 9, 2020 Share Posted August 9, 2020 Hi can`t access the todays ratings anyone have same problem Quote Link to comment Share on other sites More sharing options...
NickP Posted August 9, 2020 Author Share Posted August 9, 2020 Nope not working for me either note3user 1 Quote Link to comment Share on other sites More sharing options...
note3user Posted August 9, 2020 Share Posted August 9, 2020 I sent message to an admin about this, so you have not got any rating for today then ? Quote Link to comment Share on other sites More sharing options...
NickP Posted August 9, 2020 Author Share Posted August 9, 2020 Only the one mentioned above for Elfsborg Quote Link to comment Share on other sites More sharing options...
note3user Posted August 9, 2020 Share Posted August 9, 2020 Ok just wait until its fixed Quote Link to comment Share on other sites More sharing options...
NickP Posted August 9, 2020 Author Share Posted August 9, 2020 On 8/7/2020 at 10:25 PM, NickP said: Ok just setting it back up and one pick appears for Sunday. These are based on the profitable selections from the last run, so here we go and good luck Date League Selection Bet Type Odds Stake 09-Aug-20 Swedish Allsvenskan Elfsborg Away Lay at 1.72 £10.00 Elfsborg won 1-0 with 10 men! Quote Link to comment Share on other sites More sharing options...
NickP Posted August 10, 2020 Author Share Posted August 10, 2020 No bets until Friday Quote Link to comment Share on other sites More sharing options...
darksidersfk Posted August 13, 2020 Share Posted August 13, 2020 Hello, I don't know if my elo rating spreadsheet is working or not, can someone send me a print of the "elo ratings" tab so I can compare, today games or tomorrow games Quote Link to comment Share on other sites More sharing options...
NickP Posted August 13, 2020 Author Share Posted August 13, 2020 This is what I am getting for 16th August, given my settings are as below Quote Link to comment Share on other sites More sharing options...
NickP Posted August 13, 2020 Author Share Posted August 13, 2020 On 8/10/2020 at 11:57 PM, NickP said: No bets until Friday No bets given the splintered nature of the various seasons. Appreciate one showing as a Home Win above, but as my cross check with another site has nothing, will not be advising it. Quote Link to comment Share on other sites More sharing options...
NickP Posted August 13, 2020 Author Share Posted August 13, 2020 Have a look at this thread which will provide more action over the weekend Quote Link to comment Share on other sites More sharing options...
darksidersfk Posted August 13, 2020 Share Posted August 13, 2020 39 minutes ago, NickP said: This is what I am getting for 16th August, given my settings are as below I see u added a columm to check if it is a bet or no bet, u take bets only if it has the same result in the 4avg and 2avg? Despite the fact you cross with some sites like u said. Sry for the questions, kinda new to the ELO system. Still learning Keep the bets and the good work, thanks Quote Link to comment Share on other sites More sharing options...
Jetony Posted August 14, 2020 Share Posted August 14, 2020 I discovered Elo Rating Today. How do i set up the Spreadsheet or is it downloadable ? Can someone help drop the Spreadsheet download link if its downloadable. Quote Link to comment Share on other sites More sharing options...
NickP Posted August 14, 2020 Author Share Posted August 14, 2020 Hi, and @Jetony With little applicable football over the weekend at least, will create a guide to what this is doing and the sheet so you can use it yourselves. Need to tidy a few things up my end then can hopefully publish in the next day or so (golf and working from home allowing!) freddie01 1 Quote Link to comment Share on other sites More sharing options...
Jetony Posted August 14, 2020 Share Posted August 14, 2020 Thanks Man, I really Appreciate Your Kind gesture. Quote Link to comment Share on other sites More sharing options...
NickP Posted August 16, 2020 Author Share Posted August 16, 2020 (edited) Ok was going to write a Word doc and attach, but you cannot attach word docs, so here goes.... First off grab the sheet created by @froment from this link :- https://rvasi.me/files/Punters-Lounge-parse-ELO-ratings.xlsx This has an instructions page which is very simple to follow. I assume a level of Excel ability in the below guide. All I have done, having unprotected the sheet as described, is add in a column (N) "Selection" on the "ELO Ratings" sheet, and put the following function in each row (you can copy and paste this into Row 5, then drag down the page to duplicate for all rows :- =IF((K5=""),"No Bet",IF((L5="Draw")*AND(M5="Draw"),"Draw",IF((J5>=K5)*AND(K5<-29.99)*AND(L5="Away")*AND(M5="Away"),"Away Win",IF((J5<=K5)*AND(K5>29.99)*AND(L5="Home")*AND(M5="Home"),"Home Win","No Bet")))) As you will see in the above example I have grabbed the data for next Saturday, 22nd August This has given me a selection of Home, Draws and Away Wins, based on these settings Now obviously you can set these to what you want, but based on the ELO Ratings I found these to be a decent range to play with. Then I select all selections that are not "No Bet" and then copy and past the boxed data, into this sheet.... https://drive.google.com/file/d/12SyZ9_4JG3SZ_VX96MPb8rUJqBJio5Vv/view?usp=sharing For examples sake I have entered my own values into Columns P and Q, to represent the rating and result for the game from www.soccervista.com, plus the Odds in Column R So having at this point identified suitable games via the ELO Rating, I then validate that against the Soccervista ratings, and end up with the set of selections in Columns AA to AN, which, based on my criteria in the spreadsheet, get auto populated into these columns And the picks and values are as displayed here. As you can see, for my criteria, some games are discounted. But this sheet is competely editable to what you want to do. Once you know the result of the game you can input the "H"ome and "A"way goals into columns T and U and everything should update for you, including all the stats at the top of the sheet Now I have been updating these sheets as I write this guide, so if you spot anything please advise, or you can update yourself. Hope that helps! To use this sheet yourself just delete the data from Columns B to N (some columns copied from the first sheet are hidden in here, do not remove them or the copy and paste will not work) and P,Q,R,T, and U and it is ready to go. Edited August 16, 2020 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted August 17, 2020 Author Share Posted August 17, 2020 Not expecting many bets right now, with most leagues just getting up and running and some form needed to use this properly. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 5, 2020 Author Share Posted September 5, 2020 This thread is now superceded by the new one Thanks 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.