Multimatcher Spreadsheet

[lazza_w]

I don't know if this is of use here, but this is a spreadsheet that I've created and had posted on MSE for some time.

The sheets do the following

1) Multimatcher - standard matching spreadsheet. In addition it shows you how much to lay at a range of odds. If you are laying at a range of odds (ie when there is low liquidity) then you can input how much you have layed and the sheet recalculates how much is left to match.

2) Dutching - as above, but for dutching

3) Underlaying - basic spreadsheet but allows you to choose a % to under/overlay so that you can get a fixed return if your bet wins or loses

4) Bonus if bet wins - suitable for offers like Betdirect 'free bet if your horse wins'. It simply saves the inconvenience of adding 0.8 etc to the back odds or putting in a negative value in the 'stake forfeit' box'. In the heat of the moment I have been known to forget this minor detail!

5) Bonus if bets loses - as above.

6) Double your winnings - Winunited have these offers on a regular basis. They work the same as type 4, but the winnings is capped at a certain amount

7) Bonus if 0-0 - There isn't much money in these offers, where you have to back and lay a qualifier (probably on limited markets such as correct scores) then lay a 0-0 bet. As a result I've included 3 options. The first gives you the max return if the qualifying bet loses (likely, as it is probably at high odds), the second gives approximately equal returns whatever the qualifier result, the third gives the maximum return if the qualifier wins (high return, unlikely to happen). The 'max' and 'min' values exist because you can only lay exact pence at Betfair. The minimum lay stake is limited to £2.00, as you can't lay lower amounts at Betfair

8) There's a 'book %' sheet that you can use if you're betting on the GeeGees. Stick all the odds on offer for a race in and see what the book % is. If it's miles off Betfair's or <110% then worry

9) I've put another sheet in for 'bonus if loses multiple' offers where your refund is not based on 1 market but on a number of races (eg Skybet's Punchestown offer a couple of months ago here). The numbers in there are the ones I used on the Punches offer where how much I could bet each time was limited by either the funds I had available to deposit into sky, the Betfair liability or limiting by Skybet themselves.

It also includes a currency converter. You put the exchange rates into the 'multimatcher' sheet then each sheet has a 'currency' cell where you can input the currency that you're using (EUR/US/AUS/SG). If you leave it blank it'll assume that you're using £. Alternatively you can put another currency exchange rate in to the 'Other' box' or just type a number in to the 'currency' box (C5)

The multimatcher is currently set to back something in Euros and lay it in £ and the dutching calculator set to bet in US$ and the 2nd bet in £, just as an example.

Just check it works OK before using it. My job has nowt to do with IT and I learnt Excel using a 10 yr old book from the library.

Caveat Emptor

Multimatcher lazza.xls

[smk77]

Note to self...Have a look at this spreadsheet!!! The number of times it has been mentioned on MSE as being VERY useful and I've still not had a look!

Cheers for bringing it here Lazza!

[frosty85]

Cheers for that Lazza. Tis particularly impressive, it must have taken some time to create. Have to admit I'm not quite so detailed with my history records and calculations but may give this a go and see how I fair.

[shyle of pyte]

Lazza - thanks man! I downloaded it at the start of this year and use the underlaying page nearly every day. I honestly don't know what I would have done without this tool. Good work, thanks for sharing it!

[lazza_w]

HaHA, I NEVER use the underlaying sheet.
In fact I forgot it was there for a while and was only reminded when someone asked me how to use it. I just do that bit by guesswork using the multimatcher sheet

[munk]

Nice one lazza, post of the week material there.

[Andy]

Thankyou very much, excellent post. Personally im going to stick to a mixture of a scrap of paper/pencil and estimating the amounts i want to bet, but i can see how that would be VERY usefull if i was starting from scratch :-)

[smk77]

Just downloaded this spreadsheet! Looks great! I wish I'd downloaded it months ago!

[sKiTz0]

Just trying to download this and the link is broken.

I'm looking at doing the Totesport 0-0 offer this weekend and will also be signing up with Corals for their refund on losses promo so really need something to help me with calculations for both of these.

Does anybody have an up to date link for this please?

Thank you

[U4EA]

The Ultimatcher, I think, superseded Lazza's matcher. It can be downloaded from MSE.