Results Sheet With P/L (Match Odds)
-
@ryan-carruthers no it’s slowly building, I’m also using £2 stakes as I’m still waiting on confidence to use higher but it’s going well so far
-
@ben-price Not to shabby!!
-
@ben-price said in Results Sheet With P/L (Match Odds):
Today’s Selections -
System A -
Bordeaux - Montpellier
Lay Bordeaux @ KO @ 2.70.
Sunday’s results were okay, not great but not red so all is good!
Liverpool - Everton game Price was too high, somehow got into the filter when I must have been messing
Total for the day +1.56 Points
Long term Profit + 3.04
Another green day, whole + 0.98 Points
Taking overall Profit to + 4.02 Points
-
Today’s Selections -
System A -
Bordeaux - Montpellier (HT 1-1 FT 1-2) Won
Lay Bordeaux @ KO @ 2.70.
Sunday’s results were okay, not great but not red so all is good!
Liverpool - Everton game Price was too high, somehow got into the filter when I must have been messing
Total for the day +1.56 Points
Long term Profit + 3.04
-
@ben-watts I have 5 years of data that I’m working on
But it’s taking a while 
But will be worth it, as with juventus last night they were far to big! -
@ben-price said in Results Sheet With P/L (Match Odds):
@ben-watts said in Results Sheet With P/L (Match Odds):
Hi Ben how's it going. Been looking at this mate and it's brill thank you, been looking at it for most of the afternoon actually
Good work. How are you selecting potential trades? What qualifies for you?System A - Is lay of the home team in even matched games, where home team seems a false favourite.
System B - Heavy Away Fav’s but laying the home team to get the draw onside
System C - LTD, in games that meet certain price points with goals expected.
Also looking at maybe an away team lay in the same vain as system B, but I’m still testing and at the minute keeping it down to 3 systems seems to be working, no need to be looking for more and more and more. I find less is best.
Hope this has helped.
Thanks mate, that's a big help :-). Will be definitely keeping my eye on these.
-
@ben-watts said in Results Sheet With P/L (Match Odds):
Hi Ben how's it going. Been looking at this mate and it's brill thank you, been looking at it for most of the afternoon actually
Good work. How are you selecting potential trades? What qualifies for you?System A - Is lay of the home team in even matched games, where home team seems a false favourite.
System B - Heavy Away Fav’s but laying the home team to get the draw onside
System C - LTD, in games that meet certain price points with goals expected.
Also looking at maybe an away team lay in the same vain as system B, but I’m still testing and at the minute keeping it down to 3 systems seems to be working, no need to be looking for more and more and more. I find less is best.
Hope this has helped.
-
Hi Ben how's it going. Been looking at this mate and it's brill thank you, been looking at it for most of the afternoon actually
Good work. How are you selecting potential trades? What qualifies for you? -
@ben-price said in Results Sheet With P/L (Match Odds):
Saturdays Selections -
System A -
Frankfurt - Hoffenheim
Lay Frankfurt @ KO @ 2.34
Angers - Monaco
Lay Angers @ KO @ 3.50
Lazio - Roma
Lay Lazio @ KO @ 2.58
Real Madrid - Barcelona
Lay Madrid @ KO @ 2.84
System B -
Huesca - Sevilla
Lay Huesca @ KO @ 4.30
Yesterday the only Selection Won so profit was + 0.98 points.
Overall Longterm profit + 5.96
Yesterday was a hard knock down to earth. Sevilla conceding in the 98th minute was the worst possible outcome. Also looked offside but ref blew for full time... VAR said just level. Sevilla should of won it when they had a goal ruled out in the 92nd minute and VAR judged that to be offside when looked level. Also Roma didnt turn up against Lazio, think i will give derbies a miss depending on results today.
Just to add, Frankfurt scored 2 goals in 4 minutes of injury time to turn round a 1-2 to 3-2. Day was looking great at around 4:00 then by 4:15...
Anyhow overall - 4.48 Points yesterday
Total Longterm profit + 1.48
-
Today Selections -
System A -
Guingamp - Nantes (HT 0-0 FT 0-0) Won
Lay Guingamp @ KO @ 3.20
Nice - Strasbourg (HT 1-0 FT 1-0) Lost
Lay Nice @ KO @ 2.5
Udinese - Bologna (HT 1-0 FT 2-1) Lost
Lay Udinese @ KO @ 2.86
Betis - Getafe (HT 0-2 FT 1-2) Won
Lay Betis @ KO @ 2.46
Wolfsburg - Werder Bremen (HT 0-0 FT 1-1) Won
Lay Wolfsburg @ KO @ 2.34
Napoli - Juventus Won
Lay Napoli @ KO @ 2.58
System B -
Sociedad - Atl. Madrid (HT 0-2 FT 0-2) Won
Lay Sociedad @ KO @ 4.1
System C -
Everton - Liverpool (HT 0-0 FT 0-0) No Trade - Price Too high @ KO
LTD @ KO @ 4.3
-
Saturdays Selections -
System A -
Frankfurt - Hoffenheim (HT 1-1 FT 3-2) Lost
Lay Frankfurt @ KO @ 2.34
Angers - Monaco (HT 2-0 FT 2-2) Won
Lay Angers @ KO @ 3.50
Lazio - Roma (HT 1-0 FT 3-0) Lost
Lay Lazio @ KO @ 2.58
Real Madrid - Barcelona (HT 0-1 FT 0-1) Won
Lay Madrid @ KO @ 2.84
System B -
Huesca - Sevilla (HT 1-0 FT 2-1) Lost
Lay Huesca @ KO @ 4.30
Yesterday the only Selection Won so profit was + 0.98 points.
Overall Longterm profit + 5.96
-
1 Selection for today -
System B -
Rayo - Girona (HT 0-1 FT 0-2) Won
Lay Rayo @ KO @ 2.7
Tuesdays Selections both Won
Overall points gained on Tuesday +1.96
Total Overall Points +4.98
-
2 Selections for Tonight both are System C-
Huddersfield - Wolves (HT 0-0 FT 1-0) Won
LTD @ KO @ 3.55
Cardiff - Everton (HT 0-1 FT 0-3) Won
LTD @ KO @ 3.45
Yesterday was a perfect day!
Total Profit + 0.98 Points
Overall Total Profit + 3.02 Points
-
@ben-price said in Results Sheet With P/L (Match Odds):
@ben-price said in Results Sheet With P/L (Match Odds):
@ben-price said in Results Sheet With P/L (Match Odds):
Have taken what @Adam-Williams put up and added an P/L section. You can also filter these by leagues, teams & odds. I currently only have Bundesliga completed.
If you had backed the draw in every game in the Bundesliga this season you would be showing a 21.34 point profit. Where as laying the draw would be showing a huge loss of -35.10 points.
I hope this helps people for their set and forgets over the weekend. I will be using this, with the BTC stats to give me the games to match my system.
Here is the link, next to be completed is the La Liga.
https://docs.google.com/spreadsheets/d/16DY8ZZyTmiIf3JomdMoy5GmsQ3Rdut7Qyt5uZ8qwNUw/edit?usp=sharing
Any feedback is welcomed. @Ryan-Carruthers @Martin-Futter
Have updated this sheet.
Leagues that are on here are : Ligue 1, Serie A, La Liga & Bundesliga. Will sort out getting the Premiership done before the end of tomorrow.
After that im willing to take recommendations for the next league after that.
Does anyone want Champions League or Europa League?
Thanks for all the kind words again and if anyone needs help working this sheet give me a shout!
Now has Premier League in here.
Hope this can make you all some profit this weekend even without the Premier League this weekend.
My Set and Forget for this weekend that i will be trying with minimum stakes is :- Home Team Odds (Between)2.0 - 2.8. Draw Odds (Less Than) 4. Which would lead me to Laying the Home Team. Shows a Profit of 69.96 points of profit this season in 346 bets, which equates to £174.90 profit from a £5 stake.
Good Luck this weekend,
Now the sheet has Eredivisie, Looking at getting Primera Division done next (Portugal)
Willing to take requests. Also when @Adam-Williams updates his sheet to have O2.5 + O1.5 i will be setting those up with odds back and lay totals.
-
@matthew-davies Yeah thats the only issue, i have sat through and changed them all my end. Just something you will have to do... If you filter by the number like 40330 and then go onto flashscores and find one of the games, they will all be the same score so a simple copy and paste.
-
@ben-price one thing I have noticed when downloading to excel is any scores that don't have a zero gets converted to a date format. I have changed the format to text but then it updates those scores to a random number.
-
Will get the Eredivisie out Tomorrow as I feel that could be a nice league once we have the O2.5 odds incorporated in
-
@matthew-davies need any help with filters, or odds give me a shout
-
@ben-price Sorry my mistake I didn't see the second sheet all working fine
-
@matthew-davies File, Download as, Excel sheet.
