Recently got into this, ~1 month, have been trying to recreate the calculator in a spreadsheet to no avail. Does anyone have their own calculators they use? or do you just use the one on the site?+00December 4, 2015 at 1:03 pm
Tony 8 December 4, 2015 at 1:10 pm
I use Matt’s most of the time – the only thing that I go elsewhere for is when I want to underlay a bet. I won’t link to the competition sites out of respect to Matt, but they are not that hard to find.
I built my own calculator to work out the best way to exploit the risk-free in play offer that Ladbrokes and Bet365 often run because there are a few sums to be done on this and I was getting sick of doing them manually every time. All I have to do with that one is stick the 1-X-2 odds in and the value of the risk free bet and it does the rest for me- highlights which outcome to bet pre/in play and how much to stake.
If you use your phone to bet much, there is a fairly decent MB Calculator app (iOS and Android, I believe) – other than the annoying ads it works just fine (and again, has under/over lay options built in)+0Ice Magic 2 December 4, 2015 at 1:50 pm
I downloaded a spreadsheet from a matched betting site which not only calculates but it also records every bet detail in another tab
I modified the spreadsheet so that I could adjust the lay stake to over or under lay.
Its fantastic and if you put your email on here I can send you a copy. Not sure if we can private message?+0Mark 1 December 4, 2015 at 7:42 pm
I wouldn’t put your email on here, if you use it for gambling accounts you may find yourself banned sooner than you think!
Since I started I’ve been building my own spreadsheet calculators to do the things I need to do on a regular basis. It looks like my two year old vomited alphabet spaghetti on the screen but it works for me.+0Drogs 0 December 7, 2015 at 3:16 pm
Tony, any chance you could explain how you made the calculator for the risk free in play bets? Would love to have that as trying to work out the most profitable option is a pain in the neck!+0elis 0 December 7, 2015 at 3:34 pm
It’s quite straight forward, You multiply the risk free stake (e.g £50) by the correct odd (e.g 3.0), then both other stakes should be equal to that return (£150) minus the stake (£50) = £100. So with the above example and the odds 1.5 and 2.0, the stakes would be 100/1.5 = 66.66 and 100/2 = 50.+0Drogs 0 December 7, 2015 at 3:38 pm
Thanks Elis, I can work it out like that though. I am just wondering how you would go about making a calculator where you just input the odds and it does it for you and highlights what to stake on what etc, as Tony described above. I don’t know if this is something you could easily explain, but thought I would try my luck in asking 😛+0Tony 8 December 7, 2015 at 3:53 pm
Hey @gkitching – Currently it is sitting as a separate tab in my Google Sheets MB tracker workbook, but how about I try to copy it over to a fresh Google Sheet and share it publicly later tonight (time permitting)?
I have plumbed in the odds for the Wolfsberg v Man U game and (reassuringly!) it comes up with the same outcome as Matt’s blog – betting the Draw in play is the most profitable option. Incidentally, it is also the only option (given the odds) that actually conforms to the risk free bet rules, namely that your free bet is up to the same value as your pre match bet.
What the calculator is also useful for is showing the total outlays required to use the risk free inplay bet on each outcome (Home, Draw, Away)+0Drogs 0 December 7, 2015 at 4:12 pm
That would be awesome Tony if you get the chance at some point! Thanks!!+0Tony 8 December 8, 2015 at 11:35 am
Here you go @gkitching (and others), a link to my Risk Free In Play Bet calculator…
It is a Google Sheet, but you won’t need a google account to access it.
Hope it is helpful.
You must be logged in to reply to this topic.