how do you keep track of your wins/loses?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Vaughany
    SBR Aristocracy
    • 03-07-10
    • 45563

    #36
    Originally posted by Grabaka
    Asspergerrrs battleeeeeee!!!!
    hahaha
    Comment
    • Fragoel2
      SBR High Roller
      • 09-08-12
      • 107

      #37
      Originally posted by Grabaka
      I use a spreadsheet in excel. Calculates profits, pending plays, overall net and all that shit. I wonder if it would be better to have a spreadsheet for each sport.
      I have one too but is shittier... can I ask you to share your own? :P
      Comment
      • Oblivian
        SBR High Roller
        • 01-27-12
        • 163

        #38
        I keep track on Sherdog, the only place with real cerebral discussion. After each event, I break open the penny bank and bag up the coins. I won $.16 on Strikeforce this weekend.
        Comment
        • sideloaded
          SBR Hall of Famer
          • 08-21-10
          • 7561

          #39
          Originally posted by Boxscout
          I think it's easier to tell in combat sports, since you usually expect things to unfold in a particular way. Compare that to like, basketball. Were your sides shot's just not falling? Was it the defense? Was it the coaching? The refs?

          Obviously there's luck and variance in the fights themselves as well as your guesswork on them, but it's generally easier to see when your right or wrong.
          I still find it hard. Take for example the Cung Le vs Rich Franklin fight. Was that a lucky punch? Or was that punch going to happen 9 times out of ten because of all the years Cung has timed that punch matching up with all the years Rich has had shitty defense and sloppy leg kicks?

          Hard to answer that.
          Comment
          • Grabaka
            SBR MVP
            • 02-19-11
            • 3216

            #40
            OFFICIAL GRABAKA 2013.zip
            My spreadsheet
            Comment
            • NunyaBidness
              SBR Hall of Famer
              • 07-26-09
              • 9345

              #41
              Originally posted by sideloaded
              I still find it hard. Take for example the Cung Le vs Rich Franklin fight. Was that a lucky punch? Or was that punch going to happen 9 times out of ten because of all the years Cung has timed that punch matching up with all the years Rich has had shitty defense and sloppy leg kicks?

              Hard to answer that.
              You're exactly right (man, that was hard to write).

              It's easy to look at a fight and say, well obviously Le was undervalued there. Or look at every time a -2000 boxer wins and think 'yep, price was justified'. The actual results cloud our thinking, and this becomes clear when you look at future lines and watch someone get overvalued because of a string of wins, and then suddenly they lose as a 3-1 favorite in a fight that maybe should've been 50/50 all along.
              Comment
              • JKD
                SBR High Roller
                • 01-04-13
                • 149

                #42
                Spreadsheet, you gosta have a spreadsheet.

                Originally posted by Oblivian
                I keep track on Sherdog, the only place with real cerebral discussion. After each event, I break open the penny bank and bag up the coins. I won $.16 on Strikeforce this weekend.
                You're such a player O, much more humble on Sherdog. You never run your mouth about your big wins over there ;]
                Comment
                • Vaughany
                  SBR Aristocracy
                  • 03-07-10
                  • 45563

                  #43
                  just gotta pick winnerz boys...simples
                  Comment
                  • Fragoel2
                    SBR High Roller
                    • 09-08-12
                    • 107

                    #44
                    Originally posted by Grabaka
                    [ATTACH]52716[/ATTACH]
                    My spreadsheet

                    Thanks a lot! Noticed that I had some things that your's is missing and vice-versa. So I'm trying to merge the two so we can have the Ultimate Spreadsheet of Doom!
                    Comment
                    • sideloaded
                      SBR Hall of Famer
                      • 08-21-10
                      • 7561

                      #45
                      .ods ? u running ubuntu breh? Thought I was the only one
                      Comment
                      • NunyaBidness
                        SBR Hall of Famer
                        • 07-26-09
                        • 9345

                        #46
                        Openoffice is available on all platforms.
                        Comment
                        • sideloaded
                          SBR Hall of Famer
                          • 08-21-10
                          • 7561

                          #47
                          Originally posted by NunyaBidness
                          You're exactly right (man, that was hard to write).

                          It's easy to look at a fight and say, well obviously Le was undervalued there. Or look at every time a -2000 boxer wins and think 'yep, price was justified'. The actual results cloud our thinking, and this becomes clear when you look at future lines and watch someone get overvalued because of a string of wins, and then suddenly they lose as a 3-1 favorite in a fight that maybe should've been 50/50 all along.
                          Thanks I've started a spread sheet for each fighter. Im going to go by divisions starting with the new 135 lbs womens division. I've scraped the historic odds for each fighter from bestfightodds. I just wish I had an api key to Pinny.
                          Comment
                          • Vaughany
                            SBR Aristocracy
                            • 03-07-10
                            • 45563

                            #48
                            should have a formula for Kelly in there as well boys and girls!
                            Comment
                            • Boxscout
                              SBR High Roller
                              • 12-20-12
                              • 222

                              #49
                              Originally posted by Fragoel2
                              Thanks a lot! Noticed that I had some things that your's is missing and vice-versa. So I'm trying to merge the two so we can have the Ultimate Spreadsheet of Doom!
                              When you do, please post that as well. Thanks for the one you posted too Grabaka.

                              Now to figure out what a spreadsheet is.
                              Comment
                              • NunyaBidness
                                SBR Hall of Famer
                                • 07-26-09
                                • 9345

                                #50
                                Originally posted by Vaughany
                                should have a formula for Kelly in there as well boys and girls!
                                No doubt, it should automagically calculate your wager size by comparing the available line to your capped line.
                                Comment
                                • PunisherIND
                                  SBR MVP
                                  • 02-24-11
                                  • 4983

                                  #51
                                  Originally posted by sideloaded
                                  Thanks I've started a spread sheet for each fighter. Im going to go by divisions starting with the new 135 lbs womens division. I've scraped the historic odds for each fighter from bestfightodds. I just wish I had an api key to Pinny.
                                  damn, you are ambitious. seems like this will take forever.
                                  Comment
                                  • sideloaded
                                    SBR Hall of Famer
                                    • 08-21-10
                                    • 7561

                                    #52
                                    Originally posted by PunisherIND
                                    damn, you are ambitious. seems like this will take forever.
                                    not really Im already done with the 10-15 or so 135 lb fighters. Once the first scrapper script is wrote. You just change the name. BFO is super easy to scrape.
                                    Comment
                                    • sideloaded
                                      SBR Hall of Famer
                                      • 08-21-10
                                      • 7561

                                      #53
                                      Originally posted by NunyaBidness
                                      No doubt, it should automagically calculate your wager size by comparing the available line to your capped line.
                                      someone posted this on 2p2. It has all the formulas there. Just needs a little tweaking for mma.

                                      http://www.sendspace.com/file/39zzh8 The other field i meant market field is the capped line field
                                      Comment
                                      • Vaughany
                                        SBR Aristocracy
                                        • 03-07-10
                                        • 45563

                                        #54
                                        For example:

                                        Predicted win rate (55%) ......... 0.55 (in cell B5 for example) (decimal form)
                                        Actual odds (-110)............... 0.91 (in cell B6 for example) "
                                        Advantage calculated by predicted win rate (0.55) multiplied by actual odds (0.91) minus losing percentage (0.45)....
                                        so formula would be: =(B5*B6)-0.45 = 0.05
                                        Advantage (0.05) divided by actual odds (0.91) = 0.055 = the percentage of bankroll to wager under Kelly...
                                        So 0.055 = 5.5% (0.055 multiplied by 100) of bankroll
                                        Comment
                                        • PunisherIND
                                          SBR MVP
                                          • 02-24-11
                                          • 4983

                                          #55
                                          Originally posted by Vaughany
                                          For example:

                                          Predicted win rate (55%) ......... 0.55 (in cell B5 for example) (decimal form)
                                          Actual odds (-110)............... 0.91 (in cell B6 for example) "
                                          Advantage calculated by predicted win rate (0.55) multiplied by actual odds (0.91) minus losing percentage (0.45)....
                                          so formula would be: =(B5*B6)-0.45 = 0.05
                                          Advantage (0.05) divided by actual odds (0.91) = 0.055 = the percentage of bankroll to wager under Kelly...
                                          So 0.055 = 5.5% (0.055 multiplied by 100) of bankroll
                                          you cant stop there bruv. tell us fools how to get half kelly and quarter kelly.

                                          we want to be spoonfed!!
                                          Comment
                                          • Vaughany
                                            SBR Aristocracy
                                            • 03-07-10
                                            • 45563

                                            #56
                                            hahaha Do you all know how to divide fractions in to decimals?! Guess I should of explained tht first of all!
                                            Comment
                                            • JKD
                                              SBR High Roller
                                              • 01-04-13
                                              • 149

                                              #57
                                              After looking at spreadsheets at work all day, it's great to be at home relaxing where I can kick back and read a discussion about spreadsheets. Good stuff.
                                              Comment
                                              • sideloaded
                                                SBR Hall of Famer
                                                • 08-21-10
                                                • 7561

                                                #58
                                                Originally posted by JKD
                                                After looking at spreadsheets at work all day, it's great to be at home relaxing where I can kick back and read a discussion about spreadsheets. Good stuff.
                                                spreadsheet discussion makes the girls wet
                                                Comment
                                                • Vaughany
                                                  SBR Aristocracy
                                                  • 03-07-10
                                                  • 45563

                                                  #59
                                                  hhaha

                                                  culinary lessons and now spreadsheet lessons...even Wannabet is finding this too cerebral now
                                                  Comment
                                                  • JKD
                                                    SBR High Roller
                                                    • 01-04-13
                                                    • 149

                                                    #60
                                                    haha, WB doesn't do spreadsheets he has minions for that shit!

                                                    All fairness; I know he gets crazy amounts of stick on here, but I like that guy a lot, makes me laugh.
                                                    Comment
                                                    • PunisherIND
                                                      SBR MVP
                                                      • 02-24-11
                                                      • 4983

                                                      #61
                                                      Originally posted by JKD
                                                      After looking at spreadsheets at work all day, it's great to be at home relaxing where I can kick back and read a discussion about spreadsheets. Good stuff.
                                                      Comment
                                                      • v1y
                                                        SBR MVP
                                                        • 05-02-11
                                                        • 1138

                                                        #62
                                                        Account balance + amount withdrawn - initial deposit.
                                                        Comment
                                                        • NunyaBidness
                                                          SBR Hall of Famer
                                                          • 07-26-09
                                                          • 9345

                                                          #63
                                                          Originally posted by v1y
                                                          Account balance + amount withdrawn - initial deposit.
                                                          Only useful if you're a one sport bettor. It's good to know if you're a donator at MLB.
                                                          Comment
                                                          • sideloaded
                                                            SBR Hall of Famer
                                                            • 08-21-10
                                                            • 7561

                                                            #64
                                                            Originally posted by NunyaBidness
                                                            Only useful if you're a one sport bettor. It's good to know if you're a donator at MLB.
                                                            do you mind if I ask you question about bit coins? Is it worth it to mine my own or buy from a broker?
                                                            Comment
                                                            • NunyaBidness
                                                              SBR Hall of Famer
                                                              • 07-26-09
                                                              • 9345

                                                              #65
                                                              From what I have read its not profitable to mine them anymore, the guys who are doing it are running super high performance rigs, can barely beat the cost of electricity it would take to run it.
                                                              Comment
                                                              • sideloaded
                                                                SBR Hall of Famer
                                                                • 08-21-10
                                                                • 7561

                                                                #66
                                                                damn I havent payed attention to mining for year or more. Shit got gamed real quick I guess.
                                                                Comment
                                                                • Grabaka
                                                                  SBR MVP
                                                                  • 02-19-11
                                                                  • 3216

                                                                  #67
                                                                  Originally posted by Fragoel2
                                                                  Thanks a lot! Noticed that I had some things that your's is missing and vice-versa. So I'm trying to merge the two so we can have the Ultimate Spreadsheet of Doom!
                                                                  Yeee send me a copy if you can mi amigo
                                                                  Comment
                                                                  • Fragoel2
                                                                    SBR High Roller
                                                                    • 09-08-12
                                                                    • 107

                                                                    #68
                                                                    I will post it here guys, but it might take a couple more days... Implementing the Kelly Calculator that everybody is so excited about

                                                                    In the meantime if you have some stats that you think should be on the spreadsheet, suggest them...

                                                                    EDIT: holy penetrating penetrates Sideloaded, that's a helluva spreadsheet... k, I'm going to take something from that too.
                                                                    Comment
                                                                    • Fragoel2
                                                                      SBR High Roller
                                                                      • 09-08-12
                                                                      • 107

                                                                      #69
                                                                      Well, in the end part of me decided that doing this was more important/fun than studying... so here it is:

                                                                      https://docs.google.com/spreadsheet/ccc?key=0Ao-qXR4SYQV3dFJUZFZyR3JzS213ZmhLbzZ1aTF6UlE


                                                                      I moved the whole thing to google docs since:
                                                                      -It's easier to share
                                                                      -It's cross platform
                                                                      -You won't lose data if your hard drive dies

                                                                      Mostly, I merged the spredsheet posted by Sideloaded (since it was really well made) with the one of Grabaka (since I really liked the whole W, L, Pending system that it had).

                                                                      In the win/loss column you can insert:
                                                                      W = win
                                                                      L = loss
                                                                      PENDING = yeah, pending
                                                                      PUSH = push, very original I know
                                                                      C = Cash out
                                                                      D = deposit

                                                                      Anyway, there are some fictional bets so you can play with those and see it for yourself...

                                                                      I checked the various calculations but you should still be careful and double check it yourself... lemme be more clear:

                                                                      THE SPREADSHEET HAS UNDERGONE LIMITED TESTING, THERE MIGHT BE SOME ERROR IN THE CALCULATIONS, YOU SHOULD CHECK THE RESULTS IT PROVIDES BY YOURSELF! SHOULD YOU LOSE MONEY DUE TO SOME ERROR, SCREW YOU! YOU TAKE ALL RESPONSABILITY FOR USING THE SPREADSHEET!!!

                                                                      Hope you enjoy, if you have suggestions on how to improve it lemme know.
                                                                      Comment
                                                                      • Grabaka
                                                                        SBR MVP
                                                                        • 02-19-11
                                                                        • 3216

                                                                        #70
                                                                        WOW yours is amazing.
                                                                        Comment
                                                                        Search
                                                                        Collapse
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...