a1ehouse
-
Posts
504 -
Joined
-
Last visited
Posts posted by a1ehouse
-
-
Re: Total Corners Spreads: 100 bets, +31% yield !!! :bignana
-
-
Re: Total Corners Spreads: 96 bets, +30% yield :clap Like it mate :ok
-
Re: The a1ehouse top and the plops Thank davidc. Back testing the system over the last 9 seasons I get: Bets: 2068 Wins: 1803 Strike Rate: 87.19% Ave Odds: 5.31 So there has to be a staking plan in there! I have had a play around with "the Staking Machine" and the analysis for the lay systems are pretty good. ROI between 5.4 on Maria to 10.27 on Basic Lay Ladder. Cumulative profit peaked on Lay Percentage.
The +13.05pt profit is based on a stake of £1 for every bet rather than ratchet and percentage of bank, and liability ranged from £3.20 to £10. At that time:Is the above return calculated on 1pt risk or reward, if you see what I mean.A1ehouse LtD Starting Bank £1,000.00 Current Bank £1,013.05 Total Liability £147.40 Number of Bets 25 Winning Bets 23 Losing Bets 2 Strike Rate 92.00% Yield 8.85% P/L less 5% Comm £13.05 -
Re: The a1ehouse top and the plops Disappointed with another draw, could have been worse before the last minute goal at Sp Lisbon. Looking into other staking plans to avoid wiping the winnings out as with all lay systems. Anyone offer any advice?
TopAndThePlops HomeTeam Result Anderlecht :dude Benfica :wall Sivasspor :dude Sp Lisbon :dude A1ehouse LtD Starting Bank £1,000.00 Current Bank £1,037.35 Total Liability £1,021.00 Number of Bets 33 Winning Bets 29 Losing Bets 4 Strike Rate 87.88% Yield 3.66% P/L less 5% Comm £37.35 -
-
Re: The a1ehouse top and the plops
A last minute equalizer stops a streak of 25. Had to happen sooner or later.TopAndThePlops HomeTeam AwayTeam Liverpool :dude Juventus :wall
Stakes as follows after the Liverpool game:A1ehouse LtD Starting Bank £1,000.00 Current Bank £1,055.98 Total Liability £885.37 Number of Bets 29 Winning Bets 26 Losing Bets 3 Strike Rate 89.66% Yield 6.32% P/L less 5% Comm £55.98 100% of Bank £1,083.28 Prices Stake Liability 3.5 £10.83 £27.08 3.6 £6.50 £16.90 7.4 £6.50 £41.60 7.5 £4.33 £28.17 11 £4.33 £43.33 -
Re: Total Corners Spreads: 76 bets, +28% yield Wise move mate being the "business end" of the season. Review, reflect, revise during the summer break, looks like you could be on to something.
-
Re: Total Corners Spreads: 76 bets, +28% yield :nana Lovely jubley! Good stuff muppet.
-
Re: The a1ehouse top and the plops
TopAndThePlops HomeTeam Result Brechin :dude Inter :dude
New bank = New stakes:A1ehouse LtD Starting Bank £1,000.00 Current Bank £1,077.14 Total Liability £821.88 Number of Bets 27 Winning Bets 25 Losing Bets 2 Strike Rate 92.59% Yield 9.39% P/L less 5% Comm £77.14
Tomorrows selections:100% of Bank £1,077.14 Prices Stake Liability 3.5 £10.77 £26.93 3.6 £6.46 £16.80 7.4 £6.46 £41.36 7.5 £4.31 £28.01 11 £4.31 £43.09 TopAndThePlops Date Division HomeTeam AwayTeam WinExpectancy GoalSuperiority HomeTeamForm AwayTeamForm HeadToHead Betfair Stake Liability 03/05/2009 Serie A Juventus Lecce 92.59% 12 9 WWDlDd 4 lDlLlW Juventus:11(6) Lecce:2(1) Draws:4(1) 5.2 6.46 27.30 03/05/2009 Premier League Liverpool Newcastle 94.04% 21 16 WWWWDW 2 LdLLdl Liverpool:18(12) Newcastle:7(1) Draws:6(2) 6.6 6.46 36.18 -
Re: The a1ehouse top and the plops Couple today:
Hi draws on Inter/Lazio, but relying on the ratings!TopAndThePlops Date Division HomeTeam AwayTeam WinExpectancy GoalSuperiority HomeTeamForm AwayTeamForm HeadToHead Betfair Stake Liability 02/05/2009 Division 2 Brechin Stranraer 93.32% 9 9 LLWWWl 3 lLLWLl Brechin:12(6) Stranraer:5(1) Draws:2(2) 6.2 6.39 33.23 02/05/2009 Serie A Inter Lazio 93.27% 9 11 WWWDdl 6 LllWWL Inter:6(3) Lazio:9(3) Draws:16(9) 4.3 6.39 or 6.43 if bet1 wins 21.09 or 21.21if bet1 wins -
Re: Total Corners Spreads: 71 bets, +22% yield :clap nice!
-
Re: Calling a1ehouse No worries - it what a forum is about! Good for you to try and work it out though. I started by picking up bits and bobs too, so takes years of learning and putting into practice, but a powerful thing to have at your disposal. The web has a raft of info out there - google Mr. Excel or J Walk.
-
Re: Calling a1ehouse Goto the Excel Objects again, double click on your main worksheet you want to copy from (e.g. Sheet1), select WorkSheet from the (General) drop down box then Change from the other one.
-
Re: Calling a1ehouse Don't use MSN/AOL sorry. It won't overwrite. If it's your sheet is open all the time, you can make it even easier and use the WorkSheet_Change object (from the Excel Objects again) This will fire everytime a cell is changed, no need to run it everyday as it will be immediate as soon as "Finished" appears in column C:
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Left(Target.AddressLocal(ColumnAbsolute:=False), 1) = "C" Then If InStr(Target.Text, "Finished") Then Rows(Target.Row).Copy Sheets("Results").Range("A65536").End(xlUp).Offset(1, 0) Rows(Target.Row).Delete shift:=xlUp End If End If End Sub -
Re: Calling a1ehouse
You should be able to run the code manually by running the MoveAndPurge macro. Make sure you change "Sheet1" to the name of where your pulling the info from. In VBA editor, on the left in the Excel Objects, double click ThisWorkbook. In the dropdown list (General) select WorkBook, 2nd code should go in there.I ran it and nothing happpend ... I pasted the 2nd code in the same module as the first code .. was I supposed to make two seperate macros or something? -
Re: Calling a1ehouse Untested, so let me know if there's a problem! :tongue2
Option Explicit 'Copy the whole row instead: Sub CopyFinished() Dim rng As Range For Each rng In Range(Sheets("Sheet1").Range("C1"), Sheets("Sheet1").Range("C65536").End(xlUp)) If InStr(rng.Text, "Finished") Then rng.EntireRow.Cut Sheets("Results").Range("A65536").End(xlUp).Offset(1, 0) End If Next rng End Sub 'Then this deletes the empty rows: Sub DeleteEmptyRows() Dim lastRow As Long, r As Long lastRow = Sheets("Sheet1").UsedRange.Rows.Count For r = lastRow To 1 Step -1 If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete Next r End Sub 'So to run them every day we bung them together in a single macro: Sub MoveAndPurge() Call CopyFinished Call DeleteEmptyRows End Sub'Bung this in the Workbook_Open: Private Sub Workbook_Open() Application.OnTime TimeValue("18:00:00"), "MoveAndPurge" End Sub -
Re: The a1ehouse top and the plops I am basing my selections on my ratings regardless of market price. However, the stakes are adjusted depending on available odds. Where odds are between 2.6 and 7.4 I stake 0.6% of the bank (currently £1064.97). This makes a stake of £6.38 with a liability between £16.61 and £40.89. Two games with odds of 7.0 and 7.5 may well be similar chances of a draw, but I am going off the ratings where a win expectancy is <=10% or >=90%.
-
Re: The a1ehouse top and the plops
Thanks mate I am laying the draws, and the stakes are based on a percentage of my bank. Each time the bank grows, so do the stakes so with odds all being different so is my liability. At 1pt level stakes its +13.05ptsGood work on this a1ehouse. Why are you having such varied liabilities (effectively your stakes)? Are you keeping a record for level stakes (your stakes)? -
Re: Football System that works but needs advcie
Possibly, but from experience, top 3 and Liverpool always seem to get the ref's "advantage" ;)Not so sure that's as easy to quantify but in the long run I think it will even out. Good teams avoid losing in spite of poor ref performances. -
Re: The a1ehouse top and the plops Full house today, 22 on the bounce. Waiting for the next draw to eat into the profit!
HomeTeam Result Arsenal :dude Oxford :dude Panathinaikos :dude PAOK :dude Thrasyvoulos :dude Xerez :dude Porto :dude
New bank, new stakes:A1ehouse LTD Starting Bank £1,000.00 Current Bank £1,064.97 Total Liability £766.82 Number of Bets 25 Winning Bets 23 Losing Bets 2 Strike Rate 92.00% Yield 8.47% P/L less 5% Comm £64.97
Went live with this when switched to laying draws :ok:100% of Bank £1,064.97 Prices Stake Liability 3.5 £10.65 £26.62 3.6 £6.39 £16.61 7.4 £6.39 £40.89 7.5 £4.26 £27.69 11 £4.26 £42.60 
-
Re: Football System that works but needs advcie Ouch. Actually come to think of it the ref and linesmen made some shocking decisions, maybe something to include on a system is their performance?!?
-
Re: Football System that works but needs advcie
Yeh mate, was there - tell me about it :sad gutted for Jag's.Take Man City this season for example....apart from yesterday:eyes -
Re: The a1ehouse top and the plops Panathinaikos odd dropped to 11; stake 4.12, liability 41.17
Holy Grail Total Corners
in Betting Systems & Strategy
Posted
Re: Total Corners Spreads: 102 bets, +32% yield !!! For me, it's about striking that balance between time, effort and profitability. 46/102 bets is nearly twice the effort to gain 10/170 points! I'd be inclined to focus on the 2+3's but also look into alternative ways how 1 units could be used, profit is profit at the end of the day!