Matched Betting Question Creating a Google Spreadsheet - queries

Knopfler

The cleverest woodpecker in all of Yorkshire!
Joined
Jul 7, 2016
Messages
1,111
Points
203
Location
South Yorkshire
As the title suggests I have created a spreadsheet for my mb'ing in Google Sheets but am not quite sure of the following:

1) Free Bets. Do I put £0 in the Bet Stake column or the actual amount of the free bet e.g. £5?
I would obviously put the amount won (unless I punted it and lost) in the Profit column.
Just trying to figure it out for when I total up the columns at the end of the year.


2) Unlaid Bets that Win. I put the correct Bet Stake in the column. Do I put the total winnings MINUS the original Bet Stake into the Profit column?
Also it looks like some bookies show the total payout including the stake and some show it after it has been deducted?

If this is the case, is it possible to fill in a calculator to show the correct profit to add to the spreadsheet, instead of noting which bookies use which system?

I am not with OM or PA at the moment, so no Profit Tracker - besides which I always had a bug bear about the OM one showing custom laid free bets wrongly, which I created a thread about and it still was not fixed months later.

Thanks in advance :)
 

jkg-jkg

Money Making Megastar!
Joined
Aug 17, 2016
Messages
1,353
Points
273
Have you tried Ultimatcher - as all this work has already been done (or is it because you don't have Excel)

For 1) the free bet is Stake Not Returned so you are actually betting £5 but the return is 0 on lose and (Decimal Odds - 1) if you win. You can't use 0 as the stake as it won't multiply with anything.

For 2) You are right with both, but I do find most bookies show the 'return' as including the original stake. Ignore what they say as you already know what calc to use to get the profit.
 

Knopfler

The cleverest woodpecker in all of Yorkshire!
Joined
Jul 7, 2016
Messages
1,111
Points
203
Location
South Yorkshire
Thanks @jkg-jkg - you're right, I don't have Excel :)

So basically, I would always put the Bet Stake amount in, regardless of whether it was a free bet, normal bet, unlaid bet etc. and the Profit column would be the amount I received after the bet stake was deducted.

The Profit can be worked out by deducting 1 from the back bet odds and multiplying by the bet stake eg £5 bet at odds of 5.2 would return a total profit of £21.00 if it won (5.2 -1 x5 = 21)

Many thanks :)
 

Members online

No members online now.

Amazon Discount Finder Tool

Find hidden 80%+ savings on Amazon products



 

 

 

 

 

 

 

Forum statistics

Threads
7,380
Messages
199,740
Members
11,387
Latest member
jbniche1