keef75 Posted August 17, 2018 Share Posted August 17, 2018 Following on from previous discussions about this (unfortunately all posts have been removed from the betting tools section of this forum), I'm pleased to announce that the rdata site is still up and running and I'll be keeping it updated with the latest fixtures and results so we can get some ideas of the best performing historical systems. The site is http://rdata.uk and it is available to everyone. It is absolutely free to use with no restrictions, log-ins etc. and I intend to keep it that way. I update the data daily and am still adding the lower league information so that more selections can get picked up. There's only data going back to 10th August at the moment as that's all I could get my hands on but it is an extension of the infamous 'Monster'. If anyone has any historical data that shows results with the league positions of the home/away teams (at the time of the match) plus prices for 1X2, BTTS and U/O2.5 I'd be very interested in seeing it. I know there are paid-for solutions out there but the ethos of what I am doing here is all about keeping data free. I won't be posting any unnecessary information or links here. I'll mostly leave it up to you to visit when you want. I added a little bit of extra functionality earlier - Eligible Matches. Once you've set up the parameters you can click on the green button above the filter box and you will see the matches that fit the criteria chosen. Sometimes there won't be any matches (especially at this time of year when lots of seasons are only just starting). Sir Puntalot 1 Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 17, 2018 Author Share Posted August 17, 2018 There is an option to save parameter (filter) sets so they can be loaded at a later date and re-tweaked if necessary. Scroll down to the bottom of the Football Analysis page and you'll see the save box. I noticed earlier that someone had saved a set (the ones in capitals are mine) and the one selection for today was a winner so well done whoever that was! Quote Link to comment Share on other sites More sharing options...
harry_rag Posted August 17, 2018 Share Posted August 17, 2018 20 minutes ago, keef75 said: If anyone has any historical data that shows results with the league positions of the home/away teams (at the time of the match) plus prices for 1X2, BTTS and U/O2.5 I'd be very interested in seeing it. I think there are websites that will give you the historical odds for the markets you mention but that won't necessarily show the league positions at the time. Just google historical odds or similar, I've just been looking at Oddsportal for example. I'm not sure you'll find a single source so there'd be a degree of mashing together to do (finding the league positions on different dates then adding the odds). Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 17, 2018 Author Share Posted August 17, 2018 Just now, harry_rag said: I think there are websites that will give you the historical odds for the markets you mention but that won't necessarily show the league positions at the time. Just google historical odds or similar, I've just been looking at Oddsportal for example. I'm not sure you'll find a single source so there'd be a degree of mashing together to do (finding the league positions on different dates then adding the odds). Thanks, Harry. I know that others have searched for this data too but couldn't find it anywhere. I'm trying to make the process as automated as possible, there's still a bit of work needed each day to get the data that is available in a format that's suitable for importing into the database. I had a look at the oddsportal site and the number of clicks that are required to get the data means it isn't going to be easy enough for me. I downloaded a massive free spreadsheet this evening from indatabet that has matches going back years with bet365 prices for 1X2 and U/O2.5 but no double chance or BTTS. I forgot to mention double chance in my previous post - that's quite important to have too. So, although I'll be able to use all this data for other purposes, I won't be able to use it for the main analysis page. For current data, I'm using PDFs converted into Excel. They have everything I need including league positions, one match per line but I can't get historical info in the same format, only on a day-to-day basis going forwards. I'm open to trying anything to speed up the process and add more history so please keep suggestions coming. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 17, 2018 Author Share Posted August 17, 2018 I've just had a thought about the big spreadsheet I downloaded... If I order it by league and date I can write a script to calculate the league positions of every team after every match day. Genius. Once I have that all I need to do is find the historical odds for double chance and BTTS in a nice format. Quote Link to comment Share on other sites More sharing options...
harry_rag Posted August 17, 2018 Share Posted August 17, 2018 You could just dutch the win and draw prices for a double chance price in the absence of an actual price! keef75 1 Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 17, 2018 Author Share Posted August 17, 2018 Absolutely you can! We'll get there! Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 17, 2018 Share Posted August 17, 2018 @keef75 its nice seeing you back with your great work keep it up keef75 1 Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 17, 2018 Share Posted August 17, 2018 I would really love you to implement ability to filter out some leagues in the filter parameters. Some leagues are notorious for spoiling stats, hope you understand what i mean Quote Link to comment Share on other sites More sharing options...
Kentucky110 Posted August 18, 2018 Share Posted August 18, 2018 Hi keef75 You could try calculating your own double chance odds try the below formulas in Excel they are pretty close to what the bookie would offer 1X formula = Home Odds*Draw Odds/(Home Odds+Draw Odds) 12 formula = Home Odds*Away Odds/(Home Odds+Away Odds) 2X formula = Away Odds*Draw Odds/(Away Odds+Draw Odds) I have used the above for a couple off seasons now and found them to be fairly accurate also quite often you can find a few value bets where the bookie is offering higher odds Hope this may be off use to you Regards Ken keef75 1 Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 Thanks for all the suggestions. @Rivilearner, it's good to be back! Regarding the filtering of certain teams, I'll see what I can do. @Kentucky110, I'll do that this morning and hopefully have it all working by the end of the day. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 Just a quick update on the historical data... I've managed to get it all working in the development version and it's going really well. I've written a script that takes all the matches from that huge indatabet spreadsheet and works though a league/season calculating the tables. I've run it on 2017/18 English Premiership and Championship and everything looks good. As a side effect I now have table standings at any day throughout the season which is a bonus. I'll be adding a page so these can be searched in later so you can see, for example, how the Premiership looked on Christmas Day 2017. On the down side, I've run the saved parameter sets through it all and mine come out as losers! The one parameter set that someone else has saved (Straight Home wins 1 4) still comes out as a winner though. Also, I'm going to have to run the script separately for each league/season as it's quite processor intensive and I need to cross check team names are consistent in each league over the course of the season, I noticed some small differences in the Premiership teams that I had to change before it all worked properly. I'll add a couple of dozen leagues from last year and hopefully I'll be able to copy it into the live database some time tomorrow for you all to play around with. Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 More grease to your elbow, keep up the good work keef75 1 Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 9 minutes ago, keef75 said: Just a quick update on the historical data... I've managed to get it all working in the development version and it's going really well. I've written a script that takes all the matches from that huge indatabet spreadsheet and works though a league/season calculating the tables. I've run it on 2017/18 English Premiership and Championship and everything looks good. As a side effect I now have table standings at any day throughout the season which is a bonus. I'll be adding a page so these can be searched in later so you can see, for example, how the Premiership looked on Christmas Day 2017. On the down side, I've run the saved parameter sets through it all and mine come out as losers! The one parameter set that someone else has saved (Straight Home wins 1 4) still comes out as a winner though. Also, I'm going to have to run the script separately for each league/season as it's quite processor intensive and I need to cross check team names are consistent in each league over the course of the season, I noticed some small differences in the Premiership teams that I had to change before it all worked properly. I'll add a couple of dozen leagues from last year and hopefully I'll be able to copy it into the live database some time tomorrow for you all to play around with. Your latest indatabet spreadsheet has not being included in the site database yet? Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 No it hasn't. It's in the version I use for testing out new stuff. I'll copy it across tomorrow for you. I'm shattered now, I've been working on it for about 8 hours straight today. Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 Take your time the season is still very young, beating the bookies...Its a must Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 Ok @Rivilearner, just for you I've copied the historical data across so you can now use it on rdata. I've added 2017/18 season data for the following: Austria D1 and D2 Croatia D1 Denmark D1 and D2 England Premiership. Championship, League 1 and 2 and National league Spain D1 and D2 France D1, D2 and D3 Germany D1, D2 and D3 Hungary D1 Italy D1 and D2 Netherlands D1 and D2 Poland D1 Portugal D1 and D2 Romania D1 Russia D1 Scotland Premiership Switzerland D1 Slovakia D1 Slovenia D1 Turkey D1 Ukraine D1 There are more to come, especially the South American leagues but these are often split into two sub-seasons with separate tables so I'll have to look into that tomorrow. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 Sorry, I've just noticed an error with the calculations so I've reverted it back to not having the historical data. I'll get it sorted now and it should be back up in a few minutes. Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 12 minutes ago, keef75 said: Ok @Rivilearner, just for you I've copied the historical data across so you can now use it on rdata. I've added 2017/18 season data for the following: Austria D1 and D2 Croatia D1 Denmark D1 and D2 England Premiership. Championship, League 1 and 2 and National league Spain D1 and D2 France D1, D2 and D3 Germany D1, D2 and D3 Hungary D1 Italy D1 and D2 Netherlands D1 and D2 Poland D1 Portugal D1 and D2 Romania D1 Russia D1 Scotland Premiership Switzerland D1 Slovakia D1 Slovenia D1 Turkey D1 Ukraine D1 There are more to come, especially the South American leagues but these are often split into two sub-seasons with separate tables so I'll have to look into that tomorrow. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 Ok, all fixed. Time for a break I think! Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 you deserve it, please rest for the day. Thanks Quote Link to comment Share on other sites More sharing options...
Data Posted August 18, 2018 Share Posted August 18, 2018 4 hours ago, keef75 said: . . . and I need to cross check team names are consistent in each league over the course of the season, I noticed some small differences in the Premiership teams that I had to change before it all worked properly. Team names can be a nightmare when trawling information from multiple sources. The number of variants appears to be directly proportional with the obscurity of the league. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 18, 2018 Author Share Posted August 18, 2018 27 minutes ago, Data said: Team names can be a nightmare when trawling information from multiple sources. The number of variants appears to be directly proportional with the obscurity of the league. Tell me about it! The thought of creating a lookup table with all the aliases is a very daunting one but something I'm going to have to do at some point. I'm seriously considering reducing the number of leagues I'm using, get rid of some of the more obscure ones and concentrate on the major ones. Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 18, 2018 Share Posted August 18, 2018 personally Asian leagues, Estonia leagues, probably some few south American leagues should be rid of, so as to reduce your work load Quote Link to comment Share on other sites More sharing options...
footysystems Posted August 19, 2018 Share Posted August 19, 2018 Nice work @keef75 great once the season gets going and the data grows. Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 19, 2018 Author Share Posted August 19, 2018 (edited) Thanks, @footysystems. If we can come to some sort of consensus as to which leagues to include I'll make sure that only they are in the database. I'll make a start: Austria - Tipico Bundesliga, 2.LigaBelgium - Jupiler League, Proximus LeagueBrazil - Serie A, Serie BCzech Republic - 1.Liga, Division 2Denmark - Superliga, 1st Division England - Prem, Champ, League One, League Two, NorthernFinland - Veikkausliiga, YkkonenFrance - Ligue 1, 2, NationalGermany - Bundesliga, 2.Bundesliga, 3.LigaGreece - Super League, Football League Hungary - OTP Bank LigaIceland - Pepsideild, Inkasso DieldinIreland - Premier, Division 1Italy - Serie A, Serie BJapan - J League, J2 LeagueMexico - Primera, Liga de AscensoNetherlands - Eredivisie, Eerste DivisieNorway - Eliteserien, OBOS LigaenPoland - EkstraklasaPortugal - Primeira, SegundaRomania - Liga 1Russia - Premier Leauge, FNLScotland - Prem, Champ, League One, League TwoSlovakia - Fortuna LigaSlovenia - Prva LigaSpain - LaLiga, LaLiga2Sweden - Allsvenskan, SuperettanSwitzerland - Super League, Challenge LeagueTurkey - Super LigUkraine - Premier LeagueWales - Premier League, Division 1 How does that look? Edited August 19, 2018 by keef75 Formatting Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 19, 2018 Author Share Posted August 19, 2018 Yesterday's results have now been uploaded. Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 19, 2018 Share Posted August 19, 2018 (edited) 3 hours ago, keef75 said: Thanks, @footysystems. If we can come to some sort of consensus as to which leagues to include I'll make sure that only they are in the database. I'll make a start: Austria - Tipico Bundesliga, 2.LigaBelgium - Jupiler League, Proximus LeagueBrazil - Serie A, Serie BCzech Republic - 1.Liga, Division 2Denmark - Superliga, 1st Division England - Prem, Champ, League One, League Two, NorthernFinland - Veikkausliiga, YkkonenFrance - Ligue 1, 2, NationalGermany - Bundesliga, 2.Bundesliga, 3.LigaGreece - Super League, Football League Hungary - OTP Bank LigaIceland - Pepsideild, Inkasso DieldinIreland - Premier, Division 1Italy - Serie A, Serie BJapan - J League, J2 LeagueMexico - Primera, Liga de AscensoNetherlands - Eredivisie, Eerste DivisieNorway - Eliteserien, OBOS LigaenPoland - EkstraklasaPortugal - Primeira, SegundaRomania - Liga 1Russia - Premier Leauge, FNLScotland - Prem, Champ, League One, League TwoSlovakia - Fortuna LigaSlovenia - Prva LigaSpain - LaLiga, LaLiga2Sweden - Allsvenskan, SuperettanSwitzerland - Super League, Challenge LeagueTurkey - Super LigUkraine - Premier LeagueWales - Premier League, Division 1 How does that look? This is simply great, no need to cumber your self with lots of league, moreover how many will we follow? Edited August 19, 2018 by Rivilearner Quote Link to comment Share on other sites More sharing options...
Rivilearner Posted August 19, 2018 Share Posted August 19, 2018 What about the league filter, hope it will soon be ready Quote Link to comment Share on other sites More sharing options...
keef75 Posted August 19, 2018 Author Share Posted August 19, 2018 The filter will be a lot easier to implement with fewer leagues. I'll sort out the leagues first to make sure we're only using the ones listed above and then I'll be able to add a filter. Should be ready tomorrow some time. 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.