Excel / Greening Formula

[The Geek]

There is somebody on the BetDevil forum asking for a hedging formula for Excel.

Just in case you read ours too, I've put a spreadsheet up here for you to download which calculates greening.

http://www.geekstoy.com/Download/Hedge.xls

You should be able to work out the formula you need from there.

[Wednesday 13]

Hi, Geek; I hope you don't mind if I post link to a similar spreadsheet I have created for my own use, and I uploaded them to my site in order to be accessible, when I got involved in similar thread in another forum; the spreadsheet allows you to calculate stakes needed to equalize your profit, or profit when you stake different amounts; there are two tables, one when you first back then lay, and another for the opposite case; I included "Effective odds" (both back or lay), which show your "return of investment" for that specific trade; for example, if you get effective odds of 1.20, that means your profit amounts to 20% of your initial stake (in case of back then lay) or liability (in case of lay then back).

https://www.strugar.info/pl/Back - Lay calc.xls

I like your spreadsheet, too, it has more serious look, and makes the job done!

[The Geek]

No probs. I did mine way back when I built greening into TT. Thouhgt it might be handy for the BD guy, as he wasn't getting the answer he needed over there.

[Chas]

Hi I wonder if any one has made a spread sheet for the following football idea. In a match where you think there will be a lot of goals back both teams before the off. Then after a goal has been scored and the odds for the draw are high enough. Back the draw for an equal profit across the board

[PFY]

Hi I wonder if any one has made a spread sheet for the following football idea. In a match where you think there will be a lot of goals back both teams before the off. Then after a goal has been scored and the odds for the draw are high enough. Back the draw for an equal profit across the board

I did one for the lay the draw tactic, it also allowed for the 0-0 insurance bet. However I fooked my PC a while back and lost it among other things.

[Wednesday 13]

Hey, Chas, what you propose is well known strategy of laying the draw - backing both teams to win in fact is equal to laying the draw; as I said, it's one of the basic strategies, which works well if you carefully chose your match, but it has its flaws which can ruin your bank; we had a discussion about that strategy some time ago in this thread: http://www.geekstoy.com/forum/showthread.php?p=5076

[Chas]

Cheers Wednesday been looking at that thread and there’s some useful info.
Thanks a lot.

[Sheza58]

I did one for the lay the draw tactic, it also allowed for the 0-0 insurance bet. However I fooked my PC a while back and lost it among other things.

Have you redone that particular formula mate? I am looking for a simple spreadsheet that does exactly that.

[1/4 of a millionaire fund]

I lost my green up xls file when switching computers recently so wrote a new one in ladder format to give a range of greens/reds rather than the usual one. If anyone wants a copy I've stuck it here

http://www.mediafire.com/file/yzrmmjwkyg1/greenup.xls

It's protected but not password protected only so people don't overwrite any calc cells in error. Haven't fully checked it but seems to work OK

[starkygold]

Multiple bets calculation

How to do this in excel.

BET1 @1.40 100eur
BET2 @1.70 200eur
BET3 @2.00 400eur

Let's assume the price is around @1,93 and my profit is in red now. How to calculate at which odds and the stake to gain a profit of 6 ticks @2.00?
( 400eur @2.00, 6 ticks is LAY@1.94 green all and profit will be 12.37 eur)

So how to calculate at which odds I need to green out to earn 12.37eur?
:Thanks:Thanks:Thanks

[Wednesday 13]

You effectively backed with stake of 700 eur at odds of 1.8286:

1 + (100 * 0.40 + 200 * 0.70 + 400 * 1.00) / (100 + 200 + 400)

You want gross profit of 12.37 eur, so lay stake is 712.37 eur. And then you calculate lay odds as

back stake * back odds / lay stake = 700 * 1.8286 / 712.37 = 1.7968 -> 1.80

However, are you sure of profit of 12.37 eur? You calculated it based on back stake of 400 eur, while it's actually 700 eur, so profit in your example is 21.64 eur, so lay stake in above formula is 721.64 eur.

[starkygold]

Thanks for that! :Brilliant

[starkygold]

If I want to calculate average LAY odds... stake?
I made something in excel and want to know if this is correct:

ODDS STAKE/Liab
1,78 128,21
1,58 344,83

Average odds: 1,63
liabiilty 473,03

So I will need to back 473,03eur @1,63 to have a profit of 0.
No something is wrong....

[doubleback]

If you lay and back the same amount, at the same odds, then you will have zero profit ...

If the available back odds were 1.7 ...

(€473.03 * 1.63) / 1.7 = €453.55

€19.48 profit

[starkygold]

If you lay and back the same amount, at the same odds, then you will have zero profit ...

If the available back odds were 1.7 ...

(€473.03 * 1.63) / 1.7 = €453.55

€19.48 profit

Please read the post above.
I layed @1,78 128,21eur and @1,58 344,83.
Tell me the average odds I layed and the stake I need to back to have a profit of zero. Is 473,03 @1,63 correct or not?

I know If I lay @1,70 100 eur then back @1,70 100eur the profit is zero but I'm talking for multiple lays and calculation for average odds...

Thanks