The Maximiser Posted February 11, 2019 Share Posted February 11, 2019 Hi there Just started using the ratings in anger and developing a strategy. Any chance this could be coded to export into excel better as at the moment when I paste in it puts all the data in one column rather than reflecting the layoutas per the web page? Thanks for the ratings though i have already had some huge wins using them Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted February 11, 2019 Share Posted February 11, 2019 3 hours ago, The Maximiser said: Hi there Just started using the ratings in anger and developing a strategy. Any chance this could be coded to export into excel better as at the moment when I paste in it puts all the data in one column rather than reflecting the layoutas per the web page? Thanks for the ratings though i have already had some huge wins using them @The Maximiser Glad you've been hitting the bookies with the ratings. We'll put it on the list, but I'll be honest there's some pretty big things ahead of it in the development queue. Quote Link to comment Share on other sites More sharing options...
The Maximiser Posted February 14, 2019 Author Share Posted February 14, 2019 Ok thanks no problem look forward to the improvements. Four out of four last night, very nice! Quote Link to comment Share on other sites More sharing options...
Ratso Posted May 24, 2019 Share Posted May 24, 2019 Hi Sir Puntalot, any news on this request yet? Quote Link to comment Share on other sites More sharing options...
froment Posted May 28, 2019 Share Posted May 28, 2019 Hey, @The Maximiser, @Ratso, do you want to export daily ELO ratings or ratings for individual leagues? If it is daily ratings, I can offer help untill your request is resolved. Indeed, data can be copied only into single column, even when using web query within Excel, so I created a small workbook that parses data into a proper table. You can download it from here: https://rvasi.me/files/Punters-Lounge-parse-ELO-ratings.xlsx Instructions are inside, and please note again, it works only for daily ratings, not for individual leagues, they appeared to be too stubborn... ? Sir Puntalot and world 1 1 Quote Link to comment Share on other sites More sharing options...
Ratso Posted May 29, 2019 Share Posted May 29, 2019 Brilliant Froment, thank you so much this will do the trick nicely. Once again, thank you Ratso froment 1 Quote Link to comment Share on other sites More sharing options...
note3user Posted May 29, 2019 Share Posted May 29, 2019 Thanks Froment job well done, Is it possible with the excel that it can highlight the ones for a selection to have a bet on Cheers froment 1 Quote Link to comment Share on other sites More sharing options...
froment Posted May 30, 2019 Share Posted May 30, 2019 Thanks for feedback! Yes, it is possible, but what is criteria for a selection? I have updated the spreadsheet, available in the same link above; it now has two additional columns, for last 4 and last 2 matches. You enter desired value, i.e., range of ELO ratings in sheet "Settings", and if difference in ratings fits into those values, it suggests home, draw or away team. Is that what you had in your mind? note3user 1 Quote Link to comment Share on other sites More sharing options...
note3user Posted May 31, 2019 Share Posted May 31, 2019 @froment That is spot on 100% what i was looking for Thanks very much, Hope members on here will now play with the settings and maybe leave some feedback on what they found to be a good setting to use froment 1 Quote Link to comment Share on other sites More sharing options...
NickP Posted June 11, 2019 Share Posted June 11, 2019 (edited) @froment HI there! Sorry only just seen this, dropped footie betting with strange results happening at the seasons end, but obviously with the summer leagues now up and running and in form, will need to have a look at this again. Too much time on the golf course!, except this week :-] Cheers NickP / TheMaximiser Edited June 11, 2019 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 2, 2019 Share Posted September 2, 2019 (edited) Ok I know it is easy to post past results and claim success, but with a few weeks into the season, and many thanks again to @froment for the ease of capturing selections, I am having rather good success on the home win front. 09-Aug-19 Romania Liga 1 Politehnica Iași Home Win 2.60 2 0 W 10-Aug-19 Brazil Serie A Flamengo Home Win 1.50 3 1 W 10-Aug-19 Czech Republic 1 Liga Baník Ostrava Home Win 1.70 4 2 W 11-Aug-19 Czech Republic 1 Liga Jablonec Home Win 1.36 2 1 W 11-Aug-19 Czech Republic 1 Liga Viktoria Plzeň Home Win 1.36 0 2 L 12-Aug-19 USA Major League Soccer LAFC Home Win 1.33 4 2 W 17-Aug-19 Slovakia Fortuna Liga Žilina Home Win 1.28 3 0 W 24-Aug-19 Bulgaria Parva Liga Botev Plovdiv Home Win 1.33 2 1 W 24-Aug-19 Czech Republic 1 Liga Slavia Praha Home Win 1.20 4 0 W 24-Aug-19 English League One Wycombe Wanderers Home Win 1.90 4 3 W 25-Aug-19 Brazil Serie A Santos Home Win 1.30 3 3 L 25-Aug-19 Danish Superliga Copenhagen Home Win 1.60 3 1 W 25-Aug-19 English Championship Swansea City Home Win 1.85 3 0 W 25-Aug-19 Russia Premier League Arsenal Tula Home Win 2.05 2 1 W 31-Aug-19 Brazil Serie B Bragantino Home Win 1.25 2 1 W 31-Aug-19 English League One Gillingham Home Win 1.20 5 0 W 31-Aug-19 Russia Premier League Lokomotiv Moscow Home Win 1.66 1 2 L 01-Sep-19 Belgium Jupiler League Gent Home Win 1.28 3 2 W 01-Sep-19 USA Major League Soccer FC Dallas Home Win 1.36 3 1 W 01-Sep-19 USA Major League Soccer San Jose Earthquakes Home Win 1.40 3 0 W My profit is £67.80 (EDITED - My spreadsheet was talking parp) to £10 stakes, and staking is doubled where the odds are less than 1.40 Obviously we go into a quieter spell with the international break, but given the above, I will continue to paper trade, and attempt to advise beforehand to track progress. Edited September 4, 2019 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 4, 2019 Share Posted September 4, 2019 (edited) Fluminese lost 0-1 -£10 LA FC lost 0-2 -£20 running balance +£37.80 Two picks over the weekend 7/9 Belgium Proximus League - Westerlo £10 @ 2.50 8/9 Brazil Serie A - Santos £10 @ 1.57 Edited September 4, 2019 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 8, 2019 Share Posted September 8, 2019 Westerlo Won, Santos Drew +£42.80 Nothing until the weekend now. thecurlyone1 1 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 12, 2019 Share Posted September 12, 2019 For this weekend 14-Sep-19 Czech Republic 1 Liga Mladá Boleslav - 1.40 - £20 14-Sep-19 Czech Republic 1 Liga Slavia Praha - 1.25 - £20 14-Sep-19 English League One Rotherham United - 1.57 - £20 14-Sep-19 English Premier League Liverpool - 1.14 - £40 14-Sep-19 Netherlands Eredivisie Utrecht - 1.28 - £40 14-Sep-19 Scottish Premiership - Aberdeen - 1.55 - £20 Quote Link to comment Share on other sites More sharing options...
Pawkoo Posted September 13, 2019 Share Posted September 13, 2019 Hi Could anyone share parsed data collected so far? Any amount would be really helpful Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted September 13, 2019 Share Posted September 13, 2019 to Punters Lounge @Pawkoo Quote Link to comment Share on other sites More sharing options...
NickP Posted September 14, 2019 Share Posted September 14, 2019 On 9/12/2019 at 10:28 PM, NickP said: For this weekend 14-Sep-19 Czech Republic 1 Liga Mladá Boleslav - 1.40 - £20 14-Sep-19 Czech Republic 1 Liga Slavia Praha - 1.25 - £20 14-Sep-19 English League One Rotherham United - 1.57 - £20 14-Sep-19 English Premier League Liverpool - 1.14 - £40 14-Sep-19 Netherlands Eredivisie Utrecht - 1.28 - £40 14-Sep-19 Scottish Premiership - Aberdeen - 1.55 - £20 Mlada Boleslav WON 6-0 +£8 Slavia Praha WON 3-0 +£5 Rotherham WON 6-1 +£11.40 Liverpool WON 3-1 +£5.60 Utrecht WON 3-1 +£11.20 Aberdeen DREW 1-1 -£20 Profit on the Day £21.20 Bank +£64.00 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 15, 2019 Share Posted September 15, 2019 One for Monday Russian Premier - Rostov £20 @ 1.75 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 16, 2019 Share Posted September 16, 2019 22 hours ago, NickP said: One for Monday Russian Premier - Rostov £20 @ 1.75 Rostov WON 2-1 +£15 Bank +£79 Will move this thread into the Glory Hunters Forum from now on Quote Link to comment Share on other sites More sharing options...
NickP Posted September 16, 2019 Share Posted September 16, 2019 New thread https://forum.punterslounge.com/topic/170502-elo-ratings-based-football-picks/ Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 22, 2019 Share Posted September 22, 2019 @froment Big thanks on the Excel tool! Quote Link to comment Share on other sites More sharing options...
rootsrunner Posted September 29, 2019 Share Posted September 29, 2019 (edited) On 5/28/2019 at 8:38 PM, froment said: Hey, @The Maximiser, @Ratso, do you want to export daily ELO ratings or ratings for individual leagues? If it is daily ratings, I can offer help untill your request is resolved. Indeed, data can be copied only into single column, even when using web query within Excel, so I created a small workbook that parses data into a proper table. You can download it from here: https://rvasi.me/files/Punters-Lounge-parse-ELO-ratings.xlsx Instructions are inside, and please note again, it works only for daily ratings, not for individual leagues, they appeared to be too stubborn... ? Hi Froment, Your workbook is a great tool - unfortunately, it doesn't work for me although I have followed your instructions in respect of copying data into excel. I work with a German version of Excel 2010. Below you find a screenshot from the input page after copying in the ELO ratings for 29th September 2019. Column C shows that there is a problem with the data. I have tried to change the format of the respective A lines, e.g. A23, A27 - but without success. Do have any idea what the problems is? Edited October 1, 2019 by rootsrunner Quote Link to comment Share on other sites More sharing options...
froment Posted October 3, 2019 Share Posted October 3, 2019 On 9/29/2019 at 11:15 AM, rootsrunner said: Hi Froment, Your workbook is a great tool - unfortunately, it doesn't work for me although I have followed your instructions in respect of copying data into excel. I work with a German version of Excel 2010. Below you find a screenshot from the input page after copying in the ELO ratings for 29th September 2019. Column C shows that there is a problem with the data. I have tried to change the format of the respective A lines, e.g. A23, A27 - but without success. Do have any idea what the problems is? Hi, rootsrunner; sory for delayed answer, I'm not visiting forum regulary. Column C in your screenshot is not wrong, it should contain True/False statements, to decide which cell in column A contains the date, which is beginning of new row, and in column G you can see it identified rows properly - new rows of ELO ratings at PuntersLounge start in Excel rows 11, 20, 29 and 38 - the ones that contain date "29 Sep". Now, why rows 23 and 27 contain this input "Mai 50" and "Jan 67", I have no clue; it might be some regional settings in your Excel, or it might be that rating at PL was some specific value that Excel recognized as number; or it might be something else, I don't know; I cannot replicate it as ratings for 29 September are not available any longer. Hence, I'm afraid I cannot determine what is the issue in your screenshot, cannot help you, sorry. Below are screenshots of ratings for 5. October from PL and from this Excel - as you can see, it works for me. Quote Link to comment Share on other sites More sharing options...
Pawkoo Posted October 3, 2019 Share Posted October 3, 2019 (edited) On 9/29/2019 at 11:15 AM, rootsrunner said: Hi Froment, Your workbook is a great tool - unfortunately, it doesn't work for me although I have followed your instructions in respect of copying data into excel. I work with a German version of Excel 2010. Below you find a screenshot from the input page after copying in the ELO ratings for 29th September 2019. Column C shows that there is a problem with the data. I have tried to change the format of the respective A lines, e.g. A23, A27 - but without success. Do have any idea what the problems is? Hi I also have Excel with different language and sometimes there are cells showing date instead of a number in "input" sheet. But if you go to "ELO ratings" sheet you should notice that almost everything is fine. Sometimes I have to correct manually a few cells (but not because of a date, too big number). Make sure that Excel uses "." as separator instead of "," (File -> Options -> Advanced) Edited October 3, 2019 by Pawkoo Quote Link to comment Share on other sites More sharing options...
rootsrunner Posted October 5, 2019 Share Posted October 5, 2019 (edited) On 10/3/2019 at 8:48 PM, froment said: Hi, rootsrunner; sory for delayed answer, I'm not visiting forum regulary. Column C in your screenshot is not wrong, it should contain True/False statements, to decide which cell in column A contains the date, which is beginning of new row, and in column G you can see it identified rows properly - new rows of ELO ratings at PuntersLounge start in Excel rows 11, 20, 29 and 38 - the ones that contain date "29 Sep". Now, why rows 23 and 27 contain this input "Mai 50" and "Jan 67", I have no clue; it might be some regional settings in your Excel, or it might be that rating at PL was some specific value that Excel recognized as number; or it might be something else, I don't know; I cannot replicate it as ratings for 29 September are not available any longer. Hence, I'm afraid I cannot determine what is the issue in your screenshot, cannot help you, sorry. Below are screenshots of ratings for 5. October from PL and from this Excel - as you can see, it works for me. Hi froment and Pawkoo, I have copied ELO Ratings for 5th October today and copied into the "input" map as described in the instructions. Before I have done that I have changed the separator from "," to ".". Anyway, some number are shown as "Apr50", "Nov50", "Jul75" and so on. Furthermore, even for matches with correct AVG numbers in all rows the "ELO ratings" sheet shows no bet selection at all. It`s a pity I cannot use this wonderful tool... ? Anyway, many thanks for your help!!! Greetings, rootsrunner Edited October 5, 2019 by rootsrunner Quote Link to comment Share on other sites More sharing options...
froment Posted October 5, 2019 Share Posted October 5, 2019 @rootsrunner I have checked again, and it works for me again. But then, I uploaded file to OneDrive, and I got similar issue as you did - some weird dates in column A. So I would say this is definitely something about cells formatting, something makes your Excel and Excel at OneDrive to recognize wrong date; I don't know what, I don't use Excel at Onedrive, so I cannot bother to investigate it now. Though, when I formatted entire column A as number, it worked again, with exception that actual date is wrong - it recognizes "6. October 2019" as "19. October"; it doesn't affect rendering of ELO ratings, so I would say it does the job - just don't pay attention to the date in cell B2. So, try to format column A in your Excel as number (Home tab - Number - Format Cells), and then copy/paste ratings again, to see if it works. Alternativelly, you can try this online version: https://vuko.me/link/Punters-Lounge-ELO-ratings Click "Edit in browser" button if you want to try it for another date; but I don't know what will happen if several people try to edit it at the same time. Quote Link to comment Share on other sites More sharing options...
rootsrunner Posted October 5, 2019 Share Posted October 5, 2019 48 minutes ago, froment said: @rootsrunner I have checked again, and it works for me again. But then, I uploaded file to OneDrive, and I got similar issue as you did - some weird dates in column A. So I would say this is definitely something about cells formatting, something makes your Excel and Excel at OneDrive to recognize wrong date; I don't know what, I don't use Excel at Onedrive, so I cannot bother to investigate it now. Though, when I formatted entire column A as number, it worked again, with exception that actual date is wrong - it recognizes "6. October 2019" as "19. October"; it doesn't affect rendering of ELO ratings, so I would say it does the job - just don't pay attention to the date in cell B2. So, try to format column A in your Excel as number (Home tab - Number - Format Cells), and then copy/paste ratings again, to see if it works. Alternativelly, you can try this online version: https://vuko.me/link/Punters-Lounge-ELO-ratings Click "Edit in browser" button if you want to try it for another date; but I don't know what will happen if several people try to edit it at the same time. @froment - it works now! I have tried the online version, without any problems. Great!!! MANY THANKS!!! froment 1 Quote Link to comment Share on other sites More sharing options...
troman Posted October 10, 2019 Share Posted October 10, 2019 Many thanks for sharing this and to let you know that it's working fine with LibreOffice. froment 1 Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted October 10, 2019 Share Posted October 10, 2019 to Punters Lounge @troman Quote Link to comment Share on other sites More sharing options...
MaverickRat Posted November 12, 2019 Share Posted November 12, 2019 (edited) Hi, just found this. I think the issue with other ELO tables being stubborn is the different dates so I have changed some formulas in the input sheet Change F2 to this and then copy down: =COUNTIFS($A$2:A2,">="&$B$1,$A$2:A2,"<"&$B$2+50000) Change G3 to this and copy down: =IF(AND((A3>($B$1-1)),(A3<($B$1+50000))),"Start","") This means that instead of just matching with the date in B1 it looks 50000 units (not sure what they are but it works) ahead. Works for me - needs testing though. You could now add a date column in the ELO ratings sheet In the example below the bottom two games are on different dates to the rest. It is broken though - says Man United will win Edit: Change B2 to this and copy down: =IF(AND((A2>($B$1-1)),(A2<($B$1+50000))),1,0) You can now paste data from multiple ELO tables! Edited again - Added date column in ratings sheet. Hard to explain (if you know arrays, you know!) so will find a way to upload file (with massive thanks to Froment) Edited November 12, 2019 by MaverickRat Revised fornula froment 1 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.