1. #1
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256

    Good Excel Sports Betting Spreadsheet?

    Hey guys...im looking for a spreadsheet that is easy to use and calculates a running bankroll...I know sbr has a good one but I prefer to have my stats offline in excel format...I would appreciate anyone willing to lend some help..

  2. #2
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256

    If I was at all computer savvy I could do it on my own, but obviously im not too good with excel since im asking for some help...ha...thanks guys..

  3. #3
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256

    Bump...

  4. #4
    TCU
    TCU's Avatar Become A Pro!
    Join Date: 01-09-12
    Posts: 88
    Betpoints: 1214

    Here's a link to one I use, hope it's the sort of thing you're looking for

    http://www.aussportsbetting.com/tool...cel-worksheet/

  5. #5
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256

    Thanks TCU...I will take a look at it...

  6. #6
    Hereindallas
    Hereindallas's Avatar Become A Pro!
    Join Date: 09-30-12
    Posts: 122

    All the pages are protected and need a password to unprotect. Do you have the password?

  7. #7
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

    There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

    http://www.sendspace.com/file/ygu24d

  8. #8
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888

    Which check link out and see if any good

  9. #9
    70kgman
    70kgman's Avatar Become A Pro!
    Join Date: 01-31-10
    Posts: 4,354
    Betpoints: 1822

    Quote Originally Posted by shari91 View Post
    This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

    There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

    http://www.sendspace.com/file/ygu24d
    Do you know how if there is a way to quickly change the date range for the entire spreadsheet including the graphs and all?

  10. #10
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888

    well lets say go to the summary sheet
    then the first date box click it and then with your mouse go to bottom right edge of box and wait until you see a + sign and then click and hold drag them all down and you will see dates changing

  11. #11
    Sam Odom
    Sam Odom's Avatar Become A Pro!
    Join Date: 10-30-05
    Posts: 58,074
    Betpoints: 36


  12. #12
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    Quote Originally Posted by 70kgman View Post
    Do you know how if there is a way to quickly change the date range for the entire spreadsheet including the graphs and all?
    All of your info will go into the Details sheet and that's where all of the calculations and graphs are performed from. Manually enter the first 2 or 3 dates you want to start with ie 10/5/12, 10/6/12, 10/7/12.

    Highlight those 3 boxes with your mouse and then go the bottom right corner like JJ suggested to grab the cross. Left click and scroll down as far as you want... the dates will auto populate sequentially until you stop. But unless you're only going to make one wager a day, this won't be of much use to you as you'll still have to go into change it manually.
    Last edited by shari91; 10-05-12 at 01:22 PM.

  13. #13
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    Here are Tom's instructions from 2010 (he usually makes an updated spreadsheet each year so I posted the 2012 version):

    The 'Details' tab is where all the data entry is performed. Enter each wager's information in columns A:K and O:Q. Try to use consistent naming conventions for stuff like "Sportsbook" (e.g., always use either TheGreek or Greek), "Wager Type" and "Bet Type" as those fields power the 'Analytics' tab.

    When each game is finished, grade the results in the "Results" column by entering either WIN, LOSS, or PUSH. Next, click on the 'Pivots' tab. Right click any of the pivot tables and Refresh. The 'Summary' and 'Analytics' tabs will auto-populate with the results. For the most part you don't need to change anything on either of the 'Summary' or 'Analytics' tabs. The exception is if you make no wagers on a certain day (???). Then you need to manually enter 0's for that day on 'Summary' tab in columns B:I.

    Each month, the monthly graphs need to be manually updated. Right click the graph and select new data using the same conventions as the previous month.

  14. #14
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    And this was the last post I've seen him make about it...

    oh looks like on the summary tab you need to fix the empty cells. copy and paste the formulas in cells B185:E185 for example and paste those formulas in all the cells above and it will work

  15. #15
    HoulihansTX
    Bowl $ea$on
    HoulihansTX's Avatar Become A Pro!
    Join Date: 02-12-09
    Posts: 30,567

    Bookmarking this thread. We are working on this in my class.

  16. #16
    baskets
    Poster of the Month Twice a Month
    baskets's Avatar Become A Pro!
    Join Date: 11-24-11
    Posts: 11,691

    so funny. guy says he makes 10-15 wagers a day, then says he makes hundreds of wagers a day ... whatever is +EV. guy says he doesn't use excel b/c it's too much effort, then provides a spreadsheet. says he makes 20 - 30k /month gambling .... yet has no money in Pinnacle... and on and on.

    as Andywend said, 'he is one sick fukk of a human being' .... but I would like to know about the accuracy of his pro gambling claims

  17. #17
    szk1983
    szk1983's Avatar Become A Pro!
    Join Date: 07-08-06
    Posts: 642
    Betpoints: 108

    I'm sure there must be something out there, but I have no clue what it is! Sorry!

  18. #18
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    Quote Originally Posted by baskets View Post
    so funny. guy says he makes 10-15 wagers a day, then says he makes hundreds of wagers a day ... whatever is +EV. guy says he doesn't use excel b/c it's too much effort, then provides a spreadsheet. says he makes 20 - 30k /month gambling .... yet has no money in Pinnacle... and on and on.

    as Andywend said, 'he is one sick fukk of a human being' .... but I would like to know about the accuracy of his pro gambling claims
    It's not his spreadsheet although I'd assume he used it at least at some point. I had asked for help with this ages ago and he pointed me towards TomG's spreadsheet. SBR spreadsheet is great too but I wanted something a bit more advanced. Thankfully Tom is generous enough to share an updated version each year.

  19. #19
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888

    Its not good

    I deleted it already.........way too much manual input

  20. #20
    shari91
    shari91's Avatar Moderator
    Join Date: 02-23-10
    Posts: 32,646
    Betpoints: 11959

    Quote Originally Posted by jjgold View Post
    Its not good

    I deleted it already.........way too much manual input
    Where is there a spreadsheet that you don't have to input your bets and the result??? That's all you have to do here. One page: Details.

    Definitely not at SBR. The only difference with Tom's is that you need to be consistent with how you input the book name as it actually means something on his sheet whereas at SBR's you can skip it. Nowhere else offers this. At least not for free. Maybe someone has figured out a way to link it with auto scoring on everyone's home computer and they're charging for it across every sport? If so, let me know but I'm not aware of it.

    Either way Tom's spreadsheet has been a perfect accompaniment for me to SBR's. The OP was asking for options. This spreadsheet is probably the most used - and its updates anticipated - by gamblers every year. Between SBR and TomG I can't see how anyone can screw it up.

  21. #21
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119

    Duff posted a link to http://www.betdog.eu not long ago; it's a pretty powerful (free) bet tracking tool. It does a lot of the work for you when entering games.
    Nomination(s):
    This post was nominated 1 time . To view the nominated thread please click here. People who nominated: 2205

  22. #22
    daneblazer
    Most Well Rounded POY
    daneblazer's Avatar SBR PRO
    Join Date: 09-14-08
    Posts: 27,835
    Betpoints: 6895

    Was googling betting spreadsheets and this popped up. Good stuff

  23. #23
    jayem
    jayem's Avatar Become A Pro!
    Join Date: 05-10-14
    Posts: 9
    Betpoints: 36

    Quote Originally Posted by shari91 View Post
    This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

    There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

    http://www.sendspace.com/file/ygu24d
    planning to use this for a world cup bankroll, is there another instructions besides those you posted on the forum?

  24. #24
    phinfan27615
    1972
    phinfan27615's Avatar SBR PRO
    Join Date: 07-10-17
    Posts: 1,822
    Betpoints: 11644

    These aren't working for me, is there an updated version? When I try to open the file it says I don't have a program that can open it

  25. #25
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888

    I use SBR

    But for custom stuff here you go

    http://www.aussportsbetting.com/tool...cel-worksheet/

  26. #26
    phinfan27615
    1972
    phinfan27615's Avatar SBR PRO
    Join Date: 07-10-17
    Posts: 1,822
    Betpoints: 11644

    Quote Originally Posted by jjgold View Post
    I use SBR

    But for custom stuff here you go

    http://www.aussportsbetting.com/tool...cel-worksheet/
    How do you use sbr?

  27. #27
    gauchojake
    Fansplainer
    gauchojake's Avatar SBR PRO
    Join Date: 09-17-10
    Posts: 32,451
    Betpoints: 8886

    Where is baskets????

  28. #28

  29. #29
    Slipknot26
    Slipknot26's Avatar Become A Pro!
    Join Date: 07-17-15
    Posts: 5,143
    Betpoints: 1322

    I've used Google sheets for awhile. Basically excel , send links and people can get updates , etc.
    Excellent way to track and share also
    Last edited by Slipknot26; 01-24-18 at 10:21 PM.

  30. #30
    phinfan27615
    1972
    phinfan27615's Avatar SBR PRO
    Join Date: 07-10-17
    Posts: 1,822
    Betpoints: 11644

    So it doesn't automatically track previous picks? I would need to start putting mine in for the future?

  31. #31
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888

    Have To Start new

  32. #32
    phinfan27615
    1972
    phinfan27615's Avatar SBR PRO
    Join Date: 07-10-17
    Posts: 1,822
    Betpoints: 11644

    Quote Originally Posted by jjgold View Post
    Have To Start new
    Awesome well im starting today, kinda nice no one will see all my losers from the past couple of months lol. Im using money on the sheet but really its sbr betpoints

  33. #33
    magaman
    Update your status
    magaman's Avatar Become A Pro!
    Join Date: 01-17-18
    Posts: 1,940
    Betpoints: 25

    Quote Originally Posted by jolmscheid View Post
    Hey guys...im looking for a spreadsheet that is easy to use and calculates a running bankroll...I know sbr has a good one but I prefer to have my stats offline in excel format...I would appreciate anyone willing to lend some help..
    Make your own excel spreadsheet... you can do anything you want. It's pretty simple

  34. #34
    HurryUpAndDrink
    HurryUpAndDrink's Avatar Become A Pro!
    Join Date: 08-23-13
    Posts: 13,061

    Im pissed... spent like 2 hrs trying and using new spreadsheets and was not able to find or set one to American sports

    FUKK that decimal shit

  35. #35
    jjgold
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 394,888


Top