PDA

View Full Version : Excel / Greening Formula



The Geek
5th January 2010, 10:56 AM
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
5th January 2010, 12:29 PM
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).

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
5th January 2010, 12:48 PM
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
5th January 2010, 07:15 PM
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
5th January 2010, 07:40 PM
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
5th January 2010, 07:41 PM
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
5th January 2010, 07:58 PM
Cheers Wednesday been looking at that thread and there’s some useful info.
Thanks a lot.

Sheza58
19th January 2010, 01:07 AM
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
22nd January 2010, 03:56 PM
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
10th April 2013, 02:19 PM
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
10th April 2013, 08:09 PM
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
19th April 2013, 03:40 PM
Thanks for that! :Brilliant

starkygold
21st April 2013, 12:00 PM
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
21st April 2013, 07:40 PM
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
22nd April 2013, 01:30 PM
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

custard
22nd April 2013, 01:56 PM
Liability = (0.78 x 128.21) + (0.58 x 344.83)

= 100.003 + 200.001

= 300

Back, 473.03 @ 1.63

Profit = 298.008


So, the answer is "yes".

I was doing this sort of arithmetic when I was eight.

Wednesday 13
22nd April 2013, 01:57 PM
Is 473,03 @1,63 correct or not?

Yes.

In the same way as for back bets - liability for first bet is 128.21 * 0.78 = 100, and for second bet 344.83 * 0.58 = 200; so, total stake 473.04, total liability 300, and average lay odds = 1 + 300/473.04 = 1.6342.

Wednesday 13
22nd April 2013, 01:59 PM
Custard, we typed in the same time, it seems... :D


I was doing this sort of arithmetic when I was eight.

You started trading at the age of eight?! :p

doubleback
22nd April 2013, 02:21 PM
So I will need to back 473,03eur @1,63 to have a profit of 0.
No something is wrong.... :(

You seemed a little perplexed as to why you had zero profit and that is the issue I addressed!

Never mind, you seem sorted now!


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

custard
22nd April 2013, 03:23 PM
Custard, we typed in the same time, it seems... :D



You started trading at the age of eight?! :p

It's kind of complicated. My father taught me how to read when I was four. My grandmother had a pub and that had an illegal betting clock. I was backing "spot" horses listed in the Daily Mirror when I was six. My usual bet was sixpence each way. The regulars in the pub spoiled me and I was drinking beer at a very early age with the approval of my parents. My father was ex-Navy and believed that a real man should be able to drink sensibly. Mental arithmetic was also a high priority for a six year old in those days. I was better educated at six than most kids are today at sixteen. We all were.