Calculating how to hedge a multiple?

[jakes]

Hi!

Curious if anybody has a spreadsheet or something similar they can throw at me which is made to calculate hedging amounts for full cover bets?

I've not used excel since I left secondary school and the maths of it all bend my mind although I may have a crack at it if there's none around.

Thanks!

[Keefter]

Well you cant really hedge a multiple until the last leg obviously. but say you have a 4 leg multi on the nags and the first 3 have won, then calculating a hedge on teh fourth selection is straight forward enough. I'll do a random example below.


Stake £10

Leg 1: Horse a @ 3.75 WON
Leg 2: Horse b @ 4.20 WON
Leg 3: Horse c @ 2.77 WON

Now assume you only have leg 4 remaining. Firstly you simply multiple your stake by the odds of you selections so far. 10 x 3.75 x 4.20 x 2.77 = 436.27.

so basically you have 436.27 rolling onto the last selection. If you decided you want to get out as cleanly as possible and dont care if it wins or loses then you simply lay the last selection until the exposure is equal to the amount you have rolling up. say its 2.00, you'd literally lay the 436.27, if it wins your multi pays 872.55 but you lose the lay bet and if it loses your multi pays nothing but you win the lay bet, either way you win 436.27.

I'm not sure any fancy excel spreadsheet is required tbh and if you did ant something then you could knock it up in 5 mins I'm sure.

Hope that helps.

[jakes]

When I said multi I was more referring to the slightly more advanced bets, I'd like to eventually put together a spreadsheet which could calculate how to hedge these.

Trixie
Yankee
Canadian or Super Yankee
Heinz
Patent
Lucky 15
Lucky 31
Lucky 63

None of these are that simple as they consist of doubles, trebles, acc's and singles.

Thank you for that info though, very useful!

[Keefter]

yeah that makes it more complicated. The same principle applies though. I did something for yankees years ago in Excel. Didnt take long. I guess you'd have to have a worksheet for each type of multi.