Green up help needed

[bolpx001]

Hi I just can't get my head around this. I can green up fine if it is just one bet ie back £4 at 4.0 and if the odds drop to 3.0 I lay 5.33 to make a net profit of 1.33 However when I bet I back and lay and usually end up in a situation where if I do nothing and the horse wins, I lose £5.60 and if it loses I win £4. I need a formula to take care of this and have an even P/L win of lose. I looked at Gary's code in his greenUp spread sheet and am no wiser. Any help of guidance much appreciated. best regards Paul

[alrodopial]

If I remember correctly there was a post from Garry explaining the maths behind equal.
It was also sticky post but I cant find it
Is the personal message of the forum working?
I cant compose a pm neither see my old messages

[bolpx001]

Thanks for the reply alrodopial , hopefully somebody will come up with a simple formula

[osknows]

Have a look at the GreenUp Fast.xlsm workbook in this thread viewtopic.php?f=12&t=7844

[Captain Sensible]

The maths behind greening up a bet with equal win/loss regardless of the result is pretty simple. You're basically working out how much you're due to win/lose then dividing that by the new odds to give your the stake needed to acheive that.

Say we back £10 @ 3's so our overall return (including our stake) is £30 (3x10) , say the new odds are 2.5 - to work out the stake we need to lay at 2.5 we simply 30 divided by 2.5 i.e. £12 to give us a greened up field of £2

Horse wins
We won £20 but have to pay out £18 from laying £12 @ 2.5 so £20 less £18 = £2 profit

Horse loses
We lose our £10 stake but win £12 stake from the lay so again overall profit of £12 less £10 = £2 profit.

Where you have multiple bets you'd just add all the returns together then divide that by the new odds to give you the stake

so as simple as

new_stake = (old_stake X old_odds) / new_odds

[bolpx001]

Thanks Captain Sensible, I think I see where I am going wrong, thank you, I was basing everything on my original stake and it should have bee the probable return - best regards Paul