Announcement

Collapse
No announcement yet.

Excel / Greening Formula

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel / Greening Formula

    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.

    What's new in version 1.2

  • #2
    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!
    Last edited by Wednesday 13; 5 January 2010, 01:31 PM. Reason: Link correction.

    Comment


    • #3
      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.

      What's new in version 1.2

      Comment


      • #4
        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

        Comment


        • #5
          Originally posted by Chas View Post
          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.
          What's the rumpus?

          Comment


          • #6
            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

            Comment


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

              Comment


              • #8
                Originally posted by PFY View Post
                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.

                Comment


                • #9
                  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
                  Last edited by 1/4 of a millionaire fund; 22 January 2010, 06:13 PM. Reason: Updated file to allow manual closing odds to be input

                  Comment


                  • #10
                    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?

                    Comment


                    • #11
                      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.

                      Comment


                      • #12
                        Thanks for that!

                        Comment


                        • #13
                          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....

                          Comment


                          • #14
                            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

                            Comment


                            • #15
                              Originally posted by doubleback View Post
                              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

                              Comment

                              Working...
                              X