NickP Posted September 16, 2019 Share Posted September 16, 2019 (edited) Following on from this thread https://forum.punterslounge.com/topic/167228-exporting-daily-ratings-into-excel/ ..and keeping it going forward in the right place. Stats so far 31 Selections, 24 winners, 7 losers, Bank +£79 to a variable £10 staking plan, increasing depending on the game. Edited September 16, 2019 by NickP thecurlyone1 and Sir Puntalot 2 Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted September 16, 2019 Share Posted September 16, 2019 Good luck @NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 18, 2019 Author Share Posted September 18, 2019 Ok this weekends selections:- Now I appreciate several are those are really low odds but they match my selection criteria, so for the purposes of this I will track at those prices, as on Bet365 now, and stakes. However either proceed with caution, or create doubles/trebles on the short ones each day, whatever your attitude to risk is. Man City/Bayern/Zilina/Porto/Celtic all looked nailed on, but you only need one to go wrong to lose across all five. Man CIty and Bayern have both played tonight, with City travelling back from Donetsk. However City are home to Watford who are bottom of the league at present, not sure a battling draw against the present Arsenal team counts for much and I guess Aguero will start having been benched tonight. Even thought Cologne won at Freiburg they have lost every other game and the newly promoted side away at Bayern should be easy pickings. Zilina should be fine again against a newly promoted Pohronie who have a W1D3L4 record, their only win against another low placed side. Porto and Celtic are both in Europa league action on Thursday night before their games on Sunday.Porto are at home both Thursday and Sunday so that counts in their favour. Celtic have a trip to Rennes before home to Kilmarnock, and hey it's Celtic at home in the league where they Won 17 and Drew 2 last season. Five fold? If you are brave enough.... thecurlyone1 1 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 21, 2019 Author Share Posted September 21, 2019 Saturday Results Antwerp WON 3-1 +£14.40 Brentford DREW 0-0 -£20 Man City WON 8-0 +£4 Bayern Munich WON 4-0 +£4 Zilina WON 2-1 +£8 Fenerbahce WON 2-1 +£5 Running Total = +£94.40 Squeaky bum time on the treble when Zilina let one in, but they held on and it went in, even if I cashed out just to make sure!! thecurlyone1 1 Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 22, 2019 Share Posted September 22, 2019 @NickP Thanks for the continual updates. If I may - what criteria are you using? I've been working purely on Home games (so taking into account Home Field Advantage) with an ELO difference of 25 (may be a bit conservative...) Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted September 22, 2019 Share Posted September 22, 2019 to Punters Lounge @BlinkingSpirit Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 22, 2019 Share Posted September 22, 2019 59 minutes ago, Sir Puntalot said: to Punters Lounge @BlinkingSpirit Thanks! Been lurking for sometime so may as well formalise things ? Sir Puntalot 1 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 22, 2019 Author Share Posted September 22, 2019 22/09 Results Arsenal WON 3-2 +£8.00 Porto WON 2-0 +£2.20 Celtic WON 3-1 +£12.00 LA Galaxy WON 2-1 +£6.10 Running total Bank +£122.70 to variable £10 staking plan. So 9 out of 10 for the weekend with just Brentford letting us down, balanced out by Arsenal somehow winning with 10 men! Selections 41, WON 33, Lost 8. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 22, 2019 Author Share Posted September 22, 2019 4 hours ago, BlinkingSpirit said: @NickP Thanks for the continual updates. If I may - what criteria are you using? I've been working purely on Home games (so taking into account Home Field Advantage) with an ELO difference of 25 (may be a bit conservative...) Basically I use the Parser and have an improving "2 AVG" against the "4 AVG" with at least a +20 in the "4 AVG", then check another site for it's rating and away we go. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 22, 2019 Author Share Posted September 22, 2019 Selections for this week are Will update with odds and stakes tomorrow night. Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 23, 2019 Share Posted September 23, 2019 8 hours ago, NickP said: Basically I use the Parser and have an improving "2 AVG" against the "4 AVG" with at least a +20 in the "4 AVG", then check another site for it's rating and away we go. Thanks! This is helpful...maybe I'm off jargon, but is the "Parser" the ELO scores? What is an "improving" 2 AVG (are you comparing game on game?). Lastly, what other sites are you using for the ratings? (I'm cognisant of the rules of the forum so if it's a commercial site you needn't share). Would this be something like the Club ELO site? Or the SoccerSTATS? If I need to mind my business, please say ? Just on the various tweaks out there... 8 hours ago, NickP said: ...balanced out by Arsenal somehow winning with 10 men! Ha ha...this. NickP 1 Quote Link to comment Share on other sites More sharing options...
Str8 Posted September 23, 2019 Share Posted September 23, 2019 Hi Well done with the spreadsheet, it looks promising! Btw, I tried to test today's elo ratings and it doesn't work. After following the copy and paste process, I go to "ELO ratings" sections and the values are very low, therefore the outputs are always "DRAW-DRAW". Tried on different days as well, it doesn't work too. For Example: PuntersLounge.com ELO Ratings https://www.punterslounge.com/elo-football-ratings/todays-elo-ratings Bet selection, insert cut-off values at sheet "Settings" 1 1 2 3 4 5 6 7 8 # League Home Team Average ELO ratings of last 4 and 2 matches Away Team Average ELO ratings of last 4 and 2 matches Difference 4 Avg 2 Avg 4 Avg 2 Avg 4 Avg 2 Avg 4 Avg 2 Avg 1 Brazil Serie A Avaí 1,14 0,63 Atlético-MG 0,99 1,71 0,15 -1,08 Draw Draw 2 Bulgaria Parva Liga Etar 0,88 1,29 Vitosha Bistritsa 0,29 0,54 0,58 0,75 Draw Draw 3 Czech Republic 1 Liga Jablonec 1,26 0,91 Sigma Olomouc 0,79 0,58 0,47 0,33 Draw Draw 4 Danish Superliga Randers 1,00 1,13 Horsens 1,00 0,29 0,00 0,83 Draw Draw 5 France Ligue 2 Lorient 1,23 1,04 Rodez 0,86 0,99 0,38 0,05 Draw Draw 6 German Bundesliga VfL Wolfsburg 1,63 1,63 TSG Hoffenheim 0,54 0,54 1,08 1,08 Draw Draw 7 Portugal Primeira Liga Sporting Braga 0,78 0,78 Marítimo 0,50 0,50 0,28 0,28 Draw Draw 8 Portugal Primeira Liga Sporting CP 0,74 0,74 Famalicão 1,42 1,21 -0,67 -0,47 Draw Draw 9 Romania Liga 1 Viitorul 1,13 1,58 Politehnica Iași 0,88 1,25 0,25 0,33 Draw Draw 10 Turkey Super Lig Beşiktaş 1,53 1,53 Istanbul Basaksehir 1,66 1,66 -0,13 -0,13 Draw Draw 11 Turkey Super Lig Sivasspor 1,63 1,63 Trabzonspor 1,38 1,38 0,25 0,25 Draw Draw Any tips on how to solve the problem? Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 23, 2019 Share Posted September 23, 2019 My first guess would be the decimal format you have Excel setup - you are using commas instead of periods. It should look like this: Quote Link to comment Share on other sites More sharing options...
Str8 Posted September 23, 2019 Share Posted September 23, 2019 37 minutes ago, BlinkingSpirit said: My first guess would be the decimal format you have Excel setup - you are using commas instead of periods. It should look like this: Yess you were right! I had to change it from , to . Thanks NickP 1 Quote Link to comment Share on other sites More sharing options...
note3user Posted September 23, 2019 Share Posted September 23, 2019 The German match for home win looks good odds Quote Link to comment Share on other sites More sharing options...
NickP Posted September 23, 2019 Author Share Posted September 23, 2019 22 hours ago, NickP said: Selections for this week are Will update with odds and stakes tomorrow night. OK updated with odds and stake. Technically Talleres does not meet the original criteria on the ELO Ratings, but given the league positions and the other site rating and the price am happy to throw it in for £10. This does kick off early Tuesday morning so get on quick if you are. Sociedad removed (filter error) Le Havre odds not out yet will update later in the week. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 23, 2019 Author Share Posted September 23, 2019 14 hours ago, BlinkingSpirit said: Thanks! This is helpful...maybe I'm off jargon, but is the "Parser" the ELO scores? What is an "improving" 2 AVG (are you comparing game on game?). Lastly, what other sites are you using for the ratings? (I'm cognisant of the rules of the forum so if it's a commercial site you needn't share). Would this be something like the Club ELO site? Or the SoccerSTATS? By "Parser" I am referring to the Spreadsheet developed on the previous thread, linked at the top of this one, provided by @froment in his post on 28th May, and which you are getting to grips with as per your post above. By improving 2 AVG, I mean the "2 AVG" rating is higher than the "4 AVG" rating, focussing here for my purposes on home games. As exemplified in your post above for Etar and 14.00 > 18.00 and Viitorul. However I am using a minimum +19.99 on the "4 AVG" as a start point in my selections My other site is, and please remove @Sir Puntalot if not supposed to be here, https://www.soccervista.com/ Str8, froment and Retired_BSpirit 3 Quote Link to comment Share on other sites More sharing options...
Retired_BSpirit Posted September 24, 2019 Share Posted September 24, 2019 Thanks @NickP On the same page now! NickP 1 Quote Link to comment Share on other sites More sharing options...
Str8 Posted September 24, 2019 Share Posted September 24, 2019 (edited) Nick you're doing a fantastic job!!! I just took 2 accas in 2 days. What I do is basically playing "safer" in comparison to what ELO ratings / your spreadsheet is providing. One acca was 20/1 and yesterday 10/1 For example the call for today is Talleres 1 @1.83 . What I did was putting Talleres 1X @1.16 . Yesterday Sporting - Farmalicao was an away win based on the ELO Rating and I took away +2 @1.55 which was an absolute banker imo (They won anyway lol) Some bets are trickier. For example yesterday Wolfsburg didn't have high enough odds for a straight win and there was no value in betting on them (Hoffenheim are not a bad team at all). Due to their goalscoring/conceding attitute my safe bet was 1X+Over1.5 @1.50 I had also luck to take 6-8 matches in my accas but I think you can bring consistent doubles or trebles by mixing the right bets. Let me know if you want me to share accas guys, I don't want to spam your thread tho Edited September 24, 2019 by Str8 NickP 1 Quote Link to comment Share on other sites More sharing options...
Sir Puntalot Posted September 24, 2019 Share Posted September 24, 2019 13 hours ago, NickP said: By "Parser" I am referring to the Spreadsheet developed on the previous thread, linked at the top of this one, provided by @froment in his post on 28th May, and which you are getting to grips with as per your post above. By improving 2 AVG, I mean the "2 AVG" rating is higher than the "4 AVG" rating, focussing here for my purposes on home games. As exemplified in your post above for Etar and 14.00 > 18.00 and Viitorul. However I am using a minimum +19.99 on the "4 AVG" as a start point in my selections My other site is, and please remove @Sir Puntalot if not supposed to be here, https://www.soccervista.com/ @NickP I've no problem with this as long as you're contributing and not just directing traffic to your website. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 24, 2019 Author Share Posted September 24, 2019 (edited) Results for 24/09 Tallares WON 2-1 +£8.30 Djugardens WON 1-0 + £7.20 Running Totals Selections 43 WON 35 = 81.3% Strike Rate LOST 8 Bank +£138.20 to £10 Stakes Edited September 24, 2019 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 24, 2019 Author Share Posted September 24, 2019 11 hours ago, Str8 said: Nick you're doing a fantastic job!!! I just took 2 accas in 2 days. What I do is basically playing "safer" in comparison to what ELO ratings / your spreadsheet is providing. One acca was 20/1 and yesterday 10/1 For example the call for today is Talleres 1 @1.83 . What I did was putting Talleres 1X @1.16 . Yesterday Sporting - Farmalicao was an away win based on the ELO Rating and I took away +2 @1.55 which was an absolute banker imo (They won anyway lol) Some bets are trickier. For example yesterday Wolfsburg didn't have high enough odds for a straight win and there was no value in betting on them (Hoffenheim are not a bad team at all). Due to their goalscoring/conceding attitute my safe bet was 1X+Over1.5 @1.50 I had also luck to take 6-8 matches in my accas but I think you can bring consistent doubles or trebles by mixing the right bets. Let me know if you want me to share accas guys, I don't want to spam your thread tho Yes not quite got round to acca's myself yet but the potential is obviously there. I am recording all results that my selection criteria are giving for 1X2 but right now only publishing here ,and actively betting, the singles to the variable bank. In terms of spamming the thread, no problem, glad to have helped out, but not sure if we can keep two selection strategies going in the same thread so would appreciate, and obviously follow myself, any Acca thread you would like to open ? Quote Link to comment Share on other sites More sharing options...
NickP Posted September 24, 2019 Author Share Posted September 24, 2019 9 hours ago, Sir Puntalot said: @NickP I've no problem with this as long as you're contributing and not just directing traffic to your website. Nope no other website trickery at play here, just using both in terms of formulating my selections only to be posted here. No alterior motive at all? Sir Puntalot 1 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 24, 2019 Author Share Posted September 24, 2019 (edited) So just to be clear and back on topic ?, here are tomorrows selections:- £20 on Lille @ 1.85 £20 on Basel @ 1.45 £40 on PSG @1.18 £40 on Maribor @ 1.28 Edited September 24, 2019 by NickP Quote Link to comment Share on other sites More sharing options...
NickP Posted September 25, 2019 Author Share Posted September 25, 2019 Results 25/09 Lille WON 2-0 +£17 Basel WON 4-0 +£9 PSG LOST 0-2 -£40? (Watched em they were shocking in the final third!!) Maribor WON 5-0 +£11.20 Bank +£135.40 / Selections 47 / Won 38 / Lost 9 / 80.8% Winners Quote Link to comment Share on other sites More sharing options...
NickP Posted September 25, 2019 Author Share Posted September 25, 2019 Selections for 26th Gremio £40 @ 1.33 Sao Paulo £20 @ 1.40 Malmo £40 @ 1.22 Norrkoping £40 @ 1.16 Posted these above previously, but aware Brazil kicks off early tomorrow morning, so get on tonight! Busy weekend coming up having looked at the stats so 14 games in total from Friday to Monday night, will post them all tomorrow night. Quote Link to comment Share on other sites More sharing options...
NickP Posted September 26, 2019 Author Share Posted September 26, 2019 This weekends game selections starting in France Friday evening. US games will be updated once odds are out. Good luck! Quote Link to comment Share on other sites More sharing options...
NickP Posted September 27, 2019 Author Share Posted September 27, 2019 On 9/25/2019 at 10:25 PM, NickP said: Selections for 26th Gremio £40 @ 1.33 Sao Paulo £20 @ 1.40 Malmo £40 @ 1.22 Norrkoping £40 @ 1.16 Posted these above previously, but aware Brazil kicks off early tomorrow morning, so get on tonight! Busy weekend coming up having looked at the stats so 14 games in total from Friday to Monday night, will post them all tomorrow night. Gremio WON 6-1 +£13.20 Sao Paulo LOST 0-1 -£20 Malmo WON 3-0 +£8.80 Norrkoping WON 4-0 +£6.40 Le Havre LOST 0-1 -£20 Running Total +£123.80 Selections 52 Won 41 - 78.8% Lost 11 Quote Link to comment Share on other sites More sharing options...
NickP Posted September 27, 2019 Author Share Posted September 27, 2019 Games for the weekend updated with MLS odds from Bet365 and staking Quote Link to comment Share on other sites More sharing options...
NickP Posted September 27, 2019 Author Share Posted September 27, 2019 One more game that has sneaked in for Sunday, Italian Serie A - Napoli - 1.25 £20 Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.32384c3055cbc1254b0eb6212fda1359.jpg)
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.